contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA631119" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 603163 | 603163 | PRJNA631119_P_NODE_20621_length_293_cov_4.186364_g20503_i0 | PRJNA631119 | 20621 | 293 | 4.186364 | 12.26604652 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 1.56e-34 | NTclustered | gi|813207114|ref|XM_012354790.1| | 695850 | g20503 | i0 | 78.346 | 3.99658703071672 | 254 | 49 | 86 | 6 | 32 | 282 | 251 | 1 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein partial mRNA | blastn | 1171 | 159 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 603221 | 603221 | PRJNA631119_P_NODE_3101_length_618_cov_56.460550_g2990_i0 | PRJNA631119 | 3101 | 618 | 56.46055 | 348.926199 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 7.18e-71 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g2990 | i0 | 80.533 | 54.7378640776699 | 375 | 65 | 60 | 4 | 29 | 396 | 68 | 441 | Aphanomyces astaci polyubiquitin mRNA | blastn | 33828 | 281 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 603255 | 603255 | PRJNA631119_P_NODE_37121_length_243_cov_1.817647_g37003_i0 | PRJNA631119 | 37121 | 243 | 1.817647 | 4.41688221 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 9.98e-16 | NTclustered | gi|813141275|ref|XM_012343514.1| | 695850 | g37003 | i0 | 96.552 | 2.18930041152263 | 58 | 2 | 24 | 0 | 80 | 137 | 857 | 800 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 532 | 97.1 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 4430944 | 4430944 | PRJNA631119_P_NODE_29044_length_257_cov_1.521739_g28926_i0 | PRJNA631119 | 29044 | 257 | 1.521739 | 3.91086923 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 56.5 | 0.002 | NTclustered | gi|695468773|ref|XM_009541657.1| | 67593 | g28926 | i0 | 100 | 0.272373540856031 | 30 | 0 | 12 | 0 | 115 | 144 | 136 | 107 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 70 | 56.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 5706838 | 5706838 | PRJNA631119_P_NODE_27565_length_262_cov_6.010582_g27447_i0 | PRJNA631119 | 27565 | 262 | 6.010582 | 15.74772484 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 241 | 4.750000000000001e-59 | NTclustered | gi|813199585|ref|XM_012353974.1| | 695850 | g27447 | i0 | 84.553 | 64.824427480916 | 246 | 34 | 93 | 4 | 17 | 260 | 299 | 56 | Saprolegnia parasitica CBS 223.65 40S ribosomal protein S15a mRNA | blastn | 16984 | 241 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 8256338 | 8256338 | PRJNA631119_P_NODE_19167_length_301_cov_2.640351_g19049_i0 | PRJNA631119 | 19167 | 301 | 2.640351 | 7.94745651 | Pythium sp. CHE-287 | 480030 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 1.21e-50 | NTclustered | gi|158905788|gb|EU199087.1| | 480030 | g19049 | i0 | 84.753 | 69.1328903654485 | 223 | 22 | 71 | 10 | 88 | 301 | 279 | 60 | Pythium sp. CHE-287 translation elongation factor 1 alpha gene, partial cds | blastn | 20809 | 213 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium sp. CHE-287 | ||
| 8256454 | 8256454 | PRJNA631119_P_NODE_39967_length_236_cov_3.276074_g39849_i0 | PRJNA631119 | 39967 | 236 | 3.276074 | 7.73153464 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 1.22e-29 | NTclustered | gi|669138647|ref|XM_008606670.1| | 1156394 | g39849 | i0 | 80.208 | 0.813559322033898 | 192 | 36 | 81 | 2 | 46 | 236 | 2109 | 1919 | Saprolegnia diclina VS20 hypothetical protein mRNA | blastn | 192 | 143 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 9531646 | 9531646 | PRJNA631119_P_NODE_12928_length_348_cov_1.534545_g12810_i0 | PRJNA631119 | 12928 | 348 | 1.534545 | 5.3402166 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 261 | 5.03e-65 | NTclustered | gi|2795044224|ref|XM_067924377.1| | 4785 | g12810 | i0 | 83.217 | 8.5 | 286 | 46 | 82 | 2 | 26 | 310 | 638 | 354 | Phytophthora cinnamomi Carbohydrate esterase (IUM83_00594), partial mRNA | blastn | 2958 | 261 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 9531724 | 9531724 | PRJNA631119_P_NODE_24988_length_273_cov_1.780000_g24870_i0 | PRJNA631119 | 24988 | 273 | 1.78 | 4.8594 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 8.219999999999999e-67 | NTclustered | gi|813171391|ref|XM_012349061.1| | 695850 | g24870 | i0 | 86.667 | 20.5054945054945 | 240 | 32 | 88 | 0 | 6 | 245 | 860 | 1099 | Saprolegnia parasitica CBS 223.65 adenosylhomocysteinase mRNA | blastn | 5598 | 267 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 11355229 | 11355229 | PRJNA631119_P_NODE_2209_length_720_cov_8.057187_g2104_i0 | PRJNA631119 | 2209 | 720 | 8.057187 | 58.0117464 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 477 | 1e-129 | NTclustered | gi|9858457|gb|AF085344.1|AF085344 | 82926 | g2104 | i0 | 85.621 | 61.8972222222222 | 459 | 61 | 63 | 4 | 165 | 621 | 483 | 28 | Pythium splendens calmodulin mRNA, complete cds | blastn | 44566 | 481 | 0.991683991683992 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 12082594 | 12082594 | PRJNA631119_P_NODE_13430_length_343_cov_1.744444_g13312_i0 | PRJNA631119 | 13430 | 343 | 1.744444 | 5.98344292 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 5.0199999999999985e-55 | NTclustered | gi|2795050879|ref|XM_067944282.1| | 4785 | g13312 | i0 | 80.317 | 7.43440233236152 | 315 | 50 | 90 | 8 | 5 | 313 | 534 | 226 | Phytophthora cinnamomi Mitochondrial Carrier (MC) Family (IUM83_19238), partial mRNA | blastn | 2550 | 228 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 12082731 | 12082731 | PRJNA631119_P_NODE_37930_length_242_cov_2.437870_g37812_i0 | PRJNA631119 | 37930 | 242 | 2.43787 | 5.8996454 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 7.3e-52 | NTclustered | gi|673019533|ref|XM_008865506.1| | 157072 | g37812 | i0 | 87.368 | 20.4628099173554 | 190 | 22 | 78 | 2 | 44 | 232 | 108 | 296 | Aphanomyces invadans hypothetical protein mRNA | blastn | 4952 | 217 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 12082733 | 12082733 | PRJNA631119_P_NODE_38270_length_242_cov_0.911243_g38152_i0 | PRJNA631119 | 38270 | 242 | 0.911243 | 2.20520806 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 1.2599999999999998e-29 | NTclustered | gi|698823182|ref|XM_009846318.1| | 112090 | g38152 | i0 | 77.459 | 1.93388429752066 | 244 | 51 | 100 | 4 | 1 | 242 | 490 | 249 | Aphanomyces astaci 60S ribosomal protein mRNA | blastn | 468 | 143 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 13357409 | 13357409 | PRJNA631119_P_NODE_21711_length_288_cov_1.888372_g21593_i0 | PRJNA631119 | 21711 | 288 | 1.888372 | 5.43851136 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 63.9 | 1.23e-5 | NTclustered | gi|675181624|ref|XM_008901449.1| | 761204 | g21593 | i0 | 95 | 0.375 | 40 | 2 | 14 | 0 | 49 | 88 | 102 | 141 | Phytophthora parasitica INRA-310 hypothetical protein mRNA | blastn | 108 | 63.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 14632089 | 14632089 | PRJNA631119_P_NODE_14392_length_334_cov_3.091954_g14274_i0 | PRJNA631119 | 14392 | 334 | 3.091954 | 10.32712636 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 8.509999999999999e-23 | NTclustered | gi|2794897781|ref|XM_067888306.1| | 164328 | g14274 | i0 | 81.507 | 3.49700598802395 | 146 | 27 | 44 | 0 | 132 | 277 | 298 | 443 | Phytophthora ramorum Embryonic polyadenylate-binding protein (KRP23_3453), partial mRNA | blastn | 1168 | 121 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 15906110 | 15906110 | PRJNA631119_P_NODE_37793_length_243_cov_0.905882_g37675_i0 | PRJNA631119 | 37793 | 243 | 0.905882 | 2.20129326 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 257 | 4.32e-64 | NTclustered | gi|813191598|ref|XM_012352292.1| | 695850 | g37675 | i0 | 85.892 | 31.201646090535 | 241 | 34 | 99 | 0 | 2 | 242 | 518 | 758 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 7582 | 257 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 19003409 | 19003409 | PRJNA631119_P_NODE_6595_length_451_cov_2.185185_g6477_i0 | PRJNA631119 | 6595 | 451 | 2.185185 | 9.85518435 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 1.9199999999999998e-40 | NTclustered | gi|813164261|ref|XM_012347801.1| | 695850 | g6477 | i0 | 79.528 | 32.0953436807095 | 254 | 50 | 56 | 2 | 189 | 441 | 611 | 359 | Saprolegnia parasitica CBS 223.65 40S ribosomal protein mRNA | blastn | 14475 | 180 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 20278331 | 20278331 | PRJNA631119_P_NODE_26396_length_267_cov_2.170103_g26278_i0 | PRJNA631119 | 26396 | 267 | 2.170103 | 5.79417501 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 8.419999999999998e-32 | NTclustered | gi|301119740|ref|XM_002907552.1| | 403677 | g26278 | i0 | 81.622 | 60.4157303370786 | 185 | 31 | 69 | 3 | 13 | 195 | 425 | 242 | Phytophthora infestans T30-4 60S ribosomal protein L23a (PITG_02694), mRNA | blastn | 16131 | 150 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 22280300 | 22280300 | PRJNA631119_P_NODE_21638_length_288_cov_15.037209_g21520_i0 | PRJNA631119 | 21638 | 288 | 15.037209 | 43.30716192 | Achlya bisexualis | 4766 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 6.8e-63 | NTclustered | gi|2289|emb|X59936.1| | 4766 | g21520 | i0 | 87.054 | 75.6909722222222 | 224 | 29 | 78 | 0 | 1 | 224 | 224 | 1 | A.bisexualis gene for actin | blastn | 21799 | 254 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya bisexualis | ||
| 23555849 | 23555849 | PRJNA631119_P_NODE_35419_length_245_cov_2.145349_g35301_i0 | PRJNA631119 | 35419 | 245 | 2.145349 | 5.25610505 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 6.02e-18 | NTclustered | gi|673042388|ref|XM_008876933.1| | 157072 | g35301 | i0 | 91.892 | 7.30204081632653 | 74 | 6 | 30 | 0 | 71 | 144 | 151 | 224 | Aphanomyces invadans 60S ribosomal protein L39 mRNA | blastn | 1789 | 104 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 24103788 | 24103788 | PRJNA631119_P_NODE_31679_length_250_cov_0.870056_g31561_i0 | PRJNA631119 | 31679 | 250 | 0.870056 | 2.17514 | Albugo | 65356 | SAR_Eukaryotes | SAR_Eukaryotes | 163 | 1e-35 | NTclustered | gi|325183295|emb|FR824085.1| | 890382 | g31561 | i0 | 83.333 | 6.536 | 180 | 27 | 72 | 2 | 1 | 180 | 34697 | 34873 | Albugo laibachii Nc14, genomic contig CONTIG_40_NC14_v4_133649_231 | blastn | 1634 | 163 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 24829524 | 24829524 | PRJNA631119_P_NODE_33520_length_248_cov_0.880000_g33402_i0 | PRJNA631119 | 33520 | 248 | 0.88 | 2.1824 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 2.7199999999999993e-46 | NTclustered | gi|813178309|ref|XM_012350234.1| | 695850 | g33402 | i0 | 82.895 | 6.49193548387097 | 228 | 31 | 90 | 7 | 1 | 224 | 5052 | 5275 | Saprolegnia parasitica CBS 223.65 pre-mRNA-processing-splicing factor 8 mRNA | blastn | 1610 | 198 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica |
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);;