RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA235310" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 17 ✖

tax_clade 1

bioproject 1

  • PRJNA235310 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
1056694 1056694 PRJNA235310_P_NODE_761_length_452_cov_2.094293_g735_i0 PRJNA235310 761 452 2.094293 9.46620436 root 1 Root_unresolved Root_unresolved 208 2.65e-59   NR DAZ97935.1 4803 g735 i0 63.8 21.7566371681416 149 54 98.9 0 2 448 195 343 DAZ97935.1 TPA: hypothetical protein N0F65_006360, partial [Lagenidium giganteum] diamond 9834 210 0.990476190476191 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
10571474 10571474 PRJNA235310_P_NODE_889_length_421_cov_1.782258_g863_i0 PRJNA235310 889 421 1.782258 7.50330618 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 216 9.4e-70   NR KAF0716874.1 120398 g863 i0 78 6.07838479809976 123 27 87.6 0 38 406 3 125 KAF0716874.1 hypothetical protein As57867_002609 [Aphanomyces stellatus] diamond 2559 216 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
20768871 20768871 PRJNA235310_P_NODE_2577_length_239_cov_2.084211_g2551_i0 PRJNA235310 2577 239 2.084211 4.98126429 root 1 Root_unresolved Root_unresolved 131 5.299999999999998e-35   NR XP_009529225.1 67593 g2551 i0 83.3 3.9163179916318 78 13 97.9 0 239 6 159 236 XP_009529225.1 hypothetical protein PHYSODRAFT_286325 [Phytophthora sojae] diamond 936 132 0.992424242424242 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
20768924 20768924 PRJNA235310_P_NODE_597_length_497_cov_1.799107_g572_i0 PRJNA235310 597 497 1.799107 8.94156179 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 217 4.15e-69   NR KAF0735269.1 100861 g572 i0 67.9 5.7102615694165 156 49 94.2 1 470 3 18 172 KAF0735269.1 hypothetical protein Ae201684_008184 [Aphanomyces euteiches] diamond 2838 217 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
21458369 21458369 PRJNA235310_P_NODE_37_length_1321_cov_5.673742_g27_i0 PRJNA235310 37 1321 5.673742 74.95013182 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 523 4.7899999999999986e-182   NR TMW60420.1 41045 g27 i0 68.4 41.6548069644209 393 111 89 4 1315 140 1 381 TMW60420.1 hypothetical protein Poli38472_000462 [Pythium oligandrum] diamond 55026 524 0.998091603053435 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
22043945 22043945 PRJNA235310_P_NODE_338_length_615_cov_1.837456_g315_i0 PRJNA235310 338 615 1.837456 11.3003544 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 252 2.41e-82   NR OQR95014.1 74557 g315 i0 75.9 6.82926829268293 174 42 84.9 0 22 543 1 174 OQR95014.1 60S ribosomal protein L19-1 [Thraustotheca clavata] diamond 4200 253 0.99604743083004 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
26743200 26743200 PRJNA235310_P_NODE_3421_length_205_cov_1.000000_g3395_i0 PRJNA235310 3421 205 1 2.05 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.00624   NR KAG9410335.1 112091 g3395 i0 39.4 2.85365853658537 71 38 98 2 202 2 66 135 KAG9410335.1 hypothetical protein AC1031_018369 [Aphanomyces cochlioides] diamond 585 44.3 0.99097065462754 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces cochlioides
27263764 27263764 PRJNA235310_P_NODE_2443_length_247_cov_1.833333_g2417_i0 PRJNA235310 2443 247 1.833333 4.52833251 Peronospora effusa 542832 SAR_Eukaryotes SAR_Eukaryotes 110 1.84e-29   NR RQM08885.1 542832 g2417 i0 80 1.68825910931174 70 14 85 0 239 30 16 85 RQM08885.1 hypothetical protein DD237_000613 [Peronospora effusa] diamond 417 110 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora effusa
28084599 28084599 PRJNA235310_P_NODE_4785_length_169_cov_1.733333_g4759_i0 PRJNA235310 4785 169 1.733333 2.92933277 Nothophytophthora sp. Chile5 2483409 SAR_Eukaryotes SAR_Eukaryotes 84.7 8.3e-18   NR RLN05664.1 2483409 g4759 i0 82.1 1.98816568047337 56 8 95.9 1 1 162 254 309 RLN05664.1 hypothetical protein BBJ28_00014501, partial [Nothophytophthora sp. Chile5] diamond 336 84.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Nothophytophthora Nothophytophthora sp. Chile5
28842323 28842323 PRJNA235310_P_NODE_4788_length_169_cov_1.733333_g4762_i0 PRJNA235310 4788 169 1.733333 2.92933277 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 53.1 5.5e-7   NR KAF0732339.1 100861 g4762 i0 75.8 1.75739644970414 33 8 58.6 0 2 100 93 125 KAF0732339.1 hypothetical protein Ae201684_010625 [Aphanomyces euteiches] diamond 297 53.1 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
30453396 30453396 PRJNA235310_P_NODE_2813_length_228_cov_1.145251_g2787_i0 PRJNA235310 2813 228 1.145251 2.61117228 Achlya hypogyna 1202772 SAR_Eukaryotes SAR_Eukaryotes 96.3 3.82e-21   NR OQR98335.1 1202772 g2787 i0 60.8 3.90789473684211 74 29 97.4 0 227 6 340 413 OQR98335.1 aldehyde dehydrogenase family 7 member A1 [Achlya hypogyna] diamond 891 96.3 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya hypogyna
31355855 31355855 PRJNA235310_P_NODE_2536_length_242_cov_1.378238_g2510_i0 PRJNA235310 2536 242 1.378238 3.33533596 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 75.1 1.46e-13   NR GLD93891.1 114742 g2510 i0 47.1 2.72727272727273 70 34 86.8 1 32 241 507 573 GLD93891.1 hypothetical protein PINS_up002496 [Pythium insidiosum] diamond 660 75.5 0.994701986754967 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
32083208 32083208 PRJNA235310_P_NODE_6038_length_164_cov_0.860870_g6012_i0 PRJNA235310 6038 164 0.86087 1.4118268 root 1 Root_unresolved Root_unresolved 94.7 4.82e-21   NR CAI5714846.1 86335 g6012 i0 74.1 6.91463414634146 54 14 98.8 0 162 1 182 235 CAI5714846.1 unnamed protein product [Peronospora destructor] diamond 1134 95.5 0.991623036649215 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora destructor
32526592 32526592 PRJNA235310_P_NODE_3339_length_207_cov_1.974684_g3313_i0 PRJNA235310 3339 207 1.974684 4.08759588 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 68.6 1.41e-13   NR XP_008610509.1 1156394 g3313 i0 59.3 3.17391304347826 54 21 78.3 1 199 38 1 53 XP_008610509.1 40S ribosomal protein S29 [Saprolegnia diclina VS20] diamond 657 68.9 0.995645863570392 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
32666115 32666115 PRJNA235310_P_NODE_160_length_773_cov_2.964088_g143_i0 PRJNA235310 160 773 2.964088 22.91240024 Saprolegnia diclina VS2 112098 SAR_Eukaryotes SAR_Eukaryotes 165 4.05e-45   NR XP_008605263.1 1156394 g143 i0 48.4 3.55109961190168 186 91 71.4 3 2 553 107 289 XP_008605263.1 hypothetical protein SDRG_01511 [Saprolegnia diclina VS20] diamond 2745 165 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
32823646 32823646 PRJNA235310_P_NODE_4820_length_169_cov_1.266667_g4794_i0 PRJNA235310 4820 169 1.266667 2.14066723 Saprolegnia parasitica CBS 223.65 695850 SAR_Eukaryotes SAR_Eukaryotes 60.5 3.66e-9   NR XP_012208870.1 695850 g4794 i0 60.4 0.85207100591716 48 16 79.9 1 140 6 92 139 XP_012208870.1 hypothetical protein SPRG_14352 [Saprolegnia parasitica CBS 223.65] diamond 144 60.5 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
32886404 32886404 PRJNA235310_P_NODE_3340_length_207_cov_1.854430_g3314_i0 PRJNA235310 3340 207 1.85443 3.8386701 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 48.5 1.2e-5   NR XP_008874019.1 157072 g3314 i0 56.5 2.71014492753623 46 20 66.7 0 151 14 1 46 XP_008874019.1 hypothetical protein H310_09657 [Aphanomyces invadans] diamond 561 48.5 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans

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