RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA401346" and tax_phylum = "Basidiomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Basidiomycota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA401346 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
28370245 28370245 PRJNA401346_P_NODE_6846_length_207_cov_0.876712_g6825_i0 PRJNA401346 6846 207 0.876712 1.81479384 Trametes polyzona 239206 Fungi Fungi 48.9 1.55e-4   NR KAI0629374.1 239206 g6825 i0 41.9 1.7536231884058 62 36 89.9 0 190 5 810 871 KAI0629374.1 ARM repeat-containing protein [Trametes polyzona] diamond 363 48.9 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Polyporales Polyporaceae Trametes Trametes polyzona
28654489 28654489 PRJNA401346_P_NODE_3087_length_293_cov_2.163793_g3066_i0 PRJNA401346 3087 293 2.163793 6.33991349 Auriculariales sp. MPI-PUGE-AT- 1916346 Fungi Fungi 55.1 3.14e-7   NR KAH7106003.1 2829486 g3066 i0 51.7 0.593856655290102 58 27 59.4 1 284 111 20 76 KAH7106003.1 hypothetical protein BKA62DRAFT_826399 [Auriculariales sp. MPI-PUGE-AT-0066] diamond 174 55.1 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Auriculariales     Auriculariales sp. MPI-PUGE-AT-0066
30233394 30233394 PRJNA401346_P_NODE_6432_length_209_cov_0.864865_g6411_i0 PRJNA401346 6432 209 0.864865 1.80756785 Cantharellus anzutake 1750568 Fungi Fungi 74.7 4.13e-14   NR XP_038917079.1 1750568 g6411 i0 54.4 0.976076555023923 68 27 97.6 1 207 4 181 244 XP_038917079.1 40S ribosomal protein S1 [Cantharellus anzutake] diamond 204 74.7 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Cantharellales Hydnaceae Cantharellus Cantharellus anzutake

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