contig_metadata
15 rows where bioproject = "PRJNA674308" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 644548 | 644548 | PRJNA674308_P_NODE_19081_length_224_cov_1.782857_g18846_i0 | PRJNA674308 | 19081 | 224 | 1.782857 | 3.99359968 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 409 | 1.03e-109 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g18846 | i0 | 99.554 | 86.9464285714286 | 224 | 1 | 100 | 0 | 1 | 224 | 1917 | 1694 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 19476 | 409 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 644599 | 644599 | PRJNA674308_P_NODE_24801_length_200_cov_3.443709_g24566_i0 | PRJNA674308 | 24801 | 200 | 3.443709 | 6.887418 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 3.6e-29 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g24566 | i0 | 82.143 | 1.79 | 168 | 26 | 84 | 4 | 16 | 182 | 3878 | 4042 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 358 | 141 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 644874 | 644874 | PRJNA674308_P_NODE_6741_length_365_cov_10.120253_g6506_i0 | PRJNA674308 | 6741 | 365 | 10.120253 | 36.93892345 | Bodomorpha sp. HFCC 92 | 458884 | SAR_Eukaryotes | SAR_Eukaryotes | 628 | 1.2599999999999999e-175 | NTclustered | gi|197723521|gb|EF681900.2| | 458884 | g6506 | i0 | 97.802 | 1.99452054794521 | 364 | 8 | 99 | 0 | 1 | 364 | 349 | 712 | Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence | blastn | 728 | 628 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 | |||
| 3195833 | 3195833 | PRJNA674308_P_NODE_9263_length_313_cov_1.571970_g9028_i0 | PRJNA674308 | 9263 | 313 | 1.57197 | 4.9202661 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 579 | 1.0899999999999999e-160 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g9028 | i0 | 100 | 1 | 313 | 0 | 100 | 0 | 1 | 313 | 713 | 401 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 313 | 579 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 7023387 | 7023387 | PRJNA674308_P_NODE_27506_length_191_cov_5.859155_g27271_i0 | PRJNA674308 | 27506 | 191 | 5.859155 | 11.19098605 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 1.52e-57 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g27271 | i0 | 92.216 | 81.2356020942408 | 167 | 11 | 87 | 2 | 22 | 188 | 1473 | 1309 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 15516 | 235 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 14673983 | 14673983 | PRJNA674308_P_NODE_7252_length_353_cov_1.161184_g7017_i0 | PRJNA674308 | 7252 | 353 | 1.161184 | 4.09897952 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 501 | 2.76e-137 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g7017 | i0 | 92.33 | 0.997167138810198 | 352 | 27 | 99 | 0 | 2 | 353 | 18311 | 17960 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 352 | 501 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 15947469 | 15947469 | PRJNA674308_P_NODE_39213_length_168_cov_0.873950_g38978_i0 | PRJNA674308 | 39213 | 168 | 0.87395 | 1.468236 | Guttulinopsis rogosa | 2231170 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 9.81e-79 | NTclustered | gi|1402550485|gb|MH488771.1| | 2231170 | g38978 | i0 | 99.405 | 4 | 168 | 1 | 100 | 0 | 1 | 168 | 152 | 319 | Guttulinopsis rogosa isolate ATCC 50030 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 672 | 305 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Guttulinopsis | Guttulinopsis rogosa | ||||
| 17222767 | 17222767 | PRJNA674308_P_NODE_25174_length_199_cov_1.846667_g24939_i0 | PRJNA674308 | 25174 | 199 | 1.846667 | 3.67486733 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 2.65e-60 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g24939 | i0 | 92.857 | 72.2261306532663 | 168 | 12 | 84 | 0 | 1 | 168 | 1770 | 1937 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 14373 | 244 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 18496959 | 18496959 | PRJNA674308_P_NODE_14715_length_251_cov_24.009901_g14480_i0 | PRJNA674308 | 14715 | 251 | 24.009901 | 60.26485151 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 86.1 | 2.24e-12 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g14480 | i0 | 88.571 | 0.278884462151394 | 70 | 8 | 28 | 0 | 46 | 115 | 4021 | 3952 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 70 | 86.1 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 19018277 | 19018277 | PRJNA674308_P_NODE_30675_length_182_cov_2.345865_g30440_i0 | PRJNA674308 | 30675 | 182 | 2.345865 | 4.2694743 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 3.82e-88 | NTclustered | gi|225216798|gb|FJ176713.1| | 458884 | g30440 | i0 | 100 | 102.082417582418 | 182 | 0 | 100 | 0 | 1 | 182 | 304 | 123 | Bodomorpha sp. HFCC92 18S ribosomal RNA gene, partial sequence | blastn | 18579 | 337 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC 92 | |||
| 22321910 | 22321910 | PRJNA674308_P_NODE_16118_length_241_cov_2.484375_g15883_i0 | PRJNA674308 | 16118 | 241 | 2.484375 | 5.98734375 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 335 | 1.9199999999999993e-87 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g15883 | i0 | 92.34 | 0.975103734439834 | 235 | 18 | 98 | 0 | 7 | 241 | 253 | 19 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 235 | 335 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 23597454 | 23597454 | PRJNA674308_P_NODE_17899_length_230_cov_3.867403_g17664_i0 | PRJNA674308 | 17899 | 230 | 3.867403 | 8.8950269 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 344 | 3.0299999999999993e-90 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g17664 | i0 | 94.977 | 0.952173913043478 | 219 | 11 | 95 | 0 | 12 | 230 | 355 | 573 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 219 | 344 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 23597583 | 23597583 | PRJNA674308_P_NODE_3179_length_542_cov_5.298174_g2948_i0 | PRJNA674308 | 3179 | 542 | 5.298174 | 28.71610308 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 490 | 9.53e-134 | NTclustered | gi|756877536|ref|NC_026310.1| | 372086 | g2948 | i0 | 84.008 | 0.957564575645756 | 519 | 74 | 95 | 8 | 30 | 542 | 25686 | 25171 | Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome | blastn | 519 | 490 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 24871102 | 24871102 | PRJNA674308_P_NODE_6640_length_368_cov_4.485893_g6405_i0 | PRJNA674308 | 6640 | 368 | 4.485893 | 16.50808624 | Cercomonas sp. HFCC549 | 458874 | SAR_Eukaryotes | SAR_Eukaryotes | 652 | 0 | NTclustered | gi|161015714|gb|EF681948.1| | 458874 | g6405 | i0 | 98.641 | 23.1385869565217 | 368 | 5 | 100 | 0 | 1 | 368 | 282 | 649 | Cercomonas sp. HFCC549 28S ribosomal RNA gene, partial sequence | blastn | 8515 | 652 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. HFCC549 | |||
| 29197742 | 29197742 | PRJNA674308_P_NODE_49229_length_164_cov_0.886957_g48994_i0 | PRJNA674308 | 49229 | 164 | 0.886957 | 1.45460948 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 87.4 | 2.57e-21 | NR | MES1911722.1 | 1215613 | g48994 | i0 | 80.9 | 0.859756097560976 | 47 | 9 | 86 | 0 | 162 | 22 | 6 | 52 | MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 141 | 87.4 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM |
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);;