RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJEB29441" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 15 ✖

tax_clade 1

bioproject 1

  • PRJEB29441 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
6404792 6404792 PRJEB29441_P_NODE_31906_length_185_cov_1.875000_g31465_i0 PRJEB29441 31906 185 1.875 3.46875 Pythiaceae 4782 SAR_Eukaryotes SAR_Eukaryotes 99 1.23e-24   NR TMW64892.1 41045 g31465 i0 78.7 7.91351351351351 61 13 98.9 0 183 1 88 148 TMW64892.1 hypothetical protein Poli38472_009059 [Pythium oligandrum] diamond 1464 99 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
17877893 17877893 PRJEB29441_P_NODE_13395_length_301_cov_2.107143_g12954_i0 PRJEB29441 13395 301 2.107143 6.34250043 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 153 1.12e-44   NR KAG1694345.1 4784 g12954 i0 77.8 2.96013289036545 99 22 98.7 0 1 297 36 134 KAG1694345.1 40S ribosomal protein S4 [Phytophthora capsici] diamond 891 154 0.993506493506494 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
26589785 26589785 PRJEB29441_P_NODE_31921_length_185_cov_1.750000_g31480_i0 PRJEB29441 31921 185 1.75 3.2375 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 82 7.27e-18   NR KAJ0410394.1 114742 g31480 i0 67.9 1.81621621621622 56 18 90.8 0 6 173 79 134 KAJ0410394.1 hypothetical protein P43SY_002726 [Pythium insidiosum] diamond 336 82 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
27311461 27311461 PRJEB29441_P_NODE_43623_length_163_cov_2.605263_g43182_i0 PRJEB29441 43623 163 2.605263 4.24657869 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 109 1.71e-26   NR CCI50303.1 65357 g43182 i0 96.2 10.7300613496933 53 2 97.5 0 3 161 366 418 CCI50303.1 unnamed protein product [Albugo candida] diamond 1749 110 0.990909090909091 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
27690544 27690544 PRJEB29441_P_NODE_20904_length_232_cov_1.010929_g20463_i0 PRJEB29441 20904 232 1.010929 2.34535528 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 104 1.09e-26   NR KAG1703166.1 4784 g20463 i0 70.7 4.84913793103448 75 21 95.7 1 224 3 1 75 KAG1703166.1 hypothetical protein DVH05_008077 [Phytophthora capsici] diamond 1125 104 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
28069028 28069028 PRJEB29441_P_NODE_18685_length_248_cov_1.537688_g18244_i0 PRJEB29441 18685 248 1.537688 3.81346624 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 95.5 2.16e-21   NR XP_024582431.1 4781 g18244 i0 58.1 3.58064516129032 74 31 89.5 0 26 247 1 74 XP_024582431.1 rok family protein [Plasmopara halstedii] diamond 888 95.9 0.995828988529718 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Plasmopara Plasmopara halstedii
28138968 28138968 PRJEB29441_P_NODE_36805_length_172_cov_1.211382_g36364_i0 PRJEB29441 36805 172 1.211382 2.08357704 Phytophthora palmivora 4796 SAR_Eukaryotes SAR_Eukaryotes 87.4 2.5e-18   NR POM80711.1 4796 g36364 i0 71.7 8.42441860465116 53 15 92.4 0 170 12 535 587 POM80711.1 ABC Superfamily [Phytophthora palmivora] diamond 1449 87.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora palmivora
28479605 28479605 PRJEB29441_P_NODE_28646_length_196_cov_1.040816_g28205_i0 PRJEB29441 28646 196 1.040816 2.03999936 Pythium 4797 SAR_Eukaryotes SAR_Eukaryotes 118 4.15e-29   NR TMW60322.1 41045 g28205 i0 84.6 9.94897959183673 65 10 99.5 0 1 195 209 273 TMW60322.1 hypothetical protein Poli38472_000364 [Pythium oligandrum] diamond 1950 119 0.991596638655462 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
28928046 28928046 PRJEB29441_P_NODE_31708_length_186_cov_1.291971_g31267_i0 PRJEB29441 31708 186 1.291971 2.40306606 Phytophthora idaei 53986 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0341   NR KAG3171441.1 53986 g31267 i0 60 0.483870967741935 30 11 48.4 1 68 157 81 109 KAG3171441.1 hypothetical protein PI126_g1913 [Phytophthora idaei] diamond 90 41.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora idaei
29205950 29205950 PRJEB29441_P_NODE_34869_length_177_cov_1.195312_g34428_i0 PRJEB29441 34869 177 1.195312 2.11570224 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 42 0.0279   NR KAF0710815.1 120398 g34428 i0 48.1 1.61016949152542 54 27 91.5 1 2 163 30 82 KAF0710815.1 hypothetical protein As57867_005451, partial [Aphanomyces stellatus] diamond 285 42 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
29306884 29306884 PRJEB29441_P_NODE_14789_length_284_cov_1.953191_g14348_i0 PRJEB29441 14789 284 1.953191 5.54706244 Aphanomyces cochlioides 112091 SAR_Eukaryotes SAR_Eukaryotes 139 4.32e-38   NR KAG9404282.1 112091 g14348 i0 72 5.8943661971831 93 26 98.2 0 1 279 231 323 KAG9404282.1 Guanine nucleotide-binding protein subunit beta-2-like 1 [Aphanomyces cochlioides] diamond 1674 139 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces cochlioides
29370177 29370177 PRJEB29441_P_NODE_47049_length_161_cov_0.910714_g46608_i0 PRJEB29441 47049 161 0.910714 1.46624954 Lagenidium giganteum 4803 SAR_Eukaryotes SAR_Eukaryotes 62.8 1.02e-9   NR DAZ93968.1 4803 g46608 i0 51.9 3.8944099378882 52 25 96.9 0 157 2 219 270 DAZ93968.1 TPA: hypothetical protein N0F65_008697 [Lagenidium giganteum] diamond 627 62.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
29805546 29805546 PRJEB29441_P_NODE_20711_length_233_cov_1.505435_g20270_i0 PRJEB29441 20711 233 1.505435 3.50766355 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 89.7 9.59e-19   NR KAL0584202.1 65357 g20270 i0 66.2 3.97854077253219 65 22 83.7 0 39 233 2818 2882 KAL0584202.1 hypothetical protein ABG067_005976 [Albugo candida] diamond 927 90.1 0.995560488346282 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
30538765 30538765 PRJEB29441_P_NODE_8493_length_393_cov_2.287791_g8054_i0 PRJEB29441 8493 393 2.287791 8.99101863 Phytophthora fragariae 53985 SAR_Eukaryotes SAR_Eukaryotes 93.6 2.06e-21   NR KAE8911393.1 53985 g8054 i0 53.3 2.73282442748092 92 32 63.4 3 392 144 50 139 KAE8911393.1 hypothetical protein PF003_g4481 [Phytophthora fragariae] diamond 1074 93.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora fragariae
31138763 31138763 PRJEB29441_P_NODE_25615_length_208_cov_1.232704_g25174_i0 PRJEB29441 25615 208 1.232704 2.56402432 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.00147   NR KAJ0401079.1 114742 g25174 i0 42.2 4.52884615384615 45 26 64.9 0 135 1 2099 2143 KAJ0401079.1 hypothetical protein ATCC90586_000763 [Pythium insidiosum] diamond 942 46.2 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum

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