contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA743294" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 722116 | 722116 | PRJNA743294_P_NODE_45861_length_253_cov_3.438889_g45405_i0 | PRJNA743294 | 45861 | 253 | 3.438889 | 8.70038917 | Bodomorpha sp. Panama105 | 555789 | SAR_Eukaryotes | SAR_Eukaryotes | 468 | 1.92e-127 | NTclustered | gi|219524917|gb|EU709280.1| | 555789 | g45405 | i0 | 100 | 86.4189723320158 | 253 | 0 | 100 | 0 | 1 | 253 | 1621 | 1369 | Bodomorpha sp. Panama105 18S ribosomal RNA gene, partial sequence | blastn | 21864 | 468 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. Panama105 | |||
| 1998180 | 1998180 | PRJNA743294_P_NODE_5262_length_667_cov_2.627946_g4817_i0 | PRJNA743294 | 5262 | 667 | 2.627946 | 17.52839982 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 1072 | 0 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g4817 | i0 | 95.652 | 97.6911544227886 | 667 | 29 | 100 | 0 | 1 | 667 | 107 | 773 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 65160 | 1072 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 3273244 | 3273244 | PRJNA743294_P_NODE_14883_length_415_cov_13.295322_g14427_i0 | PRJNA743294 | 14883 | 415 | 13.295322 | 55.1755863 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 756 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g14427 | i0 | 99.518 | 101.332530120482 | 415 | 2 | 100 | 0 | 1 | 415 | 3091 | 2677 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 42053 | 756 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 3273300 | 3273300 | PRJNA743294_P_NODE_2243_length_976_cov_18.296788_g1928_i0 | PRJNA743294 | 2243 | 976 | 18.296788 | 178.57665088 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 65.8 | 1.27e-5 | NTclustered | gi|413965549|gb|AC254076.1| | 227086 | g1928 | i0 | 79.57 | 0.998975409836066 | 93 | 17 | 9 | 2 | 332 | 423 | 450 | 359 | Bigelowiella natans clone JGIFHCC-65K07, complete sequence | blastn | 975 | 65.8 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 3273347 | 3273347 | PRJNA743294_P_NODE_31063_length_299_cov_1.867257_g30607_i0 | PRJNA743294 | 31063 | 299 | 1.867257 | 5.58309843 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 4.2999999999999994e-55 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g30607 | i0 | 81.655 | 77.9130434782609 | 278 | 47 | 92 | 4 | 19 | 294 | 579 | 304 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 23296 | 228 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 3273603 | 3273603 | PRJNA743294_P_NODE_7783_length_562_cov_2.676892_g7328_i0 | PRJNA743294 | 7783 | 562 | 2.676892 | 15.04413304 | Rosculus vulgaris | 2231165 | SAR_Eukaryotes | SAR_Eukaryotes | 479 | 2.1399999999999993e-130 | NTclustered | gi|1402550474|gb|MH488760.1| | 2231165 | g7328 | i0 | 87.239 | 33.211743772242 | 431 | 41 | 76 | 6 | 5 | 430 | 2448 | 2869 | Rosculus vulgaris isolate CCA sequence | blastn | 18665 | 479 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus vulgaris | ||||
| 12677934 | 12677934 | PRJNA743294_P_NODE_41170_length_265_cov_2.989583_g40714_i0 | PRJNA743294 | 41170 | 265 | 2.989583 | 7.92239495 | Sandona | 1239209 | SAR_Eukaryotes | SAR_Eukaryotes | 490 | 4.3299999999999986e-134 | NTclustered | gi|2163362299|dbj|LC663795.1| | 563755 | g40714 | i0 | 100 | 99.9471698113207 | 265 | 0 | 100 | 0 | 1 | 265 | 603 | 867 | Sandona mutans Flagella An1019C gene for 18S rRNA, partial sequence | blastn | 26486 | 490 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Sandonidae | Sandona | Sandona mutans | |||
| 13476025 | 13476025 | PRJNA743294_P_NODE_49611_length_249_cov_1.329545_g49155_i0 | PRJNA743294 | 49611 | 249 | 1.329545 | 3.31056705 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 422 | 1.49e-113 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g49155 | i0 | 97.189 | 98.8433734939759 | 249 | 7 | 100 | 0 | 1 | 249 | 140 | 388 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 24612 | 422 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 14750820 | 14750820 | PRJNA743294_P_NODE_13252_length_438_cov_20.942466_g12796_i0 | PRJNA743294 | 13252 | 438 | 20.942466 | 91.72800108 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 6.19e-95 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g12796 | i0 | 83.871 | 53.8150684931507 | 403 | 39 | 91 | 19 | 1 | 398 | 3658 | 4039 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 23571 | 361 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 14750907 | 14750907 | PRJNA743294_P_NODE_26472_length_321_cov_1.540323_g26016_i0 | PRJNA743294 | 26472 | 321 | 1.540323 | 4.94443683 | Chlorarachniophyceae sp. | 2303673 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 6.07e-49 | NTclustered | gi|2071061694|gb|MZ611732.1| | 2303673 | g26016 | i0 | 79.479 | 62.1059190031153 | 307 | 51 | 95 | 12 | 6 | 309 | 664 | 961 | Chlorarachniophyceae sp. isolate AL-FL05 small subunit ribosomal RNA gene, partial sequence | blastn | 19936 | 207 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Chlorarachniophyceae sp. | |||||
| 16024765 | 16024765 | PRJNA743294_P_NODE_51993_length_246_cov_4.294798_g51537_i0 | PRJNA743294 | 51993 | 246 | 4.294798 | 10.56520308 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 5.68e-63 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g51537 | i0 | 85.433 | 48.1788617886179 | 254 | 25 | 100 | 7 | 1 | 246 | 1881 | 1632 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 11852 | 254 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 18573942 | 18573942 | PRJNA743294_P_NODE_60395_length_209_cov_10.426471_g59939_i0 | PRJNA743294 | 60395 | 209 | 10.426471 | 21.79132439 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 387 | 4.42e-103 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g59939 | i0 | 100 | 100.311004784689 | 209 | 0 | 100 | 0 | 1 | 209 | 828 | 1036 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 20965 | 387 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 21124752 | 21124752 | PRJNA743294_P_NODE_53217_length_245_cov_1.540698_g52761_i0 | PRJNA743294 | 53217 | 245 | 1.540698 | 3.7747101 | Rosculus cf. ithacus CCAP 1571/3 | 1808993 | SAR_Eukaryotes | SAR_Eukaryotes | 239 | 1.5799999999999998e-58 | NTclustered | gi|1002343692|gb|KU738570.1| | 1808993 | g52761 | i0 | 99.242 | 17.930612244898 | 132 | 1 | 54 | 0 | 1 | 132 | 1127 | 1258 | Rosculus cf. ithacus CCAP 1571/3 18S ribosomal RNA gene, partial sequence | blastn | 4393 | 239 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus cf. ithacus CCAP 1571/3 | ||||
| 22399538 | 22399538 | PRJNA743294_P_NODE_37098_length_277_cov_3.539216_g36642_i0 | PRJNA743294 | 37098 | 277 | 3.539216 | 9.80362832 | Cercomonas sp. HFCC500 | 458865 | SAR_Eukaryotes | SAR_Eukaryotes | 484 | 2.1199999999999996e-132 | NTclustered | gi|161015654|gb|EF666119.1| | 458865 | g36642 | i0 | 98.545 | 99.6462093862816 | 275 | 3 | 99 | 1 | 3 | 277 | 275 | 2 | Cercomonas sp. HFCC500 28S ribosomal RNA gene, partial sequence | blastn | 27602 | 484 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. HFCC500 | |||
| 22399654 | 22399654 | PRJNA743294_P_NODE_53858_length_244_cov_16.239766_g53402_i0 | PRJNA743294 | 53858 | 244 | 16.239766 | 39.62502904 | Eocercomonas perecta | 1043734 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 1.1299999999999999e-114 | NTclustered | gi|336245462|gb|HM536153.1| | 1043734 | g53402 | i0 | 98.354 | 99.4467213114754 | 243 | 3 | 99 | 1 | 1 | 243 | 227 | 468 | Eocercomonas perecta strain HFCC 908 18S ribosomal RNA gene, partial sequence | blastn | 24265 | 425 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Eocercomonas | Eocercomonas perecta | |||
| 23674864 | 23674864 | PRJNA743294_P_NODE_11059_length_476_cov_10.873449_g10603_i0 | PRJNA743294 | 11059 | 476 | 10.873449 | 51.75761724 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 765 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g10603 | i0 | 95.625 | 22.0819327731092 | 480 | 16 | 100 | 5 | 1 | 476 | 330 | 808 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 10511 | 765 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 23674912 | 23674912 | PRJNA743294_P_NODE_16339_length_398_cov_3.710769_g15883_i0 | PRJNA743294 | 16339 | 398 | 3.710769 | 14.76886062 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 680 | 0 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g15883 | i0 | 97.487 | 89.8793969849246 | 398 | 10 | 100 | 0 | 1 | 398 | 783 | 386 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 35772 | 680 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 24948704 | 24948704 | PRJNA743294_P_NODE_59800_length_223_cov_9.740000_g59344_i0 | PRJNA743294 | 59800 | 223 | 9.74 | 21.7202 | Cercomonas sp. C59 | 372078 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 3.04e-60 | NTclustered | gi|88792584|gb|DQ386165.1| | 372078 | g59344 | i0 | 86.58 | 80.4932735426009 | 231 | 19 | 99 | 8 | 3 | 223 | 2738 | 2510 | Cercomonas sp. C59 28S ribosomal RNA gene, partial sequence | blastn | 17950 | 244 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. C59 |
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);;