contig_metadata
19 rows where bioproject = "PRJNA577226" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1836828 | 1836828 | PRJNA577226_S_NODE_21802_length_270_cov_4.497854_g20863_i0 | PRJNA577226 | 21802 | 270 | 4.497854 | 12.1442058 | Desmodesmus armatus | 375941 | Plants | Plants | 403 | 5.93e-108 | NTclustered | gi|2575200469|gb|OR533320.1| | 375941 | g20863 | i0 | 93.727 | 64.1740740740741 | 271 | 14 | 100 | 2 | 1 | 270 | 5428 | 5696 | Desmodesmus armatus culture FBCC:A0245 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 17327 | 403 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Desmodesmus | Desmodesmus armatus | |
| 1836962 | 1836962 | PRJNA577226_S_NODE_26062_length_245_cov_4.187500_g25123_i0 | PRJNA577226 | 26062 | 245 | 4.1875 | 10.259375 | Koliella sp. HS-2024a | 3231931 | Plants | Plants | 398 | 2.47e-106 | NTclustered | gi|2754686484|gb|PP990793.1| | 3231931 | g25123 | i0 | 95.918 | 114.261224489796 | 245 | 10 | 100 | 0 | 1 | 245 | 19811 | 20055 | Koliella sp. HS-2024a strain FACHB-3607 chloroplast, complete genome | blastn | 27994 | 398 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella sp. HS-2024a | |
| 2412750 | 2412750 | PRJNA577226_S_NODE_37702_length_202_cov_4.406061_g36763_i0 | PRJNA577226 | 37702 | 202 | 4.406061 | 8.90024322 | Desmodesmus | 91202 | Plants | Plants | 363 | 7.149999999999999e-96 | NTclustered | gi|2575200469|gb|OR533320.1| | 375941 | g36763 | i0 | 99.01 | 108.173267326733 | 202 | 2 | 100 | 0 | 1 | 202 | 4736 | 4937 | Desmodesmus armatus culture FBCC:A0245 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 21851 | 363 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Desmodesmus | Desmodesmus armatus | |
| 3688561 | 3688561 | PRJNA577226_S_NODE_19083_length_291_cov_5.586614_g18144_i0 | PRJNA577226 | 19083 | 291 | 5.586614 | 16.25704674 | Chlorophyta | 3041 | Plants | Plants | 527 | 3.67e-145 | NTclustered | gi|359385188|emb|FR865599.1| | 3054 | g18144 | i0 | 99.313 | 99.9965635738832 | 291 | 2 | 100 | 0 | 1 | 291 | 1188 | 898 | Chlamydomonas moewusii genomic DNA containing 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, culture collection CCAP 11/61A | blastn | 29099 | 532 | 0.990601503759398 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas moewusii | |
| 6240883 | 6240883 | PRJNA577226_S_NODE_33125_length_216_cov_4.726257_g32186_i0 | PRJNA577226 | 33125 | 216 | 4.726257 | 10.20871512 | Scenedesmaceae | 3086 | Plants | Plants | 394 | 2.75e-105 | NTclustered | gi|1669402954|gb|MK975486.1| | 1169099 | g32186 | i0 | 99.537 | 99.7731481481482 | 216 | 1 | 100 | 0 | 1 | 216 | 1031 | 1246 | Coelastrella striolata strain SAG 16.95 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 | 21551 | 394 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Coelastrella | Coelastrella striolata | |
| 6241068 | 6241068 | PRJNA577226_S_NODE_48805_length_178_cov_6.361702_g47866_i0 | PRJNA577226 | 48805 | 178 | 6.361702 | 11.32382956 | Eukaryota | 2759 | Plants | Plants | 318 | 1.34e-82 | NTclustered | gi|1898545223|gb|MT951391.1| | 3078 | g47866 | i0 | 98.876 | 100 | 178 | 2 | 100 | 0 | 1 | 178 | 926 | 1103 | Auxenochlorella pyrenoidosa strain Ozcimen001 small subunit ribosomal RNA gene, partial sequence | blastn | 17800 | 318 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella pyrenoidosa | |
| 7515362 | 7515362 | PRJNA577226_S_NODE_51166_length_174_cov_7.306569_g50227_i0 | PRJNA577226 | 51166 | 174 | 7.306569 | 12.71343006 | Watanabeaceae | 2981775 | Plants | Plants | 294 | 2.1999999999999998e-75 | NTclustered | gi|1169296931|gb|KY364701.1| | 63676 | g50227 | i0 | 97.126 | 100.086206896552 | 174 | 5 | 100 | 0 | 1 | 174 | 3933 | 4106 | Chloroidium ellipsoideum 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 17415 | 294 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 12040363 | 12040363 | PRJNA577226_S_NODE_16650_length_314_cov_3.072202_g15711_i0 | PRJNA577226 | 16650 | 314 | 3.072202 | 9.64671428 | Nannochloris sp. 'desiccata' | 1650286 | Plants | Plants | 496 | 1.1299999999999999e-135 | NTclustered | gi|2175794152|gb|OK569791.1| | 1650286 | g15711 | i0 | 95.498 | 124.570063694268 | 311 | 12 | 99 | 2 | 5 | 314 | 55148 | 54839 | Chlorella desiccata (nom. nud.) chloroplast, complete genome | blastn | 39115 | 496 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 13315931 | 13315931 | PRJNA577226_S_NODE_40571_length_195_cov_1.962025_g39632_i0 | PRJNA577226 | 40571 | 195 | 1.962025 | 3.82594875 | Coelastrella saipanensis | 152631 | Plants | Plants | 359 | 8.87e-95 | NTclustered | gi|1642520538|ref|NC_042181.1| | 152631 | g39632 | i0 | 100 | 41.6205128205128 | 194 | 0 | 99 | 0 | 2 | 195 | 114930 | 114737 | Coelastrella saipanensis chloroplast, complete genome | blastn | 8116 | 359 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Coelastrella | Coelastrella saipanensis | |
| 13891653 | 13891653 | PRJNA577226_S_NODE_5931_length_567_cov_4.160377_g5011_i0 | PRJNA577226 | 5931 | 567 | 4.160377 | 23.58933759 | Tetradesmus | 91192 | Plants | Plants | 821 | 0 | NTclustered | gi|2576955160|gb|OR551481.1| | 113531 | g5011 | i0 | 92.794 | 100.359788359788 | 569 | 37 | 100 | 4 | 1 | 567 | 4252 | 3686 | Tetradesmus distendus culture FBCC:A1020 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 | 56904 | 821 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus distendus | |
| 17715304 | 17715304 | PRJNA577226_S_NODE_40834_length_194_cov_7.847134_g39895_i0 | PRJNA577226 | 40834 | 194 | 7.847134 | 15.22343996 | root | 1 | Root_unresolved | Root_unresolved | 270 | 4.2499999999999985e-68 | NTclustered | gi|760450178|ref|XM_011403856.1| | 3075 | g39895 | i0 | 91.753 | 99.9432989690722 | 194 | 16 | 100 | 0 | 1 | 194 | 85 | 278 | Auxenochlorella protothecoides Putative uncharacterized protein ART2 partial mRNA | blastn | 19389 | 270 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 18988890 | 18988890 | PRJNA577226_S_NODE_53055_length_171_cov_5.977612_g52116_i0 | PRJNA577226 | 53055 | 171 | 5.977612 | 10.22171652 | Chlorophyta | 3041 | Plants | Plants | 300 | 4.63e-77 | NTclustered | gi|359385302|emb|FR865718.1| | 1034620 | g52116 | i0 | 98.246 | 99.9298245614035 | 171 | 3 | 100 | 0 | 1 | 171 | 1433 | 1603 | Scenedesmus parvus genomic DNA containing 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, culture collection CCAP 276/32 | blastn | 17088 | 300 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Verrucodesmus | Verrucodesmus parvus | |
| 19688776 | 19688776 | PRJNA577226_S_NODE_56536_length_166_cov_6.604651_g55597_i0 | PRJNA577226 | 56536 | 166 | 6.604651 | 10.96372066 | Picochlorum sp. | 2812594 | Plants | Plants | 296 | 5.82e-76 | NTclustered | gi|2632235342|gb|OR922724.1| | 2812594 | g55597 | i0 | 98.795 | 100.301204819277 | 166 | 2 | 100 | 0 | 1 | 166 | 3462 | 3297 | Picochlorum sp. strain AGSB0210 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 | 16650 | 296 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Picochlorum | Picochlorum sp. | |||
| 20964687 | 20964687 | PRJNA577226_S_NODE_6197_length_552_cov_16.749515_g5274_i0 | PRJNA577226 | 6197 | 552 | 16.749515 | 92.4573228 | Nannochloris sp. 'desiccata' | 1650286 | Plants | Plants | 769 | 0 | NTclustered | gi|2175794152|gb|OK569791.1| | 1650286 | g5274 | i0 | 91.848 | 123.309782608696 | 552 | 43 | 100 | 2 | 1 | 552 | 56328 | 55779 | Chlorella desiccata (nom. nud.) chloroplast, complete genome | blastn | 68067 | 769 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 22238136 | 22238136 | PRJNA577226_S_NODE_10198_length_411_cov_8.221925_g9262_i0 | PRJNA577226 | 10198 | 411 | 8.221925 | 33.79211175 | Micractinium reisseri | 532145 | Plants | Plants | 601 | 3.1299999999999992e-167 | NTclustered | gi|297501471|dbj|AB506071.1| | 532145 | g9262 | i0 | 93.154 | 48.1995133819951 | 409 | 28 | 99 | 0 | 1 | 409 | 6046 | 6454 | Micractinium reisseri genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence, clone: 2 | blastn | 19810 | 601 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium reisseri | |
| 22814399 | 22814399 | PRJNA577226_S_NODE_24038_length_256_cov_23.141553_g23099_i0 | PRJNA577226 | 24038 | 256 | 23.141553 | 59.24237568 | Marvania | 97104 | Plants | Plants | 409 | 1.2e-109 | NTclustered | gi|723457130|ref|NC_025549.1| | 97105 | g23099 | i0 | 96.047 | 171.04296875 | 253 | 6 | 98 | 2 | 5 | 256 | 4607 | 4856 | Marvania geminata culture-collection SAG:12.88 chloroplast, complete genome | blastn | 43787 | 409 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Marvania | Marvania geminata | |
| 23515017 | 23515017 | PRJNA577226_S_NODE_67079_length_154_cov_2.324786_g66140_i0 | PRJNA577226 | 67079 | 154 | 2.324786 | 3.58017044 | Stichococcus bacillaris | 37433 | Plants | Plants | 100 | 4.45e-17 | NTclustered | gi|371782093|emb|HE610125.1| | 37433 | g66140 | i0 | 77.914 | 1.70779220779221 | 163 | 22 | 97 | 8 | 5 | 154 | 7298 | 7137 | Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 | blastn | 263 | 100 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 24088998 | 24088998 | PRJNA577226_S_NODE_10119_length_413_cov_20.002660_g9183_i0 | PRJNA577226 | 10119 | 413 | 20.00266 | 82.6109858 | Chlorellaceae | 35461 | Plants | Plants | 505 | 2.54e-138 | NTclustered | gi|723457130|ref|NC_025549.1| | 97105 | g9183 | i0 | 91.803 | 181.753026634383 | 366 | 25 | 88 | 3 | 49 | 413 | 4495 | 4856 | Marvania geminata culture-collection SAG:12.88 chloroplast, complete genome | blastn | 75064 | 505 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Marvania | Marvania geminata | |
| 28595689 | 28595689 | PRJNA577226_S_NODE_56147_length_167_cov_1.500000_g55208_i0 | PRJNA577226 | 56147 | 167 | 1.5 | 2.505 | Micractinium sp. CCAP 211/92 | 554058 | Plants | Plants | 41.6 | 0.0348 | NR | KAL4447325.1 | 554058 | g55208 | i0 | 54.8 | 0.754491017964072 | 42 | 13 | 70.1 | 2 | 18 | 134 | 110 | 148 | KAL4447325.1 hypothetical protein ABPG77_007358 [Micractinium sp. CCAP 211/92] | diamond | 126 | 41.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium sp. CCAP 211/92 |
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);;