contig_metadata
7 rows where bioproject = "PRJNA825466" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19947033 | 19947033 | PRJNA825466_P_NODE_7776_length_310_cov_1.088608_g7675_i0 | PRJNA825466 | 7776 | 310 | 1.088608 | 3.3746848 | Eukaryota | 2759 | Plants | Plants | 155 | 2.38e-45 | NR | KXZ41300.1 | 33097 | g7675 | i0 | 73 | 7.74193548387097 | 100 | 27 | 96.8 | 0 | 302 | 3 | 3 | 102 | KXZ41300.1 hypothetical protein GPECTOR_569g606 [Gonium pectorale] | diamond | 2400 | 156 | 0.993589743589744 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale | |
| 21222433 | 21222433 | PRJNA825466_P_NODE_10117_length_287_cov_3.046729_g10016_i0 | PRJNA825466 | 10117 | 287 | 3.046729 | 8.74411223 | Chlorochytrium lemnae | 1199099 | Plants | Plants | 127 | 1.75e-35 | NR | CCI69515.1 | 1199099 | g10016 | i0 | 63.2 | 1.98606271777003 | 95 | 34 | 99.3 | 1 | 286 | 2 | 2 | 95 | CCI69515.1 40S ribosomal protein S9, partial [Chlorochytrium lemnae] | diamond | 570 | 127 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlorochytriaceae | Chlorochytrium | Chlorochytrium lemnae | |
| 22497200 | 22497200 | PRJNA825466_P_NODE_29678_length_229_cov_3.000000_g29577_i0 | PRJNA825466 | 29678 | 229 | 3 | 6.87 | Eukaryota | 2759 | Plants | Plants | 126 | 6.35e-34 | NR | PRW39136.1 | 3076 | g29577 | i0 | 73.7 | 48.7467248908297 | 76 | 20 | 99.6 | 0 | 229 | 2 | 148 | 223 | PRW39136.1 40S ribosomal S2-4 [Chlorella sorokiniana] | diamond | 11163 | 127 | 0.992125984251969 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 29873603 | 29873603 | PRJNA825466_P_NODE_22571_length_246_cov_0.890173_g22470_i0 | PRJNA825466 | 22571 | 246 | 0.890173 | 2.18982558 | Eukaryota | 2759 | Plants | Plants | 85.9 | 2.27e-17 | NR | XP_002954352.1 | 3068 | g22470 | i0 | 51.2 | 27.4878048780488 | 82 | 33 | 96.3 | 3 | 239 | 3 | 245 | 322 | XP_002954352.1 uncharacterized protein VOLCADRAFT_76255 [Volvox carteri f. nagariensis] | diamond | 6762 | 86.3 | 0.995365005793743 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 30023047 | 30023047 | PRJNA825466_P_NODE_3771_length_388_cov_3.800000_g3670_i0 | PRJNA825466 | 3771 | 388 | 3.8 | 14.744 | Symbiochloris irregularis | 706552 | Plants | Plants | 117 | 1.5e-30 | NR | KAK9807347.1 | 706552 | g3670 | i0 | 55.7 | 1.63917525773196 | 106 | 46 | 81.2 | 1 | 384 | 70 | 45 | 150 | KAK9807347.1 hypothetical protein WJX73_004182 [Symbiochloris irregularis] | diamond | 636 | 117 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 30852977 | 30852977 | PRJNA825466_P_NODE_29074_length_241_cov_0.916667_g28973_i0 | PRJNA825466 | 29074 | 241 | 0.916667 | 2.20916747 | Eukaryota | 2759 | Plants | Plants | 91.7 | 2.18e-19 | NR | KAK9810517.1 | 41462 | g28973 | i0 | 51.9 | 16.7178423236515 | 79 | 38 | 98.3 | 0 | 239 | 3 | 1392 | 1470 | KAK9810517.1 hypothetical protein WJX72_012055 [[Myrmecia] bisecta] | diamond | 4029 | 91.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 31200124 | 31200124 | PRJNA825466_P_NODE_5375_length_345_cov_1.691176_g5274_i0 | PRJNA825466 | 5375 | 345 | 1.691176 | 5.8345572 | Chlorophyceae | 3166 | Plants | Plants | 139 | 8.01e-37 | NR | KAF5837245.1 | 3046 | g5274 | i0 | 58.8 | 10.7652173913043 | 114 | 45 | 97.4 | 1 | 344 | 9 | 141 | 254 | KAF5837245.1 S-adenosylmethionine synthase [Dunaliella salina] | diamond | 3714 | 139 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina |
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);;