contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA876641" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8506190 | 8506190 | PRJNA876641_P_NODE_2447_length_453_cov_1.181579_g2373_i0 | PRJNA876641 | 2447 | 453 | 1.181579 | 5.35255287 | Thaumatomastix sp. NIES-2378 | 717846 | SAR_Eukaryotes | SAR_Eukaryotes | 388 | 2.95e-103 | NTclustered | gi|302563030|dbj|AB546338.1| | 717846 | g2373 | i0 | 82.34 | 52.6887417218543 | 453 | 66 | 98 | 11 | 8 | 453 | 277 | 722 | Thaumatomastix sp. NIES-2378 EFL mRNA for elongation factor like, partial cds | blastn | 23868 | 388 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomastix | Thaumatomastix sp. NIES-2378 | ||
| 8506279 | 8506279 | PRJNA876641_P_NODE_8227_length_294_cov_2.090498_g8153_i0 | PRJNA876641 | 8227 | 294 | 2.090498 | 6.14606412 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 252 | 2.51e-62 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g8153 | i0 | 82.886 | 48.4761904761905 | 298 | 34 | 100 | 12 | 1 | 294 | 3701 | 3985 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 14252 | 252 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 12332284 | 12332284 | PRJNA876641_P_NODE_20210_length_245_cov_0.895349_g20136_i0 | PRJNA876641 | 20210 | 245 | 0.895349 | 2.19360505 | Thaumatomonas sp. TMT002 | 407209 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 1.2e-74 | NTclustered | gi|193875699|gb|EU812202.1| | 407209 | g20136 | i0 | 88.163 | 70.5183673469388 | 245 | 29 | 100 | 0 | 1 | 245 | 267 | 23 | Thaumatomonas sp. TMT002 clone tshsp70-1 70 kDa heat shock protein mRNA, partial cds | blastn | 17277 | 292 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. TMT002 | ||
| 19979850 | 19979850 | PRJNA876641_P_NODE_18856_length_247_cov_0.885057_g18782_i0 | PRJNA876641 | 18856 | 247 | 0.885057 | 2.18609079 | uncultured Cercozoa | 175275 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 1.14e-114 | NTclustered | gi|512134091|gb|KC575315.1| | 175275 | g18782 | i0 | 97.59 | 100.611336032389 | 249 | 4 | 100 | 2 | 1 | 247 | 49 | 297 | Uncultured cercozoan clone A.3.2 18S ribosomal RNA gene, partial sequence | blastn | 24851 | 425 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 22530057 | 22530057 | PRJNA876641_P_NODE_7738_length_302_cov_1.772926_g7664_i0 | PRJNA876641 | 7738 | 302 | 1.772926 | 5.35423652 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 1.97e-73 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g7664 | i0 | 84.868 | 12.0695364238411 | 304 | 26 | 99 | 11 | 3 | 302 | 4009 | 3722 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 3645 | 289 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 23805416 | 23805416 | PRJNA876641_P_NODE_22679_length_242_cov_0.911243_g22605_i0 | PRJNA876641 | 22679 | 242 | 0.911243 | 2.20520806 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 3.42e-45 | NTclustered | gi|300676720|gb|GQ377713.1| | 323453 | g22605 | i0 | 87.952 | 15.4132231404959 | 166 | 18 | 68 | 2 | 2 | 166 | 158 | 322 | Heteromita sp. PRA-74 gcr5-like mRNA, partial sequence | blastn | 3730 | 195 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 25079413 | 25079413 | PRJNA876641_P_NODE_840_length_694_cov_1.383253_g770_i0 | PRJNA876641 | 840 | 694 | 1.383253 | 9.59977582 | Cercomonas sp. ATCC 50316 | 45110 | SAR_Eukaryotes | SAR_Eukaryotes | 311 | 1.04e-79 | NTclustered | gi|27734378|gb|AY099144.1| | 45110 | g770 | i0 | 92.237 | 166.276657060519 | 219 | 17 | 32 | 0 | 412 | 630 | 427 | 209 | Cercomonas ATCC50316 isolate pub6 polyubiquitin gene, partial cds | blastn | 115396 | 311 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. ATCC 50316 | |||
| 25465166 | 25465166 | PRJNA876641_P_NODE_21920_length_243_cov_0.905882_g21846_i0 | PRJNA876641 | 21920 | 243 | 0.905882 | 2.20129326 | Thaumatomonas | 45099 | SAR_Eukaryotes | SAR_Eukaryotes | 444 | 3.09e-120 | NTclustered | gi|33309605|gb|AF411259.1| | 188939 | g21846 | i0 | 99.588 | 99.4979423868313 | 243 | 1 | 100 | 0 | 1 | 243 | 1614 | 1372 | Thaumatomonas seravini 18S ribosomal RNA gene, complete sequence | blastn | 24178 | 444 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas seravini |
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);;