RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJEB27957" and tax_phylum = "Basidiomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Basidiomycota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB27957 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
26875273 26875273 PRJEB27957_P_NODE_38701_length_256_cov_1.405797_g38591_i0 PRJEB27957 38701 256 1.405797 3.59884032 Boletus coccyginus 1758874 Fungi Fungi 42.7 0.0386   NR KAI9570093.1 1758874 g38591 i0 39 0.69140625 59 31 63.3 1 36 197 92 150 KAI9570093.1 hypothetical protein HD554DRAFT_2170720 [Boletus coccyginus] diamond 177 42.7 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Boletales Boletaceae Boletus Boletus coccyginus
27033122 27033122 PRJEB27957_P_NODE_94682_length_176_cov_3.220472_g94572_i0 PRJEB27957 94682 176 3.220472 5.66803072 Crucibulum laeve 68775 Fungi Fungi 46.2 8.25e-4   NR TFK38387.1 68775 g94572 i0 40 0.852272727272727 50 30 85.2 0 167 18 48 97 TFK38387.1 hypothetical protein BDQ12DRAFT_630844, partial [Crucibulum laeve] diamond 150 46.2 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Agaricales Nidulariaceae Crucibulum Crucibulum laeve
27349498 27349498 PRJEB27957_P_NODE_45163_length_241_cov_1.333333_g45053_i0 PRJEB27957 45163 241 1.333333 3.21333253 Leucocoprinus birnbaumii 56174 Fungi Fungi 42.4 0.0496   NR KAJ3564268.1 56174 g45053 i0 48.8 0.535269709543568 43 21 52.3 1 128 3 217 259 KAJ3564268.1 hypothetical protein NP233_g8409 [Leucocoprinus birnbaumii] diamond 129 42.4 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Agaricales Agaricaceae Leucocoprinus Leucocoprinus birnbaumii
27381040 27381040 PRJEB27957_P_NODE_48943_length_233_cov_2.826087_g48833_i0 PRJEB27957 48943 233 2.826087 6.58478271 Leucoagaricus sp. SymC.cos 1714833 Fungi Fungi 45.1 0.00487   NR KXN92644.1 1714833 g48833 i0 44.7 0.489270386266094 38 21 48.9 0 12 125 312 349 KXN92644.1 O-methylsterigmatocystin oxidoreductase [Leucoagaricus sp. SymC.cos] diamond 114 45.1 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Agaricales Agaricaceae Leucoagaricus Leucoagaricus sp. SymC.cos
28927971 28927971 PRJEB27957_P_NODE_43348_length_245_cov_1.219388_g43238_i0 PRJEB27957 43348 245 1.219388 2.9875006 Chiua virens 1914213 Fungi Fungi 42.4 0.0435   NR KAG9316513.1 1914213 g43238 i0 34.7 0.6 49 31 58.8 1 229 86 140 188 KAG9316513.1 hypothetical protein JVU11DRAFT_2562 [Chiua virens] diamond 147 42.4 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Boletales Boletaceae Chiua Chiua virens

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