RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA193544", tax_clade = "Amoebozoa" and tax_phylum = "Discosea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Discosea · 3 ✖

tax_clade 1

  • Amoebozoa · 3 ✖

bioproject 1

  • PRJNA193544 · 3 ✖

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
365892 365892 PRJNA193544_S_NODE_3141_length_157_cov_12.421875_g3126_i0 PRJNA193544 3141 157 12.421875 19.50234375 Vannella septentrionalis 197531 Discosea other_Eukaryota 274 2.54e-69   NTclustered gi|300078499|gb|GU001161.1| 197531 g3126 i0 98.089 43.2165605095541 157 3 100 0 1 157 866 1022 Vannella septentrionalis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 6785 274 1 Eukaryota Amoebozoa   Discosea Flabellinia   Vannellidae Vannella Vannella septentrionalis
2916530 2916530 PRJNA193544_S_NODE_1203_length_233_cov_3040.176471_g1188_i0 PRJNA193544 1203 233 3040.176471 7083.61117743 Vannella septentrionalis 197531 Discosea other_Eukaryota 305 1.45e-78   NTclustered gi|300078499|gb|GU001161.1| 197531 g1188 i0 96.721 11.9828326180258 183 6 79 0 1 183 2961 3143 Vannella septentrionalis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 2792 305 1 Eukaryota Amoebozoa   Discosea Flabellinia   Vannellidae Vannella Vannella septentrionalis
15668657 15668657 PRJNA193544_S_NODE_1133_length_240_cov_8.085308_g1118_i0 PRJNA193544 1133 240 8.085308 19.4047392 uncultured Vannellidae 544561 Discosea other_Eukaryota 394 3.11e-105   NTclustered gi|270381377|emb|FN598227.1| 544561 g1118 i0 97.414 89.3625 232 5 96 1 1 231 812 1043 Uncultured Vannellidae partial 18S rRNA gene, clone BIO1_A11 blastn 21447 394 1 Eukaryota Amoebozoa   Discosea Flabellinia   Vannellidae   uncultured Vannellidae

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