RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA1126198" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 16 ✖

tax_clade 1

bioproject 1

  • PRJNA1126198 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
20156668 20156668 PRJNA1126198_P_NODE_2376_length_1205_cov_6.831272_g1982_i0 PRJNA1126198 2376 1205 6.831272 82.3168276 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 523 5.429999999999998e-183   NR TMW60420.1 41045 g1982 i0 68.1 44.7136929460581 398 113 98.8 5 1200 10 1 385 TMW60420.1 hypothetical protein Poli38472_000462 [Pythium oligandrum] diamond 53880 526 0.994296577946768 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
20683301 20683301 PRJNA1126198_P_NODE_489717_length_228_cov_3.425806_g488996_i0 PRJNA1126198 489717 228 3.425806 7.81083768 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 86.7 1.34e-19   NR KAF0684136.1 120398 g488996 i0 68.8 10.4342105263158 64 20 84.2 0 36 227 20 83 KAF0684136.1 hypothetical protein As57867_023793 [Aphanomyces stellatus] diamond 2379 87.4 0.991990846681922 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
23233675 23233675 PRJNA1126198_P_NODE_287479_length_268_cov_5.887179_g286758_i0 PRJNA1126198 287479 268 5.887179 15.77763972 Phytophthora fragariae 53985 SAR_Eukaryotes SAR_Eukaryotes 108 3.59e-28   NR KAE9065155.1 53985 g286758 i0 67 3.91791044776119 88 29 98.5 0 2 265 16 103 KAE9065155.1 hypothetical protein PF010_g28318, partial [Phytophthora fragariae] diamond 1050 108 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora fragariae
26975297 26975297 PRJNA1126198_P_NODE_123802_length_327_cov_1.224409_g123083_i0 PRJNA1126198 123802 327 1.224409 4.00381743 [Pythium] brassicae (nom. inval.) 1485010 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.0207   NR TYZ59692.1 1485010 g123083 i0 29.5 1.02752293577982 112 72 96.3 4 12 326 651 762 TYZ59692.1 hypothetical protein PybrP1_007909 [[Pythium] brassicae (nom. inval.)] diamond 336 44.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium [Pythium] brassicae (nom. inval.)
27228199 27228199 PRJNA1126198_P_NODE_204123_length_291_cov_1.435780_g203403_i0 PRJNA1126198 204123 291 1.43578 4.1781198 Aphanomyces stellatus 120398 SAR_Eukaryotes SAR_Eukaryotes 65.5 5.64e-10   NR KAF0688224.1 120398 g203403 i0 45.3 2.21649484536082 86 44 85.6 2 290 42 74 159 KAF0688224.1 hypothetical protein As57867_020028 [Aphanomyces stellatus] diamond 645 65.5 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
27249023 27249023 PRJNA1126198_P_NODE_329183_length_259_cov_1.655914_g328462_i0 PRJNA1126198 329183 259 1.655914 4.28881726 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 100 1.62e-22   NR XP_067816137.1 4779 g328462 i0 61.2 3.93822393822394 85 33 98.5 0 3 257 72 156 XP_067816137.1 uncharacterized protein CCR75_006092 [Bremia lactucae] diamond 1020 100 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Bremia Bremia lactucae
27481080 27481080 PRJNA1126198_P_NODE_74523_length_365_cov_1.500000_g73806_i0 PRJNA1126198 74523 365 1.5 5.475 Lagenidium giganteum 4803 SAR_Eukaryotes SAR_Eukaryotes 136 2.5899999999999993e-34   NR DAZ94200.1 4803 g73806 i0 54 1.01917808219178 124 53 99.5 2 363 1 267 389 DAZ94200.1 TPA: hypothetical protein N0F65_000427, partial [Lagenidium giganteum] diamond 372 136 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
27533343 27533343 PRJNA1126198_P_NODE_182683_length_299_cov_1.358407_g181963_i0 PRJNA1126198 182683 299 1.358407 4.06163693 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 152 4.53e-45   NR KAJ8524041.1 4785 g181963 i0 82.4 2.70903010033445 91 16 91.3 0 298 26 43 133 KAJ8524041.1 hypothetical protein ON010_g17076 [Phytophthora cinnamomi] diamond 810 152 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
27923087 27923087 PRJNA1126198_P_NODE_459805_length_243_cov_0.911765_g459084_i0 PRJNA1126198 459805 243 0.911765 2.21558895 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 72 1.78e-12   NR GLE04377.1 114742 g459084 i0 44.4 1 81 42 97.5 2 243 7 338 417 GLE04377.1 hypothetical protein PINS_up013306 [Pythium insidiosum] diamond 243 72 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
28838656 28838656 PRJNA1126198_P_NODE_10428_length_587_cov_1.564202_g9759_i0 PRJNA1126198 10428 587 1.564202 9.18186574 Saprolegnia parasitica CBS 223.65 695850 SAR_Eukaryotes SAR_Eukaryotes 291 8.209999999999999e-95   NR XP_012213591.1 695850 g9759 i0 72.8 4.98296422487223 195 51 99.7 1 587 3 148 340 XP_012213591.1 protein transporter Sec61 subunit alpha [Saprolegnia parasitica CBS 223.65] diamond 2925 291 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
28922458 28922458 PRJNA1126198_P_NODE_482268_length_234_cov_2.459627_g481547_i0 PRJNA1126198 482268 234 2.459627 5.75552718 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 91.7 2.39e-20   NR KAG1700196.1 4784 g481547 i0 61 26.3974358974359 77 30 98.7 0 233 3 101 177 KAG1700196.1 hypothetical protein DVH05_012004 [Phytophthora capsici] diamond 6177 92 0.996739130434783 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
30217308 30217308 PRJNA1126198_P_NODE_265912_length_274_cov_1.338308_g265191_i0 PRJNA1126198 265912 274 1.338308 3.66696392 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 100 1.9e-22   NR OQR99619.1 74557 g265191 i0 46.2 10.0948905109489 91 48 98.5 1 272 3 81 171 OQR99619.1 hypothetical protein THRCLA_06440 [Thraustotheca clavata] diamond 2766 101 0.99009900990099 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
30596359 30596359 PRJNA1126198_P_NODE_287053_length_269_cov_1.158163_g286332_i0 PRJNA1126198 287053 269 1.158163 3.11545847 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 50.8 6.58e-5   NR DBA01407.1 4803 g286332 i0 32.5 1.89591078066915 80 48 85.9 2 253 23 235 311 DBA01407.1 TPA: hypothetical protein N0F65_007304 [Lagenidium giganteum] diamond 510 51.2 0.9921875 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
30754555 30754555 PRJNA1126198_P_NODE_233534_length_282_cov_2.354067_g232813_i0 PRJNA1126198 233534 282 2.354067 6.63846894 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 57.4 2.14e-7   NR KAG7399116.1 109152 g232813 i0 50 3.41489361702128 72 34 74.5 1 212 3 17 88 KAG7399116.1 Nucleoside diphosphate kinase III, chloroplastic/mitochondrial [Phytophthora boehmeriae] diamond 963 57.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora boehmeriae
30912637 30912637 PRJNA1126198_P_NODE_396914_length_249_cov_0.886364_g396193_i0 PRJNA1126198 396914 249 0.886364 2.20704636 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 58.9 7.92e-8   NR KAJ0396857.1 114742 g396193 i0 37.7 2.62650602409639 77 48 92.8 0 232 2 468 544 KAJ0396857.1 hypothetical protein ATCC90586_008220 [Pythium insidiosum] diamond 654 58.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
32473312 32473312 PRJNA1126198_P_NODE_381499_length_250_cov_2.039548_g380778_i0 PRJNA1126198 381499 250 2.039548 5.09887 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 49.7 1.36e-4   NR XP_067800973.1 4785 g380778 i0 37.5 0.768 64 40 76.8 0 42 233 322 385 XP_067800973.1 Superoxide-generating NADPH oxidase heavy chain subunit A [Phytophthora cinnamomi] diamond 192 49.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi

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