contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA1103784" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9139756 | 9139756 | PRJNA1103784_P_NODE_5448_length_254_cov_1.331492_g5393_i0 | PRJNA1103784 | 5448 | 254 | 1.331492 | 3.38198968 | Trebouxiophyceae | 75966 | Plants | Plants | 142 | 2.9399999999999996e-37 | NR | KAL4858421.1 | 3077 | g5393 | i0 | 77.4 | 10.3228346456693 | 84 | 19 | 99.2 | 0 | 253 | 2 | 76 | 159 | KAL4858421.1 40S ribosomal protein S4 [Chlorella vulgaris] | diamond | 2622 | 142 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 14240902 | 14240902 | PRJNA1103784_P_NODE_1952_length_374_cov_5.063123_g1897_i0 | PRJNA1103784 | 1952 | 374 | 5.063123 | 18.93608002 | Eukaryota | 2759 | Plants | Plants | 178 | 2.22e-53 | NR | CAD7703417.1 | 121088 | g1897 | i0 | 75.7 | 2.70320855614973 | 115 | 27 | 92.2 | 1 | 374 | 30 | 144 | 257 | CAD7703417.1 unnamed protein product [Ostreobium quekettii] | diamond | 1011 | 179 | 0.994413407821229 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 22697156 | 22697156 | PRJNA1103784_P_NODE_6638_length_246_cov_1.329480_g6583_i0 | PRJNA1103784 | 6638 | 246 | 1.32948 | 3.2705208 | Eukaryota | 2759 | Plants | Plants | 132 | 1.4199999999999998e-37 | NR | XP_001697388.1 | 3055 | g6583 | i0 | 85.5 | 213.170731707317 | 76 | 11 | 92.7 | 0 | 245 | 18 | 78 | 153 | XP_001697388.1 ribosomal protein S14 [Chlamydomonas reinhardtii] | diamond | 52440 | 133 | 0.992481203007519 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 26941009 | 26941009 | PRJNA1103784_P_NODE_1982_length_373_cov_0.946667_g1927_i0 | PRJNA1103784 | 1982 | 373 | 0.946667 | 3.53106791 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 168 | 2.83e-50 | NR | GAX77325.1 | 1157962 | g1927 | i0 | 68.3 | 2.96782841823056 | 123 | 39 | 98.9 | 0 | 369 | 1 | 82 | 204 | GAX77325.1 hypothetical protein CEUSTIGMA_g4771.t1 [Chlamydomonas eustigma] | diamond | 1107 | 168 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 27659431 | 27659431 | PRJNA1103784_P_NODE_2964_length_316_cov_2.020576_g2909_i0 | PRJNA1103784 | 2964 | 316 | 2.020576 | 6.38502016 | root | 1 | Root_unresolved | Root_unresolved | 136 | 1.79e-35 | NR | GAX80193.1 | 1157962 | g2909 | i0 | 74 | 3.90189873417722 | 77 | 19 | 73.1 | 1 | 233 | 3 | 181 | 256 | GAX80193.1 hypothetical protein CEUSTIGMA_g7631.t1 [Chlamydomonas eustigma] | diamond | 1233 | 136 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 27699838 | 27699838 | PRJNA1103784_P_NODE_5484_length_253_cov_1.711111_g5429_i0 | PRJNA1103784 | 5484 | 253 | 1.711111 | 4.32911083 | Symbiochloris irregularis | 706552 | Plants | Plants | 56.6 | 5.08e-7 | NR | KAK9806054.1 | 706552 | g5429 | i0 | 54.4 | 1.43478260869565 | 57 | 25 | 66.4 | 1 | 184 | 17 | 288 | 344 | KAK9806054.1 hypothetical protein WJX73_009471 [Symbiochloris irregularis] | diamond | 363 | 56.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 28362445 | 28362445 | PRJNA1103784_P_NODE_3766_length_288_cov_1.246512_g3711_i0 | PRJNA1103784 | 3766 | 288 | 1.246512 | 3.58995456 | Bryopsis sp. KO-2 | 3115439 | Plants | Plants | 131 | 4.72e-33 | NR | GMH35311.1 | 3041901 | g3711 | i0 | 64.9 | 0.979166666666667 | 94 | 33 | 97.9 | 0 | 287 | 6 | 377 | 470 | GMH35311.1 hypothetical protein BSKO_03179 [Bryopsis sp. KO-2023] | diamond | 282 | 131 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis sp. KO-2023 | |
| 30532868 | 30532868 | PRJNA1103784_P_NODE_6353_length_248_cov_0.880000_g6298_i0 | PRJNA1103784 | 6353 | 248 | 0.88 | 2.1824 | Chlorella | 3071 | Plants | Plants | 117 | 2.17e-28 | NR | PRW51008.1 | 3076 | g6298 | i0 | 68.3 | 7.93548387096774 | 82 | 26 | 99.2 | 0 | 2 | 247 | 446 | 527 | PRW51008.1 eukaryotic translation elongation factor 1 alpha 2 [Chlorella sorokiniana] | diamond | 1968 | 117 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 30541597 | 30541597 | PRJNA1103784_P_NODE_4653_length_269_cov_1.362245_g4598_i0 | PRJNA1103784 | 4653 | 269 | 1.362245 | 3.66443905 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 45.1 | 0.00804 | NR | XP_011399984.1 | 3075 | g4598 | i0 | 31.8 | 1.96282527881041 | 88 | 56 | 98.1 | 1 | 266 | 3 | 849 | 932 | XP_011399984.1 Importin-5 [Auxenochlorella protothecoides] | diamond | 528 | 45.1 | 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);;