RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA699078", tax_clade = "Sar" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 13 ✖

tax_clade 1

  • Sar · 13 ✖

bioproject 1

  • PRJNA699078 · 13 ✖

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
19809231 19809231 PRJNA699078_S_NODE_48696_length_245_cov_3.474490_g47747_i0 PRJNA699078 48696 245 3.47449 8.5125005 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 152 2.12e-32   NTclustered gi|813141452|ref|XM_012343573.1| 695850 g47747 i0 78.632 31.3387755102041 234 47 96 2 8 241 686 456 Saprolegnia parasitica CBS 223.65 60S ribosomal protein L8 mRNA blastn 7678 152 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
26682350 26682350 PRJNA699078_S_NODE_39221_length_276_cov_1.832599_g38272_i0 PRJNA699078 39221 276 1.832599 5.05797324 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 51.6 4.19e-5   NR KAF0733593.1 100861 g38272 i0 48.1 8.14130434782609 54 23 58.7 1 107 268 289 337 KAF0733593.1 hypothetical protein Ae201684_009527 [Aphanomyces euteiches] diamond 2247 52 0.992307692307692 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
27777825 27777825 PRJNA699078_S_NODE_9624_length_485_cov_29.548165_g8718_i0 PRJNA699078 9624 485 29.548165 143.30860025 Lagenidium giganteum 4803 SAR_Eukaryotes SAR_Eukaryotes 141 1.84e-38   NR DAZ97987.1 4803 g8718 i0 53.4 10.1072164948454 148 68 91.5 1 482 39 65 211 DAZ97987.1 TPA: hypothetical protein N0F65_005145 [Lagenidium giganteum] diamond 4902 141 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
28787850 28787850 PRJNA699078_S_NODE_109347_length_157_cov_2.388889_g108398_i0 PRJNA699078 109347 157 2.388889 3.75055573 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 51.6 6.82e-6   NR XP_009843886.1 112090 g108398 i0 47.1 0.974522292993631 51 27 97.5 0 3 155 151 201 XP_009843886.1 hypothetical protein H257_16960 [Aphanomyces astaci] diamond 153 51.6 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
30082546 30082546 PRJNA699078_S_NODE_49712_length_243_cov_1.041237_g48763_i0 PRJNA699078 49712 243 1.041237 2.53020591 Phytophthora capsici 4784 SAR_Eukaryotes SAR_Eukaryotes 55.1 1.18e-6   NR KAG1689153.1 4784 g48763 i0 41.7 1.48148148148148 60 35 74.1 0 8 187 110 169 KAG1689153.1 hypothetical protein DVH05_002791 [Phytophthora capsici] diamond 360 55.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
30125295 30125295 PRJNA699078_S_NODE_100672_length_167_cov_0.881356_g99723_i0 PRJNA699078 100672 167 0.881356 1.47186452 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00108   NR KAF0697373.1 120398 g99723 i0 44.9 1.92215568862275 49 22 88 1 161 15 147 190 KAF0697373.1 hypothetical protein As57867_011880 [Aphanomyces stellatus] diamond 321 45.8 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
30272591 30272591 PRJNA699078_S_NODE_30952_length_310_cov_1.593870_g30003_i0 PRJNA699078 30952 310 1.59387 4.940997 Lagenidium giganteum 4803 SAR_Eukaryotes SAR_Eukaryotes 117 3.81e-28   NR DBA04048.1 4803 g30003 i0 53.4 1.90645161290323 103 48 99.7 0 2 310 1154 1256 DBA04048.1 TPA: hypothetical protein N0F65_009395 [Lagenidium giganteum] diamond 591 117 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
30599301 30599301 PRJNA699078_S_NODE_16293_length_403_cov_4.799435_g15350_i0 PRJNA699078 16293 403 4.799435 19.34172305 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 73.2 4.18e-12   NR XP_009823393.1 112090 g15350 i0 36.8 2.29280397022332 106 65 78.2 2 3 317 272 376 XP_009823393.1 CMGC/MAPK protein kinase [Aphanomyces astaci] diamond 924 73.6 0.994565217391304 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
31062440 31062440 PRJNA699078_S_NODE_79855_length_188_cov_1.266187_g78906_i0 PRJNA699078 79855 188 1.266187 2.38043156 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0173   NR GLE01710.1 114742 g78906 i0 86.4 0.702127659574468 22 3 35.1 0 174 109 255 276 GLE01710.1 hypothetical protein PINS_up010544 [Pythium insidiosum] diamond 132 42.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
31357999 31357999 PRJNA699078_S_NODE_30216_length_313_cov_3.742424_g29267_i0 PRJNA699078 30216 313 3.742424 11.71378712 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 121 3.1599999999999997e-32   NR KAG2835771.1 29920 g29267 i0 63.1 14.2811501597444 103 33 93.9 1 311 18 97 199 KAG2835771.1 hypothetical protein PC111_g5317 [Phytophthora cactorum] diamond 4470 121 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cactorum
31769012 31769012 PRJNA699078_S_NODE_24177_length_346_cov_3.585859_g23228_i0 PRJNA699078 24177 346 3.585859 12.40707214 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 63.2 4.55e-9   NR KAF0691976.1 120398 g23228 i0 40.6 2.07225433526012 69 41 59.8 0 47 253 165 233 KAF0691976.1 hypothetical protein As57867_016824 [Aphanomyces stellatus] diamond 717 63.5 0.995275590551181 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
32232734 32232734 PRJNA699078_S_NODE_978_length_1179_cov_4.553982_g638_i0 PRJNA699078 978 1179 4.553982 53.69144778 Bremia lactucae 4779 SAR_Eukaryotes SAR_Eukaryotes 67.4 6.06e-8   NR XP_067820846.1 4779 g638 i0 40.4 0.27735368956743 109 62 27.5 2 1095 772 807 913 XP_067820846.1 hypothetical protein CCR75_003514 [Bremia lactucae] diamond 327 67.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Bremia Bremia lactucae
32264376 32264376 PRJNA699078_S_NODE_54038_length_232_cov_1.442623_g53089_i0 PRJNA699078 54038 232 1.442623 3.34688536 Globisporangium splendens 82926 SAR_Eukaryotes SAR_Eukaryotes 47.4 7.37e-4   NR KAF1331364.1 82926 g53089 i0 37.9 0.853448275862069 66 35 82.8 2 39 230 312 373 KAF1331364.1 Tkl protein kinase, partial [Globisporangium splendens] diamond 198 47.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium Globisporangium splendens

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