RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJEB49404" and tax_phylum = "Basidiomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Basidiomycota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB49404 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
27886347 27886347 PRJEB49404_P_NODE_435305_length_201_cov_1.518519_g421504_i0 PRJEB49404 435305 201 1.518519 3.05222319 Puccinia triticina 1-1 BBBD Race 1 630390 Fungi Fungi 138 5.69e-40   NR OAV84586.1 630390 g421504 i0 100 0.985074626865672 66 0 98.5 0 3 200 83 148 OAV84586.1 hypothetical protein PTTG_11626, partial [Puccinia triticina 1-1 BBBD Race 1] diamond 198 138 1 Eukaryota Opisthokonta Fungi Basidiomycota Pucciniomycetes Pucciniales Pucciniaceae Puccinia Puccinia triticina
28391562 28391562 PRJEB49404_P_NODE_442506_length_198_cov_3.786164_g428705_i0 PRJEB49404 442506 198 3.786164 7.49660472 Puccinia triticina 1-1 BBBD Race 1 630390 Fungi Fungi 134 4.84e-38   NR OAV84643.1 630390 g428705 i0 100 0.984848484848485 65 0 98.5 0 197 3 20 84 OAV84643.1 hypothetical protein PTTG_09483, partial [Puccinia triticina 1-1 BBBD Race 1] diamond 195 134 1 Eukaryota Opisthokonta Fungi Basidiomycota Pucciniomycetes Pucciniales Pucciniaceae Puccinia Puccinia triticina
28833594 28833594 PRJEB49404_P_NODE_578328_length_164_cov_0.984000_g564527_i0 PRJEB49404 578328 164 0.984 1.61376 Irpex lacteus 5319 Fungi Fungi 44.3 0.00188   NR KAI0747317.1 5319 g564527 i0 100 0.439024390243902 24 0 43.9 0 62 133 101 124 KAI0747317.1 hypothetical protein BC629DRAFT_210646 [Irpex lacteus] diamond 72 44.3 1 Eukaryota Opisthokonta Fungi Basidiomycota Agaricomycetes Polyporales Irpicaceae Irpex Irpex lacteus
28991809 28991809 PRJEB49404_P_NODE_539808_length_172_cov_1.383459_g526007_i0 PRJEB49404 539808 172 1.383459 2.37954948 Cystobasidium minutum MCA 421 29899 Fungi Fungi 57.4 3.25e-8   NR XP_066824345.1 1397322 g526007 i0 82.4 0.593023255813954 34 6 59.3 0 103 2 62 95 XP_066824345.1 uncharacterized protein P389DRAFT_208513 [Cystobasidium minutum MCA 4210] diamond 102 57.4 1 Eukaryota Opisthokonta Fungi Basidiomycota Cystobasidiomycetes Cystobasidiales Cystobasidiaceae Cystobasidium Cystobasidium minutum

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