contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJEB2925" and tax_phylum = "Oomycota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1300348 | 1300348 | PRJEB2925_P_NODE_15322_length_257_cov_2.103604_g14044_i0 | PRJEB2925 | 15322 | 257 | 2.103604 | 5.40626228 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 4.85e-29 | NTclustered | gi|166035253|emb|CU349086.1| | 100861 | g14044 | i0 | 89.908 | 28.1867704280156 | 109 | 11 | 42 | 0 | 5 | 113 | 223 | 115 | Aphanomyces euteiches cDNA | blastn | 7244 | 141 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 2576058 | 2576058 | PRJEB2925_P_NODE_9643_length_378_cov_2.825073_g8372_i0 | PRJEB2925 | 9643 | 378 | 2.825073 | 10.67877594 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 342 | 1.9099999999999994e-89 | NTclustered | gi|325195057|emb|FR825852.1| | 890382 | g8372 | i0 | 90.805 | 49.6587301587302 | 261 | 16 | 68 | 7 | 122 | 377 | 144 | 401 | Albugo laibachii Nc14, genomic contig CONTIG_2891_NC14_v4_540_391 | blastn | 18771 | 342 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 4815928 | 4815928 | PRJEB2925_P_NODE_10044_length_365_cov_1.954545_g8772_i0 | PRJEB2925 | 10044 | 365 | 1.954545 | 7.13408925 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 333 | 1.1e-86 | NTclustered | gi|698783790|ref|XM_009826637.1| | 112090 | g8772 | i0 | 90.196 | 1.39452054794521 | 255 | 25 | 70 | 0 | 1 | 255 | 357 | 103 | Aphanomyces astaci hypothetical protein mRNA | blastn | 509 | 333 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 7678345 | 7678345 | PRJEB2925_P_NODE_15407_length_256_cov_1.615385_g14129_i0 | PRJEB2925 | 15407 | 256 | 1.615385 | 4.1353856 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 412 | 9.27e-111 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g14129 | i0 | 95.72 | 105.40234375 | 257 | 9 | 100 | 2 | 1 | 256 | 2555 | 2810 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 26983 | 412 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 7678361 | 7678361 | PRJEB2925_P_NODE_1787_length_1308_cov_3.877455_g1323_i0 | PRJEB2925 | 1787 | 1308 | 3.877455 | 50.7171114 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 8e-4 | NTclustered | gi|673039582|ref|XM_008875530.1| | 157072 | g1323 | i0 | 85.246 | 0.0695718654434251 | 61 | 6 | 5 | 2 | 198 | 258 | 1098 | 1155 | Aphanomyces invadans hypothetical protein mRNA | blastn | 91 | 60.2 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 15015977 | 15015977 | PRJEB2925_P_NODE_7412_length_465_cov_22.153488_g6230_i0 | PRJEB2925 | 7412 | 465 | 22.153488 | 103.0137192 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 848 | 0 | NTclustered | gi|338798188|gb|HQ665249.1| | 82940 | g6230 | i0 | 99.57 | 99.9569892473118 | 465 | 2 | 100 | 0 | 1 | 465 | 322 | 786 | Pythium middletonii isolate CBS 528.74 28S large subunit ribosomal RNA gene, partial sequence | blastn | 46480 | 848 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium middletonii | ||
| 15328244 | 15328244 | PRJEB2925_P_NODE_14893_length_263_cov_1.228070_g13615_i0 | PRJEB2925 | 14893 | 263 | 1.22807 | 3.2298241 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 9.979999999999999e-81 | NTclustered | gi|698794321|ref|XM_009831888.1| | 112090 | g13615 | i0 | 88.168 | 8.98859315589354 | 262 | 31 | 99 | 0 | 2 | 263 | 847 | 586 | Aphanomyces astaci hypothetical protein mRNA | blastn | 2364 | 313 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 16602997 | 16602997 | PRJEB2925_P_NODE_9434_length_385_cov_1.448571_g8165_i0 | PRJEB2925 | 9434 | 385 | 1.448571 | 5.57699835 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 322 | 2.54e-83 | NTclustered | gi|675210554|ref|XM_008915914.1| | 761204 | g8165 | i0 | 82.011 | 95.3844155844156 | 378 | 68 | 98 | 0 | 5 | 382 | 778 | 1155 | Phytophthora parasitica INRA-310 ATP-dependent RNA helicase eIF4A partial mRNA | blastn | 36723 | 322 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 21702789 | 21702789 | PRJEB2925_P_NODE_11118_length_334_cov_1.675585_g9844_i0 | PRJEB2925 | 11118 | 334 | 1.675585 | 5.5964539 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 8.1e-58 | NTclustered | gi|2795023784|ref|XM_067929914.1| | 4785 | g9844 | i0 | 82.593 | 80.9251497005988 | 270 | 45 | 81 | 2 | 61 | 329 | 1129 | 1397 | Phytophthora cinnamomi hsp70-like protein (IUM83_05758), partial mRNA | blastn | 27029 | 237 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 21702876 | 21702876 | PRJEB2925_P_NODE_5678_length_559_cov_3.127863_g4614_i0 | PRJEB2925 | 5678 | 559 | 3.127863 | 17.48475417 | Globisporangium ultimum | 2052682 | SAR_Eukaryotes | SAR_Eukaryotes | 946 | 0 | NTclustered | gi|299830435|ref|NC_014280.1| | 2052682 | g4614 | i0 | 97.985 | 101.713774597496 | 546 | 10 | 98 | 1 | 14 | 559 | 10176 | 9632 | Pythium ultimum mitochondrion, complete genome | blastn | 56858 | 946 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium ultimum | ||
| 22978027 | 22978027 | PRJEB2925_P_NODE_11419_length_326_cov_10.989691_g10144_i0 | PRJEB2925 | 11419 | 326 | 10.989691 | 35.82639266 | Aquastella attenuata | 1495612 | SAR_Eukaryotes | SAR_Eukaryotes | 492 | 1.5199999999999999e-134 | NTclustered | gi|629632980|gb|KF294792.1| | 1495612 | g10144 | i0 | 93.958 | 101.263803680982 | 331 | 11 | 100 | 5 | 1 | 326 | 1263 | 1589 | Aquastella attenuata isolate SL45 18S ribosomal RNA gene, partial sequence | blastn | 33012 | 492 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aquastella | Aquastella attenuata | ||
| 24251863 | 24251863 | PRJEB2925_P_NODE_12160_length_309_cov_2.164234_g10884_i0 | PRJEB2925 | 12160 | 309 | 2.164234 | 6.68748306 | Phytophthora iranica | 67592 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 9.88e-37 | NTclustered | gi|1233049515|gb|KX250443.1| | 67592 | g10884 | i0 | 77.143 | 51.2847896440129 | 315 | 54 | 99 | 14 | 1 | 306 | 658 | 353 | Phytophthora iranica isolate 61J4(ex-type) heat shock protein 90 gene, partial cds | blastn | 15847 | 167 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora iranica | ||
| 24251872 | 24251872 | PRJEB2925_P_NODE_13160_length_289_cov_9.244094_g11883_i0 | PRJEB2925 | 13160 | 289 | 9.244094 | 26.71543166 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 379 | 1.08e-100 | NTclustered | gi|813199067|ref|XR_001099866.1| | 695850 | g11883 | i0 | 91.941 | 74.5259515570934 | 273 | 18 | 94 | 4 | 1 | 271 | 1395 | 1665 | Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA | blastn | 21538 | 379 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 24251909 | 24251909 | PRJEB2925_P_NODE_17420_length_204_cov_14.455621_g16142_i0 | PRJEB2925 | 17420 | 204 | 14.455621 | 29.48946684 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 339 | 1.22e-88 | NTclustered | gi|256009645|gb|GQ374534.1| | 112090 | g16142 | i0 | 96.569 | 96.8333333333333 | 204 | 7 | 100 | 0 | 1 | 204 | 190 | 393 | Aphanomyces astaci strain Gb04 28S ribosomal RNA gene, partial sequence | blastn | 19754 | 339 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci |
Advanced export
JSON shape: default, array, newline-delimited
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);;