RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJEB75227", 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 · 11 ✖

tax_clade 1

  • Sar · 11 ✖

bioproject 1

  • PRJEB75227 · 11 ✖

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
135637 135637 PRJEB75227_P_NODE_3481_length_387_cov_1.238854_g3310_i0 PRJEB75227 3481 387 1.238854 4.79436498 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 401 3.189999999999999e-107   NTclustered gi|695448559|ref|XM_009536718.1| 67593 g3310 i0 85.751 93.147286821705407 386 47 99 6 3 387 976 598 Phytophthora sojae ATP synthase beta subunit mRNA blastn 36048 401 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
3961799 3961799 PRJEB75227_P_NODE_7204_length_268_cov_1.600000_g7033_i0 PRJEB75227 7204 268 1.6 4.288 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 152 2.3499999999999998e-32   NTclustered gi|695407986|ref|XM_009526229.1| 67593 g7033 i0 80.193 23.7089552238806 207 37 76 4 64 268 677 473 Phytophthora sojae hypothetical protein partial mRNA blastn 6354 152 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
7788013 7788013 PRJEB75227_P_NODE_11827_length_242_cov_0.923077_g11656_i0 PRJEB75227 11827 242 0.923077 2.23384634 Phytophthora ramorum 164328 SAR_Eukaryotes SAR_Eukaryotes 287 5.49e-73   NTclustered gi|2794889416|ref|XM_067886769.1| 164328 g11656 i0 88.017 94.7933884297521 242 29 100 0 1 242 1077 836 Phytophthora ramorum ATP-dependent RNA helicase eIF4A (KRP23_2082), partial mRNA blastn 22940 287 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum
23087427 23087427 PRJEB75227_P_NODE_1939_length_557_cov_4.407025_g1768_i0 PRJEB75227 1939 557 4.407025 24.54712925 Hyaloperonospora parasitica 123356 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.015   NTclustered gi|170285697|emb|CU672270.3| 123356 g1768 i0 100 0.052064631956912 29 0 5 0 89 117 1761 1789 H.parasitica DNA sequence from clone HpEmoy2-20J10, complete sequence blastn 29 54.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Hyaloperonospora Hyaloperonospora parasitica
24361472 24361472 PRJEB75227_P_NODE_7920_length_256_cov_1.661202_g7749_i0 PRJEB75227 7920 256 1.661202 4.25267712 Phytophthora nicotianae 4792 SAR_Eukaryotes SAR_Eukaryotes 250 7.69e-62   NTclustered gi|38489929|gb|AY456093.1| 4792 g7749 i0 87.85 81.17578125 214 24 83 2 1 213 2152 2364 Phytophthora nicotianae heat shock protein 70 (Hsp70a) gene, complete cds blastn 20781 250 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
27539822 27539822 PRJEB75227_P_NODE_11484_length_243_cov_0.917647_g11313_i0 PRJEB75227 11484 243 0.917647 2.22988221 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 52.8 4.83e-6   NR KAJ0394760.1 114742 g11313 i0 32.1 0.962962962962963 78 52 95.1 1 12 242 40 117 KAJ0394760.1 hypothetical protein P43SY_000334 [Pythium insidiosum] diamond 234 52.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
28297442 28297442 PRJEB75227_P_NODE_4246_length_345_cov_1.433824_g4075_i0 PRJEB75227 4246 345 1.433824 4.9466928 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 65.9 5.82e-10   NR QFU96438.1 114742 g4075 i0 71.4 1.10434782608696 42 12 36.5 0 344 219 2 43 QFU96438.1 PF16, partial [Pythium insidiosum] diamond 381 65.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
29774152 29774152 PRJEB75227_P_NODE_9751_length_248_cov_0.891429_g9580_i0 PRJEB75227 9751 248 0.891429 2.21074392 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 102 2.81e-23   NR TMW56933.1 41045 g9580 i0 56.1 10.0403225806452 82 36 99.2 0 1 246 391 472 TMW56933.1 hypothetical protein Poli38472_002858 [Pythium oligandrum] diamond 2490 103 0.990291262135922 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
32081612 32081612 PRJEB75227_P_NODE_5078_length_311_cov_1.310924_g4907_i0 PRJEB75227 5078 311 1.310924 4.07697364 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 131 7.15e-33   NR XP_009517664.1 67593 g4907 i0 62 4.86173633440514 100 38 96.5 0 4 303 163 262 XP_009517664.1 hypothetical protein PHYSODRAFT_263761 [Phytophthora sojae] diamond 1512 131 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
32461485 32461485 PRJEB75227_P_NODE_6619_length_278_cov_1.253659_g6448_i0 PRJEB75227 6619 278 1.253659 3.48517202 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 58.5 1.06e-7   NR KAG7388632.1 221518 g6448 i0 36.5 4.20863309352518 63 40 68 0 276 88 150 212 KAG7388632.1 hypothetical protein PHYPSEUDO_012123 [Phytophthora pseudosyringae] diamond 1170 58.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora pseudosyringae
32493153 32493153 PRJEB75227_P_NODE_4639_length_329_cov_1.218750_g4468_i0 PRJEB75227 4639 329 1.21875 4.0096875 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 75.1 4.68e-13   NR RHY98191.1 112090 g4468 i0 50.6 4.32218844984802 79 36 71.1 2 94 327 1252 1328 RHY98191.1 hypothetical protein DYB35_005244 [Aphanomyces astaci] diamond 1422 75.1 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);;