RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA1073005" 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

  • PRJNA1073005 · 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
10390281 10390281 PRJNA1073005_P_NODE_8869_length_253_cov_1.255556_g8750_i0 PRJNA1073005 8869 253 1.255556 3.17655668 Agaricomycetes 155619 Fungi Fungi 131 1.35e-36   NR KAI0313781.1 55340 g8750 i0 85.7 3.98418972332016 84 10 99.6 1 253 2 46 127 KAI0313781.1 histone-fold-containing protein [Amylostereum chailletii] diamond 1008 132 0.992424242424242 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Russulales Stereaceae Amylostereum Amylostereum chailletii
30785590 30785590 PRJNA1073005_P_NODE_6414_length_351_cov_1.107914_g6295_i0 PRJNA1073005 6414 351 1.107914 3.88877814 Tulasnella 5240 Fungi Fungi 191 2.13e-59   NR KAG8864261.1 2600220 g6295 i0 77.8 9.98290598290598 117 26 100 0 1 351 28 144 KAG8864261.1 60S ribosomal protein L15 [Tulasnella sp. 330] diamond 3504 192 0.994791666666667 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Cantharellales Tulasnellaceae Tulasnella Tulasnella sp. 330
31900685 31900685 PRJNA1073005_P_NODE_7937_length_285_cov_1.287736_g7818_i0 PRJNA1073005 7937 285 1.287736 3.6700476 Thelephora terrestris 56493 Fungi Fungi 49.7 2.23e-4   NR KAF9785898.1 56493 g7818 i0 59.4 0.631578947368421 32 13 33.7 0 281 186 627 658 KAF9785898.1 Metallo-peptidase family M12-domain-containing protein [Thelephora terrestris] diamond 180 49.7 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Thelephorales Thelephoraceae Thelephora Thelephora terrestris
31986982 31986982 PRJNA1073005_P_NODE_7938_length_285_cov_1.283019_g7819_i0 PRJNA1073005 7938 285 1.283019 3.65660415 Mycenaceae 2024004 Fungi Fungi 79.3 1.62e-15   NR GAT51362.1 658473 g7819 i0 40.5 6.18947368421053 84 50 88.4 0 5 256 100 183 GAT51362.1 tubulin beta chain [Mycena chlorophos] diamond 1764 79.3 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Agaricales Mycenaceae Mycena Mycena chlorophos
32714075 32714075 PRJNA1073005_P_NODE_9180_length_249_cov_1.721591_g9061_i0 PRJNA1073005 9180 249 1.721591 4.28676159 Ceratobasidiaceae 5250 Fungi Fungi 115 2.08e-28   NR ELU41693.1 983506 g9061 i0 66.3 9 83 28 100 0 249 1 86 168 ELU41693.1 60S ribosomal protein L3 [Rhizoctonia solani AG-1 IA] diamond 2241 115 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Cantharellales Ceratobasidiaceae Rhizoctonia Rhizoctonia solani

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