RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA299585" and tax_phylum = "Ascomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ascomycota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA299585 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
9989860 9989860 PRJNA299585_S_NODE_10168_length_208_cov_20.301676_g9938_i0 PRJNA299585 10168 208 20.301676 42.22748608 root 1 Root_unresolved Root_unresolved 63.9 8.42e-6   NTclustered gi|2749703766|ref|XM_014090103.2| 63577 g9938 i0 85.714 1.24038461538462 63 6 30 1 146 208 2198 2257 Trichoderma atroviride uncharacterized protein (TrAtP1_012533), partial mRNA blastn 258 63.9 1 Eukaryota Opisthokonta Fungi Ascomycota Sordariomycetes Hypocreales Hypocreaceae Trichoderma Trichoderma atroviride
9989871 9989871 PRJNA299585_S_NODE_13348_length_170_cov_3.283688_g13118_i0 PRJNA299585 13348 170 3.283688 5.5822696 Dothideomycetes 147541 Fungi Fungi 311 2.12e-80   NTclustered gi|206597967|gb|FJ176833.1| 40221 g13118 i0 100 98.8352941176471 168 0 99 0 3 170 215 48 Symbiotaphrina kochii isolate AFTOL-ID 1902 18S small subunit ribosomal RNA gene, partial sequence blastn 16802 311 1 Eukaryota Opisthokonta Fungi Ascomycota   Symbiotaphrinales Symbiotaphrinaceae Symbiotaphrina Symbiotaphrina kochii
14404134 14404134 PRJNA299585_S_NODE_3632_length_462_cov_3.725173_g3195_i1 PRJNA299585 3632 462 3.725173 17.21029926 uncultured Ascomycota 175243 Fungi Fungi 678 0   NTclustered gi|313483124|gb|HQ433129.1| 175243 g3195 i1 99.73 78.6168831168831 370 1 80 0 1 370 335 704 Uncultured Ascomycota clone asc07192 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 36321 678 1 Eukaryota Opisthokonta Fungi Ascomycota         uncultured Ascomycota
18913146 18913146 PRJNA299585_S_NODE_15855_length_151_cov_2.254098_g15625_i0 PRJNA299585 15855 151 2.254098 3.40368798 root 1 Root_unresolved Root_unresolved 279 5.19e-71   NTclustered gi|1280049812|gb|MF072571.1| 29917 g15625 i0 100 100 151 0 100 0 1 151 705 555 Cladosporium cladosporioides strain 007 small subunit ribosomal RNA gene, partial sequence blastn 15100 279 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Cladosporiales Cladosporiaceae Cladosporium Cladosporium cladosporioides
22051705 22051705 PRJNA299585_S_NODE_3418_length_484_cov_4.778022_g3195_i0 PRJNA299585 3418 484 4.778022 23.12562648 uncultured Ascomycota 175243 Fungi Fungi 665 0   NTclustered gi|313483124|gb|HQ433129.1| 175243 g3195 i0 99.189 75.2190082644628 370 2 76 1 1 369 335 704 Uncultured Ascomycota clone asc07192 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 36406 665 1 Eukaryota Opisthokonta Fungi Ascomycota         uncultured Ascomycota

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