RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJEB7366" and tax_phylum = "Chytridiomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chytridiomycota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB7366 · 3 ✖

analysis 1

  • blastn · 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
135276 135276 PRJEB7366_P_NODE_3181_length_532_cov_4.315895_g2774_i0 PRJEB7366 3181 532 4.315895 22.9605614 Polychytrium aggregatum 110093 Fungi Fungi 372 3.53e-98   NTclustered gi|2432131711|ref|XM_053109357.1| 110093 g2774 i0 81.36 84.9116541353384 456 85 86 0 2 457 121 576 Polychytrium aggregatum calmodulin (BJ171DRAFT_488251), mRNA blastn 45173 372 1 Eukaryota Opisthokonta Fungi Chytridiomycota Chytridiomycetes Polychytriales   Polychytrium Polychytrium aggregatum
14163681 14163681 PRJEB7366_P_NODE_5632_length_377_cov_38.634503_g5199_i0 PRJEB7366 5632 377 38.634503 145.65207631 Fimicolochytrium jonesii 1396493 Fungi Fungi 128 5.8e-25   NTclustered gi|2432058563|ref|XM_053065718.1| 1396493 g5199 i0 79.558 2.19628647214854 181 35 48 2 103 282 80 259 Fimicolochytrium jonesii 40S ribosomal protein S28 (EV422DRAFT_248144), mRNA blastn 828 128 1 Eukaryota Opisthokonta Fungi Chytridiomycota Chytridiomycetes Spizellomycetales Powellomycetaceae Fimicolochytrium Fimicolochytrium jonesii
15437723 15437723 PRJEB7366_P_NODE_15893_length_195_cov_1.750000_g15459_i0 PRJEB7366 15893 195 1.75 3.4125 Fimicolochytrium jonesii 1396493 Fungi Fungi 62.1 2.8e-5   NTclustered gi|2432081773|ref|XM_053071924.1| 1396493 g15459 i0 100 16.0820512820513 33 0 17 0 162 194 1225 1257 Fimicolochytrium jonesii kinase-like domain-containing protein (EV422DRAFT_558227), mRNA blastn 3136 62.1 1 Eukaryota Opisthokonta Fungi Chytridiomycota Chytridiomycetes Spizellomycetales Powellomycetaceae Fimicolochytrium Fimicolochytrium jonesii

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