RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB82358 · 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
26590833 26590833 PRJEB82358_P_NODE_19561_length_235_cov_13.839506_g19550_i0 PRJEB82358 19561 235 13.839506 32.5228391 Botrytis porri 87229 Fungi Fungi 43.1 0.0144   NR XP_038771599.1 87229 g19550 i0 42.1 0.485106382978723 38 22 48.5 0 151 38 93 130 XP_038771599.1 uncharacterized protein EAF01_005258 [Botrytis porri] diamond 114 43.1 1 Eukaryota Opisthokonta Fungi Ascomycota Leotiomycetes Helotiales Sclerotiniaceae Botrytis Botrytis porri
29932428 29932428 PRJEB82358_P_NODE_20451_length_230_cov_2.942675_g20440_i0 PRJEB82358 20451 230 2.942675 6.7681525 Hypocreales 5125 Fungi Fungi 57.8 3.75e-8   NR KAG8422704.1 92637 g20440 i0 79.4 4.25217391304348 34 7 44.3 0 113 12 20 53 KAG8422704.1 hypothetical protein J3459_010130 [Metarhizium acridum] diamond 978 58.2 0.993127147766323 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Clavicipitaceae Metarhizium Metarhizium acridum
31202893 31202893 PRJEB82358_P_NODE_23995_length_196_cov_5.821138_g23984_i0 PRJEB82358 23995 196 5.821138 11.40943048 Paraphaeosphaeria sporulosa 1460663 Fungi Fungi 58.5 5.46e-8   NR KAK7177432.1 1460663 g23984 i0 53.8 0.795918367346939 52 24 79.6 0 2 157 423 474 KAK7177432.1 reverse transcriptase domain protein [Paraphaeosphaeria sporulosa] diamond 156 58.5 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Pleosporales Didymosphaeriaceae Paraphaeosphaeria Paraphaeosphaeria sporulosa

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