contig_metadata
10 rows where bioproject = "PRJNA493632", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 464988 | 464988 | PRJNA493632_P_NODE_494841_length_253_cov_1.533333_g491402_i0 | PRJNA493632 | 494841 | 253 | 1.533333 | 3.87933249 | Cercomonas agilis | 310805 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 3.48e-70 | NTclustered | gi|58414956|gb|AY748813.1| | 310805 | g491402 | i0 | 86.747 | 159.221343873518 | 249 | 33 | 98 | 0 | 1 | 249 | 3 | 251 | Cercomonas agilis polyubiquitin (UBQ) gene, partial cds | blastn | 40283 | 278 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas agilis | |||
| 5572624 | 5572624 | PRJNA493632_P_NODE_735185_length_196_cov_4.788618_g731742_i0 | PRJNA493632 | 735185 | 196 | 4.788618 | 9.38569128 | Thaumatomonas sp. TMT002 | 407209 | SAR_Eukaryotes | SAR_Eukaryotes | 329 | 6.99e-86 | NTclustered | gi|116222192|gb|DQ980477.1| | 407209 | g731742 | i0 | 96.954 | 41.9081632653061 | 197 | 5 | 100 | 1 | 1 | 196 | 2813 | 2617 | Thaumatomonas sp. TMT002 large subunit ribosomal RNA gene, partial sequence | blastn | 8214 | 329 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. TMT002 | ||
| 6840283 | 6840283 | PRJNA493632_P_NODE_371666_length_278_cov_1.804878_g368227_i0 | PRJNA493632 | 371666 | 278 | 1.804878 | 5.01756084 | uncultured Cercozoa | 175275 | SAR_Eukaryotes | SAR_Eukaryotes | 407 | 4.74e-109 | NTclustered | gi|1002343676|gb|KU738554.1| | 175275 | g368227 | i0 | 99.552 | 2.44604316546763 | 223 | 1 | 80 | 0 | 1 | 223 | 223 | 1 | Uncultured Cercozoa clone goat_dung18 18S ribosomal RNA gene, partial sequence | blastn | 680 | 407 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 10662087 | 10662087 | PRJNA493632_P_NODE_125349_length_414_cov_94.293255_g121935_i0 | PRJNA493632 | 125349 | 414 | 94.293255 | 390.3740757 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 4.7e-66 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g121935 | i0 | 93.333 | 45.4033816425121 | 180 | 10 | 43 | 2 | 1 | 178 | 3659 | 3838 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 18797 | 265 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 17681791 | 17681791 | PRJNA493632_P_NODE_693974_length_229_cov_4.628205_g690533_i0 | PRJNA493632 | 693974 | 229 | 4.628205 | 10.59858945 | Imbricatea | 1736114 | SAR_Eukaryotes | SAR_Eukaryotes | 110 | 1.2e-19 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g690533 | i0 | 100 | 26.5851528384279 | 59 | 0 | 26 | 0 | 171 | 229 | 1697 | 1639 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 6088 | 110 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 20863138 | 20863138 | PRJNA493632_P_NODE_308557_length_292_cov_3.114155_g305118_i0 | PRJNA493632 | 308557 | 292 | 3.114155 | 9.0933326 | Thaumatomonas seravini | 188939 | SAR_Eukaryotes | SAR_Eukaryotes | 490 | 4.839999999999998e-134 | NTclustered | gi|161015724|gb|EF681958.1| | 188939 | g305118 | i0 | 96.928 | 100.33904109589 | 293 | 8 | 100 | 1 | 1 | 292 | 997 | 705 | Thaumatomonas seravini strain HFCC58 28S ribosomal RNA gene, partial sequence | blastn | 29299 | 490 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas seravini | ||
| 22781257 | 22781257 | PRJNA493632_P_NODE_709078_length_221_cov_5.520270_g705636_i0 | PRJNA493632 | 709078 | 221 | 5.52027 | 12.1997967 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 377 | 2.85e-100 | NTclustered | gi|1723854567|gb|MN323574.1| | 1937813 | g705636 | i0 | 99.048 | 94.1809954751131 | 210 | 2 | 95 | 0 | 4 | 213 | 315 | 106 | Uncultured Allapsidae clone OTU1700 small subunit ribosomal RNA gene, partial sequence | blastn | 20814 | 377 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | uncultured Allapsidae | ||||
| 25330242 | 25330242 | PRJNA493632_P_NODE_662740_length_240_cov_11.850299_g659299_i0 | PRJNA493632 | 662740 | 240 | 11.850299 | 28.4407176 | Thaumatomastigidae | 45098 | SAR_Eukaryotes | SAR_Eukaryotes | 435 | 1.83e-117 | NTclustered | gi|88792586|gb|DQ386167.1| | 188980 | g659299 | i0 | 99.17 | 97.4 | 241 | 1 | 100 | 1 | 1 | 240 | 1723 | 1963 | Thaumatomastix sp. ATCC 50250 28S ribosomal RNA gene, partial sequence | blastn | 23376 | 438 | 0.993150684931507 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomastix | Thaumatomastix sp. ATCC 50250 | ||
| 25330599 | 25330599 | PRJNA493632_P_NODE_723860_length_206_cov_15.030075_g720418_i0 | PRJNA493632 | 723860 | 206 | 15.030075 | 30.9619545 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.005 | NTclustered | gi|2915662025|gb|PV134890.1| | 1821257 | g720418 | i0 | 100 | 0.422330097087379 | 29 | 0 | 14 | 0 | 58 | 86 | 6255 | 6283 | Uncultured Endomyxa isolate IOM_2014_24 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 87 | 54.7 | 1 | Eukaryota | Sar | Cercozoa | uncultured Endomyxa | ||||||
| 29760715 | 29760715 | PRJNA493632_P_NODE_70931_length_523_cov_3.373333_g67580_i0 | PRJNA493632 | 70931 | 523 | 3.373333 | 17.64253159 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 177 | 8.84e-52 | NR | MES1911029.1 | 1215613 | g67580 | i0 | 53.8 | 3.90630975143403 | 169 | 72 | 94.6 | 2 | 2 | 496 | 128 | 294 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 2043 | 177 | 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);;