RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1009807", 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

  • PRJNA1009807 · 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
1001422 1001422 PRJNA1009807_S_NODE_781_length_335_cov_36.111486_g753_i0 PRJNA1009807 781 335 36.111486 120.9734781 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 93.5 1.86e-14   NTclustered gi|300078498|gb|GU001160.1| 5755 g753 i0 93.651 18.9283582089552 63 2 19 2 274 335 7629 7568 Acanthamoeba castellanii 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 6341 93.5 1 Eukaryota Amoebozoa   Discosea   Longamoebia Acanthamoebidae Acanthamoeba Acanthamoeba castellanii
9082272 9082272 PRJNA1009807_S_NODE_1868_length_226_cov_6.770053_g1840_i0 PRJNA1009807 1868 226 6.770053 15.30031978 Protacanthamoeba bohemica 325062 Discosea other_Eukaryota 412 8.01e-111   NTclustered gi|2806326584|gb|PQ345834.1| 325062 g1840 i0 99.558 64.8230088495575 226 1 100 0 1 226 472 247 Protacanthamoeba bohemica isolate 6FSb1 small subunit ribosomal RNA gene, partial sequence blastn 14650 412 1 Eukaryota Amoebozoa   Discosea   Longamoebia Acanthamoebidae Protacanthamoeba Protacanthamoeba bohemica
17579253 17579253 PRJNA1009807_S_NODE_2954_length_186_cov_9.462585_g2926_i0 PRJNA1009807 2954 186 9.462585 17.6004081 Acanthamoebidae 33677 Discosea other_Eukaryota 324 3.05e-84   NTclustered gi|2046610951|gb|MZ314579.1| 325062 g2926 i0 98.37 82.2043010752688 184 3 99 0 1 184 190 7 Protacanthamoeba bohemica isolate 157 small subunit ribosomal RNA gene, partial sequence blastn 15290 324 1 Eukaryota Amoebozoa   Discosea   Longamoebia Acanthamoebidae Protacanthamoeba Protacanthamoeba bohemica

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