contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA900028" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12725300 | 12725300 | PRJNA900028_P_NODE_89390_length_181_cov_1.143939_g88641_i0 | PRJNA900028 | 89390 | 181 | 1.143939 | 2.07052959 | Chlorophyta | 3041 | Plants | Plants | 95.1 | 3.02e-21 | NR | PRW58440.1 | 3076 | g88641 | i0 | 71.7 | 5.96685082872928 | 60 | 17 | 99.4 | 0 | 181 | 2 | 263 | 322 | PRW58440.1 phosphoglycerate kinase [Chlorella sorokiniana] | diamond | 1080 | 95.9 | 0.991657977059437 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 17452650 | 17452650 | PRJNA900028_P_NODE_117674_length_167_cov_1.728814_g116925_i0 | PRJNA900028 | 117674 | 167 | 1.728814 | 2.88711938 | root | 1 | Root_unresolved | Root_unresolved | 85.1 | 1.55e-17 | NR | KAJ9518463.1 | 44745 | g116925 | i0 | 81.6 | 10.437125748503 | 49 | 9 | 88 | 0 | 166 | 20 | 149 | 197 | KAJ9518463.1 hypothetical protein QJQ45_018485 [Haematococcus lacustris] | diamond | 1743 | 85.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 27568884 | 27568884 | PRJNA900028_P_NODE_80504_length_185_cov_1.117647_g79755_i0 | PRJNA900028 | 80504 | 185 | 1.117647 | 2.06764695 | Trebouxia | 13786 | Plants | Plants | 44.7 | 0.00367 | NR | KAA6428449.1 | 2608996 | g79755 | i0 | 58.3 | 2.33513513513514 | 36 | 15 | 58.4 | 0 | 19 | 126 | 1364 | 1399 | KAA6428449.1 MAG: DNA ligase [Trebouxia sp. A1-2] | diamond | 432 | 44.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 27758706 | 27758706 | PRJNA900028_P_NODE_172984_length_163_cov_0.894737_g172235_i0 | PRJNA900028 | 172984 | 163 | 0.894737 | 1.45842131 | Chlorella | 3071 | Plants | Plants | 70.9 | 1.54e-12 | NR | PRW57419.1 | 3076 | g172235 | i0 | 81 | 5.26380368098159 | 42 | 8 | 77.3 | 0 | 5 | 130 | 1565 | 1606 | PRW57419.1 DNA polymerase zeta [Chlorella sorokiniana] | diamond | 858 | 70.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 28003547 | 28003547 | PRJNA900028_P_NODE_136305_length_166_cov_0.871795_g135556_i0 | PRJNA900028 | 136305 | 166 | 0.871795 | 1.4471797 | Tetradesmus obliquus | 3088 | Plants | Plants | 50.4 | 2.5e-5 | NR | WIA40489.1 | 3088 | g135556 | i0 | 49 | 1.7710843373494 | 51 | 26 | 92.2 | 0 | 13 | 165 | 146 | 196 | WIA40489.1 hypothetical protein OEZ86_013842 [Tetradesmus obliquus] | diamond | 294 | 50.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 28129744 | 28129744 | PRJNA900028_P_NODE_157185_length_164_cov_0.886957_g156436_i0 | PRJNA900028 | 157185 | 164 | 0.886957 | 1.45460948 | Trebouxia sp. C | 2796353 | Plants | Plants | 57.8 | 6.32e-8 | NR | KAL3162659.1 | 3373144 | g156436 | i0 | 69.6 | 1.79268292682927 | 46 | 14 | 84.1 | 0 | 164 | 27 | 236 | 281 | KAL3162659.1 Cytosolic carboxypeptidase 6 [Trebouxia sp. C0009 RCD-2024] | diamond | 294 | 57.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0009 RCD-2024 | |
| 28192579 | 28192579 | PRJNA900028_P_NODE_190166_length_161_cov_0.910714_g189417_i0 | PRJNA900028 | 190166 | 161 | 0.910714 | 1.46624954 | Micractinium tetrahymenae | 2728915 | Plants | Plants | 52 | 6.59e-6 | NR | KAL4444155.1 | 2728915 | g189417 | i0 | 60.5 | 0.708074534161491 | 38 | 15 | 70.8 | 0 | 25 | 138 | 293 | 330 | KAL4444155.1 hypothetical protein ABPG75_011892 [Micractinium tetrahymenae] | diamond | 114 | 52 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium tetrahymenae | |
| 28389824 | 28389824 | PRJNA900028_P_NODE_157606_length_164_cov_0.886957_g156857_i0 | PRJNA900028 | 157606 | 164 | 0.886957 | 1.45460948 | Chlorellaceae | 35461 | Plants | Plants | 45.4 | 0.00143 | NR | PRW58157.1 | 3076 | g156857 | i0 | 61.3 | 3.96951219512195 | 31 | 12 | 56.7 | 0 | 27 | 119 | 424 | 454 | PRW58157.1 zinc finger CCCH domain-containing ZFN-like isoform X1 [Chlorella sorokiniana] | diamond | 651 | 45.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 28540378 | 28540378 | PRJNA900028_P_NODE_94187_length_178_cov_1.581395_g93438_i0 | PRJNA900028 | 94187 | 178 | 1.581395 | 2.8148831 | Trebouxia sp. C | 2796353 | Plants | Plants | 81.6 | 2.89e-16 | NR | KAL0024637.1 | 2905653 | g93438 | i0 | 66.7 | 3.03370786516854 | 60 | 19 | 99.4 | 1 | 178 | 2 | 113 | 172 | KAL0024637.1 hypothetical protein WJX77_004945 [Trebouxia sp. C0004] | diamond | 540 | 81.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0004 | |
| 28729586 | 28729586 | PRJNA900028_P_NODE_182767_length_162_cov_0.902655_g182018_i0 | PRJNA900028 | 182767 | 162 | 0.902655 | 1.4623011 | Apatococcus lobatus | 904363 | Plants | Plants | 59.7 | 1.31e-8 | NR | KAK9816282.1 | 904363 | g182018 | i0 | 100 | 0.481481481481481 | 26 | 0 | 48.1 | 0 | 78 | 1 | 374 | 399 | KAK9816282.1 hypothetical protein WJX74_002986 [Apatococcus lobatus] | diamond | 78 | 59.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Apatococcus | Apatococcus lobatus | |
| 29171754 | 29171754 | PRJNA900028_P_NODE_85849_length_182_cov_1.533835_g85100_i0 | PRJNA900028 | 85849 | 182 | 1.533835 | 2.7915797 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 45.4 | 0.00181 | NR | KAK9904674.1 | 248742 | g85100 | i0 | 55.3 | 0.626373626373626 | 38 | 17 | 62.6 | 0 | 14 | 127 | 305 | 342 | KAK9904674.1 hypothetical protein WJX75_000388 [Coccomyxa subellipsoidea] | diamond | 114 | 45.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 29234783 | 29234783 | PRJNA900028_P_NODE_126849_length_167_cov_0.864407_g126100_i0 | PRJNA900028 | 126849 | 167 | 0.864407 | 1.44355969 | Symbiochloris handae | 1853882 | Plants | Plants | 44.7 | 0.00284 | NR | YP_009104797.1 | 1853882 | g126100 | i0 | 45.7 | 0.826347305389222 | 46 | 23 | 82.6 | 1 | 29 | 166 | 1304 | 1347 | YP_009104797.1 beta'' subunit of RNA polymerase [Symbiochloris handae] | diamond | 138 | 44.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris handae | |
| 29550287 | 29550287 | PRJNA900028_P_NODE_180430_length_162_cov_0.902655_g179681_i0 | PRJNA900028 | 180430 | 162 | 0.902655 | 1.4623011 | Edaphochlamys debaryana | 47281 | Plants | Plants | 55.8 | 6.49e-8 | NR | KAG2484231.1 | 47281 | g179681 | i0 | 49.1 | 0.981481481481482 | 53 | 27 | 98.1 | 0 | 159 | 1 | 63 | 115 | KAG2484231.1 hypothetical protein HYH03_016966 [Edaphochlamys debaryana] | diamond | 159 | 55.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Edaphochlamys | Edaphochlamys debaryana |
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);;