RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJNA1009807" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 20 ✖

tax_clade 1

bioproject 1

  • PRJNA1009807 · 20 ✖

analysis 1

  • blastn · 20 ✖

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
154849 154849 PRJNA1009807_S_NODE_821_length_327_cov_5.163194_g793_i0 PRJNA1009807 821 327 5.163194 16.88364438 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 473 5.54e-129   NTclustered gi|1111669722|ref|NC_032051.1| 112090 g793 i0 92.923 99.8073394495413 325 23 99 0 1 325 607 283 Aphanomyces astaci isolate AP03 mitochondrion, complete genome blastn 32637 473 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
1429615 1429615 PRJNA1009807_S_NODE_682_length_354_cov_67.787302_g654_i0 PRJNA1009807 682 354 67.787302 239.96704908 Aphanomyces brasiliensis 2525538 SAR_Eukaryotes SAR_Eukaryotes 654 0   NTclustered gi|2098511708|gb|OK235679.1| 2525538 g654 i0 100 100.206214689266 354 0 100 0 1 354 910 557 Aphanomyces brasiliensis voucher CCIBt4545 small subunit ribosomal RNA gene, partial sequence blastn 35473 654 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces brasiliensis
2705021 2705021 PRJNA1009807_S_NODE_1143_length_285_cov_1.475610_g1115_i0 PRJNA1009807 1143 285 1.47561 4.2054885 Aphanomyces sp. 1982524 SAR_Eukaryotes SAR_Eukaryotes 527 3.59e-145   NTclustered gi|1186441155|gb|KY989960.1| 1982524 g1115 i0 100 34.5122807017544 285 0 100 0 1 285 391 675 Aphanomyces sp. isolate CNUaq small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 9836 527 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces sp.
2705022 2705022 PRJNA1009807_S_NODE_1183_length_279_cov_4.250000_g1155_i0 PRJNA1009807 1183 279 4.25 11.8575 Thraustotheca clavata 74557 SAR_Eukaryotes SAR_Eukaryotes 375 1.3399999999999995e-99   NTclustered gi|533310373|ref|NC_022179.1| 74557 g1155 i0 90.909 56.405017921147 286 16 100 7 1 279 12899 13181 Thraustotheca clavata mitochondrion, complete genome blastn 15737 375 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
2705026 2705026 PRJNA1009807_S_NODE_1643_length_238_cov_94.773869_g1615_i0 PRJNA1009807 1643 238 94.773869 225.56180822 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 307 4.13e-79   NTclustered gi|813199067|ref|XR_001099866.1| 695850 g1615 i0 90 73.218487394958 240 20 100 4 1 238 1451 1688 Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA blastn 17426 307 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
3551992 3551992 PRJNA1009807_S_NODE_723_length_345_cov_20.290850_g695_i0 PRJNA1009807 723 345 20.29085 70.0034325 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 187 8.58e-43   NTclustered gi|156085307|gb|EF553481.1| 4779 g695 i0 99.038 30.3014492753623 104 1 30 0 1 104 503 400 Bremia lactucae voucher H. Voglmayr H.V.180 (WU) 28S ribosomal RNA gene, partial sequence blastn 10454 187 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Bremia Bremia lactucae
3981230 3981230 PRJNA1009807_S_NODE_2464_length_200_cov_81.229814_g2436_i0 PRJNA1009807 2464 200 81.229814 162.459628 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 363 7.069999999999999e-96   NTclustered gi|698793876|ref|XR_717098.1| 112090 g2436 i0 99.5 99.795 200 0 99 1 2 200 1859 1660 Aphanomyces astaci 28S ribosomal RNA rRNA blastn 19959 363 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
9082276 9082276 PRJNA1009807_S_NODE_2088_length_215_cov_58.869318_g2060_i0 PRJNA1009807 2088 215 58.869318 126.5690337 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 359 9.969999999999999e-95   NTclustered gi|256009645|gb|GQ374534.1| 112090 g2060 i0 96.744 97.0093023255814 215 7 100 0 1 215 181 395 Aphanomyces astaci strain Gb04 28S ribosomal RNA gene, partial sequence blastn 20857 359 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
9082321 9082321 PRJNA1009807_S_NODE_968_length_304_cov_89.543396_g940_i0 PRJNA1009807 968 304 89.543396 272.21192384 Aphanomyces brasiliensis 2525538 SAR_Eukaryotes SAR_Eukaryotes 562 1.06e-155   NTclustered gi|2098511708|gb|OK235679.1| 2525538 g940 i0 100 100.934210526316 304 0 100 0 1 304 330 27 Aphanomyces brasiliensis voucher CCIBt4545 small subunit ribosomal RNA gene, partial sequence blastn 30684 562 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces brasiliensis
10357935 10357935 PRJNA1009807_S_NODE_469_length_420_cov_7.706037_g441_i0 PRJNA1009807 469 420 7.706037 32.3653554 Plasmopara pimpinellae 162137 SAR_Eukaryotes SAR_Eukaryotes 267 1.33e-66   NTclustered gi|33520243|gb|AY273988.1| 162137 g441 i0 81.197 83.1833333333333 351 49 82 13 76 420 133 472 Plasmopara pimpinellae large subunit ribosomal RNA gene, partial sequence blastn 34937 267 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Plasmopara Plasmopara pimpinellae
13754797 13754797 PRJNA1009807_S_NODE_2951_length_186_cov_56.367347_g2923_i0 PRJNA1009807 2951 186 56.367347 104.84326542 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 322 1.1e-83   NTclustered gi|166051677|emb|CU353805.1| 100861 g2923 i0 97.849 101.623655913978 186 4 100 0 1 186 116 301 Aphanomyces euteiches cDNA blastn 18902 322 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
14183448 14183448 PRJNA1009807_S_NODE_212_length_558_cov_6.957611_g190_i0 PRJNA1009807 212 558 6.957611 38.82346938 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 977 0   NTclustered gi|1111669722|ref|NC_032051.1| 112090 g190 i0 98.214 107.030465949821 560 8 100 2 1 558 2637 2078 Aphanomyces astaci isolate AP03 mitochondrion, complete genome blastn 59723 977 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
14183462 14183462 PRJNA1009807_S_NODE_2952_length_186_cov_30.367347_g2924_i0 PRJNA1009807 2952 186 30.367347 56.48326542 Aphanomyces sp. 1982524 SAR_Eukaryotes SAR_Eukaryotes 335 1.4099999999999996e-87   NTclustered gi|1578815423|gb|MK546600.1| 1982524 g2924 i0 99.457 98.4193548387097 184 1 99 0 3 186 863 680 Aphanomyces sp. voucher CPZ14 large subunit ribosomal RNA gene, partial sequence blastn 18306 335 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces sp.
15457382 15457382 PRJNA1009807_S_NODE_1193_length_277_cov_51.273109_g1165_i0 PRJNA1009807 1193 277 51.273109 142.02651193 Aphanomyces stellatus 120398 SAR_Eukaryotes SAR_Eukaryotes 512 9.73e-141   NTclustered gi|363498776|gb|JN662487.1| 120398 g1165 i0 100 99.5198555956679 277 0 100 0 1 277 45 321 Aphanomyces stellatus strain GF 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 27567 512 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
18006572 18006572 PRJNA1009807_S_NODE_4635_length_155_cov_16.922414_g4607_i0 PRJNA1009807 4635 155 16.922414 26.2297417 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 265 1.5e-66   NTclustered gi|698793876|ref|XR_717098.1| 112090 g4607 i0 97.419 99.7483870967742 155 4 100 0 1 155 1932 2086 Aphanomyces astaci 28S ribosomal RNA rRNA blastn 15461 265 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
18006579 18006579 PRJNA1009807_S_NODE_855_length_322_cov_6.929329_g827_i0 PRJNA1009807 855 322 6.929329 22.31243938 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 518 2.48e-142   NTclustered gi|1111669722|ref|NC_032051.1| 112090 g827 i0 95.692 94.6211180124224 325 9 100 4 1 322 4866 4544 Aphanomyces astaci isolate AP03 mitochondrion, complete genome blastn 30468 518 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
18853074 18853074 PRJNA1009807_S_NODE_1095_length_290_cov_6.597610_g1067_i0 PRJNA1009807 1095 290 6.59761 19.133069 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 477 3.74e-130   NTclustered gi|50261276|ref|NC_005984.1| 4770 g1067 i0 96.233 108.686206896552 292 9 100 2 1 290 9911 9620 Saprolegnia ferax mitochondrion, complete genome blastn 31519 481 0.991683991683992 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia ferax
18853097 18853097 PRJNA1009807_S_NODE_2795_length_190_cov_40.708609_g2767_i0 PRJNA1009807 2795 190 40.708609 77.3463571 Aquastella 1495611 SAR_Eukaryotes SAR_Eukaryotes 344 2.3999999999999993e-90   NTclustered gi|629632980|gb|KF294792.1| 1495612 g2767 i0 99.471 99.4736842105263 189 1 99 0 2 190 1569 1381 Aquastella attenuata isolate SL45 18S ribosomal RNA gene, partial sequence blastn 18900 344 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aquastella Aquastella attenuata
23107095 23107095 PRJNA1009807_S_NODE_1939_length_222_cov_5.617486_g1911_i0 PRJNA1009807 1939 222 5.617486 12.47081892 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 313 8.18e-81   NTclustered gi|1111669769|ref|NC_032052.1| 157072 g1911 i0 92.035 101.468468468468 226 12 100 5 1 222 2552 2775 Aphanomyces invadans isolate NJM9701 mitochondrion, complete genome blastn 22526 313 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
23107128 23107128 PRJNA1009807_S_NODE_519_length_402_cov_7.561983_g491_i0 PRJNA1009807 519 402 7.561983 30.39917166 Aphanomyces sp. 1982524 SAR_Eukaryotes SAR_Eukaryotes 743 0   NTclustered gi|1578815424|gb|MK546601.1| 1982524 g491 i0 100 99.8681592039801 402 0 100 0 1 402 589 188 Aphanomyces sp. voucher CCIBt4545 large subunit ribosomal RNA gene, partial sequence blastn 40147 743 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces sp.

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