contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJEB58983" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 124874 | 124874 | PRJEB58983_P_NODE_24481_length_267_cov_2.860825_g24066_i0 | PRJEB58983 | 24481 | 267 | 2.860825 | 7.63840275 | Stichococcus bacillaris | 37433 | Plants | Plants | 494 | 3.38e-135 | NTclustered | gi|371782093|emb|HE610125.1| | 37433 | g24066 | i0 | 100 | 99.9737827715356 | 267 | 0 | 100 | 0 | 1 | 267 | 4594 | 4328 | Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 | blastn | 26693 | 494 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 992178 | 992178 | PRJEB58983_P_NODE_3961_length_612_cov_5.441558_g3554_i0 | PRJEB58983 | 3961 | 612 | 5.441558 | 33.30233496 | Chlorellaceae | 35461 | Plants | Plants | 965 | 0 | NTclustered | gi|254798615|ref|NC_012978.1| | 3074 | g3554 | i0 | 95.114 | 111.307189542484 | 614 | 26 | 100 | 3 | 1 | 612 | 93804 | 93193 | Parachlorella kessleri chloroplast, complete genome | blastn | 68120 | 972 | 0.992798353909465 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Parachlorella | Parachlorella kessleri | |
| 1399531 | 1399531 | PRJEB58983_P_NODE_32822_length_240_cov_2.077844_g32407_i0 | PRJEB58983 | 32822 | 240 | 2.077844 | 4.9868256 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 145 | 3.46e-30 | NTclustered | gi|2082248650|ref|XM_043063418.1| | 3055 | g32407 | i0 | 77.778 | 25.15 | 234 | 52 | 98 | 0 | 7 | 240 | 598 | 831 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g290950v5), mRNA | blastn | 6036 | 145 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 2674973 | 2674973 | PRJEB58983_P_NODE_24443_length_267_cov_5.201031_g24028_i0 | PRJEB58983 | 24443 | 267 | 5.201031 | 13.88675277 | Dicloster acuatus | 91190 | Plants | Plants | 374 | 4.589999999999998e-99 | NTclustered | gi|725651324|ref|NC_025546.1| | 91190 | g24028 | i0 | 99.038 | 123.468164794007 | 208 | 2 | 100 | 0 | 1 | 208 | 100867 | 101074 | Dicloster acuatus culture-collection SAG:41.98 chloroplast, complete genome | blastn | 32966 | 374 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Dicloster | Dicloster acuatus | |
| 3542635 | 3542635 | PRJEB58983_P_NODE_20243_length_288_cov_4.860465_g19828_i0 | PRJEB58983 | 20243 | 288 | 4.860465 | 13.9981392 | Eukaryota | 2759 | Plants | Plants | 520 | 6.079999999999999e-143 | NTclustered | gi|2031975395|emb|OD962788.1| | 3077 | g19828 | i0 | 99.303 | 100.670138888889 | 287 | 2 | 99 | 0 | 2 | 288 | 1037 | 1323 | Chlorella vulgaris partial 18S rRNA gene, strain JKVK1 | blastn | 28993 | 520 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 3542715 | 3542715 | PRJEB58983_P_NODE_34963_length_219_cov_4.130137_g34548_i0 | PRJEB58983 | 34963 | 219 | 4.130137 | 9.04500003 | Chlorophyta | 3041 | Plants | Plants | 405 | 1.29e-108 | NTclustered | gi|1799637107|gb|MN968499.1| | 29647 | g34548 | i0 | 100 | 100.383561643836 | 219 | 0 | 100 | 0 | 1 | 219 | 18 | 236 | Stichococcus sp. strain SAG 379-2 small subunit ribosomal RNA gene, partial sequence | blastn | 21984 | 405 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus sp. | |
| 7369552 | 7369552 | PRJEB58983_P_NODE_15126_length_328_cov_2.345098_g14711_i0 | PRJEB58983 | 15126 | 328 | 2.345098 | 7.69192144 | Eukaryota | 2759 | Plants | Plants | 141 | 6.399999999999998e-29 | NTclustered | gi|28193497|emb|AJ439528.1| | 37502 | g14711 | i0 | 81.215 | 41.8079268292683 | 181 | 29 | 54 | 4 | 1 | 178 | 417 | 595 | Polytomella sp. 'Pringsheim 198.80' mRNA for 40S ribosomal protein s5 (rs5 gene) | blastn | 13713 | 141 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella sp. Pringsheim 198.80 | |
| 8645254 | 8645254 | PRJEB58983_P_NODE_30387_length_246_cov_14.069364_g29972_i0 | PRJEB58983 | 30387 | 246 | 14.069364 | 34.61063544 | Chlorophyta | 3041 | Plants | Plants | 449 | 6.74e-122 | NTclustered | gi|1810811894|gb|MT078160.1| | 187459 | g29972 | i0 | 99.593 | 99.8333333333333 | 246 | 1 | 100 | 0 | 1 | 246 | 1024 | 1269 | Desmococcus olivaceus strain SAG 63.90 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1 and 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 24559 | 449 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Desmococcus | Desmococcus olivaceus | |
| 10327736 | 10327736 | PRJEB58983_P_NODE_14269_length_336_cov_6.558935_g13854_i0 | PRJEB58983 | 14269 | 336 | 6.558935 | 22.0380216 | Coccomyxa viridis | 1274662 | Plants | Plants | 621 | 1.9299999999999997e-173 | NTclustered | gi|375126617|gb|JQ278717.1| | 1274662 | g13854 | i0 | 100 | 110.571428571429 | 336 | 0 | 100 | 0 | 1 | 336 | 417 | 82 | Coccomyxa viridis strain SAG 2040 23S ribosomal RNA gene, partial sequence; and putative LAGLIDADG homing endonuclease gene, complete cds; chloroplast | blastn | 37152 | 621 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 11603678 | 11603678 | PRJEB58983_P_NODE_7590_length_448_cov_10.018667_g7176_i0 | PRJEB58983 | 7590 | 448 | 10.018667 | 44.88362816 | Coccomyxa viridis | 1274662 | Plants | Plants | 737 | 0 | NTclustered | gi|2663407540|emb|OY754499.1| | 1274662 | g7176 | i0 | 96.429 | 124.015625 | 448 | 14 | 100 | 2 | 1 | 448 | 157710 | 158155 | Coccomyxa viridis genome assembly, organelle: plastid | blastn | 55559 | 737 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 14153236 | 14153236 | PRJEB58983_P_NODE_20052_length_289_cov_6.013889_g19637_i0 | PRJEB58983 | 20052 | 289 | 6.013889 | 17.38013921 | Stichococcus bacillaris | 37433 | Plants | Plants | 501 | 2.21e-137 | NTclustered | gi|371782093|emb|HE610125.1| | 37433 | g19637 | i0 | 97.924 | 100.124567474048 | 289 | 6 | 100 | 0 | 1 | 289 | 3197 | 2909 | Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 | blastn | 28936 | 501 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 14153496 | 14153496 | PRJEB58983_P_NODE_3352_length_675_cov_3.247508_g2952_i0 | PRJEB58983 | 3352 | 675 | 3.247508 | 21.920679 | Haematococcus lacustris | 44745 | Plants | Plants | 568 | 5.399999999999999e-157 | NTclustered | gi|1279575454|gb|MF683078.1| | 44745 | g2952 | i0 | 82.174 | 357.333333333333 | 690 | 96 | 100 | 25 | 1 | 675 | 3641 | 2964 | Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast | blastn | 241200 | 568 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 17569937 | 17569937 | PRJEB58983_P_NODE_18994_length_296_cov_2.139013_g18579_i0 | PRJEB58983 | 18994 | 296 | 2.139013 | 6.33147848 | root | 1 | Root_unresolved | Root_unresolved | 427 | 3.9099999999999996e-115 | NTclustered | gi|758819250|dbj|LC004716.1| | 3068 | g18579 | i0 | 98.75 | 77.9898648648649 | 240 | 3 | 81 | 0 | 56 | 295 | 1550 | 1789 | Volvox carteri f. nagariensis DNA, strain: NIES 398 | blastn | 23085 | 427 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 19250297 | 19250297 | PRJEB58983_P_NODE_16276_length_317_cov_6.733607_g15861_i0 | PRJEB58983 | 16276 | 317 | 6.733607 | 21.34553419 | Parachlorella kessleri | 3074 | Plants | Plants | 560 | 3.99e-155 | NTclustered | gi|254798615|ref|NC_012978.1| | 3074 | g15861 | i0 | 99.353 | 118.06309148265 | 309 | 2 | 97 | 0 | 1 | 309 | 93042 | 92734 | Parachlorella kessleri chloroplast, complete genome | blastn | 37426 | 560 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Parachlorella | Parachlorella kessleri | |
| 19250637 | 19250637 | PRJEB58983_P_NODE_32496_length_242_cov_0.923077_g32081_i0 | PRJEB58983 | 32496 | 242 | 0.923077 | 2.23384634 | Coccomyxa viridis | 1274662 | Plants | Plants | 213 | 9.45e-51 | NTclustered | gi|2663407678|emb|OZ004252.1| | 1274662 | g32081 | i0 | 96.154 | 235.636363636364 | 130 | 5 | 94 | 0 | 113 | 242 | 35428 | 35299 | Coccomyxa viridis genome assembly, organelle: mitochondrion | blastn | 57024 | 213 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 20525643 | 20525643 | PRJEB58983_P_NODE_14677_length_332_cov_7.818533_g14262_i0 | PRJEB58983 | 14677 | 332 | 7.818533 | 25.95752956 | Stichococcus bacillaris | 37433 | Plants | Plants | 586 | 6.929999999999998e-163 | NTclustered | gi|371782093|emb|HE610125.1| | 37433 | g14262 | i0 | 97.892 | 16.2379518072289 | 332 | 7 | 100 | 0 | 1 | 332 | 7323 | 6992 | Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 | blastn | 5391 | 586 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 20525675 | 20525675 | PRJEB58983_P_NODE_16077_length_319_cov_3.056911_g15662_i0 | PRJEB58983 | 16077 | 319 | 3.056911 | 9.75154609 | Coccomyxa viridis | 1274662 | Plants | Plants | 579 | 1.1099999999999996e-160 | NTclustered | gi|375126604|gb|JQ278712.1| | 1274662 | g15662 | i0 | 99.373 | 83.833855799373 | 319 | 2 | 100 | 0 | 1 | 319 | 872 | 554 | Coccomyxa viridis strain SAG 216-4 23S ribosomal RNA gene, partial sequence; and putative LAGLIDADG homing endonuclease gene, complete cds; chloroplast | blastn | 26743 | 579 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 21801598 | 21801598 | PRJEB58983_P_NODE_22318_length_277_cov_3.813725_g21903_i0 | PRJEB58983 | 22318 | 277 | 3.813725 | 10.56401825 | Dicloster acuatus | 91190 | Plants | Plants | 470 | 5.939999999999998e-128 | NTclustered | gi|725651324|ref|NC_025546.1| | 91190 | g21903 | i0 | 97.455 | 128.191335740072 | 275 | 7 | 99 | 0 | 1 | 275 | 98785 | 98511 | Dicloster acuatus culture-collection SAG:41.98 chloroplast, complete genome | blastn | 35509 | 470 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Dicloster | Dicloster acuatus | |
| 23076634 | 23076634 | PRJEB58983_P_NODE_10219_length_391_cov_2.415094_g9804_i0 | PRJEB58983 | 10219 | 391 | 2.415094 | 9.44301754 | Chlorella sorokiniana | 3076 | Plants | Plants | 610 | 4.919999999999998e-170 | NTclustered | gi|669174894|gb|KJ742376.1| | 3076 | g9804 | i0 | 94.872 | 102.012787723785 | 390 | 20 | 99 | 0 | 1 | 390 | 74770 | 74381 | Chlorella sorokiniana isolate 1230 chloroplast, complete genome | blastn | 39887 | 610 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 24350729 | 24350729 | PRJEB58983_P_NODE_2400_length_809_cov_2.902174_g2031_i0 | PRJEB58983 | 2400 | 809 | 2.902174 | 23.47858766 | Haematococcus lacustris | 44745 | Plants | Plants | 859 | 0 | NTclustered | gi|1279575454|gb|MF683078.1| | 44745 | g2031 | i0 | 87.03 | 191.793572311496 | 771 | 89 | 94 | 10 | 6 | 769 | 2909 | 3675 | Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast | blastn | 155161 | 859 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 25218192 | 25218192 | PRJEB58983_P_NODE_25100_length_264_cov_4.193717_g24685_i0 | PRJEB58983 | 25100 | 264 | 4.193717 | 11.07141288 | Eukaryota | 2759 | Plants | Plants | 488 | 1.5499999999999999e-133 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g24685 | i0 | 100 | 100.003787878788 | 264 | 0 | 100 | 0 | 1 | 264 | 288 | 25 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 26401 | 488 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. |
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);;