RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA964500", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA964500 · 6 ✖

analysis 1

tax_kingdom 0

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
5093760 5093760 PRJNA964500_S_NODE_10764_length_181_cov_38.440789_g10672_i0 PRJNA964500 10764 181 38.440789 69.57782809 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 222 1.11e-53   NTclustered gi|82470151|gb|DQ243994.1| 356913 g10672 i0 92.405 87.3038674033149 158 9 87 3 2 158 1607 1452 Uncultured freshwater cercozoan clone PCG6AU2004 18S ribosomal RNA gene, partial sequence blastn 15802 222 1 Eukaryota Sar   Cercozoa         uncultured freshwater cercozoan
13695466 13695466 PRJNA964500_S_NODE_1691_length_368_cov_5.710914_g1599_i0 PRJNA964500 1691 368 5.710914 21.01616352 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 86.1 3.45e-12   NTclustered gi|238617602|gb|FJ973377.1| 188950 g1599 i0 91.935 8.08695652173913 62 4 29 1 1 62 2167 2227 Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence blastn 2976 86.1 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
14969778 14969778 PRJNA964500_S_NODE_3112_length_296_cov_41.142322_g3020_i0 PRJNA964500 3112 296 41.142322 121.78127312 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 246 1.1699999999999999e-60   NTclustered gi|238617605|gb|FJ973380.1| 45107 g3020 i0 84.733 108.358108108108 262 23 88 12 19 278 1415 1169 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 32074 246 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
14969803 14969803 PRJNA964500_S_NODE_7252_length_213_cov_8.081522_g7160_i0 PRJNA964500 7252 213 8.081522 17.21364186 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 167 6.419999999999999e-37   NTclustered gi|238617605|gb|FJ973380.1| 45107 g7160 i0 82.266 6.10328638497653 203 27 92 5 1 195 1672 1873 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 1300 167 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
14969804 14969804 PRJNA964500_S_NODE_732_length_489_cov_31.436957_g651_i0 PRJNA964500 732 489 31.436957 153.72671973 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 355 3.25e-93   NTclustered gi|88792583|gb|DQ386164.1| 372086 g651 i0 81.737 98.6646216768916 449 60 91 18 26 471 1947 1518 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 48247 355 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
18793638 18793638 PRJNA964500_S_NODE_5355_length_240_cov_44882.502370_g5263_i0 PRJNA964500 5355 240 44882.50237 107718.005688 Cercomonas lata 686763 SAR_Eukaryotes SAR_Eukaryotes 154 5.75e-33   NTclustered gi|262262874|gb|FJ797465.1| 686763 g5263 i0 88.8 50.325 125 14 52 0 57 181 406 282 Cercomonas lata strain C-85 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 12078 154 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas lata

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;