RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJDB14274" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 5 ✖

tax_clade 1

bioproject 1

  • PRJDB14274 · 5 ✖

analysis 1

  • blastn · 5 ✖

tax_kingdom 0

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
980943 980943 PRJDB14274_S_NODE_6481_length_248_cov_1.101604_g6403_i0 PRJDB14274 6481 248 1.101604 2.73197792 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 178 3.5499999999999993e-40   NTclustered gi|59894163|gb|AY729864.1| 74557 g6403 i0 79.918 27.5604838709677 244 47 98 2 6 248 958 1200 Thraustotheca clavata heat shock protein 90 gene, partial cds blastn 6835 178 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
6386870 6386870 PRJDB14274_S_NODE_8926_length_212_cov_1.483444_g8848_i0 PRJDB14274 8926 212 1.483444 3.14490128 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.019   NTclustered gi|698803785|ref|XM_009836620.1| 112090 g8848 i0 96.774 0.14622641509434 31 1 15 0 84 114 963 993 Aphanomyces astaci hypothetical protein mRNA blastn 31 52.8 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
16585361 16585361 PRJDB14274_S_NODE_1994_length_431_cov_2.789189_g1916_i0 PRJDB14274 1994 431 2.789189 12.02140459 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 244 6.39e-60   NTclustered gi|698807229|ref|XM_009838342.1| 112090 g1916 i0 80.119 66.0719257540603 337 59 77 4 102 431 441 106 Aphanomyces astaci polyubiquitin mRNA blastn 28477 244 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
17860386 17860386 PRJDB14274_S_NODE_3895_length_311_cov_1.332000_g3817_i0 PRJDB14274 3895 311 1.332 4.14252 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 165 3.58e-36   NTclustered gi|2795048880|ref|XM_067943659.1| 4785 g3817 i0 76.623 4.79742765273312 308 67 98 4 1 304 415 109 Phytophthora cinnamomi Calmodulin (IUM83_18649), partial mRNA blastn 1492 165 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
20107487 20107487 PRJDB14274_S_NODE_2736_length_370_cov_2.307443_g2658_i0 PRJDB14274 2736 370 2.307443 8.5375391 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 215 4.24e-51   NTclustered gi|673019759|ref|XM_008865619.1| 157072 g2658 i0 79.734 20.6486486486486 301 57 81 4 5 303 184 482 Aphanomyces invadans 40S ribosomal protein S23 mRNA blastn 7640 217 0.990783410138249 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans

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