RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJDB12578" and tax_phylum = "Ascomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ascomycota · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJDB12578 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
8930975 8930975 PRJDB12578_S_NODE_198108_length_167_cov_1.313559_g175050_i0 PRJDB12578 198108 167 1.313559 2.19364353 Ascomycota 4890 Fungi Fungi 103 1.84e-26   NR GMF83095.1 5477 g175050 i0 90.6 13.3652694610778 53 5 95.2 0 2 160 73 125 GMF83095.1 unnamed protein product [[Candida] boidinii] diamond 2232 104 0.990384615384615 Eukaryota Opisthokonta Fungi Ascomycota Pichiomycetes Pichiales Pichiaceae Ogataea [Candida] boidinii
26715436 26715436 PRJDB12578_S_NODE_144541_length_209_cov_0.968750_g121483_i0 PRJDB12578 144541 209 0.96875 2.0246875 Torulaspora globosa 48254 Fungi Fungi 45.1 0.00364   NR QLQ82424.1 48254 g121483 i0 37.5 0.688995215311005 48 30 68.9 0 38 181 403 450 QLQ82424.1 hypothetical protein HG537_0H01860 [Torulaspora globosa] diamond 144 45.1 1 Eukaryota Opisthokonta Fungi Ascomycota Saccharomycetes Saccharomycetales Saccharomycetaceae Torulaspora Torulaspora globosa
27532094 27532094 PRJDB12578_S_NODE_200703_length_166_cov_1.333333_g177645_i0 PRJDB12578 200703 166 1.333333 2.21333278 Opisthokonta 33154 Fungi Fungi 66.2 6.51e-11   NR KAI8397459.1 5507 g177645 i0 53.8 13.1385542168675 52 24 94 0 158 3 987 1038 KAI8397459.1 hypothetical protein FOFC_20731 [Fusarium oxysporum] diamond 2181 66.2 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Nectriaceae Fusarium Fusarium oxysporum
28074617 28074617 PRJDB12578_S_NODE_104125_length_279_cov_1.356522_g81067_i0 PRJDB12578 104125 279 1.356522 3.78469638 Fusarium oxysporum f. sp. cepae 396571 Fungi Fungi 43.1 0.0343   NR RKK14334.1 396571 g81067 i0 31.2 0.827956989247312 77 53 82.8 0 37 267 22 98 RKK14334.1 hypothetical protein BFJ65_g10899 [Fusarium oxysporum f. sp. cepae] diamond 231 43.1 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Nectriaceae Fusarium Fusarium oxysporum
31359728 31359728 PRJDB12578_S_NODE_183836_length_175_cov_1.238095_g160778_i0 PRJDB12578 183836 175 1.238095 2.16666625 Geotrichum candidum 1173061 Fungi Fungi 43.1 0.0113   NR KAF5106743.1 1173061 g160778 i0 40 0.942857142857143 55 33 94.3 0 166 2 933 987 KAF5106743.1 hypothetical protein DV453_003703 [Geotrichum candidum] diamond 165 43.1 1 Eukaryota Opisthokonta Fungi Ascomycota Dipodascomycetes Dipodascales Dipodascaceae Geotrichum Geotrichum candidum
32397823 32397823 PRJDB12578_S_NODE_148039_length_205_cov_1.333333_g124981_i0 PRJDB12578 148039 205 1.333333 2.73333265 Opisthokonta 33154 Fungi Fungi 48.1 2.77e-4   NR XP_070059957.1 5467 g124981 i0 57.9 2.85365853658537 38 12 55.6 1 27 140 321 354 XP_070059957.1 reverse transcriptase domain protein [Colletotrichum truncatum] diamond 585 48.5 0.991752577319588 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Glomerellales Glomerellaceae Colletotrichum Colletotrichum truncatum

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