RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA814235" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 20 ✖

tax_clade 1

bioproject 1

  • PRJNA814235 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
26936471 26936471 PRJNA814235_P_NODE_202922_length_150_cov_0.805310_g201527_i0 PRJNA814235 202922 150 0.80531 1.207965 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 79.7 1.46e-16   NR XP_024576250.1 4781 g201527 i0 73.5 19.6 49 13 98 0 149 3 114 162 XP_024576250.1 gag-pol polyprotein [Plasmopara halstedii] diamond 2940 79.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Plasmopara Plasmopara halstedii
27496862 27496862 PRJNA814235_P_NODE_161463_length_165_cov_2.007812_g160068_i0 PRJNA814235 161463 165 2.007812 3.3128898 Phytophthora cactorum 29920 SAR_Eukaryotes SAR_Eukaryotes 54.7 5.26e-7   NR KAG2766656.1 29920 g160068 i0 63 0.981818181818182 54 12 98.2 2 2 163 70 115 KAG2766656.1 hypothetical protein Pcac1_g21976 [Phytophthora cactorum] diamond 162 54.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cactorum
27843922 27843922 PRJNA814235_P_NODE_179604_length_153_cov_1.465517_g178209_i0 PRJNA814235 179604 153 1.465517 2.24224101 Peronospora effusa 542832 SAR_Eukaryotes SAR_Eukaryotes 53.5 1.08e-6   NR CAI5709023.1 542832 g178209 i0 77.4 0.607843137254902 31 7 60.8 0 45 137 17 47 CAI5709023.1 unnamed protein product [Peronospora effusa] diamond 93 53.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora effusa
28349188 28349188 PRJNA814235_P_NODE_101886_length_203_cov_2.361446_g100491_i0 PRJNA814235 101886 203 2.361446 4.79373538 Phytophthora cactorum 29920 SAR_Eukaryotes SAR_Eukaryotes 48.5 2.02e-4   NR KAG2769006.1 29920 g100491 i0 83.3 1.77339901477833 24 4 35.5 0 131 202 68 91 KAG2769006.1 Retrovirus-related Pol polyprotein from transposon TNT 1-94 [Phytophthora cactorum] diamond 360 48.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cactorum
28349195 28349195 PRJNA814235_P_NODE_115966_length_203_cov_1.909639_g114571_i0 PRJNA814235 115966 203 1.909639 3.87656717 Peronospora effusa 542832 SAR_Eukaryotes SAR_Eukaryotes 48.9 1.46e-4   NR RMX67547.1 542832 g114571 i0 95.8 0.354679802955665 24 1 35.5 0 201 130 189 212 RMX67547.1 hypothetical protein DD238_001577 [Peronospora effusa] diamond 72 48.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora effusa
28696802 28696802 PRJNA814235_P_NODE_168747_length_160_cov_1.495935_g167352_i0 PRJNA814235 168747 160 1.495935 2.393496 Peronospora destructor 86335 SAR_Eukaryotes SAR_Eukaryotes 74.7 4.33e-14   NR CAI5712945.1 86335 g167352 i0 78.3 0.8625 46 10 86.3 0 141 4 1 46 CAI5712945.1 unnamed protein product [Peronospora destructor] diamond 138 74.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora destructor
29391333 29391333 PRJNA814235_P_NODE_182409_length_151_cov_6.192982_g181014_i0 PRJNA814235 182409 151 6.192982 9.35140282 Peronospora effusa 542832 SAR_Eukaryotes SAR_Eukaryotes 47.8 1.74e-4   NR RQM15192.1 542832 g181014 i0 96 0.496688741721854 25 1 49.7 0 149 75 189 213 RQM15192.1 hypothetical protein DD237_002694 [Peronospora effusa] diamond 75 47.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora effusa
29431267 29431267 PRJNA814235_P_NODE_97609_length_203_cov_2.572289_g96214_i0 PRJNA814235 97609 203 2.572289 5.22174667 Peronospora 70742 SAR_Eukaryotes SAR_Eukaryotes 50.8 3.01e-5   NR CAI5725138.1 86335 g96214 i0 96 1.47783251231527 25 1 36.9 0 75 1 99 123 CAI5725138.1 unnamed protein product [Peronospora destructor] diamond 300 50.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora destructor
29864877 29864877 PRJNA814235_P_NODE_77571_length_216_cov_1.776536_g76176_i0 PRJNA814235 77571 216 1.776536 3.83731776 Peronospora farinosa 134698 SAR_Eukaryotes SAR_Eukaryotes 103 6.76e-24   NR CAI5732019.1 134698 g76176 i0 67.1 0.972222222222222 70 23 97.2 0 5 214 510 579 CAI5732019.1 unnamed protein product [Peronospora farinosa] diamond 210 103 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora farinosa
30189416 30189416 PRJNA814235_P_NODE_114612_length_203_cov_1.951807_g113217_i0 PRJNA814235 114612 203 1.951807 3.96216821 Peronospora 70742 SAR_Eukaryotes SAR_Eukaryotes 57.8 3.87e-8   NR CAI5744128.1 86335 g113217 i0 56.5 1.98029556650246 69 14 97.5 2 199 2 69 124 CAI5744128.1 unnamed protein product [Peronospora destructor] diamond 402 57.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora destructor
30307685 30307685 PRJNA814235_P_NODE_21452_length_412_cov_5.562667_g20089_i0 PRJNA814235 21452 412 5.562667 22.91818804 Phytophthora fragariae 53985 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0184   NR KAE9071848.1 53985 g20089 i0 25 0.815533980582524 112 78 80.1 2 358 29 1 108 KAE9071848.1 hypothetical protein PF006_g29063 [Phytophthora fragariae] diamond 336 43.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora fragariae
30686183 30686183 PRJNA814235_P_NODE_51813_length_265_cov_1.899123_g50419_i0 PRJNA814235 51813 265 1.899123 5.03267595 Peronospora destructor 86335 SAR_Eukaryotes SAR_Eukaryotes 68.6 2.03e-11   NR CAI5708120.1 86335 g50419 i0 60.3 0.656603773584906 58 23 65.7 0 61 234 192 249 CAI5708120.1 unnamed protein product [Peronospora destructor] diamond 174 68.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora destructor
30852945 30852945 PRJNA814235_P_NODE_103194_length_203_cov_2.307229_g101799_i0 PRJNA814235 103194 203 2.307229 4.68367487 root 1 Root_unresolved Root_unresolved 50.1 5.72e-5   NR DBA02169.1 4803 g101799 i0 88 2.21674876847291 25 3 36.9 0 76 2 585 609 DBA02169.1 TPA: hypothetical protein N0F65_004804, partial [Lagenidium giganteum] diamond 450 50.4 0.994047619047619 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
30907680 30907680 PRJNA814235_P_NODE_200354_length_150_cov_2.929204_g198959_i0 PRJNA814235 200354 150 2.929204 4.393806 Phytophthora cactorum 29920 SAR_Eukaryotes SAR_Eukaryotes 62.4 1.24e-9   NR KAG3190586.1 29920 g198959 i0 54 9 50 23 100 0 1 150 263 312 KAG3190586.1 hypothetical protein PC128_g11236 [Phytophthora cactorum] diamond 1350 62.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cactorum
31729426 31729426 PRJNA814235_P_NODE_143617_length_180_cov_2.916084_g142222_i0 PRJNA814235 143617 180 2.916084 5.2489512 Peronospora effusa 542832 SAR_Eukaryotes SAR_Eukaryotes 56.2 2.86e-8   NR UIZ27316.1 542832 g142222 i0 73.5 0.566666666666667 34 9 56.7 0 4 105 48 81 UIZ27316.1 hypothetical protein KXD40_005523 [Peronospora effusa] diamond 102 56.2 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora effusa
31824291 31824291 PRJNA814235_P_NODE_94457_length_203_cov_2.801205_g93062_i0 PRJNA814235 94457 203 2.801205 5.68644615 Peronospora effusa 542832 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00431   NR CAI5716890.1 542832 g93062 i0 87.5 1.41871921182266 24 3 35.5 0 199 128 97 120 CAI5716890.1 unnamed protein product [Peronospora effusa] diamond 288 44.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora effusa
31982472 31982472 PRJNA814235_P_NODE_152378_length_172_cov_3.155556_g150983_i0 PRJNA814235 152378 172 3.155556 5.42755632 Peronospora effusa 542832 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0314   NR RMX70347.1 542832 g150983 i0 84 0.872093023255814 25 4 43.6 0 78 152 148 172 RMX70347.1 hypothetical protein DD238_000195 [Peronospora effusa] diamond 150 41.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora effusa
32615241 32615241 PRJNA814235_P_NODE_82180_length_209_cov_4.069767_g80785_i0 PRJNA814235 82180 209 4.069767 8.50581303 Aphanomyces stellatus 120398 SAR_Eukaryotes SAR_Eukaryotes 124 5.47e-31   NR KAF0685876.1 120398 g80785 i0 77.9 4.83732057416268 68 15 97.6 0 1 204 119 186 KAF0685876.1 hypothetical protein As57867_022221, partial [Aphanomyces stellatus] diamond 1011 124 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
32709603 32709603 PRJNA814235_P_NODE_91600_length_203_cov_3.126506_g90205_i0 PRJNA814235 91600 203 3.126506 6.34680718 Peronospora farinosa 134698 SAR_Eukaryotes SAR_Eukaryotes 51.6 1.61e-5   NR CAH0488029.1 134698 g90205 i0 92 0.738916256157635 25 2 36.9 0 3 77 23 47 CAH0488029.1 unnamed protein product [Peronospora farinosa] diamond 150 51.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora farinosa
32907142 32907142 PRJNA814235_P_NODE_199980_length_150_cov_3.008850_g198585_i0 PRJNA814235 199980 150 3.00885 4.513275 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 48.9 6.82e-5   NR XP_067821236.1 4779 g198585 i0 87.5 44.5 24 3 48 0 78 149 454 477 XP_067821236.1 hypothetical protein CCR75_002187 [Bremia lactucae] diamond 6675 48.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Bremia Bremia lactucae

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