RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA881257" and tax_phylum = "Ascomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ascomycota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA881257 · 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
28034616 28034616 PRJNA881257_P_NODE_6165_length_295_cov_0.878049_g5920_i0 PRJNA881257 6165 295 0.878049 2.59024455 Morchella conica CCBAS932 1392247 Fungi Fungi 42.4 0.0222   NR RPB08999.1 1392247 g5920 i0 43.1 0.51864406779661 51 29 51.9 0 2 154 10 60 RPB08999.1 hypothetical protein P167DRAFT_608278 [Morchella conica CCBAS932] diamond 153 42.4 1 Eukaryota Opisthokonta Fungi Ascomycota Pezizomycetes Pezizales Morchellaceae Morchella Morchella conica
29297434 29297434 PRJNA881257_P_NODE_14869_length_168_cov_0.873950_g14624_i0 PRJNA881257 14869 168 0.87395 1.468236 Penicillium angulare 116970 Fungi Fungi 46.6 7.74e-5   NR XP_056779450.1 116970 g14624 i0 43.1 0.910714285714286 51 29 91.1 0 168 16 13 63 XP_056779450.1 uncharacterized protein N7478_005199 [Penicillium angulare] diamond 153 46.6 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Eurotiales Aspergillaceae Penicillium Penicillium angulare
31255990 31255990 PRJNA881257_P_NODE_14255_length_169_cov_0.866667_g14010_i0 PRJNA881257 14255 169 0.866667 1.46466723 Fusarium poae 36050 Fungi Fungi 41.6 0.0331   NR XP_044710256.1 36050 g14010 i0 51.4 1.81065088757396 37 18 65.7 0 54 164 123 159 XP_044710256.1 hypothetical protein FPOAC1_007076 [Fusarium poae] diamond 306 41.6 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Nectriaceae Fusarium Fusarium poae
32402923 32402923 PRJNA881257_P_NODE_8679_length_232_cov_1.508197_g8434_i0 PRJNA881257 8679 232 1.508197 3.49901704 Fungi 4751 Fungi Fungi 46.6 0.00147   NR TGZ81795.1 341454 g8434 i0 56.1 1.59051724137931 41 18 53 0 1 123 1332 1372 TGZ81795.1 P-loop containing nucleoside triphosphate hydrolase protein [Ascodesmis nigricans] diamond 369 47 0.991489361702128 Eukaryota Opisthokonta Fungi Ascomycota Pezizomycetes Pezizales Ascodesmidaceae Ascodesmis Ascodesmis nigricans

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