RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA682370" and tax_phylum = "Olpidiomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Olpidiomycota · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA682370 · 4 ✖

analysis 1

  • blastn · 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
664146 664146 PRJNA682370_S_NODE_11921_length_209_cov_2.793103_g11309_i0 PRJNA682370 11921 209 2.793103 5.83758527 Olpidium brassicae 70189 Fungi Fungi 291 3.57e-74   NTclustered gi|358030887|dbj|AB609177.1| 70189 g11309 i0 92.574 0.966507177033493 202 15 97 0 8 209 632 833 Olpidium brassicae EF2 mRNA for translation elongation factor 2, partial cds, specimen_voucher: UBC:UBC F19784, clone: 2 blastn 202 291 1 Eukaryota Opisthokonta Fungi Olpidiomycota Olpidiomycetes Olpidiales Olpidiaceae Olpidium Olpidium brassicae
5767733 5767733 PRJNA682370_S_NODE_10265_length_228_cov_2.093264_g9653_i0 PRJNA682370 10265 228 2.093264 4.77264192 Olpidium brassicae 70189 Fungi Fungi 228 3.1499999999999988e-55   NTclustered gi|358030887|dbj|AB609177.1| 70189 g9653 i0 90.643 66.8026315789474 171 16 75 0 3 173 1627 1797 Olpidium brassicae EF2 mRNA for translation elongation factor 2, partial cds, specimen_voucher: UBC:UBC F19784, clone: 2 blastn 15231 228 1 Eukaryota Opisthokonta Fungi Olpidiomycota Olpidiomycetes Olpidiales Olpidiaceae Olpidium Olpidium brassicae
13418294 13418294 PRJNA682370_S_NODE_2011_length_600_cov_2.849558_g1476_i0 PRJNA682370 2011 600 2.849558 17.097348 Olpidium brassicae 70189 Fungi Fungi 894 0   NTclustered gi|358030887|dbj|AB609177.1| 70189 g1476 i0 93.645 66.3816666666667 598 38 99 0 3 600 895 1492 Olpidium brassicae EF2 mRNA for translation elongation factor 2, partial cds, specimen_voucher: UBC:UBC F19784, clone: 2 blastn 39829 894 1 Eukaryota Opisthokonta Fungi Olpidiomycota Olpidiomycetes Olpidiales Olpidiaceae Olpidium Olpidium brassicae
18516534 18516534 PRJNA682370_S_NODE_4355_length_386_cov_2.569801_g3744_i0 PRJNA682370 4355 386 2.569801 9.91943186 Olpidium brassicae 70189 Fungi Fungi 516 1.09e-141   NTclustered gi|358030887|dbj|AB609177.1| 70189 g3744 i0 91.293 88.6165803108808 379 31 98 2 1 378 564 187 Olpidium brassicae EF2 mRNA for translation elongation factor 2, partial cds, specimen_voucher: UBC:UBC F19784, clone: 2 blastn 34206 516 1 Eukaryota Opisthokonta Fungi Olpidiomycota Olpidiomycetes Olpidiales Olpidiaceae Olpidium Olpidium brassicae

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