RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA1174770" and tax_phylum = "Ascomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ascomycota · 10 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1174770 · 10 ✖

analysis 1

  • blastn · 10 ✖
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
1040984 1040984 PRJNA1174770_P_NODE_2041_length_336_cov_1.432056_g1952_i0 PRJNA1174770 2041 336 1.432056 4.81170816 Ceratocystidaceae 1028423 Fungi Fungi 610 4.17e-170   NTclustered gi|940789774|gb|KR673893.1| 5158 g1952 i0 99.405 98.5208333333333 336 2 100 0 1 336 357 22 Ceratocystis fimbriata 18S small subunit ribosomal RNA gene, partial sequence blastn 33103 610 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Microascales Ceratocystidaceae Ceratocystis Ceratocystis fimbriata
3591494 3591494 PRJNA1174770_P_NODE_8363_length_168_cov_0.873950_g8274_i0 PRJNA1174770 8363 168 0.87395 1.468236 Penicillium 5073 Fungi Fungi 185 1.33e-42   NTclustered gi|2513219667|ref|XM_056706224.1| 5076 g8274 i0 100 4.43452380952381 100 0 60 0 69 168 579 480 Penicillium chrysogenum uncharacterized protein (N7489_000469), partial mRNA blastn 745 185 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Eurotiales Aspergillaceae Penicillium Penicillium chrysogenum
8693969 8693969 PRJNA1174770_P_NODE_5287_length_202_cov_0.947712_g5198_i0 PRJNA1174770 5287 202 0.947712 1.91437824 Ascomycota 4890 Fungi Fungi 364 1.99e-96   NTclustered gi|61676522|gb|AY856933.1| 43218 g5198 i0 99.5 99.019801980198 200 1 99 0 3 202 304 105 Tubeufia helicomyces strain CBS 271.52 18S ribosomal RNA gene, partial sequence blastn 20002 364 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Tubeufiales Tubeufiaceae Tubeufia Tubeufia helicomyces
8693978 8693978 PRJNA1174770_P_NODE_6607_length_182_cov_2.436090_g6518_i0 PRJNA1174770 6607 182 2.43609 4.4336838 Leotiomycetes 147548 Fungi Fungi 315 1.79e-81   NTclustered gi|1706880638|gb|MK357465.1| 52586 g6518 i0 97.814 100.478021978022 183 3 100 1 1 182 58 240 Erysiphe necator isolate PTM3 small subunit ribosomal RNA gene, partial sequence blastn 18287 315 1 Eukaryota Opisthokonta Fungi Ascomycota Leotiomycetes Erysiphales Erysiphaceae Erysiphe Erysiphe necator
8693982 8693982 PRJNA1174770_P_NODE_7407_length_173_cov_2.701613_g7318_i0 PRJNA1174770 7407 173 2.701613 4.67379049 Eukaryota 2759 Fungi Fungi 320 3.61e-83   NTclustered gi|1859418681|gb|MT640259.1| 157594 g7318 i0 100 99.9942196531792 173 0 100 0 1 173 951 1123 Erysiphe alphitoides isolate DM1081 large subunit ribosomal RNA gene, partial sequence blastn 17299 320 1 Eukaryota Opisthokonta Fungi Ascomycota Leotiomycetes Erysiphales Erysiphaceae Erysiphe Erysiphe alphitoides
10519925 10519925 PRJNA1174770_P_NODE_5569_length_197_cov_1.263514_g5480_i0 PRJNA1174770 5569 197 1.263514 2.48912258 Sordaria macrospora 5147 Fungi Fungi 281 2e-71   NTclustered gi|2749645277|ref|XR_010715268.1| 5147 g5480 i0 92.424 104.329949238579 198 13 100 2 1 197 1859 2055 Sordaria macrospora 28S ribosomal RNA (SMAC4_13380), rRNA blastn 20553 281 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Sordariales Sordariaceae Sordaria Sordaria macrospora
11244321 11244321 PRJNA1174770_P_NODE_7869_length_169_cov_1.250000_g7780_i0 PRJNA1174770 7869 169 1.25 2.1125 Erysiphaceae 34371 Fungi Fungi 313 5.859999999999999e-81   NTclustered gi|1152264121|gb|KY692193.1| 52586 g7780 i0 100 99.9881656804734 169 0 100 0 1 169 383 215 Erysiphe necator strain OID105 large subunit ribosomal RNA gene, partial sequence blastn 16898 313 1 Eukaryota Opisthokonta Fungi Ascomycota Leotiomycetes Erysiphales Erysiphaceae Erysiphe Erysiphe necator
15068660 15068660 PRJNA1174770_P_NODE_11212_length_163_cov_0.912281_g11123_i0 PRJNA1174770 11212 163 0.912281 1.48701803 Gnomoniaceae 218102 Fungi Fungi 302 1.22e-77   NTclustered gi|13540012|gb|AF277111.1|AF277111 148325 g11123 i0 100 99.9141104294479 163 0 100 0 1 163 795 633 Apioplagiostoma aceriferum small subunit ribosomal RNA gene, partial sequence blastn 16286 302 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Diaporthales Gnomoniaceae Apioplagiostoma Apioplagiostoma aceriferum
16893354 16893354 PRJNA1174770_P_NODE_2974_length_272_cov_2.049327_g2885_i0 PRJNA1174770 2974 272 2.049327 5.57416944 Coniochaeta hoffmannii 91930 Fungi Fungi 387 6.02e-103   NTclustered gi|1333183594|gb|MG491499.1| 91930 g2885 i0 92.308 118.242647058824 273 19 100 2 1 272 5342 5613 Coniochaeta hoffmannii strain CBS 245.38 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; and 28S-18S intergenic spacer, partial sequence blastn 32162 387 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Coniochaetales Coniochaetaceae Coniochaeta Coniochaeta hoffmannii
19442327 19442327 PRJNA1174770_P_NODE_8256_length_168_cov_0.873950_g8167_i0 PRJNA1174770 8256 168 0.87395 1.468236 Penicillium solitum 60172 Fungi Fungi 289 9.879999999999999e-74   NTclustered gi|2741398310|ref|XM_040952556.2| 60172 g8167 i0 97.619 12.5119047619048 168 4 100 0 1 168 1011 844 Penicillium solitum uncharacterized protein (N7455_012413), partial mRNA blastn 2102 289 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Eurotiales Aspergillaceae Penicillium Penicillium solitum

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