contig_metadata
13 rows where bioproject = "PRJNA289590", tax_clade = "core chlorophytes" and tax_phylum = "Chlorophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2923473 | 2923473 | PRJNA289590_P_NODE_5783_length_405_cov_7.876404_g5559_i0 | PRJNA289590 | 5783 | 405 | 7.876404 | 31.8994362 | Dicloster acuatus | 91190 | Plants | Plants | 595 | 1.4299999999999995e-165 | NTclustered | gi|725651324|ref|NC_025546.1| | 91190 | g5559 | i0 | 93.171 | 99.1555555555556 | 410 | 21 | 100 | 5 | 1 | 405 | 99217 | 99624 | Dicloster acuatus culture-collection SAG:41.98 chloroplast, complete genome | blastn | 40158 | 595 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Dicloster | Dicloster acuatus | |
| 3610003 | 3610003 | PRJNA289590_P_NODE_8643_length_319_cov_5.251852_g8419_i0 | PRJNA289590 | 8643 | 319 | 5.251852 | 16.75340788 | Chlorellaceae | 35461 | Plants | Plants | 562 | 1.12e-155 | NTclustered | gi|291067107|gb|GQ176862.1| | 745287 | g8419 | i0 | 98.433 | 100 | 319 | 5 | 100 | 0 | 1 | 319 | 88 | 406 | Dictyosphaerium sp. CCAP 222/25 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 31900 | 562 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Dictyosphaerium | Dictyosphaerium sp. CCAP 222/25 | |
| 7437321 | 7437321 | PRJNA289590_P_NODE_23966_length_178_cov_2.015504_g23742_i0 | PRJNA289590 | 23966 | 178 | 2.015504 | 3.58759712 | Chlorophyta | 3041 | Plants | Plants | 329 | 6.21e-86 | NTclustered | gi|655359727|gb|KJ616757.1| | 3076 | g23742 | i0 | 100 | 100 | 178 | 0 | 100 | 0 | 1 | 178 | 1615 | 1438 | Chlorella sorokiniana strain LB75 18S ribosomal RNA gene, partial sequence | blastn | 17800 | 329 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 9300898 | 9300898 | PRJNA289590_P_NODE_6968_length_362_cov_2.728435_g6744_i0 | PRJNA289590 | 6968 | 362 | 2.728435 | 9.8769347 | Parachlorella kessleri | 3074 | Plants | Plants | 625 | 1.6099999999999996e-174 | NTclustered | gi|254798615|ref|NC_012978.1| | 3074 | g6744 | i0 | 97.79 | 115.524861878453 | 362 | 8 | 100 | 0 | 1 | 362 | 94239 | 93878 | Parachlorella kessleri chloroplast, complete genome | blastn | 41820 | 625 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Parachlorella | Parachlorella kessleri | |
| 9987554 | 9987554 | PRJNA289590_P_NODE_25728_length_169_cov_4.633333_g25504_i0 | PRJNA289590 | 25728 | 169 | 4.633333 | 7.83033277 | Chlorellaceae | 35461 | Plants | Plants | 285 | 1.28e-72 | NTclustered | gi|254798615|ref|NC_012978.1| | 3074 | g25504 | i0 | 97.041 | 175.201183431953 | 169 | 5 | 100 | 0 | 1 | 169 | 92107 | 91939 | Parachlorella kessleri chloroplast, complete genome | blastn | 29609 | 285 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Parachlorella | Parachlorella kessleri | |
| 15087000 | 15087000 | PRJNA289590_P_NODE_21492_length_191_cov_1.253521_g21268_i0 | PRJNA289590 | 21492 | 191 | 1.253521 | 2.39422511 | Chlorellaceae | 35461 | Plants | Plants | 303 | 4.11e-78 | NTclustered | gi|402770347|gb|JX524866.1| | 1227105 | g21268 | i0 | 95.312 | 100.324607329843 | 192 | 7 | 100 | 2 | 1 | 191 | 40 | 230 | Chlorella cf. vulgaris CHPCL2 large subunit ribosomal RNA gene, partial sequence | blastn | 19162 | 303 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella cf. vulgaris CHPCL2 | |
| 15087002 | 15087002 | PRJNA289590_P_NODE_22152_length_187_cov_3.884058_g21928_i0 | PRJNA289590 | 22152 | 187 | 3.884058 | 7.26318846 | root | 1 | Root_unresolved | Root_unresolved | 340 | 3.0499999999999998e-89 | NTclustered | gi|254798615|ref|NC_012978.1| | 3074 | g21928 | i0 | 99.465 | 106 | 187 | 1 | 100 | 0 | 1 | 187 | 90644 | 90830 | Parachlorella kessleri chloroplast, complete genome | blastn | 19822 | 340 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Parachlorella | Parachlorella kessleri | |
| 15087075 | 15087075 | PRJNA289590_P_NODE_7972_length_335_cov_2.881119_g7748_i0 | PRJNA289590 | 7972 | 335 | 2.881119 | 9.65174865 | Trebouxiophyceae | 75966 | Plants | Plants | 547 | 3.3099999999999984e-151 | NTclustered | gi|1169296931|gb|KY364701.1| | 63676 | g7748 | i0 | 96.131 | 100.546268656716 | 336 | 12 | 100 | 1 | 1 | 335 | 4304 | 3969 | 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 | 33683 | 547 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 16950222 | 16950222 | PRJNA289590_P_NODE_7854_length_338_cov_2.145329_g7630_i0 | PRJNA289590 | 7854 | 338 | 2.145329 | 7.25121202 | Chloroidium ellipsoideum | 63676 | Plants | Plants | 508 | 1.58e-139 | NTclustered | gi|1169296931|gb|KY364701.1| | 63676 | g7630 | i0 | 93.824 | 13.9970414201183 | 340 | 17 | 100 | 4 | 1 | 338 | 5734 | 5397 | 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 | 4731 | 508 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 19498330 | 19498330 | PRJNA289590_P_NODE_16796_length_219_cov_2.741176_g16572_i0 | PRJNA289590 | 16796 | 219 | 2.741176 | 6.00317544 | Dicloster acuatus | 91190 | Plants | Plants | 396 | 7.769999999999997e-106 | NTclustered | gi|725651324|ref|NC_025546.1| | 91190 | g16572 | i0 | 99.539 | 120.059360730594 | 217 | 1 | 99 | 0 | 3 | 219 | 98974 | 98758 | Dicloster acuatus culture-collection SAG:41.98 chloroplast, complete genome | blastn | 26293 | 396 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Dicloster | Dicloster acuatus | |
| 21461203 | 21461203 | PRJNA289590_P_NODE_30837_length_162_cov_1.610619_g30613_i0 | PRJNA289590 | 30837 | 162 | 1.610619 | 2.60920278 | Chlorellaceae | 35461 | Plants | Plants | 289 | 9.44e-74 | NTclustered | gi|27530003|dbj|AB080309.1| | 3074 | g30613 | i0 | 98.765 | 100 | 162 | 2 | 100 | 0 | 1 | 162 | 899 | 738 | Parachlorella kessleri gene for 18S rRNA, partial sequence | blastn | 16200 | 289 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Parachlorella | Parachlorella kessleri | |
| 22736275 | 22736275 | PRJNA289590_P_NODE_26158_length_169_cov_0.866667_g25934_i0 | PRJNA289590 | 26158 | 169 | 0.866667 | 1.46466723 | root | 1 | Root_unresolved | Root_unresolved | 305 | 9.81e-79 | NTclustered | gi|1992615818|gb|MW648643.1| | 37433 | g25934 | i0 | 100 | 97.7692307692308 | 165 | 0 | 98 | 0 | 5 | 169 | 180 | 16 | Stichococcus bacillaris strain TCC145-1-sq1 large subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 16523 | 305 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 26775488 | 26775488 | PRJNA289590_P_NODE_24461_length_176_cov_1.204724_g24237_i0 | PRJNA289590 | 24461 | 176 | 1.204724 | 2.12031424 | Eukaryota | 2759 | Plants | Plants | 80.9 | 5.3e-16 | NR | XP_011398664.1 | 3075 | g24237 | i0 | 64.3 | 3.81818181818182 | 56 | 20 | 95.5 | 0 | 169 | 2 | 270 | 325 | XP_011398664.1 Dihydrolipoyl dehydrogenase 1, mitochondrial [Auxenochlorella protothecoides] | diamond | 672 | 80.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides |
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);;