contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA849822" and tax_clade = "core chlorophytes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3389419 | 3389419 | PRJNA849822_P_NODE_39883_length_246_cov_0.901734_g39709_i0 | PRJNA849822 | 39883 | 246 | 0.901734 | 2.21826564 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 132 | 2.77e-26 | NTclustered | gi|2082260933|ref|XM_001696969.2| | 3055 | g39709 | i0 | 77.674 | 0.873983739837398 | 215 | 48 | 87 | 0 | 16 | 230 | 1538 | 1324 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g523850v5), mRNA | blastn | 215 | 132 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 3389539 | 3389539 | PRJNA849822_P_NODE_9803_length_478_cov_4.629630_g9630_i0 | PRJNA849822 | 9803 | 478 | 4.62963 | 22.1296314 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 106 | 3.52e-18 | NTclustered | gi|2082260798|ref|XM_001697008.2| | 3055 | g9630 | i0 | 92 | 1.16108786610879 | 75 | 6 | 16 | 0 | 282 | 356 | 957 | 1031 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g520500v5), mRNA | blastn | 555 | 106 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 5061517 | 5061517 | PRJNA849822_P_NODE_18404_length_337_cov_1.587121_g18230_i0 | PRJNA849822 | 18404 | 337 | 1.587121 | 5.34859777 | Eukaryota | 2759 | Plants | Plants | 60.2 | 1.9e-4 | NTclustered | gi|2082250449|ref|XM_043064139.1| | 3055 | g18230 | i0 | 97.222 | 2.24629080118694 | 36 | 0 | 10 | 1 | 204 | 238 | 4497 | 4532 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_07g328250v5), mRNA | blastn | 757 | 60.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 5941783 | 5941783 | PRJNA849822_P_NODE_22225_length_307_cov_1.726496_g22051_i0 | PRJNA849822 | 22225 | 307 | 1.726496 | 5.30034272 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 174 | 5.86e-39 | NTclustered | gi|2082248650|ref|XM_043063418.1| | 3055 | g22051 | i0 | 77.857 | 29.6449511400651 | 280 | 62 | 91 | 0 | 7 | 286 | 578 | 857 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g290950v5), mRNA | blastn | 9101 | 174 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 7216804 | 7216804 | PRJNA849822_P_NODE_35046_length_251_cov_1.213483_g34872_i0 | PRJNA849822 | 35046 | 251 | 1.213483 | 3.04584233 | Polytomella sp. Pringsheim 198.80 | 37502 | Plants | Plants | 95.3 | 3.73e-15 | NTclustered | gi|635557420|emb|FN984965.1| | 37502 | g34872 | i0 | 84 | 8.18326693227092 | 100 | 14 | 39 | 2 | 29 | 127 | 1356 | 1454 | Polytomella sp. Pringsheim 198.80 mRNA for S-Adenosyl homocysteine hydrolase (sah1 gene) | blastn | 2054 | 95.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella sp. Pringsheim 198.80 | |
| 7216870 | 7216870 | PRJNA849822_P_NODE_4566_length_743_cov_1.950746_g4402_i0 | PRJNA849822 | 4566 | 743 | 1.950746 | 14.49404278 | Volvox carteri | 3067 | Plants | Plants | 656 | 0 | NTclustered | gi|302849657|ref|XM_002956312.1| | 3068 | g4402 | i0 | 83.593 | 83.9865410497981 | 707 | 109 | 95 | 6 | 32 | 734 | 517 | 1220 | Volvox carteri f. nagariensis beta tubulin (tubB2), mRNA | blastn | 62402 | 656 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 8491344 | 8491344 | PRJNA849822_P_NODE_13007_length_407_cov_1.634731_g12833_i0 | PRJNA849822 | 13007 | 407 | 1.634731 | 6.65335517 | Cephaleuros karstenii | 1985640 | Plants | Plants | 54.7 | 0.011 | NTclustered | gi|2192923902|ref|NC_060534.1| | 1985640 | g12833 | i0 | 100 | 0.0712530712530713 | 29 | 0 | 7 | 0 | 372 | 400 | 280455 | 280483 | Cephaleuros karstenii strain GD1942 chloroplast, complete genome | blastn | 29 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Trentepohliales | Trentepohliaceae | Cephaleuros | Cephaleuros karstenii | |
| 10162065 | 10162065 | PRJNA849822_P_NODE_6728_length_595_cov_3.045977_g6559_i0 | PRJNA849822 | 6728 | 595 | 3.045977 | 18.12356315 | Eukaryota | 2759 | Plants | Plants | 324 | 1.13e-83 | NTclustered | gi|552825417|ref|XM_005846759.1| | 554065 | g6559 | i0 | 81.818 | 33.9663865546218 | 385 | 70 | 65 | 0 | 132 | 516 | 13 | 397 | Chlorella variabilis 40S ribosomal protein S14 (CHLNCDRAFT_135401) mRNA, complete cds | blastn | 20210 | 327 | 0.990825688073395 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 14866594 | 14866594 | PRJNA849822_P_NODE_24352_length_293_cov_2.127273_g24178_i0 | PRJNA849822 | 24352 | 293 | 2.127273 | 6.23290989 | Trebouxia sp. ex Placidium sp. PJ-2019a | 2571973 | Plants | Plants | 542 | 1.32e-149 | NTclustered | gi|1691252205|emb|LR586036.1| | 2571973 | g24178 | i0 | 100 | 99.7713310580205 | 293 | 0 | 100 | 0 | 1 | 293 | 457 | 165 | Trebouxia sp. ex Placidium sp. PJ-2019a partial 26S rRNA gene, isolate Trebouxia sp. pj16 ex Placidium sp. PJ-2019a | blastn | 29233 | 542 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. ex Placidium sp. PJ-2019a | |
| 17416810 | 17416810 | PRJNA849822_P_NODE_24634_length_292_cov_1.296804_g24460_i0 | PRJNA849822 | 24634 | 292 | 1.296804 | 3.78666768 | Pseudochlorella signiensis | 173497 | Plants | Plants | 540 | 4.74e-149 | NTclustered | gi|725650714|ref|NC_025529.1| | 173497 | g24460 | i0 | 100 | 120.794520547945 | 292 | 0 | 100 | 0 | 1 | 292 | 151604 | 151313 | Pabia signiensis culture-collection SAG:7.90 chloroplast, complete genome | blastn | 35272 | 540 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Pseudochlorella | Pseudochlorella signiensis | |
| 18689986 | 18689986 | PRJNA849822_P_NODE_33975_length_252_cov_3.256983_g33801_i0 | PRJNA849822 | 33975 | 252 | 3.256983 | 8.20759716 | Volvox carteri | 3067 | Plants | Plants | 52.8 | 0.023 | NTclustered | gi|302837607|ref|XM_002950317.1| | 3068 | g33801 | i0 | 100 | 0.111111111111111 | 28 | 0 | 11 | 0 | 25 | 52 | 940 | 967 | Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_90672), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 19965116 | 19965116 | PRJNA849822_P_NODE_35316_length_251_cov_0.876404_g35142_i0 | PRJNA849822 | 35316 | 251 | 0.876404 | 2.19977404 | Diplosphaera sp. (in: green algae) | 2911680 | Plants | Plants | 267 | 7.459999999999999e-67 | NTclustered | gi|2644500050|gb|PP079688.1| | 2911680 | g35142 | i0 | 99.32 | 69.1274900398406 | 147 | 1 | 59 | 0 | 105 | 251 | 1973 | 1827 | Diplosphaera sp. (in: green algae) isolate C3 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 17351 | 267 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Diplosphaera | Diplosphaera sp. (in: green algae) | |
| 20359912 | 20359912 | PRJNA849822_P_NODE_35076_length_251_cov_0.943820_g34902_i0 | PRJNA849822 | 35076 | 251 | 0.94382 | 2.3689882 | Eukaryota | 2759 | Plants | Plants | 147 | 1.01e-30 | NTclustered | gi|2082248989|ref|XM_001691400.2| | 3055 | g34902 | i0 | 79.279 | 56.9442231075697 | 222 | 36 | 86 | 8 | 28 | 244 | 956 | 740 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g298650v5), mRNA | blastn | 14293 | 148 | 0.993243243243243 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 22515310 | 22515310 | PRJNA849822_P_NODE_18578_length_336_cov_0.874525_g18404_i0 | PRJNA849822 | 18578 | 336 | 0.874525 | 2.938404 | Volvox carteri | 3067 | Plants | Plants | 54.7 | 0.009 | NTclustered | gi|302829772|ref|XM_002946407.1| | 3068 | g18404 | i0 | 100 | 0.169642857142857 | 29 | 0 | 9 | 0 | 204 | 232 | 595 | 567 | Volvox carteri f. nagariensis RegA-like protein RlsL (rlsL), partial mRNA | blastn | 57 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 22515396 | 22515396 | PRJNA849822_P_NODE_29998_length_267_cov_1.206186_g29824_i0 | PRJNA849822 | 29998 | 267 | 1.206186 | 3.22051662 | Helicosporidium sp. ex Simulium jonesi | 145475 | Plants | Plants | 206 | 1.77e-48 | NTclustered | gi|54399515|gb|AY729488.1| | 145475 | g29824 | i0 | 87.931 | 9.25468164794007 | 174 | 21 | 65 | 0 | 1 | 174 | 403 | 576 | Helicosporidium sp. ex Simulium jonesii EF-1 alpha-like protein (efl) mRNA, complete cds | blastn | 2471 | 206 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Helicosporidium | Helicosporidium sp. ex Simulium jonesi | |
| 22911131 | 22911131 | PRJNA849822_P_NODE_31458_length_260_cov_6.668449_g31284_i0 | PRJNA849822 | 31458 | 260 | 6.668449 | 17.3379674 | Eukaryota | 2759 | Plants | Plants | 481 | 2.55e-131 | NTclustered | gi|1201359270|gb|MF040792.1| | 3078 | g31284 | i0 | 100 | 100 | 260 | 0 | 100 | 0 | 1 | 260 | 339 | 80 | Auxenochlorella pyrenoidosa isolate HIT9 18S ribosomal RNA gene, partial sequence | blastn | 26000 | 481 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa |
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);;