contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA1136505" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1032003 | 1032003 | PRJNA1136505_P_NODE_82341_length_321_cov_2.036290_g75481_i0 | PRJNA1136505 | 82341 | 321 | 2.03629 | 6.5364909 | root | 1 | Root_unresolved | Root_unresolved | 549 | 8.759999999999997e-152 | NTclustered | gi|166044596|emb|CU367505.1| | 100861 | g75481 | i0 | 97.508 | 94.9127725856698 | 321 | 8 | 100 | 0 | 1 | 321 | 152 | 472 | Aphanomyces euteiches cDNA | blastn | 30467 | 549 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 4860043 | 4860043 | PRJNA1136505_P_NODE_156444_length_239_cov_2.319277_g149584_i0 | PRJNA1136505 | 156444 | 239 | 2.319277 | 5.54307203 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 7.2e-52 | NTclustered | gi|166045949|emb|CU363861.1| | 100861 | g149584 | i0 | 83.983 | 20.1213389121339 | 231 | 32 | 95 | 4 | 1 | 228 | 304 | 532 | Aphanomyces euteiches cDNA | blastn | 4809 | 217 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 6662368 | 6662368 | PRJNA1136505_P_NODE_57906_length_398_cov_3.043077_g51046_i0 | PRJNA1136505 | 57906 | 398 | 3.043077 | 12.11144646 | Placidida sp. | 2810146 | SAR_Eukaryotes | SAR_Eukaryotes | 311 | 5.7000000000000006e-80 | NTclustered | gi|2048770197|gb|MT042897.1| | 2810146 | g51046 | i0 | 81.867 | 84.4070351758794 | 375 | 62 | 93 | 6 | 24 | 395 | 1 | 372 | Placidida sp. strain HFCC739 ribosomal protein S15A mRNA, complete cds | blastn | 33594 | 311 | 1 | Eukaryota | Sar | Bigyra | Placidida | Placidida sp. | |||||
| 9212503 | 9212503 | PRJNA1136505_P_NODE_156768_length_237_cov_2.304878_g149908_i0 | PRJNA1136505 | 156768 | 237 | 2.304878 | 5.46256086 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 3.53e-5 | NTclustered | gi|914997060|ref|XM_013391675.1| | 5801 | g149908 | i0 | 100 | 1.78481012658228 | 33 | 0 | 14 | 0 | 1 | 33 | 2366 | 2334 | Eimeria acervulina ImpB/MucB/SamB family domain-containing protein, putative partial mRNA | blastn | 423 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 9212511 | 9212511 | PRJNA1136505_P_NODE_25148_length_859_cov_9.329517_g18690_i0 | PRJNA1136505 | 25148 | 859 | 9.329517 | 80.14055103 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 460 | 1.21e-124 | NTclustered | gi|2795027745|ref|XM_067926220.1| | 4785 | g18690 | i0 | 80.187 | 63.813736903376 | 641 | 106 | 74 | 18 | 158 | 789 | 133 | 761 | Phytophthora cinnamomi 40S ribosomal protein S2 (IUM83_02311), partial mRNA | blastn | 54816 | 460 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 10488067 | 10488067 | PRJNA1136505_P_NODE_50889_length_437_cov_1.903846_g44030_i0 | PRJNA1136505 | 50889 | 437 | 1.903846 | 8.31980702 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 6.77e-30 | NTclustered | gi|820692312|tpe|LN714484.1| | 572307 | g44030 | i0 | 85.926 | 6.70022883295194 | 135 | 19 | 31 | 0 | 300 | 434 | 2002162 | 2002028 | TPA_asm: Neospora caninum Liverpool, chromosome chrIX, complete genome | blastn | 2928 | 145 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 10488090 | 10488090 | PRJNA1136505_P_NODE_93689_length_298_cov_2.897778_g86829_i0 | PRJNA1136505 | 93689 | 298 | 2.897778 | 8.63537844 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 1.6099999999999997e-24 | NTclustered | gi|2794879580|ref|XM_067889356.1| | 164328 | g86829 | i0 | 86.207 | 2.72818791946309 | 116 | 16 | 39 | 0 | 149 | 264 | 116 | 1 | Phytophthora ramorum 40S ribosomal protein S21 (KRP23_462), partial mRNA | blastn | 813 | 126 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 11763167 | 11763167 | PRJNA1136505_P_NODE_89390_length_307_cov_0.841880_g82530_i0 | PRJNA1136505 | 89390 | 307 | 0.84188 | 2.5845716 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 5.58e-74 | NTclustered | gi|813192857|ref|XM_012352921.1| | 695850 | g82530 | i0 | 84.106 | 39.3615635179153 | 302 | 46 | 98 | 2 | 7 | 307 | 1297 | 997 | Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA | blastn | 12084 | 291 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 13038190 | 13038190 | PRJNA1136505_P_NODE_135791_length_249_cov_0.875000_g128931_i0 | PRJNA1136505 | 135791 | 249 | 0.875 | 2.17875 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 1.68e-28 | NTclustered | gi|669156411|ref|XM_008615546.1| | 1156394 | g128931 | i0 | 92.708 | 4.86746987951807 | 96 | 7 | 39 | 0 | 3 | 98 | 1127 | 1222 | Saprolegnia diclina VS20 acyl-CoA dehydrogenase mRNA | blastn | 1212 | 139 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 13038231 | 13038231 | PRJNA1136505_P_NODE_27411_length_777_cov_2.250000_g20797_i0 | PRJNA1136505 | 27411 | 777 | 2.25 | 17.4825 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 5.530000000000001e-63 | NTclustered | gi|2795047539|ref|XM_067937834.1| | 4785 | g20797 | i0 | 77.677 | 34.6705276705277 | 439 | 84 | 56 | 13 | 12 | 443 | 1 | 432 | Phytophthora cinnamomi 60S ribosomal protein (IUM83_13175), partial mRNA | blastn | 26939 | 255 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 14313481 | 14313481 | PRJNA1136505_P_NODE_99132_length_289_cov_2.138889_g92272_i0 | PRJNA1136505 | 99132 | 289 | 2.138889 | 6.18138921 | Saprolegnia diclina | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 6.83e-63 | NTclustered | gi|669165177|ref|XM_008619929.1| | 1156394 | g92272 | i0 | 83.214 | 11.8961937716263 | 280 | 43 | 96 | 3 | 12 | 289 | 1120 | 843 | Saprolegnia diclina VS20 hypothetical protein mRNA | blastn | 3438 | 254 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 15059684 | 15059684 | PRJNA1136505_P_NODE_85972_length_313_cov_2.454167_g79112_i0 | PRJNA1136505 | 85972 | 313 | 2.454167 | 7.68154271 | Saprolegniales | 4763 | SAR_Eukaryotes | SAR_Eukaryotes | 87.9 | 8.03e-13 | NTclustered | gi|166038860|emb|CU355090.1| | 100861 | g79112 | i0 | 85.542 | 23.0095846645367 | 83 | 12 | 27 | 0 | 231 | 313 | 750 | 668 | Aphanomyces euteiches cDNA | blastn | 7202 | 87.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 16334409 | 16334409 | PRJNA1136505_P_NODE_40133_length_530_cov_3.564551_g33290_i0 | PRJNA1136505 | 40133 | 530 | 3.564551 | 18.8921203 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 231 | 6.22e-56 | NTclustered | gi|813141990|ref|XM_012343753.1| | 695850 | g33290 | i0 | 79.36 | 11.4867924528302 | 344 | 59 | 64 | 8 | 113 | 453 | 463 | 129 | Saprolegnia parasitica CBS 223.65 40S ribosomal protein S11 mRNA | blastn | 6088 | 231 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 16861584 | 16861584 | PRJNA1136505_P_NODE_125074_length_256_cov_2.797814_g118214_i0 | PRJNA1136505 | 125074 | 256 | 2.797814 | 7.16240384 | Pfiesteria piscicida | 71001 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 4.47e-84 | NTclustered | gi|255965553|gb|FJ600030.1| | 71001 | g118214 | i0 | 89.723 | 96.6328125 | 253 | 26 | 99 | 0 | 4 | 256 | 17 | 269 | Pfiesteria piscicida clone Ppi+Rhod_cDNA160 Rac1 mRNA, complete cds | blastn | 24738 | 324 | 1 | Eukaryota | Sar | Dinophyceae | Peridiniales | Pfiesteriaceae | Pfiesteria | Pfiesteria piscicida | |||
| 16861629 | 16861629 | PRJNA1136505_P_NODE_39814_length_534_cov_3.078091_g32972_i0 | PRJNA1136505 | 39814 | 534 | 3.078091 | 16.43700594 | Bilabrum cf. latius | 3115832 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 3.13e-4 | NTclustered | gi|2918369599|emb|OZ237765.1| | 3115832 | g32972 | i0 | 100 | 0.0599250936329588 | 32 | 0 | 6 | 0 | 409 | 440 | 568107 | 568138 | Bilabrum cf. latius genome assembly, chromosome: 31 | blastn | 32 | 60.2 | 1 | Eukaryota | Sar | Bigyra | Bicosoecida | Bilabrum | Bilabrum cf. latius | ||||
| 21961282 | 21961282 | PRJNA1136505_P_NODE_32858_length_640_cov_3.246914_g26078_i0 | PRJNA1136505 | 32858 | 640 | 3.246914 | 20.7802496 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 340 | 1.21e-88 | NTclustered | gi|2795016619|ref|XM_067930420.1| | 4785 | g26078 | i0 | 79.278 | 55.80625 | 526 | 80 | 82 | 17 | 33 | 555 | 629 | 1128 | Phytophthora cinnamomi 60S ribosomal protein (IUM83_06233), partial mRNA | blastn | 35716 | 340 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 21961285 | 21961285 | PRJNA1136505_P_NODE_39958_length_532_cov_3.886710_g33116_i0 | PRJNA1136505 | 39958 | 532 | 3.88671 | 20.6772972 | uncultured Eimeriidae | 404735 | SAR_Eukaryotes | SAR_Eukaryotes | 466 | 1.57e-126 | NTclustered | gi|166083980|gb|EF024503.1| | 404735 | g33116 | i0 | 82.9 | 101.323308270677 | 538 | 72 | 100 | 18 | 1 | 532 | 560 | 37 | Eimeriidae environmental sample clone Elev_18S_807 18S ribosomal RNA gene, partial sequence | blastn | 53904 | 466 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | uncultured Eimeriidae | |||
| 23236822 | 23236822 | PRJNA1136505_P_NODE_40199_length_530_cov_1.582057_g33356_i0 | PRJNA1136505 | 40199 | 530 | 1.582057 | 8.3849021 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 388 | 3.4899999999999997e-103 | NTclustered | gi|695404622|ref|XM_009525283.1| | 67593 | g33356 | i0 | 81.628 | 77.322641509434 | 479 | 78 | 89 | 8 | 25 | 498 | 958 | 1431 | Phytophthora sojae hypothetical protein partial mRNA | blastn | 40981 | 388 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 25258298 | 25258298 | PRJNA1136505_P_NODE_33000_length_637_cov_3.083333_g26216_i0 | PRJNA1136505 | 33000 | 637 | 3.083333 | 19.64083121 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 239 | 4.53e-58 | NTclustered | gi|2795043501|ref|XM_067923847.1| | 4785 | g26216 | i0 | 81.373 | 8.22448979591837 | 306 | 45 | 47 | 10 | 311 | 609 | 308 | 8 | Phytophthora cinnamomi 40S ribosomal protein S10 (IUM83_00108), partial mRNA | blastn | 5239 | 239 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi |
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);;