RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "blastn", bioproject = "PRJNA436017" 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

  • PRJNA436017 · 16 ✖

analysis 1

  • blastn · 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
1705576 1705576 PRJNA436017_P_NODE_18722_length_189_cov_1.631579_g18424_i0 PRJNA436017 18722 189 1.631579 3.08368431 Achlya bisexualis 4766 SAR_Eukaryotes SAR_Eukaryotes 171 4.29e-38   NTclustered gi|2289|emb|X59936.1| 4766 g18424 i0 87.671 59.8253968253968 146 18 77 0 4 149 146 1 A.bisexualis gene for actin blastn 11307 171 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya bisexualis
10634721 10634721 PRJNA436017_P_NODE_25249_length_162_cov_1.536000_g24951_i0 PRJNA436017 25249 162 1.536 2.48832 Achlya hypogyna 1202772 SAR_Eukaryotes SAR_Eukaryotes 134 4.6800000000000005e-27   NTclustered gi|542687346|ref|NC_022178.1| 1202772 g24951 i0 85.271 10.8271604938272 129 19 80 0 31 159 1108 980 Achlya hypogyna mitochondrion, complete genome blastn 1754 134 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya hypogyna
10634880 10634880 PRJNA436017_P_NODE_6669_length_346_cov_2.119741_g6372_i0 PRJNA436017 6669 346 2.119741 7.33430386 Phytophthora megakarya 4795 SAR_Eukaryotes SAR_Eukaryotes 191 6.65e-44   NTclustered gi|2248513641|ref|NC_063810.1| 4795 g6372 i0 77.914 93.1849710982659 326 58 92 13 22 338 26048 25728 Phytophthora megakarya isolate Pm2 mitochondrion, complete genome blastn 32242 191 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora megakarya
11292198 11292198 PRJNA436017_P_NODE_19429_length_185_cov_9.979730_g19131_i0 PRJNA436017 19429 185 9.97973 18.4625005 Verrucalvaceae 120409 SAR_Eukaryotes SAR_Eukaryotes 316 5.07e-82   NTclustered gi|227430058|emb|FM999232.1| 281399 g19131 i0 97.814 99.0594594594595 183 4 99 0 2 184 337 155 Aphanomyces frigidophilus 18S rRNA gene (partial), ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene (partial), isolate SAP233 blastn 18326 316 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces frigidophilus
11909399 11909399 PRJNA436017_P_NODE_1270_length_832_cov_3.200000_g1084_i0 PRJNA436017 1270 832 3.2 26.624 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 274 1.64e-68   NTclustered gi|1111669769|ref|NC_032052.1| 157072 g1084 i0 75.986 35.6466346153846 583 110 69 23 33 605 1170 1732 Aphanomyces invadans isolate NJM9701 mitochondrion, complete genome blastn 29658 274 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
13184593 13184593 PRJNA436017_P_NODE_31_length_3033_cov_64.162884_g20_i0 PRJNA436017 31 3033 64.162884 1946.06027172 Phytophthora sp. ML-2023a 3044284 SAR_Eukaryotes SAR_Eukaryotes 547 3.3e-150   NTclustered gi|2500404807|gb|OQ735416.1| 3044284 g20 i0 77.011 16.4609297725025 1044 185 34 45 280 1310 35911 34910 Phytophthora sp. ML-2023a voucher AM18FRL12 mitochondrion, complete genome blastn 49926 547 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sp. ML-2023a
14459813 14459813 PRJNA436017_P_NODE_7192_length_332_cov_2.450847_g6895_i0 PRJNA436017 7192 332 2.450847 8.13681204 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 235 2.8899999999999996e-57   NTclustered gi|698807229|ref|XM_009838342.1| 112090 g6895 i0 80.312 76.671686746988 320 55 94 4 20 332 441 123 Aphanomyces astaci polyubiquitin mRNA blastn 25455 235 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
14459841 14459841 PRJNA436017_P_NODE_8332_length_305_cov_2.932836_g8035_i0 PRJNA436017 8332 305 2.932836 8.9451498 Thraustotheca clavata 74557 SAR_Eukaryotes SAR_Eukaryotes 220 7.37e-53   NTclustered gi|59894163|gb|AY729864.1| 74557 g8035 i0 79.868 94.8983606557377 303 59 99 2 3 304 964 1265 Thraustotheca clavata heat shock protein 90 gene, partial cds blastn 28944 220 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
19556535 19556535 PRJNA436017_P_NODE_14996_length_214_cov_3.491525_g14698_i0 PRJNA436017 14996 214 3.491525 7.4718635 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 296 7.89e-76   NTclustered gi|813199067|ref|XR_001099866.1| 695850 g14698 i0 92.754 66.7429906542056 207 11 96 4 1 205 1461 1665 Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA blastn 14283 296 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
20832294 20832294 PRJNA436017_P_NODE_13697_length_226_cov_1.433862_g13399_i0 PRJNA436017 13697 226 1.433862 3.24052812 Phytophthora cactorum 29920 SAR_Eukaryotes SAR_Eukaryotes 183 6.84e-42   NTclustered gi|1490229970|gb|MH094138.1| 29920 g13399 i0 91.667 58.8318584070796 132 11 58 0 5 136 667 536 Phytophthora cactorum isolate KRJ1 ATP synthase protein 9 (atp9) gene, partial cds; NADH dehydrogenase subunit 9 (nad9) gene, complete cds; and apocytochrome b (cob) gene, partial cds; mitochondrial blastn 13296 183 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cactorum
22107584 22107584 PRJNA436017_P_NODE_5918_length_368_cov_23.262840_g5622_i0 PRJNA436017 5918 368 23.26284 85.6072512 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 608 1.6499999999999992e-169   NTclustered gi|325195057|emb|FR825852.1| 890382 g5622 i0 96.477 97.7663043478261 369 12 100 1 1 368 139 507 Albugo laibachii Nc14, genomic contig CONTIG_2891_NC14_v4_540_391 blastn 35978 608 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
22766028 22766028 PRJNA436017_P_NODE_27918_length_154_cov_2.897436_g27620_i0 PRJNA436017 27918 154 2.897436 4.46205144 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 279 5.33e-71   NTclustered gi|50261276|ref|NC_005984.1| 4770 g27620 i0 99.351 108.980519480519 154 1 100 0 1 154 9323 9476 Saprolegnia ferax mitochondrion, complete genome blastn 16783 279 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia ferax
23382831 23382831 PRJNA436017_P_NODE_13399_length_229_cov_1.822917_g13101_i0 PRJNA436017 13399 229 1.822917 4.17447993 Phytophthora tropicalis 137729 SAR_Eukaryotes SAR_Eukaryotes 137 5.48e-28   NTclustered gi|2248512956|ref|NC_063793.1| 137729 g13101 i0 79.894 1.72052401746725 189 36 82 2 16 203 16286 16099 Phytophthora tropicalis isolate LT5761 mitochondrion, complete genome blastn 394 137 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora tropicalis
24040849 24040849 PRJNA436017_P_NODE_26139_length_159_cov_2.204918_g25841_i0 PRJNA436017 26139 159 2.204918 3.50581962 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 171 3.479999999999999e-38   NTclustered gi|169305|gb|M83535.1|PHTCALPIA 4787 g25841 i0 86.164 99.0817610062893 159 20 99 2 1 158 1100 943 P.infestans calmodulin (calA) gene, complete cds blastn 15754 172 0.994186046511628 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
24657376 24657376 PRJNA436017_P_NODE_9880_length_275_cov_2.415966_g9582_i0 PRJNA436017 9880 275 2.415966 6.6439065 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 503 5.809999999999998e-138   NTclustered gi|698793876|ref|XR_717098.1| 112090 g9582 i0 99.636 81.4509090909091 275 1 100 0 1 275 2454 2180 Aphanomyces astaci 28S ribosomal RNA rRNA blastn 22399 503 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
25315283 25315283 PRJNA436017_P_NODE_8880_length_293_cov_1.718750_g8582_i0 PRJNA436017 8880 293 1.71875 5.0359375 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 464 2.9399999999999994e-126   NTclustered gi|698793876|ref|XR_717098.1| 112090 g8582 i0 95.222 98.798634812286707 293 14 100 0 1 293 1233 941 Aphanomyces astaci 28S ribosomal RNA rRNA blastn 28948 464 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci

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