RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB8827" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 6 ✖

tax_clade 1

bioproject 1

  • PRJEB8827 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
25665497 25665497 PRJEB8827d_S_NODE_2266_length_194_cov_3279.364780_g2262_i0 PRJEB8827 2266 194 3279.36478 6361.9676732 Phytophthora citrophthora 4793 SAR_Eukaryotes SAR_Eukaryotes 79.7 1.61e-15   NR KAK1938198.1 4793 g2262 i0 70.9 0.850515463917526 55 16 85.1 0 2 166 161 215 KAK1938198.1 40S ribosomal protein S8 [Phytophthora citrophthora] diamond 165 79.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora citrophthora
26162048 26162048 PRJEB8827e_S_NODE_3653_length_234_cov_2.386935_g3625_i0 PRJEB8827 3653 234 2.386935 5.5854279 Aphanomyces cochlioides 112091 SAR_Eukaryotes SAR_Eukaryotes 115 3.45e-29   NR KAG9410527.1 112091 g3625 i0 85.7 0.897435897435897 70 9 88.5 1 208 2 202 271 KAG9410527.1 hypothetical protein AC1031_018567 [Aphanomyces cochlioides] diamond 210 115 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces cochlioides
26482644 26482644 PRJEB8827f_S_NODE_3200_length_246_cov_3.156398_g3180_i0 PRJEB8827 3200 246 3.156398 7.76473908 Viridiplantae 33090 SAR_Eukaryotes SAR_Eukaryotes 77.8 5.91e-16   NR TMW64892.1 41045 g3180 i0 77.8 12.4512195121951 45 10 54.9 0 1 135 104 148 TMW64892.1 hypothetical protein Poli38472_009059 [Pythium oligandrum] diamond 3063 78.2 0.994884910485933 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
33084994 33084994 PRJEB8827h_S_NODE_8342_length_194_cov_2.113208_g8323_i0 PRJEB8827 8342 194 2.113208 4.09962352 [Pythium] brassicae (nom. inval.) 1485010 SAR_Eukaryotes SAR_Eukaryotes 65.9 1.36e-10   NR TYZ57660.1 1485010 g8323 i0 70.5 1.36082474226804 44 13 68 0 193 62 730 773 TYZ57660.1 hypothetical protein PybrP1_012513 [[Pythium] brassicae (nom. inval.)] diamond 264 65.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium [Pythium] brassicae (nom. inval.)
33136171 33136171 PRJEB8827g_S_NODE_2287_length_214_cov_2.469274_g2266_i0 PRJEB8827 2287 214 2.469274 5.28424636 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 87 1.19e-18   NR YP_009327265.1 157072 g2266 i0 60.6 0.995327102803738 71 27 99.5 1 214 2 139 208 YP_009327265.1 hypothetical protein [Aphanomyces invadans] diamond 213 87 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
33169973 33169973 PRJEB8827d_S_NODE_1800_length_199_cov_1.439024_g1796_i0 PRJEB8827 1800 199 1.439024 2.86365776 Phytophthora aleatoria 2496075 SAR_Eukaryotes SAR_Eukaryotes 40.4 0.0469   NR KAG6962641.1 2496075 g1796 i0 73.7 0.28643216080402 19 5 28.6 0 182 126 89 107 KAG6962641.1 hypothetical protein JG688_00008501 [Phytophthora aleatoria] diamond 57 40.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora aleatoria

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