contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA1093380" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1473771 | 1473771 | PRJNA1093380_P_NODE_5922_length_286_cov_1.084507_g5816_i0 | PRJNA1093380 | 5922 | 286 | 1.084507 | 3.10169002 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 1.15e-50 | NTclustered | gi|2795040101|ref|XM_067937224.1| | 4785 | g5816 | i0 | 85.366 | 295.524475524476 | 205 | 30 | 72 | 0 | 79 | 283 | 683 | 479 | Phytophthora cinnamomi Polyubiquitin (IUM83_12589), partial mRNA | blastn | 84520 | 213 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 2749875 | 2749875 | PRJNA1093380_P_NODE_3083_length_344_cov_1.136531_g2977_i0 | PRJNA1093380 | 3083 | 344 | 1.136531 | 3.90966664 | Actinosphaerium nucleofilum | 238767 | SAR_Eukaryotes | SAR_Eukaryotes | 342 | 1.7199999999999994e-89 | NTclustered | gi|33089895|gb|AY283757.1| | 238767 | g2977 | i0 | 84.682 | 98.8866279069767 | 346 | 49 | 100 | 4 | 1 | 344 | 596 | 253 | Actinosphaerium nucleofilum isolate Anu4_3 actin gene, partial cds | blastn | 34017 | 342 | 1 | Eukaryota | Sar | Actinophryidae | Actinosphaerium | Actinosphaerium nucleofilum | |||||
| 4025682 | 4025682 | PRJNA1093380_P_NODE_10544_length_258_cov_6.329730_g10438_i0 | PRJNA1093380 | 10544 | 258 | 6.32973 | 16.3307034 | Plasmodium gaboni | 647221 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 3.9e-5 | NTclustered | gi|1084815949|ref|XM_018784916.1| | 647221 | g10438 | i0 | 100 | 17.6046511627907 | 33 | 0 | 13 | 0 | 143 | 175 | 5403 | 5371 | Plasmodium gaboni E3 ubiquitin-protein ligase partial mRNA | blastn | 4542 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gaboni | ||
| 4025862 | 4025862 | PRJNA1093380_P_NODE_704_length_661_cov_3.523810_g603_i0 | PRJNA1093380 | 704 | 661 | 3.52381 | 23.2923841 | Spumella sp. OF-40 | 1432661 | SAR_Eukaryotes | SAR_Eukaryotes | 761 | 0 | NTclustered | gi|677286268|gb|KF997856.1| | 1432661 | g603 | i0 | 87.462 | 86.1875945537065 | 662 | 81 | 100 | 2 | 1 | 661 | 1287 | 627 | Spumella sp. OF-40 translation elongation factor 1-alpha (EF1A) mRNA, complete cds | blastn | 56970 | 761 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Spumella | Spumella sp. OF-40 | |||
| 4025914 | 4025914 | PRJNA1093380_P_NODE_9704_length_264_cov_1.209424_g9598_i0 | PRJNA1093380 | 9704 | 264 | 1.209424 | 3.19287936 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 2.9899999999999995e-31 | NTclustered | gi|166043101|emb|CU357747.1| | 100861 | g9598 | i0 | 84.314 | 3.92045454545455 | 153 | 22 | 58 | 2 | 16 | 167 | 742 | 893 | Aphanomyces euteiches cDNA | blastn | 1035 | 148 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 5302025 | 5302025 | PRJNA1093380_P_NODE_3685_length_322_cov_1.236948_g3579_i0 | PRJNA1093380 | 3685 | 322 | 1.236948 | 3.98297256 | Poteriospumella lacustris | 1117027 | SAR_Eukaryotes | SAR_Eukaryotes | 584 | 2.41e-162 | NTclustered | gi|2295553597|gb|OP378946.1| | 1117027 | g3579 | i0 | 99.379 | 100.400621118012 | 322 | 2 | 100 | 0 | 1 | 322 | 1329 | 1650 | Poteriospumella lacustris isolate 1532 large subunit ribosomal RNA gene, partial sequence | blastn | 32329 | 584 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Dinobryaceae | Poteriospumella | Poteriospumella lacustris | |||
| 6122360 | 6122360 | PRJNA1093380_P_NODE_705_length_661_cov_2.892857_g604_i0 | PRJNA1093380 | 705 | 661 | 2.892857 | 19.12178477 | Spumella | 89043 | SAR_Eukaryotes | SAR_Eukaryotes | 749 | 0 | NTclustered | gi|2055919756|gb|MZ420314.1| | 1955568 | g604 | i0 | 87.444 | 89.4236006051437 | 669 | 61 | 100 | 21 | 1 | 661 | 1967 | 1314 | Spumella sp. strain Woeam021018A5 large subunit ribosomal RNA gene, partial sequence | blastn | 59109 | 749 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Spumella | Spumella sp. | |||
| 6577086 | 6577086 | PRJNA1093380_P_NODE_1906_length_411_cov_2.230769_g1800_i0 | PRJNA1093380 | 1906 | 411 | 2.230769 | 9.16846059 | Spumella-like flagellate 376hm | 373013 | SAR_Eukaryotes | SAR_Eukaryotes | 407 | 7.319999999999999e-109 | NTclustered | gi|161015639|gb|EF577231.1| | 373013 | g1800 | i0 | 84.729 | 97.2092457420925 | 406 | 62 | 99 | 0 | 6 | 411 | 772 | 367 | Spumella-like flagellate 376hm alpha-tubulin gene, partial cds | blastn | 39953 | 407 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Spumella-like flagellate 376hm | ||||
| 6577177 | 6577177 | PRJNA1093380_P_NODE_926_length_574_cov_2.546906_g823_i0 | PRJNA1093380 | 926 | 574 | 2.546906 | 14.61924044 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 773 | 0 | NTclustered | gi|53829589|gb|AY582847.1| | 289359 | g823 | i0 | 90.957 | 85.8658536585366 | 575 | 50 | 100 | 2 | 1 | 574 | 732 | 159 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 actin gene, partial cds | blastn | 49287 | 773 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 7851875 | 7851875 | PRJNA1093380_P_NODE_2767_length_357_cov_1.683099_g2661_i0 | PRJNA1093380 | 2767 | 357 | 1.683099 | 6.00866343 | Spumella-like flagellate Got220 | 441774 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 3.88e-86 | NTclustered | gi|161015585|gb|EF577199.1| | 441774 | g2661 | i0 | 83.427 | 91.0896358543417 | 356 | 59 | 99 | 0 | 1 | 356 | 784 | 429 | Spumella-like flagellate Got220 beta-tubulin-like gene, partial sequence | blastn | 32519 | 331 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Spumella-like flagellate Got220 | ||||
| 7851907 | 7851907 | PRJNA1093380_P_NODE_5047_length_291_cov_2.059633_g4941_i0 | PRJNA1093380 | 5047 | 291 | 2.059633 | 5.99353203 | Plasmodium cynomolgi | 5827 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.027 | NTclustered | gi|457874729|ref|XM_004224026.1| | 1120755 | g4941 | i0 | 100 | 0.0962199312714777 | 28 | 0 | 10 | 0 | 230 | 257 | 290 | 263 | Plasmodium cynomolgi strain B hypothetical protein (PCYB_126920) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium cynomolgi | ||
| 9126842 | 9126842 | PRJNA1093380_P_NODE_428_length_869_cov_4.071608_g339_i0 | PRJNA1093380 | 428 | 869 | 4.071608 | 35.38227352 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 1024 | 0 | NTclustered | gi|53829555|gb|AY582830.1| | 289359 | g339 | i0 | 88.407 | 61.5339470655926 | 854 | 93 | 98 | 6 | 19 | 869 | 1238 | 388 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds | blastn | 53473 | 1024 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 10402444 | 10402444 | PRJNA1093380_P_NODE_1889_length_413_cov_2.550000_g1783_i0 | PRJNA1093380 | 1889 | 413 | 2.55 | 10.5315 | Spumella-like flagellate 1006 | 373018 | SAR_Eukaryotes | SAR_Eukaryotes | 333 | 1.2700000000000001e-86 | NTclustered | gi|161015636|gb|EF577229.1| | 373018 | g1783 | i0 | 81.418 | 84.9733656174334 | 409 | 74 | 99 | 2 | 6 | 413 | 585 | 178 | Spumella-like flagellate 1006 alpha-tubulin-like gene, partial sequence | blastn | 35094 | 333 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Spumella-like flagellate 1006 | ||||
| 11677781 | 11677781 | PRJNA1093380_P_NODE_2530_length_368_cov_1.542373_g2424_i0 | PRJNA1093380 | 2530 | 368 | 1.542373 | 5.67593264 | Isotricha intestinalis | 47897 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 3.23e-57 | NTclustered | gi|92790151|emb|AJ965261.1| | 47897 | g2424 | i0 | 85.841 | 63.0815217391304 | 226 | 26 | 61 | 6 | 145 | 368 | 915 | 694 | Isotricha intestinalis partial mRNA for Polyubiqutin 1 (polyubiqutin 1 gene) | blastn | 23214 | 235 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Vestibuliferida | Isotrichidae | Isotricha | Isotricha intestinalis | ||
| 12952894 | 12952894 | PRJNA1093380_P_NODE_17811_length_228_cov_3.561290_g17705_i0 | PRJNA1093380 | 17811 | 228 | 3.56129 | 8.1197412 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 5.08e-78 | NTclustered | gi|158347525|gb|EU047814.1| | 151077 | g17705 | i0 | 91.071 | 97.5833333333333 | 224 | 20 | 98 | 0 | 2 | 225 | 16 | 239 | Chilodonella uncinata clone Shared_P1 beta-tubulin gene, partial cds; macronuclear | blastn | 22249 | 303 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 14227843 | 14227843 | PRJNA1093380_P_NODE_17032_length_241_cov_0.916667_g16926_i0 | PRJNA1093380 | 17032 | 241 | 0.916667 | 2.20916747 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.6100000000000002e-33 | NTclustered | gi|813142527|ref|XM_012343931.1| | 695850 | g16926 | i0 | 79.452 | 98.6721991701245 | 219 | 45 | 91 | 0 | 1 | 219 | 441 | 659 | Saprolegnia parasitica CBS 223.65 60S ribosomal protein L3 mRNA | blastn | 23780 | 156 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 14227848 | 14227848 | PRJNA1093380_P_NODE_1732_length_428_cov_1.138028_g1626_i0 | PRJNA1093380 | 1732 | 428 | 1.138028 | 4.87075984 | Spumella lacusvadosi | 1841646 | SAR_Eukaryotes | SAR_Eukaryotes | 745 | 0 | NTclustered | gi|2055919768|gb|MZ420326.1| | 1841646 | g1626 | i0 | 98.804 | 95.9415887850467 | 418 | 5 | 98 | 0 | 11 | 428 | 1826 | 1409 | Spumella lacusvadosi strain Dongmak102320A2 large subunit ribosomal RNA gene, partial sequence | blastn | 41063 | 745 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Spumella | Spumella lacusvadosi | |||
| 14227872 | 14227872 | PRJNA1093380_P_NODE_2912_length_351_cov_1.381295_g2806_i0 | PRJNA1093380 | 2912 | 351 | 1.381295 | 4.84834545 | Bilabrum cf. latius | 3115832 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.033 | NTclustered | gi|2918369592|emb|OZ237758.1| | 3115832 | g2806 | i0 | 100 | 0.0797720797720798 | 28 | 0 | 8 | 0 | 99 | 126 | 206615 | 206642 | Bilabrum cf. latius genome assembly, chromosome: 24 | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Bigyra | Bicosoecida | Bilabrum | Bilabrum cf. latius | ||||
| 14227915 | 14227915 | PRJNA1093380_P_NODE_6832_length_280_cov_1.487923_g6726_i0 | PRJNA1093380 | 6832 | 280 | 1.487923 | 4.1661844 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 1.1099999999999995e-55 | NTclustered | gi|813102101|ref|XM_012338325.1| | 695850 | g6726 | i0 | 83.27 | 62.4535714285714 | 263 | 30 | 91 | 10 | 1 | 256 | 516 | 261 | Saprolegnia parasitica CBS 223.65 ATP synthase subunit beta partial mRNA | blastn | 17487 | 230 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 16776249 | 16776249 | PRJNA1093380_P_NODE_214_length_1209_cov_2.466549_g159_i0 | PRJNA1093380 | 214 | 1209 | 2.466549 | 29.82057741 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 846 | 0 | NTclustered | gi|53829555|gb|AY582830.1| | 289359 | g159 | i0 | 81.262 | 82.6732837055418 | 1062 | 185 | 87 | 14 | 1 | 1055 | 184 | 1238 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds | blastn | 99952 | 846 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 23151461 | 23151461 | PRJNA1093380_P_NODE_3439_length_330_cov_2.311284_g3333_i0 | PRJNA1093380 | 3439 | 330 | 2.311284 | 7.6272372 | Aphanomyces sinensis | 1125843 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 1.01e-71 | NTclustered | gi|2813228406|dbj|LC754346.1| | 1125843 | g3333 | i0 | 82.335 | 94.0272727272727 | 334 | 51 | 100 | 7 | 1 | 330 | 513 | 184 | Aphanomyces sinensis NBRC 106581 btub gene for beta-tubulin, partial cds | blastn | 31029 | 283 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces sinensis | ||
| 25245570 | 25245570 | PRJNA1093380_P_NODE_1500_length_453_cov_2.810526_g1395_i0 | PRJNA1093380 | 1500 | 453 | 2.810526 | 12.73168278 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 407 | 8.129999999999999e-109 | NTclustered | gi|161734|gb|L01415.1|TETBTUBUA | 5911 | g1395 | i0 | 83.002 | 95.9911699779249 | 453 | 73 | 99 | 4 | 3 | 453 | 950 | 1400 | Tetrahymena thermophila beta-tubulin (BTU1) gene, complete cds | blastn | 43484 | 407 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila |
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);;