RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB20058", tax_clade = "Amoebozoa" and tax_phylum = "Tubulinea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Tubulinea · 4 ✖

tax_clade 1

  • Amoebozoa · 4 ✖

bioproject 1

  • PRJEB20058 · 4 ✖

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
25924104 25924104 PRJEB20058_P_NODE_170708_length_286_cov_14.231111_g167885_i0 PRJEB20058 170708 286 14.231111 40.70097746 Rhizamoeba saxonica 200886 Tubulinea other_Eukaryota 152 2.53e-32   NTclustered gi|300078497|gb|GU001159.1| 200886 g167885 i0 79.149 38.7622377622378 235 38 79 11 1 226 1212 980 Rhizamoeba saxonica 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 11086 152 1 Eukaryota Amoebozoa   Tubulinea Elardia Leptomyxida Flabellulidae Rhizamoeba Rhizamoeba saxonica
26062398 26062398 PRJEB20058_P_NODE_227389_length_235_cov_3.275862_g224564_i0 PRJEB20058 227389 235 3.275862 7.6982757 Cryptodifflugia operculata 1078836 Tubulinea other_Eukaryota 370 5.12e-98   NTclustered gi|2651357777|gb|PP174294.1| 1078836 g224564 i0 96.444 64.468085106383 225 7 95 1 1 224 2611 2387 Cryptodifflugia operculata isolate 75 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 15150 370 1 Eukaryota Amoebozoa   Tubulinea Elardia Arcellinida Cryptodifflugiidae Cryptodifflugia Cryptodifflugia operculata
26199138 26199138 PRJEB20058_P_NODE_239582_length_216_cov_6.593548_g236757_i0 PRJEB20058 239582 216 6.593548 14.24206368 Copromyxa protea 931554 Tubulinea other_Eukaryota 372 1.29e-98   NTclustered gi|399764166|gb|JQ271677.1| 931554 g236757 i0 99.034 33.0833333333333 207 2 96 0 10 216 618 824 Copromyxa protea strain LUM 18S ribosomal RNA gene, partial sequence blastn 7146 372 1 Eukaryota Amoebozoa   Tubulinea Elardia Euamoebida Hartmannellidae Copromyxa Copromyxa protea
26333212 26333212 PRJEB20058_P_NODE_195583_length_259_cov_12.318182_g192759_i0 PRJEB20058 195583 259 12.318182 31.90409138 Rhizamoeba saxonica 200886 Tubulinea other_Eukaryota 84.2 8.36e-12   NTclustered gi|300078497|gb|GU001159.1| 200886 g192759 i0 78.261 0.532818532818533 138 24 53 5 62 197 4308 4175 Rhizamoeba saxonica 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 138 84.2 1 Eukaryota Amoebozoa   Tubulinea Elardia Leptomyxida Flabellulidae Rhizamoeba Rhizamoeba saxonica

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