RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA816527" and tax_kingdom = "Fungi"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Fungi · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA816527 · 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
7605972 7605972 PRJNA816527_P_NODE_17926_length_248_cov_0.880000_g17876_i0 PRJNA816527 17926 248 0.88 2.1824 Opisthokonta 33154 Fungi Fungi 453 5.2600000000000005e-123   NTclustered gi|1546635598|ref|XR_003525370.1| 76775 g17876 i0 99.597 94.4395161290323 248 1 100 0 1 248 691 444 Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA blastn 23421 453 1 Eukaryota Opisthokonta Fungi Basidiomycota Malasseziomycetes Malasseziales Malasseziaceae Malassezia Malassezia restricta
17397713 17397713 PRJNA816527_P_NODE_14794_length_272_cov_2.020101_g14744_i0 PRJNA816527 14794 272 2.020101 5.49467472 Aspergillus fumigatus 746128 Fungi Fungi 121 6.749999999999999e-23   NTclustered gi|2279896920|gb|CP097565.1| 746128 g14744 i0 92.045 0.588235294117647 88 4 32 1 69 156 2556776 2556860 Aspergillus fumigatus CEA10 chromosome 3 blastn 160 121 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Eurotiales Aspergillaceae Aspergillus Aspergillus fumigatus
17397778 17397778 PRJNA816527_P_NODE_17054_length_250_cov_1.666667_g17004_i0 PRJNA816527 17054 250 1.666667 4.1666675 Loma acerinae 103443 Fungi Fungi 429 8.949999999999998e-116   NTclustered gi|7161819|emb|AJ252951.1| 103443 g17004 i0 97.61 100.72 251 5 100 1 1 250 610 860 Loma acerinae 16S rRNA gene blastn 25180 429 1 Eukaryota Opisthokonta Fungi Microsporidia     Glugeidae Loma Loma acerinae

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