contig_metadata
28 rows where bioproject = "PRJNA1073183" and tax_phylum = "Haptophyta"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187344 | 187344 | PRJNA1073183_P_NODE_30781_length_246_cov_0.890173_g30686_i0 | PRJNA1073183 | 30781 | 246 | 0.890173 | 2.18982558 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 455 | 1.4500000000000002e-123 | NTclustered | gi|551627571|ref|XM_005793710.1| | 280463 | g30686 | i0 | 100 | 1.46747967479675 | 246 | 0 | 100 | 0 | 1 | 246 | 1228 | 983 | Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA | blastn | 361 | 455 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 1016036 | 1016036 | PRJNA1073183_P_NODE_26781_length_251_cov_0.865169_g26686_i0 | PRJNA1073183 | 26781 | 251 | 0.865169 | 2.17157419 | Noelaerhabdaceae | 418966 | Haptophyta | other_Eukaryota | 459 | 1.1499999999999996e-124 | NTclustered | gi|2235062516|gb|OL703629.1| | 2903 | g26686 | i0 | 99.602 | 81.0756972111554 | 251 | 1 | 100 | 0 | 1 | 251 | 15393 | 15643 | Emiliania huxleyi strain Van556 mitochondrion, partial genome | blastn | 20350 | 459 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 1016067 | 1016067 | PRJNA1073183_P_NODE_401_length_1665_cov_2.893216_g373_i0 | PRJNA1073183 | 401 | 1665 | 2.893216 | 48.1720464 | Noelaerhabdaceae | 418966 | Haptophyta | other_Eukaryota | 3075 | 0 | NTclustered | gi|2530650642|gb|ON844104.1| | 2903 | g373 | i0 | 100 | 85.2882882882883 | 1665 | 0 | 100 | 0 | 1 | 1665 | 97716 | 99380 | Emiliania huxleyi strain CS-369 plastid, complete genome | blastn | 142005 | 3075 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 2291474 | 2291474 | PRJNA1073183_P_NODE_5322_length_550_cov_1.259958_g5229_i0 | PRJNA1073183 | 5322 | 550 | 1.259958 | 6.929769 | Noelaerhabdaceae | 418966 | Haptophyta | other_Eukaryota | 1016 | 0 | NTclustered | gi|2530650642|gb|ON844104.1| | 2903 | g5229 | i0 | 100 | 100.645454545455 | 550 | 0 | 100 | 0 | 1 | 550 | 19589 | 20138 | Emiliania huxleyi strain CS-369 plastid, complete genome | blastn | 55355 | 1016 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 3566704 | 3566704 | PRJNA1073183_P_NODE_32383_length_244_cov_0.900585_g32288_i0 | PRJNA1073183 | 32383 | 244 | 0.900585 | 2.1974274 | Emiliania | 2902 | Haptophyta | other_Eukaryota | 446 | 8.639999999999999e-121 | NTclustered | gi|112131799|gb|DQ658247.1| | 2903 | g32288 | i0 | 99.59 | 2 | 244 | 1 | 100 | 0 | 1 | 244 | 422 | 179 | Emiliania huxleyi clone seq197.fasta.Contig5 mRNA sequence | blastn | 488 | 446 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 4013700 | 4013700 | PRJNA1073183_P_NODE_26784_length_251_cov_0.865169_g26689_i0 | PRJNA1073183 | 26784 | 251 | 0.865169 | 2.17157419 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 97.1 | 1.04e-15 | NTclustered | gi|551615762|ref|XM_005788689.1| | 280463 | g26689 | i0 | 86.364 | 15.9721115537849 | 88 | 12 | 35 | 0 | 161 | 248 | 498 | 585 | Emiliania huxleyi CCMP1516 putative histone H2B mRNA | blastn | 4009 | 97.1 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 6119269 | 6119269 | PRJNA1073183_P_NODE_6145_length_511_cov_1.757991_g6052_i0 | PRJNA1073183 | 6145 | 511 | 1.757991 | 8.98333401 | Noelaerhabdaceae | 418966 | Haptophyta | other_Eukaryota | 944 | 0 | NTclustered | gi|2530650642|gb|ON844104.1| | 2903 | g6052 | i0 | 100 | 109.6771037182 | 511 | 0 | 100 | 0 | 1 | 511 | 46684 | 47194 | Emiliania huxleyi strain CS-369 plastid, complete genome | blastn | 56045 | 944 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 11219522 | 11219522 | PRJNA1073183_P_NODE_26849_length_251_cov_0.865169_g26754_i0 | PRJNA1073183 | 26849 | 251 | 0.865169 | 2.17157419 | Noelaerhabdaceae | 418966 | Haptophyta | other_Eukaryota | 464 | 2.47e-126 | NTclustered | gi|2530650642|gb|ON844104.1| | 2903 | g26754 | i0 | 100 | 37.5657370517928 | 251 | 0 | 100 | 0 | 1 | 251 | 68872 | 68622 | Emiliania huxleyi strain CS-369 plastid, complete genome | blastn | 9429 | 464 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 11219560 | 11219560 | PRJNA1073183_P_NODE_6329_length_504_cov_2.368910_g6236_i0 | PRJNA1073183 | 6329 | 504 | 2.36891 | 11.9393064 | Noelaerhabdaceae | 418966 | Haptophyta | other_Eukaryota | 926 | 0 | NTclustered | gi|2530650642|gb|ON844104.1| | 2903 | g6236 | i0 | 99.802 | 101.771825396825 | 504 | 1 | 100 | 0 | 1 | 504 | 92849 | 93352 | Emiliania huxleyi strain CS-369 plastid, complete genome | blastn | 51293 | 926 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 12494862 | 12494862 | PRJNA1073183_P_NODE_1010_length_1169_cov_12.167883_g961_i0 | PRJNA1073183 | 1010 | 1169 | 12.167883 | 142.24255227 | Noelaerhabdaceae | 418966 | Haptophyta | other_Eukaryota | 2159 | 0 | NTclustered | gi|2530650642|gb|ON844104.1| | 2903 | g961 | i0 | 100 | 87.3447390932421 | 1169 | 0 | 100 | 0 | 1 | 1169 | 99662 | 100830 | Emiliania huxleyi strain CS-369 plastid, complete genome | blastn | 102106 | 2159 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 12494883 | 12494883 | PRJNA1073183_P_NODE_17710_length_311_cov_1.294118_g17615_i0 | PRJNA1073183 | 17710 | 311 | 1.294118 | 4.02470698 | Noelaerhabdaceae | 418966 | Haptophyta | other_Eukaryota | 575 | 1.3899999999999995e-159 | NTclustered | gi|39753085|gb|AY391395.1| | 2903 | g17615 | i0 | 100 | 78.4340836012862 | 311 | 0 | 100 | 0 | 1 | 311 | 553 | 863 | Emiliania huxleyi strain SAG 33.90 photosystem I P700 chlorophyll a apoprotein A2 (psaB) gene, partial cds; chloroplast | blastn | 24393 | 575 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 14215754 | 14215754 | PRJNA1073183_P_NODE_14032_length_346_cov_1.985348_g13937_i0 | PRJNA1073183 | 14032 | 346 | 1.985348 | 6.86930408 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 193 | 1.85e-44 | NTclustered | gi|551548842|ref|XM_005762007.1| | 280463 | g13937 | i0 | 80.632 | 56.7745664739884 | 253 | 45 | 73 | 2 | 12 | 262 | 151 | 401 | Emiliania huxleyi CCMP1516 hypothetical protein mRNA | blastn | 19644 | 193 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 16764041 | 16764041 | PRJNA1073183_P_NODE_17594_length_312_cov_1.288703_g17499_i0 | PRJNA1073183 | 17594 | 312 | 1.288703 | 4.02075336 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 569 | 6.509999999999998e-158 | NTclustered | gi|551564253|ref|XM_005768650.1| | 280463 | g17499 | i0 | 99.678 | 79.25 | 311 | 1 | 99 | 0 | 2 | 312 | 88 | 398 | Emiliania huxleyi CCMP1516 hypothetical protein mRNA | blastn | 24726 | 569 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 16764276 | 16764276 | PRJNA1073183_P_NODE_31394_length_245_cov_0.895349_g31299_i0 | PRJNA1073183 | 31394 | 245 | 0.895349 | 2.19360505 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 436 | 5.229999999999999e-118 | NTclustered | gi|551580016|ref|XM_005775510.1| | 280463 | g31299 | i0 | 98.776 | 5.3469387755102 | 245 | 3 | 100 | 0 | 1 | 245 | 515 | 759 | Emiliania huxleyi CCMP1516 hypothetical protein mRNA | blastn | 1310 | 436 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 17593885 | 17593885 | PRJNA1073183_P_NODE_4474_length_598_cov_1.173333_g4382_i0 | PRJNA1073183 | 4474 | 598 | 1.173333 | 7.01653134 | Noelaerhabdaceae | 418966 | Haptophyta | other_Eukaryota | 1105 | 0 | NTclustered | gi|2530650642|gb|ON844104.1| | 2903 | g4382 | i0 | 100 | 101.408026755853 | 598 | 0 | 100 | 0 | 1 | 598 | 95392 | 94795 | Emiliania huxleyi strain CS-369 plastid, complete genome | blastn | 60642 | 1105 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 18867630 | 18867630 | PRJNA1073183_P_NODE_1275_length_1061_cov_3.140688_g1217_i0 | PRJNA1073183 | 1275 | 1061 | 3.140688 | 33.32269968 | Noelaerhabdaceae | 418966 | Haptophyta | other_Eukaryota | 1960 | 0 | NTclustered | gi|2530650642|gb|ON844104.1| | 2903 | g1217 | i0 | 100 | 99.5004712535344 | 1061 | 0 | 100 | 0 | 1 | 1061 | 48886 | 47826 | Emiliania huxleyi strain CS-369 plastid, complete genome | blastn | 105570 | 1960 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 19313083 | 19313083 | PRJNA1073183_P_NODE_32576_length_243_cov_0.905882_g32481_i0 | PRJNA1073183 | 32576 | 243 | 0.905882 | 2.20129326 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 103 | 2.0499999999999999e-23 | NR | KOO20942.1 | 1460289 | g32481 | i0 | 58.5 | 3.03703703703704 | 82 | 32 | 100 | 2 | 243 | 1 | 297 | 377 | KOO20942.1 acid trehalase-like protein 1 [Chrysochromulina tobinii] | diamond | 738 | 103 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 19313121 | 19313121 | PRJNA1073183_P_NODE_34256_length_241_cov_0.916667_g34161_i0 | PRJNA1073183 | 34256 | 241 | 0.916667 | 2.20916747 | Emiliania huxleyi | 2903 | Haptophyta | other_Eukaryota | 446 | 8.519999999999999e-121 | NTclustered | gi|551580188|ref|XM_005775596.1| | 280463 | g34161 | i0 | 100 | 2.60165975103734 | 241 | 0 | 100 | 0 | 1 | 241 | 17040 | 17280 | Emiliania huxleyi CCMP1516 polyketide synthase (PKS3), partial mRNA | blastn | 627 | 446 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 21418115 | 21418115 | PRJNA1073183_P_NODE_23397_length_270_cov_1.172589_g23302_i0 | PRJNA1073183 | 23397 | 270 | 1.172589 | 3.1659903 | Noelaerhabdaceae | 418966 | Haptophyta | other_Eukaryota | 499 | 7.349999999999998e-137 | NTclustered | gi|2530650642|gb|ON844104.1| | 2903 | g23302 | i0 | 100 | 35.9 | 270 | 0 | 100 | 0 | 1 | 270 | 43495 | 43764 | Emiliania huxleyi strain CS-369 plastid, complete genome | blastn | 9693 | 499 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 22693052 | 22693052 | PRJNA1073183_P_NODE_3698_length_654_cov_1.987952_g3609_i0 | PRJNA1073183 | 3698 | 654 | 1.987952 | 13.00120608 | Noelaerhabdaceae | 418966 | Haptophyta | other_Eukaryota | 1208 | 0 | NTclustered | gi|2530650642|gb|ON844104.1| | 2903 | g3609 | i0 | 100 | 91.0107033639144 | 654 | 0 | 100 | 0 | 1 | 654 | 15488 | 16141 | Emiliania huxleyi strain CS-369 plastid, complete genome | blastn | 59521 | 1208 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 22693060 | 22693060 | PRJNA1073183_P_NODE_7758_length_458_cov_1.155844_g7664_i0 | PRJNA1073183 | 7758 | 458 | 1.155844 | 5.29376552 | Noelaerhabdaceae | 418966 | Haptophyta | other_Eukaryota | 841 | 0 | NTclustered | gi|2530650642|gb|ON844104.1| | 2903 | g7664 | i0 | 99.782 | 101.076419213974 | 458 | 1 | 100 | 0 | 1 | 458 | 93422 | 93879 | Emiliania huxleyi strain CS-369 plastid, complete genome | blastn | 46293 | 841 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 23968442 | 23968442 | PRJNA1073183_P_NODE_16239_length_324_cov_1.649402_g16144_i0 | PRJNA1073183 | 16239 | 324 | 1.649402 | 5.34406248 | Noelaerhabdaceae | 418966 | Haptophyta | other_Eukaryota | 599 | 8.67e-167 | NTclustered | gi|2530650642|gb|ON844104.1| | 2903 | g16144 | i0 | 100 | 38.5740740740741 | 324 | 0 | 100 | 0 | 1 | 324 | 13694 | 13371 | Emiliania huxleyi strain CS-369 plastid, complete genome | blastn | 12498 | 599 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 25242371 | 25242371 | PRJNA1073183_P_NODE_26740_length_251_cov_0.865169_g26645_i0 | PRJNA1073183 | 26740 | 251 | 0.865169 | 2.17157419 | Noelaerhabdaceae | 418966 | Haptophyta | other_Eukaryota | 464 | 2.47e-126 | NTclustered | gi|2530650642|gb|ON844104.1| | 2903 | g26645 | i0 | 100 | 43.4900398406375 | 251 | 0 | 100 | 0 | 1 | 251 | 6330 | 6580 | Emiliania huxleyi strain CS-369 plastid, complete genome | blastn | 10916 | 464 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi | |||
| 26932390 | 26932390 | PRJNA1073183_P_NODE_5082_length_563_cov_1.100000_g4989_i0 | PRJNA1073183 | 5082 | 563 | 1.1 | 6.193 | Diacronema | 70451 | Haptophyta | other_Eukaryota | 261 | 7.67e-84 | NR | KAJ1637874.1 | 483367 | g4989 | i0 | 69.8 | 2.01420959147425 | 189 | 55 | 99.6 | 2 | 562 | 2 | 30 | 218 | KAJ1637874.1 cytosolic fructose-1,6-bisphosphatase [Pavlovales sp. CCMP2436] | diamond | 1134 | 261 | 1 | Eukaryota | Haptista | Haptophyta | Pavlovophyceae | Pavlovales | Pavlovales sp. CCMP2436 | ||||
| 27920170 | 27920170 | PRJNA1073183_P_NODE_32105_length_244_cov_0.900585_g32010_i0 | PRJNA1073183 | 32105 | 244 | 0.900585 | 2.1974274 | Prymnesium parvum | 97485 | Haptophyta | other_Eukaryota | 84 | 5.51e-17 | NR | KAL1496500.1 | 97485 | g32010 | i0 | 55.1 | 0.959016393442623 | 78 | 32 | 95.9 | 1 | 243 | 10 | 160 | 234 | KAL1496500.1 hypothetical protein AB1Y20_016454 [Prymnesium parvum] | diamond | 234 | 84 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Prymnesiaceae | Prymnesium | Prymnesium parvum | |||
| 28078001 | 28078001 | PRJNA1073183_P_NODE_33565_length_242_cov_0.911243_g33470_i0 | PRJNA1073183 | 33565 | 242 | 0.911243 | 2.20520806 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 58.5 | 9.67e-8 | NR | KOO24027.1 | 1460289 | g33470 | i0 | 51.5 | 0.818181818181818 | 66 | 28 | 76.9 | 2 | 219 | 34 | 367 | 432 | KOO24027.1 cyanophycinase [Chrysochromulina tobinii] | diamond | 198 | 58.5 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 29688052 | 29688052 | PRJNA1073183_P_NODE_24130_length_265_cov_1.604167_g24035_i0 | PRJNA1073183 | 24130 | 265 | 1.604167 | 4.25104255 | Chrysochromulina tobinii | 1460289 | Haptophyta | other_Eukaryota | 147 | 7.79e-39 | NR | KOO30669.1 | 1460289 | g24035 | i0 | 72.6 | 0.950943396226415 | 84 | 23 | 95.1 | 0 | 3 | 254 | 227 | 310 | KOO30669.1 lysosomal alpha-mannosidase-like protein [Chrysochromulina tobinii] | diamond | 252 | 147 | 1 | Eukaryota | Haptista | Haptophyta | Prymnesiales | Chrysochromulinaceae | Chrysochromulina | Chrysochromulina tobinii | |||
| 30825628 | 30825628 | PRJNA1073183_P_NODE_15694_length_329_cov_10.035156_g15599_i0 | PRJNA1073183 | 15694 | 329 | 10.035156 | 33.01566324 | Emiliania huxleyi CCMP1516 | 280463 | Haptophyta | other_Eukaryota | 87 | 1.62e-19 | NR | XP_005782836.1 | 280463 | g15599 | i0 | 50 | 1.89665653495441 | 102 | 47 | 92.1 | 2 | 309 | 7 | 16 | 114 | XP_005782836.1 hypothetical protein EMIHUDRAFT_442529 [Emiliania huxleyi CCMP1516] | diamond | 624 | 87 | 1 | Eukaryota | Haptista | Haptophyta | Isochrysidales | Noelaerhabdaceae | Emiliania | Emiliania huxleyi |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;