contig_metadata
7 rows where bioproject = "PRJNA951388" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 934783 | 934783 | PRJNA951388_S_NODE_7361_length_313_cov_3.645833_g7234_i0 | PRJNA951388 | 7361 | 313 | 3.645833 | 11.41145729 | Ostreobium quekettii | 121088 | Plants | Plants | 92.4 | 3.16e-19 | NR | CAD7701230.1 | 121088 | g7234 | i0 | 50.6 | 4.59105431309904 | 79 | 38 | 74.8 | 1 | 304 | 71 | 935 | 1013 | CAD7701230.1 unnamed protein product [Ostreobium quekettii] | diamond | 1437 | 92.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 12413843 | 12413843 | PRJNA951388_S_NODE_3310_length_435_cov_20.220994_g3183_i0 | PRJNA951388 | 3310 | 435 | 20.220994 | 87.9613239 | Eukaryota | 2759 | Plants | Plants | 172 | 2.46e-48 | NR | PRW60758.1 | 3076 | g3183 | i0 | 72.6 | 47.1379310344828 | 117 | 32 | 80.7 | 0 | 433 | 83 | 31 | 147 | PRW60758.1 putative histone H2A variant 3 [Chlorella sorokiniana] | diamond | 20505 | 172 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 28484980 | 28484980 | PRJNA951388_S_NODE_1666_length_545_cov_25.391949_g1544_i0 | PRJNA951388 | 1666 | 545 | 25.391949 | 138.38612205 | Eukaryota | 2759 | Plants | Plants | 79.3 | 1.38e-14 | NR | XP_011396990.1 | 3075 | g1544 | i0 | 32.4 | 3.90275229357798 | 136 | 91 | 74.9 | 1 | 79 | 486 | 62 | 196 | XP_011396990.1 ATP synthase subunit O, mitochondrial [Auxenochlorella protothecoides] | diamond | 2127 | 79.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 28825444 | 28825444 | PRJNA951388_S_NODE_4608_length_388_cov_2.311111_g4481_i0 | PRJNA951388 | 4608 | 388 | 2.311111 | 8.96711068 | Pleodorina starrii | 330485 | Plants | Plants | 60.5 | 1.12e-7 | NR | GLC55964.1 | 330485 | g4481 | i0 | 39.5 | 3.32474226804124 | 86 | 39 | 66.5 | 2 | 262 | 5 | 14 | 86 | GLC55964.1 hypothetical protein PLESTB_001049700 [Pleodorina starrii] | diamond | 1290 | 60.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Pleodorina | Pleodorina starrii | |
| 29267498 | 29267498 | PRJNA951388_S_NODE_10369_length_256_cov_1.262295_g10242_i0 | PRJNA951388 | 10369 | 256 | 1.262295 | 3.2314752 | Scenedesmus sp. NREL 46B-D3 | 2650976 | Plants | Plants | 54.3 | 3.53e-6 | NR | KAF6257747.1 | 2650976 | g10242 | i0 | 35.9 | 0.9140625 | 78 | 50 | 91.4 | 0 | 254 | 21 | 216 | 293 | KAF6257747.1 RNA polymerase I-associated factor PAF67-domain-containing protein [Scenedesmus sp. NREL 46B-D3] | diamond | 234 | 54.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. NREL 46B-D3 | |
| 30342094 | 30342094 | PRJNA951388_S_NODE_3852_length_412_cov_18.766962_g3725_i0 | PRJNA951388 | 3852 | 412 | 18.766962 | 77.31988344 | Dunaliella salina | 3046 | Plants | Plants | 72 | 1.2e-11 | NR | KAF5829124.1 | 3046 | g3725 | i0 | 47.7 | 0.473300970873786 | 65 | 34 | 47.3 | 0 | 412 | 218 | 122 | 186 | KAF5829124.1 hypothetical protein DUNSADRAFT_16524 [Dunaliella salina] | diamond | 195 | 72 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 32080275 | 32080275 | PRJNA951388_S_NODE_8778_length_283_cov_3.966667_g8651_i0 | PRJNA951388 | 8778 | 283 | 3.966667 | 11.22566761 | [Myrmecia] bisecta | 41462 | Plants | Plants | 103 | 2.06e-24 | NR | KAK9813183.1 | 41462 | g8651 | i0 | 52.8 | 0.943462897526502 | 89 | 38 | 94.3 | 1 | 268 | 2 | 36 | 120 | KAK9813183.1 hypothetical protein WJX72_010217 [[Myrmecia] bisecta] | diamond | 267 | 103 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta |
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);;