RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJEB55250" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 5 ✖

tax_clade 1

bioproject 1

  • PRJEB55250 · 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
7774169 7774169 PRJEB55250_P_NODE_15387_length_243_cov_1.358824_g15263_i0 PRJEB55250 15387 243 1.358824 3.30194232 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 449 6.65e-122   NTclustered gi|166044538|emb|CU367447.1| 100861 g15263 i0 100 222.131687242798 243 0 100 0 1 243 276 34 Aphanomyces euteiches cDNA blastn 53978 449 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
20522798 20522798 PRJEB55250_P_NODE_7197_length_282_cov_4.856459_g7073_i0 PRJEB55250 7197 282 4.856459 13.69521438 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 521 1.6499999999999996e-143   NTclustered gi|166044523|emb|CU367432.1| 100861 g7073 i0 100 98.1843971631206 282 0 100 0 1 282 88 369 Aphanomyces euteiches cDNA blastn 27688 521 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
27847958 27847958 PRJEB55250_P_NODE_15284_length_243_cov_1.811765_g15160_i0 PRJEB55250 15284 243 1.811765 4.40258895 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 67 9.91e-11   NR CAH0481103.1 622444 g15160 i0 47 2.71604938271605 66 35 81.5 0 46 243 136 201 CAH0481103.1 unnamed protein product [Peronospora belbahrii] diamond 660 67.4 0.99406528189911 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora belbahrii
31645268 31645268 PRJEB55250_P_NODE_14557_length_245_cov_0.895349_g14433_i0 PRJEB55250 14557 245 0.895349 2.19360505 Phytophthora fragariaefolia 1490495 SAR_Eukaryotes SAR_Eukaryotes 49.3 1.74e-4   NR GMF48238.1 1490495 g14433 i0 32.9 0.857142857142857 70 47 85.7 0 238 29 164 233 GMF48238.1 unnamed protein product [Phytophthora fragariaefolia] diamond 210 49.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora fragariaefolia
32814811 32814811 PRJEB55250_P_NODE_12180_length_250_cov_0.870056_g12056_i0 PRJEB55250 12180 250 0.870056 2.17514 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 80.5 2.09e-15   NR XP_009844359.1 112090 g12056 i0 60 4.524 80 27 90 2 11 235 527 606 XP_009844359.1 hsp70-like protein [Aphanomyces astaci] diamond 1131 80.5 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci

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