contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA951412" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3485443 | 3485443 | PRJNA951412_P_NODE_1403_length_377_cov_2.029605_g1318_i0 | PRJNA951412 | 1403 | 377 | 2.029605 | 7.65161085 | root | 1 | Root_unresolved | Root_unresolved | 142 | 2.11e-36 | NR | KAJ9517333.1 | 44745 | g1318 | i0 | 66.1 | 18.7320954907162 | 124 | 42 | 98.7 | 0 | 1 | 372 | 1062 | 1185 | KAJ9517333.1 hypothetical protein QJQ45_016698 [Haematococcus lacustris] | diamond | 7062 | 143 | 0.993006993006993 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 14962636 | 14962636 | PRJNA951412_P_NODE_272_length_949_cov_3.033105_g203_i0 | PRJNA951412 | 272 | 949 | 3.033105 | 28.78416645 | Chlorophyta | 3041 | Plants | Plants | 361 | 7.209999999999997e-110 | NR | KAL4858421.1 | 3077 | g203 | i0 | 65.9 | 11.2824025289779 | 258 | 88 | 81.6 | 0 | 12 | 785 | 81 | 338 | KAL4858421.1 40S ribosomal protein S4 [Chlorella vulgaris] | diamond | 10707 | 364 | 0.991758241758242 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 27569226 | 27569226 | PRJNA951412_P_NODE_4364_length_252_cov_0.865922_g4279_i0 | PRJNA951412 | 4364 | 252 | 0.865922 | 2.18212344 | Chlamydomonadales | 3042 | Plants | Plants | 121 | 4.86e-30 | NR | XP_042926294.1 | 3055 | g4279 | i0 | 69.9 | 2.94047619047619 | 83 | 25 | 98.8 | 0 | 250 | 2 | 3 | 85 | XP_042926294.1 uncharacterized protein CHLRE_03g189950v5 [Chlamydomonas reinhardtii] | diamond | 741 | 122 | 0.991803278688525 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 27721070 | 27721070 | PRJNA951412_P_NODE_1064_length_436_cov_1.283747_g979_i0 | PRJNA951412 | 1064 | 436 | 1.283747 | 5.59713692 | Bryopsis sp. KO-2 | 3115439 | Plants | Plants | 169 | 1.6999999999999998e-48 | NR | GMH37549.1 | 3041901 | g979 | i0 | 52.4 | 0.997706422018349 | 145 | 69 | 99.8 | 0 | 435 | 1 | 75 | 219 | GMH37549.1 hypothetical protein BSKO_05422 [Bryopsis sp. KO-2023] | diamond | 435 | 169 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis sp. KO-2023 | |
| 27752371 | 27752371 | PRJNA951412_P_NODE_4544_length_251_cov_0.876404_g4459_i0 | PRJNA951412 | 4544 | 251 | 0.876404 | 2.19977404 | Scenedesmus sp. NREL 46B-D3 | 2650976 | Plants | Plants | 51.6 | 4.25e-6 | NR | KAF6266637.1 | 2650976 | g4459 | i0 | 40 | 0.836653386454183 | 70 | 42 | 83.7 | 0 | 35 | 244 | 13 | 82 | KAF6266637.1 transmembrane proteins 14C-domain-containing protein [Scenedesmus sp. NREL 46B-D3] | diamond | 210 | 51.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. NREL 46B-D3 | |
| 28067890 | 28067890 | PRJNA951412_P_NODE_2585_length_297_cov_1.745536_g2500_i0 | PRJNA951412 | 2585 | 297 | 1.745536 | 5.18424192 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 184 | 2.56e-53 | NR | CAG9464639.1 | 765719 | g2500 | i0 | 93.9 | 31.6767676767677 | 98 | 6 | 99 | 0 | 2 | 295 | 372 | 469 | CAG9464639.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 9408 | 184 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 28793957 | 28793957 | PRJNA951412_P_NODE_3987_length_253_cov_2.222222_g3902_i0 | PRJNA951412 | 3987 | 253 | 2.222222 | 5.62222166 | Prototheca wickerhamii | 3111 | Plants | Plants | 81.6 | 6.09e-17 | NR | KAK2076667.1 | 3111 | g3902 | i0 | 63.3 | 0.711462450592885 | 60 | 22 | 71.1 | 0 | 252 | 73 | 124 | 183 | KAK2076667.1 hypothetical protein QBZ16_005427 [Prototheca wickerhamii] | diamond | 180 | 81.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 29463313 | 29463313 | PRJNA951412_P_NODE_2330_length_309_cov_1.313559_g2245_i0 | PRJNA951412 | 2330 | 309 | 1.313559 | 4.05889731 | Eukaryota | 2759 | Plants | Plants | 156 | 4.7e-45 | NR | KAK9820033.1 | 41462 | g2245 | i0 | 73.7 | 26.7087378640777 | 99 | 26 | 96.1 | 0 | 11 | 307 | 1 | 99 | KAK9820033.1 hypothetical protein WJX72_005304 [[Myrmecia] bisecta] | diamond | 8253 | 156 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 31454355 | 31454355 | PRJNA951412_P_NODE_2836_length_287_cov_1.439252_g2751_i0 | PRJNA951412 | 2836 | 287 | 1.439252 | 4.13065324 | Chlorellaceae | 35461 | Plants | Plants | 124 | 7.09e-31 | NR | XP_005845202.1 | 554065 | g2751 | i0 | 57.4 | 3.93031358885017 | 94 | 40 | 98.3 | 0 | 286 | 5 | 382 | 475 | XP_005845202.1 hypothetical protein CHLNCDRAFT_137433 [Chlorella variabilis] | diamond | 1128 | 124 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis |
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);;