contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA489308" and tax_phylum = "Cercozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1724827 | 1724827 | PRJNA489308_P_NODE_162_length_1595_cov_35.247043_g135_i1 | PRJNA489308 | 162 | 1595 | 35.247043 | 562.19033585 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1386 | 0 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g135 | i1 | 96.535 | 70.0557993730408 | 837 | 29 | 52 | 0 | 280 | 1116 | 1 | 837 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 111739 | 1386 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 1725040 | 1725040 | PRJNA489308_P_NODE_5862_length_438_cov_10.257534_g5786_i0 | PRJNA489308 | 5862 | 438 | 10.257534 | 44.92799892 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 429 | 1.67e-115 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g5786 | i0 | 86.902 | 51.648401826484 | 397 | 35 | 90 | 10 | 1 | 395 | 3658 | 4039 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 22622 | 429 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 5553865 | 5553865 | PRJNA489308_P_NODE_41125_length_209_cov_6.852941_g41049_i0 | PRJNA489308 | 41125 | 209 | 6.852941 | 14.32264669 | Thaumatomastix sp. CC002-Boundary Bay | 741090 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 7.889999999999998e-56 | NTclustered | gi|290760490|gb|GQ144693.1| | 741090 | g41049 | i0 | 86.957 | 100.531100478469 | 207 | 23 | 99 | 4 | 4 | 209 | 1794 | 1997 | Thaumatomastix sp. CC002-Boundary Bay large subunit ribosomal RNA gene, partial sequence | blastn | 21011 | 230 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomastix | Thaumatomastix sp. CC002-Boundary Bay | ||
| 5553905 | 5553905 | PRJNA489308_P_NODE_6165_length_429_cov_9.160112_g6089_i0 | PRJNA489308 | 6165 | 429 | 9.160112 | 39.29688048 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 619 | 9.05e-173 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g6089 | i0 | 92.774 | 100.310023310023 | 429 | 30 | 100 | 1 | 1 | 429 | 1186 | 1613 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 43033 | 619 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 6827929 | 6827929 | PRJNA489308_P_NODE_7046_length_406_cov_2.732733_g6970_i0 | PRJNA489308 | 7046 | 406 | 2.732733 | 11.09489598 | Bodomorpha sp. HFCC 92 | 458884 | SAR_Eukaryotes | SAR_Eukaryotes | 484 | 3.24e-132 | NTclustered | gi|197723521|gb|EF681900.2| | 458884 | g6970 | i0 | 99.254 | 89.0591133004926 | 268 | 2 | 66 | 0 | 1 | 268 | 268 | 1 | Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence | blastn | 36158 | 484 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 | |||
| 7476091 | 7476091 | PRJNA489308_P_NODE_18326_length_294_cov_2.773756_g18250_i0 | PRJNA489308 | 18326 | 294 | 2.773756 | 8.15484264 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 544 | 3.69e-150 | NTclustered | gi|225216798|gb|FJ176713.1| | 458884 | g18250 | i0 | 100 | 98.7108843537415 | 294 | 0 | 100 | 0 | 1 | 294 | 599 | 892 | Bodomorpha sp. HFCC92 18S ribosomal RNA gene, partial sequence | blastn | 29021 | 544 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 | |||
| 8103251 | 8103251 | PRJNA489308_P_NODE_1747_length_715_cov_23.900312_g1673_i0 | PRJNA489308 | 1747 | 715 | 23.900312 | 170.8872308 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1184 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g1673 | i0 | 96.528 | 56.3104895104895 | 720 | 17 | 99 | 7 | 3 | 715 | 1039 | 321 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 40262 | 1184 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 9378151 | 9378151 | PRJNA489308_P_NODE_8028_length_386_cov_5.022364_g7952_i0 | PRJNA489308 | 8028 | 386 | 5.022364 | 19.38632504 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 706 | 0 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g7952 | i0 | 99.741 | 86.160621761658 | 386 | 0 | 100 | 1 | 1 | 386 | 1319 | 1703 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 33258 | 706 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 10653997 | 10653997 | PRJNA489308_P_NODE_5249_length_459_cov_4.746114_g5173_i0 | PRJNA489308 | 5249 | 459 | 4.746114 | 21.78466326 | Bodomorpha sp. HFCC 92 | 458884 | SAR_Eukaryotes | SAR_Eukaryotes | 798 | 0 | NTclustered | gi|197723521|gb|EF681900.2| | 458884 | g5173 | i0 | 98.043 | 21.1851851851852 | 460 | 8 | 100 | 1 | 1 | 459 | 758 | 299 | Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence | blastn | 9724 | 798 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 | |||
| 14478828 | 14478828 | PRJNA489308_P_NODE_352_length_1285_cov_8.692244_g317_i0 | PRJNA489308 | 352 | 1285 | 8.692244 | 111.6953354 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1038 | 0 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g317 | i0 | 89.196 | 69.2 | 833 | 88 | 65 | 2 | 454 | 1285 | 837 | 6 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 88922 | 1038 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 14478869 | 14478869 | PRJNA489308_P_NODE_41212_length_201_cov_8.828125_g41136_i0 | PRJNA489308 | 41212 | 201 | 8.828125 | 17.74453125 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 8.02e-11 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g41136 | i0 | 97.826 | 21.2686567164179 | 46 | 1 | 41 | 0 | 156 | 201 | 2353 | 2398 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 4275 | 80.5 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 15753020 | 15753020 | PRJNA489308_P_NODE_9293_length_365_cov_6.184932_g9217_i0 | PRJNA489308 | 9293 | 365 | 6.184932 | 22.5750018 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 363 | 1.41e-95 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g9217 | i0 | 85.326 | 50.5452054794521 | 368 | 35 | 99 | 13 | 1 | 363 | 3669 | 4022 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 18449 | 363 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 17027620 | 17027620 | PRJNA489308_P_NODE_5994_length_434_cov_15.509695_g5918_i0 | PRJNA489308 | 5994 | 434 | 15.509695 | 67.3120763 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 758 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g5918 | i0 | 99.052 | 98.2764976958525 | 422 | 4 | 97 | 0 | 1 | 422 | 2677 | 3098 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 42652 | 758 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 19575910 | 19575910 | PRJNA489308_P_NODE_18316_length_294_cov_3.814480_g18240_i0 | PRJNA489308 | 18316 | 294 | 3.81448 | 11.2145712 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 7.42e-18 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g18240 | i0 | 75.397 | 13.8571428571429 | 252 | 43 | 85 | 11 | 45 | 294 | 4021 | 3787 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 4074 | 104 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 22126558 | 22126558 | PRJNA489308_P_NODE_158_length_1608_cov_31.633876_g135_i0 | PRJNA489308 | 158 | 1608 | 31.633876 | 508.67272608 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1386 | 0 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g135 | i0 | 96.535 | 69.443407960199 | 837 | 29 | 52 | 0 | 280 | 1116 | 1 | 837 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 111665 | 1386 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 22126773 | 22126773 | PRJNA489308_P_NODE_6058_length_432_cov_10.164345_g5982_i0 | PRJNA489308 | 6058 | 432 | 10.164345 | 43.9099704 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 586 | 9.239999999999998e-163 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g5982 | i0 | 91.224 | 100.564814814815 | 433 | 35 | 100 | 3 | 1 | 432 | 1198 | 1628 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 43444 | 586 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 22775124 | 22775124 | PRJNA489308_P_NODE_378_length_1254_cov_4.341236_g342_i0 | PRJNA489308 | 378 | 1254 | 4.341236 | 54.43909944 | Viridiraptoridae | 1435001 | SAR_Eukaryotes | SAR_Eukaryotes | 1009 | 0 | NTclustered | gi|302026150|gb|GQ377654.1| | 149084 | g342 | i0 | 89.233 | 68.0199362041467 | 808 | 85 | 64 | 2 | 45 | 851 | 395 | 1201 | Proleptomonas faecicola beta-tubulin (Btub) gene, partial cds | blastn | 85297 | 1009 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Proleptomonas | Proleptomonas faecicola | ||||
| 24676075 | 24676075 | PRJNA489308_P_NODE_120_length_1728_cov_13.511178_g101_i0 | PRJNA489308 | 120 | 1728 | 13.511178 | 233.47315584 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1544 | 0 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g101 | i0 | 97.872 | 72.4091435185185 | 893 | 19 | 52 | 0 | 495 | 1387 | 893 | 1 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 125123 | 1544 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 24676178 | 24676178 | PRJNA489308_P_NODE_24060_length_271_cov_1.555556_g23984_i0 | PRJNA489308 | 24060 | 271 | 1.555556 | 4.21555676 | Proleptomonas faecicola | 149084 | SAR_Eukaryotes | SAR_Eukaryotes | 381 | 2.789999999999999e-101 | NTclustered | gi|302026150|gb|GQ377654.1| | 149084 | g23984 | i0 | 92.481 | 53.7822878228782 | 266 | 20 | 98 | 0 | 1 | 266 | 882 | 617 | Proleptomonas faecicola beta-tubulin (Btub) gene, partial cds | blastn | 14575 | 381 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Proleptomonas | Proleptomonas faecicola |
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);;