RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "blastn", bioproject = "PRJNA1103784" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 21 ✖

tax_clade 1

bioproject 1

  • PRJNA1103784 · 21 ✖

analysis 1

  • blastn · 21 ✖

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
1486785 1486785 PRJNA1103784_P_NODE_2362_length_348_cov_0.840000_g2307_i0 PRJNA1103784 2362 348 0.84 2.9232 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 333 1.05e-86   NTclustered gi|166034888|emb|CU351888.1| 100861 g2307 i0 87.075 2.34770114942529 294 38 84 0 4 297 538 831 Aphanomyces euteiches cDNA blastn 817 333 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
1486797 1486797 PRJNA1103784_P_NODE_3122_length_310_cov_1.616034_g3067_i0 PRJNA1103784 3122 310 1.616034 5.0097054 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 333 9.24e-87   NTclustered gi|673025067|ref|XM_008868273.1| 157072 g3067 i0 89.655 2.39032258064516 261 27 84 0 1 261 210 470 Aphanomyces invadans ribosomal protein L29 mRNA blastn 741 333 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
4038907 4038907 PRJNA1103784_P_NODE_4844_length_266_cov_0.974093_g4789_i0 PRJNA1103784 4844 266 0.974093 2.59108738 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 215 2.93e-51   NTclustered gi|698822976|ref|XM_009846215.1| 112090 g4789 i0 85.308 52.8984962406015 211 28 79 3 57 266 527 319 Aphanomyces astaci 40S ribosomal protein S13 mRNA blastn 14071 215 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
4038935 4038935 PRJNA1103784_P_NODE_6764_length_246_cov_0.890173_g6709_i0 PRJNA1103784 6764 246 0.890173 2.18982558 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 207 4.48e-49   NTclustered gi|166035407|emb|CU354286.1| 100861 g6709 i0 82.186 1.3130081300813 247 38 99 6 3 246 747 504 Aphanomyces euteiches cDNA blastn 323 207 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
5314972 5314972 PRJNA1103784_P_NODE_1825_length_386_cov_2.143770_g1770_i0 PRJNA1103784 1825 386 2.14377 8.2749522 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 652 0   NTclustered gi|166047510|emb|CU361626.1| 100861 g1770 i0 97.15 99.380829015544 386 11 100 0 1 386 322 707 Aphanomyces euteiches cDNA blastn 38361 652 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
5315034 5315034 PRJNA1103784_P_NODE_6345_length_248_cov_0.880000_g6290_i0 PRJNA1103784 6345 248 0.88 2.1824 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 392 1.1599999999999999e-104   NTclustered gi|698784774|ref|XM_009827129.1| 112090 g6290 i0 95.161 29.9395161290323 248 12 100 0 1 248 62 309 Aphanomyces astaci hypothetical protein mRNA blastn 7425 392 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
6590186 6590186 PRJNA1103784_P_NODE_2486_length_341_cov_1.436567_g2431_i0 PRJNA1103784 2486 341 1.436567 4.89869347 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 351 2.84e-92   NTclustered gi|698812547|ref|XM_009841001.1| 112090 g2431 i0 90.909 30.0029325513196 264 20 77 2 1 263 287 547 Aphanomyces astaci hypothetical protein mRNA blastn 10231 351 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
10415543 10415543 PRJNA1103784_P_NODE_4649_length_269_cov_1.510204_g4594_i0 PRJNA1103784 4649 269 1.510204 4.06244876 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 363 1e-95   NTclustered gi|166037617|emb|CU352458.1| 100861 g4594 i0 91.045 3.93308550185874 268 24 99 0 2 269 238 505 Aphanomyces euteiches cDNA blastn 1058 363 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
10415545 10415545 PRJNA1103784_P_NODE_4709_length_268_cov_1.184615_g4654_i0 PRJNA1103784 4709 268 1.184615 3.1747682 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 381 2.759999999999999e-101   NTclustered gi|166047463|emb|CU361579.1| 100861 g4654 i0 93.385 8.61567164179104 257 17 96 0 4 260 390 134 Aphanomyces euteiches cDNA blastn 2309 381 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
11690809 11690809 PRJNA1103784_P_NODE_3530_length_294_cov_1.751131_g3475_i0 PRJNA1103784 3530 294 1.751131 5.14832514 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 427 3.88e-115   NTclustered gi|166035705|emb|CU351918.1| 100861 g3475 i0 92.857 96.7721088435374 294 21 100 0 1 294 413 120 Aphanomyces euteiches cDNA blastn 28451 427 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
12965959 12965959 PRJNA1103784_P_NODE_2091_length_365_cov_2.085616_g2036_i0 PRJNA1103784 2091 365 2.085616 7.6124984 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 503 7.96e-138   NTclustered gi|166039189|emb|CU355239.1| 100861 g2036 i0 91.53 36.3068493150685 366 29 100 2 1 365 568 204 Aphanomyces euteiches cDNA blastn 13252 503 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
12965977 12965977 PRJNA1103784_P_NODE_3351_length_301_cov_1.688596_g3296_i0 PRJNA1103784 3351 301 1.688596 5.08267396 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 416 8.619999999999999e-112   NTclustered gi|698807229|ref|XM_009838342.1| 112090 g3296 i0 91.503 46.1893687707641 306 20 99 1 2 301 176 481 Aphanomyces astaci polyubiquitin mRNA blastn 13903 416 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
16789241 16789241 PRJNA1103784_P_NODE_2674_length_330_cov_2.105058_g2619_i0 PRJNA1103784 2674 330 2.105058 6.9466914 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 311 4.64e-80   NTclustered gi|673017231|ref|XM_008864355.1| 157072 g2619 i0 84.29 2.0030303030303 331 38 99 7 4 330 392 72 Aphanomyces invadans hypothetical protein mRNA blastn 661 311 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
16789282 16789282 PRJNA1103784_P_NODE_5014_length_262_cov_2.407407_g4959_i0 PRJNA1103784 5014 262 2.407407 6.30740634 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 226 1.3299999999999994e-54   NTclustered gi|698780446|ref|XM_009824965.1| 112090 g4959 i0 84.034 2.74045801526718 238 34 90 4 4 239 373 138 Aphanomyces astaci hypothetical protein, variant mRNA blastn 718 226 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
16789297 16789297 PRJNA1103784_P_NODE_5874_length_250_cov_0.870056_g5819_i0 PRJNA1103784 5874 250 0.870056 2.17514 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 296 9.47e-76   NTclustered gi|698779890|ref|XM_009824687.1| 112090 g5819 i0 88 50.7 250 30 100 0 1 250 429 180 Aphanomyces astaci glyceraldehyde-3-phosphate dehydrogenase mRNA blastn 12675 296 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
18063848 18063848 PRJNA1103784_P_NODE_5195_length_259_cov_1.467742_g5140_i0 PRJNA1103784 5195 259 1.467742 3.80145178 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 267 7.739999999999999e-67   NTclustered gi|166036473|emb|CU349515.1| 100861 g5140 i0 87.029 6.31274131274131 239 28 91 1 19 254 353 115 Aphanomyces euteiches cDNA blastn 1635 267 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
18063851 18063851 PRJNA1103784_P_NODE_5375_length_255_cov_1.692308_g5320_i0 PRJNA1103784 5375 255 1.692308 4.3153854 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 388 1.5499999999999998e-103   NTclustered gi|166038792|emb|CU355022.1| 100861 g5320 i0 94.118 23.9843137254902 255 15 100 0 1 255 233 487 Aphanomyces euteiches cDNA blastn 6116 388 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
18063856 18063856 PRJNA1103784_P_NODE_5635_length_251_cov_0.865169_g5580_i0 PRJNA1103784 5635 251 0.865169 2.17157419 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 303 5.69e-78   NTclustered gi|166036596|emb|CU352219.1| 100861 g5580 i0 88.446 14.5099601593625 251 29 100 0 1 251 209 459 Aphanomyces euteiches cDNA blastn 3642 303 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
21888904 21888904 PRJNA1103784_P_NODE_2238_length_358_cov_1.080702_g2183_i0 PRJNA1103784 2238 358 1.080702 3.86891316 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 645 1.2199999999999996e-180   NTclustered gi|698793876|ref|XR_717098.1| 112090 g2183 i0 99.162 101.625698324022 358 3 100 0 1 358 2158 2515 Aphanomyces astaci 28S ribosomal RNA rRNA blastn 36382 645 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
24437990 24437990 PRJNA1103784_P_NODE_1520_length_414_cov_2.994135_g1465_i0 PRJNA1103784 1520 414 2.994135 12.3957189 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 78.7 6.57e-10   NTclustered gi|2795060342|ref|XM_067935485.1| 4785 g1465 i0 79.464 0.814009661835749 112 21 27 2 163 273 271 381 Phytophthora cinnamomi Ankyrin repeat protein (IUM83_10953), partial mRNA blastn 337 78.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
24438056 24438056 PRJNA1103784_P_NODE_5720_length_251_cov_0.865169_g5665_i0 PRJNA1103784 5720 251 0.865169 2.17157419 Hyaloperonospora parasitica 123356 SAR_Eukaryotes SAR_Eukaryotes 159 1.3e-34   NTclustered gi|187467741|emb|CU694978.2| 123356 g5665 i0 80.374 0.852589641434263 214 38 84 3 40 251 73184 72973 H.parasitica DNA sequence from clone HpEmoy2-18A18, complete sequence blastn 214 159 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Hyaloperonospora Hyaloperonospora parasitica

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