contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJEB39269" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 989249 | 989249 | PRJEB39269_P_NODE_72621_length_165_cov_1.626984_g72216_i0 | PRJEB39269 | 72621 | 165 | 1.626984 | 2.6845236 | Chlorellaceae | 35461 | Plants | Plants | 65.8 | 1.77e-6 | NTclustered | gi|2724824493|gb|PP746561.1| | 97105 | g72216 | i0 | 91.667 | 6.55757575757576 | 48 | 3 | 28 | 1 | 1 | 47 | 421 | 374 | Marvania geminata culture SAG:12.88 mitochondrion, complete genome | blastn | 1082 | 65.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Marvania | Marvania geminata | |
| 2264529 | 2264529 | PRJEB39269_P_NODE_24202_length_284_cov_1.959184_g23797_i0 | PRJEB39269 | 24202 | 284 | 1.959184 | 5.56408256 | Chlorophyta | 3041 | Plants | Plants | 351 | 2.31e-92 | NTclustered | gi|1197510887|ref|NC_034709.1| | 141643 | g23797 | i0 | 89.161 | 106.183098591549 | 286 | 25 | 100 | 5 | 1 | 284 | 148799 | 149080 | Trichosarcina mucosa culture SAG:4.90 chloroplast, complete genome | blastn | 30156 | 351 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Sarcinofilaceae | Sarcinofilum | Sarcinofilum mucosum | |
| 2607023 | 2607023 | PRJEB39269_P_NODE_8803_length_466_cov_7.969555_g8405_i0 | PRJEB39269 | 8803 | 466 | 7.969555 | 37.1381263 | Trebouxia sp. SL0000003 | 3350044 | Plants | Plants | 58.4 | 0.001 | NTclustered | gi|2917929625|emb|OZ234913.1| | 3350044 | g8405 | i0 | 100 | 0.133047210300429 | 31 | 0 | 7 | 0 | 377 | 407 | 2994164 | 2994134 | Trebouxia sp. SL0000003 genome assembly, chromosome: 8 | blastn | 62 | 58.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. SL0000003 | |
| 3539788 | 3539788 | PRJEB39269_P_NODE_68983_length_169_cov_1.576923_g68578_i0 | PRJEB39269 | 68983 | 169 | 1.576923 | 2.66499987 | Chlorophyta | 3041 | Plants | Plants | 169 | 1.34e-37 | NTclustered | gi|2254866750|gb|MW900257.1| | 3077 | g68578 | i0 | 84.94 | 98.8343195266272 | 166 | 25 | 98 | 0 | 3 | 168 | 439 | 274 | Chlorella vulgaris chloroplast, complete genome | blastn | 16703 | 169 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 4817105 | 4817105 | PRJEB39269_P_NODE_28864_length_258_cov_10.844749_g28459_i0 | PRJEB39269 | 28864 | 258 | 10.844749 | 27.97945242 | Eukaryota | 2759 | Plants | Plants | 477 | 3.2699999999999985e-130 | NTclustered | gi|1201359270|gb|MF040792.1| | 3078 | g28459 | i0 | 100 | 99.9961240310078 | 258 | 0 | 100 | 0 | 1 | 258 | 366 | 109 | Auxenochlorella pyrenoidosa isolate HIT9 18S ribosomal RNA gene, partial sequence | blastn | 25799 | 477 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 7709490 | 7709490 | PRJEB39269_P_NODE_82127_length_157_cov_1.661017_g81722_i0 | PRJEB39269 | 82127 | 157 | 1.661017 | 2.60779669 | Edaphochlorella mirabilis | 3083 | Plants | Plants | 130 | 5.820000000000001e-26 | NTclustered | gi|725675941|ref|NC_025528.1| | 3083 | g81722 | i0 | 81.529 | 9.42675159235669 | 157 | 29 | 100 | 0 | 1 | 157 | 2708 | 2864 | 'Chlorella' mirabilis culture-collection SAG:38.88 chloroplast, complete genome | blastn | 1480 | 130 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Prasiolaceae | Edaphochlorella | Edaphochlorella mirabilis | |
| 8984196 | 8984196 | PRJEB39269_P_NODE_89568_length_151_cov_1.946429_g89163_i0 | PRJEB39269 | 89568 | 151 | 1.946429 | 2.93910779 | Chlamydomonas zimbabwiensis | 158510 | Plants | Plants | 235 | 1.14e-57 | NTclustered | gi|66864303|gb|DQ015758.1| | 158510 | g89163 | i0 | 94.702 | 30.9006622516556 | 151 | 8 | 100 | 0 | 1 | 151 | 3230 | 3080 | Chlamydomonas zimbabwiensis strain UTEX 2214 26S ribosomal RNA gene, partial sequence | blastn | 4666 | 235 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas zimbabwiensis | |
| 10259867 | 10259867 | PRJEB39269_P_NODE_68309_length_170_cov_1.137405_g67904_i0 | PRJEB39269 | 68309 | 170 | 1.137405 | 1.9335885 | Pedinophyceae sp. YPF-701 | 765719 | Plants | Plants | 158 | 2.93e-34 | NTclustered | gi|307931079|dbj|AB561039.1| | 765719 | g67904 | i0 | 88.55 | 40.5117647058824 | 131 | 13 | 76 | 2 | 39 | 168 | 267 | 396 | Pedinophyceae sp. YPF-701 chloroplast PsaB gene for photosystem I P700 apoprotein A2, partial cds | blastn | 6887 | 158 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 12468391 | 12468391 | PRJEB39269_P_NODE_86210_length_154_cov_1.252174_g85805_i0 | PRJEB39269 | 86210 | 154 | 1.252174 | 1.92834796 | Chlorophyta | 3041 | Plants | Plants | 285 | 1.14e-72 | NTclustered | gi|359385262|emb|FR865676.1| | 3082 | g85805 | i0 | 100 | 99.987012987013 | 154 | 0 | 100 | 0 | 1 | 154 | 816 | 663 | 'Chlorella' saccharophila genomic DNA containing 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, culture collection CCAP 211/57 | blastn | 15398 | 285 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium saccharophilum | |
| 12810583 | 12810583 | PRJEB39269_P_NODE_44371_length_206_cov_1.353293_g43966_i0 | PRJEB39269 | 44371 | 206 | 1.353293 | 2.78778358 | Chlamydomonas sp. CCMP235 | 327070 | Plants | Plants | 276 | 9.82e-70 | NTclustered | gi|2243438197|emb|LR798803.1| | 327070 | g43966 | i0 | 90.777 | 6.02912621359223 | 206 | 19 | 100 | 0 | 1 | 206 | 7017 | 6812 | Chlamydomonas sp. CCMP235 partial 45s rRNA cluster gene for 45s rRNA cluster | blastn | 1242 | 276 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. CCMP235 | |
| 13742732 | 13742732 | PRJEB39269_P_NODE_7691_length_497_cov_1.541485_g7295_i0 | PRJEB39269 | 7691 | 497 | 1.541485 | 7.66118045 | Chlorogonium | 52027 | Plants | Plants | 778 | 0 | NTclustered | gi|17028187|gb|L42860.1|CGZCPRGOL | 52029 | g7295 | i0 | 95.325 | 138.595573440644 | 492 | 20 | 99 | 3 | 8 | 497 | 3771 | 3281 | Chlorogonium elongatum chloroplast large-subunit ribosomal RNA (rrnL), site-specific DNA endonuclease I-CelI gene | blastn | 68882 | 778 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Chlorogonium | Chlorogonium elongatum | |
| 14085352 | 14085352 | PRJEB39269_P_NODE_51472_length_191_cov_2.407895_g51067_i0 | PRJEB39269 | 51472 | 191 | 2.407895 | 4.59907945 | Sarcinofilum mucosum | 141643 | Plants | Plants | 348 | 1.87e-91 | NTclustered | gi|1197510887|ref|NC_034709.1| | 141643 | g51067 | i0 | 99.476 | 121.251308900524 | 191 | 1 | 100 | 0 | 1 | 191 | 146797 | 146987 | Trichosarcina mucosa culture SAG:4.90 chloroplast, complete genome | blastn | 23159 | 348 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Sarcinofilaceae | Sarcinofilum | Sarcinofilum mucosum | |
| 15017110 | 15017110 | PRJEB39269_P_NODE_72552_length_165_cov_1.793651_g72147_i0 | PRJEB39269 | 72552 | 165 | 1.793651 | 2.95952415 | Chlorophyceae | 3166 | Plants | Plants | 235 | 1.28e-57 | NTclustered | gi|953272850|gb|KT625416.1| | 51730 | g72147 | i0 | 92.638 | 137.684848484848 | 163 | 12 | 99 | 0 | 3 | 165 | 134078 | 133916 | Chloromonas perforata culture-collection SAG:11-43 chloroplast, partial genome | blastn | 22718 | 235 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chloromonas | Chloromonas perforata | |
| 15359191 | 15359191 | PRJEB39269_P_NODE_15333_length_358_cov_3.479624_g14928_i0 | PRJEB39269 | 15333 | 358 | 3.479624 | 12.45705392 | Sarcinofilum mucosum | 141643 | Plants | Plants | 606 | 5.769999999999998e-169 | NTclustered | gi|1197510887|ref|NC_034709.1| | 141643 | g14928 | i0 | 97.207 | 107.494413407821 | 358 | 10 | 100 | 0 | 1 | 358 | 149548 | 149191 | Trichosarcina mucosa culture SAG:4.90 chloroplast, complete genome | blastn | 38483 | 606 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Sarcinofilaceae | Sarcinofilum | Sarcinofilum mucosum | |
| 15359215 | 15359215 | PRJEB39269_P_NODE_45273_length_204_cov_1.236364_g44868_i0 | PRJEB39269 | 45273 | 204 | 1.236364 | 2.52218256 | Chlamydomonas pulsatilla | 57475 | Plants | Plants | 243 | 9.84e-60 | NTclustered | gi|66864277|gb|DQ015732.1| | 57475 | g44868 | i0 | 88.293 | 6.72549019607843 | 205 | 21 | 100 | 3 | 1 | 204 | 3237 | 3035 | Chlamydomonas pulsatilla strain UTEX 410 26S ribosomal RNA gene, partial sequence | blastn | 1372 | 243 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas pulsatilla | |
| 16633887 | 16633887 | PRJEB39269_P_NODE_21774_length_300_cov_3.482759_g21369_i0 | PRJEB39269 | 21774 | 300 | 3.482759 | 10.448277 | Sarcinofilum mucosum | 141643 | Plants | Plants | 505 | 1.7799999999999995e-138 | NTclustered | gi|1197510887|ref|NC_034709.1| | 141643 | g21369 | i0 | 97 | 108.773333333333 | 300 | 9 | 100 | 0 | 1 | 300 | 151205 | 150906 | Trichosarcina mucosa culture SAG:4.90 chloroplast, complete genome | blastn | 32632 | 505 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Sarcinofilaceae | Sarcinofilum | Sarcinofilum mucosum | |
| 21733822 | 21733822 | PRJEB39269_P_NODE_61218_length_176_cov_4.525547_g60813_i0 | PRJEB39269 | 61218 | 176 | 4.525547 | 7.96496272 | Sarcinofilum mucosum | 141643 | Plants | Plants | 315 | 1.7199999999999996e-81 | NTclustered | gi|1197510887|ref|NC_034709.1| | 141643 | g60813 | i0 | 98.864 | 118.545454545455 | 176 | 2 | 100 | 0 | 1 | 176 | 147167 | 146992 | Trichosarcina mucosa culture SAG:4.90 chloroplast, complete genome | blastn | 20864 | 315 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Sarcinofilaceae | Sarcinofilum | Sarcinofilum mucosum | |
| 23941599 | 23941599 | PRJEB39269_P_NODE_83419_length_156_cov_1.538462_g83014_i0 | PRJEB39269 | 83419 | 156 | 1.538462 | 2.40000072 | root | 1 | Root_unresolved | Root_unresolved | 206 | 9.32e-49 | NTclustered | gi|1197510977|ref|NC_034710.1| | 44573 | g83014 | i0 | 95.349 | 85.8846153846154 | 129 | 6 | 83 | 0 | 28 | 156 | 101186 | 101314 | Pseudoneochloris marina culture UTEX:1445 chloroplast, complete genome | blastn | 13398 | 206 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Sykidiales | Sykidiacaeae | Sykidion | Sykidion marinum | |
| 24282831 | 24282831 | PRJEB39269_P_NODE_24820_length_280_cov_3.684647_g24415_i0 | PRJEB39269 | 24820 | 280 | 3.684647 | 10.3170116 | Desmochloris halophila | 138176 | Plants | Plants | 420 | 6.139999999999998e-113 | NTclustered | gi|371782086|emb|HE610118.1| | 138176 | g24415 | i0 | 93.907 | 62.4464285714286 | 279 | 16 | 99 | 1 | 1 | 279 | 3721 | 3998 | Desmochloris halophila 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain UTEX 2073 | blastn | 17485 | 420 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris halophila |
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);;