RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1085664" and tax_phylum = "Ascomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ascomycota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1085664 · 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
193542 193542 PRJNA1085664_S_NODE_26221_length_172_cov_5.224806_g25802_i0 PRJNA1085664 26221 172 5.224806 8.98666632 Ascoidea rubescens 54195 Fungi Fungi 60.2 8.62e-5   NTclustered gi|1147181152|ref|XM_020192680.1| 1344418 g25802 i0 94.737 0.22093023255814 38 2 22 0 96 133 2735 2772 Ascoidea rubescens DSM 1968 uncharacterized protein (ASCRUDRAFT_74425), mRNA blastn 38 60.2 1 Eukaryota Opisthokonta Fungi Ascomycota Saccharomycetes Ascoideales Ascoideaceae Ascoidea Ascoidea rubescens
17595118 17595118 PRJNA1085664_S_NODE_18934_length_200_cov_1.426752_g18515_i0 PRJNA1085664 18934 200 1.426752 2.853504 Mycosphaerellales 2726947 Fungi Fungi 318 1.55e-82   NTclustered gi|284159107|gb|GU214694.1| 438378 g18515 i0 95.5 100 200 7 100 1 1 200 4136 4333 Ramularia uredinicola strain CPC 10813 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 20000 318 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Mycosphaerellales Mycosphaerellaceae Ramularia Ramularia uredinicola
21870349 21870349 PRJNA1085664_S_NODE_18878_length_200_cov_2.248408_g18459_i0 PRJNA1085664 18878 200 2.248408 4.496816 Penicilliopsis zonata 41063 Fungi Fungi 110 1.02e-19   NTclustered gi|1249078766|ref|XM_022724715.1| 1073090 g18459 i0 87.368 6.79 95 12 48 0 7 101 197 291 Penicilliopsis zonata CBS 506.65 hypothetical protein (ASPZODRAFT_141064), partial mRNA blastn 1358 110 1 Eukaryota Opisthokonta Fungi Ascomycota Eurotiomycetes Eurotiales Aspergillaceae Penicilliopsis Penicilliopsis zonata

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