RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA795663" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

bioproject 1

  • PRJNA795663 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
28348676 28348676 PRJNA795663_S_NODE_6466_length_232_cov_2.446154_g6361_i0 PRJNA795663 6466 232 2.446154 5.67507728 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 55.1 7.7e-7   NR CEP01997.1 37360 g6361 i0 50 0.931034482758621 72 36 93.1 0 2 217 132 203 CEP01997.1 hypothetical protein PBRA_002262 [Plasmodiophora brassicae] diamond 216 55.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28569648 28569648 PRJNA795663_S_NODE_8587_length_206_cov_1.449704_g8482_i0 PRJNA795663 8587 206 1.449704 2.98639024 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 78.6 5.37e-15   NR CEO96163.1 37360 g8482 i0 71.4 1.48543689320388 49 14 71.4 0 204 58 206 254 CEO96163.1 hypothetical protein PBRA_004853 [Plasmodiophora brassicae] diamond 306 78.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28853679 28853679 PRJNA795663_S_NODE_11228_length_184_cov_2.006803_g11123_i0 PRJNA795663 11228 184 2.006803 3.69251752 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 91.3 2.7100000000000004e-21   NR CAG9318382.1 1481888 g11123 i0 60.7 0.994565217391304 61 24 99.5 0 183 1 65 125 CAG9318382.1 unnamed protein product [Blepharisma stoltei] diamond 183 91.3 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
32235480 32235480 PRJNA795663_S_NODE_13838_length_169_cov_2.015152_g13733_i0 PRJNA795663 13838 169 2.015152 3.40560688 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 79 2.77e-16   NR CEP01997.1 37360 g13733 i0 64.3 4.91715976331361 56 20 99.4 0 168 1 13 68 CEP01997.1 hypothetical protein PBRA_002262 [Plasmodiophora brassicae] diamond 831 79 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae

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