RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA385064" and tax_phylum = "Ascomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ascomycota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA385064 · 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
29191076 29191076 PRJNA385064_P_NODE_8029_length_161_cov_0.910714_g7904_i0 PRJNA385064 8029 161 0.910714 1.46624954 Lecanicillium sp. MT-2 1756136 Fungi Fungi 87.8 1.61e-18   NR KAK3187561.1 1964301 g7904 i0 84.9 0.987577639751553 53 8 98.8 0 159 1 1305 1357 KAK3187561.1 hypothetical protein K4F52_003619 [Lecanicillium sp. MT-2017a] diamond 159 87.8 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Cordycipitaceae Lecanicillium Lecanicillium sp. MT-2017a
29380416 29380416 PRJNA385064_P_NODE_8149_length_161_cov_0.910714_g8024_i0 PRJNA385064 8149 161 0.910714 1.46624954 Acrodontium crateriforme 150365 Fungi Fungi 48.9 8.08e-5   NR WPG98543.1 150365 g8024 i0 48.1 0.968944099378882 52 25 93.2 1 151 2 5 56 WPG98543.1 Hypothetical protein R9X50_00133500 [Acrodontium crateriforme] diamond 156 48.9 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Mycosphaerellales Teratosphaeriaceae Acrodontium Acrodontium crateriforme
31148990 31148990 PRJNA385064_P_NODE_5975_length_174_cov_0.896000_g5850_i0 PRJNA385064 5975 174 0.896 1.55904 Ascobolus immersus RN42 1160509 Fungi Fungi 41.6 0.0388   NR RPA76642.1 1160509 g5850 i0 43.8 0.827586206896552 48 25 82.8 1 168 25 329 374 RPA76642.1 hypothetical protein BJ508DRAFT_330893 [Ascobolus immersus RN42] diamond 144 41.6 1 Eukaryota Opisthokonta Fungi Ascomycota Pezizomycetes Pezizales Ascobolaceae Ascobolus Ascobolus immersus

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