RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJEB1404", tax_clade = "Amoebozoa" and tax_phylum = "Discosea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Discosea · 6 ✖

tax_clade 1

  • Amoebozoa · 6 ✖

bioproject 1

  • PRJEB1404 · 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
21112 21112 PRJEB1404_S_NODE_21_length_701_cov_58.421922_g10_i0 PRJEB1404 21 701 58.421922 409.53767322 Ripella sp. 805 1217113 Discosea other_Eukaryota 1000 0   NTclustered gi|399764202|gb|JQ271713.1| 1217113 g10 i0 94.876 91.6447931526391 644 25 92 6 50 691 638 1 Ripella sp. 805 18S ribosomal RNA gene, partial sequence blastn 64243 1000 1 Eukaryota Amoebozoa   Discosea Flabellinia   Vannellidae Ripella Ripella sp. 805
3847302 3847302 PRJEB1404_P_NODE_1964_length_248_cov_4.764977_g1938_i0 PRJEB1404 1964 248 4.764977 11.81714296 Ripella sp. GP2 1217115 Discosea other_Eukaryota 387 5.409999999999998e-103   NTclustered gi|399764204|gb|JQ271715.1| 1217115 g1938 i0 94.253 100.576612903226 261 2 100 2 1 248 649 389 Ripella sp. GP2 18S ribosomal RNA gene, partial sequence blastn 24943 387 1 Eukaryota Amoebozoa   Discosea Flabellinia   Vannellidae Ripella Ripella sp. GP2
11189055 11189055 PRJEB1404_S_NODE_4769_length_150_cov_1.739130_g4749_i0 PRJEB1404 4769 150 1.73913 2.608695 Ripella 1217112 Discosea other_Eukaryota 252 1.12e-62   NTclustered gi|2666517888|gb|PP258999.1| 1973050 g4749 i0 97.945 91.08 146 2 97 1 6 150 384 239 Ripella sp. strain CHIESE83/1 small subunit ribosomal RNA gene, partial sequence blastn 13662 252 1 Eukaryota Amoebozoa   Discosea Flabellinia   Vannellidae Ripella Ripella sp.
12774687 12774687 PRJEB1404_S_NODE_1611_length_242_cov_3.483092_g1591_i0 PRJEB1404 1611 242 3.483092 8.42908264 Vannella septentrionalis 197531 Discosea other_Eukaryota 414 2.41e-111   NTclustered gi|300078499|gb|GU001161.1| 197531 g1591 i0 97.521 73.3429752066116 242 6 100 0 1 242 1175 934 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 17749 414 1 Eukaryota Amoebozoa   Discosea Flabellinia   Vannellidae Vannella Vannella septentrionalis
21697813 21697813 PRJEB1404_S_NODE_1118_length_270_cov_5933.693617_g1098_i0 PRJEB1404 1118 270 5933.693617 16020.9727659 Ripella sp. GP2 1217115 Discosea other_Eukaryota 274 4.85e-69   NTclustered gi|399764204|gb|JQ271715.1| 1217115 g1098 i0 98.089 48.7592592592593 157 3 58 0 1 157 9 165 Ripella sp. GP2 18S ribosomal RNA gene, partial sequence blastn 13165 274 1 Eukaryota Amoebozoa   Discosea Flabellinia   Vannellidae Ripella Ripella sp. GP2
24246909 24246909 PRJEB1404_P_NODE_1800_length_258_cov_1.889868_g1774_i0 PRJEB1404 1800 258 1.889868 4.87585944 Ripella sp. GP2 1217115 Discosea other_Eukaryota 385 2.04e-102   NTclustered gi|399764204|gb|JQ271715.1| 1217115 g1774 i0 98.19 84.1937984496124 221 3 86 1 35 255 222 3 Ripella sp. GP2 18S ribosomal RNA gene, partial sequence blastn 21722 385 1 Eukaryota Amoebozoa   Discosea Flabellinia   Vannellidae Ripella Ripella sp. GP2

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