contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA951412" and tax_phylum = "Chlorophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 934816 | 934816 | PRJNA951412_P_NODE_301_length_897_cov_4.861650_g228_i0 | PRJNA951412 | 301 | 897 | 4.86165 | 43.6090005 | Chloropicon primus | 1764295 | Plants | Plants | 346 | 7.49e-116 | NR | QDZ22777.1 | 1764295 | g228 | i0 | 56.9 | 0.963210702341137 | 288 | 115 | 94 | 5 | 846 | 4 | 27 | 312 | QDZ22777.1 cathepsin B cysteine protease [Chloropicon primus] | diamond | 864 | 346 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Chloropicophyceae | Chloropicales | Chloropicaceae | Chloropicon | Chloropicon primus | ||
| 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 | |
| 22611799 | 22611799 | PRJNA951412_P_NODE_2658_length_294_cov_1.407240_g2573_i0 | PRJNA951412 | 2658 | 294 | 1.40724 | 4.1372856 | Chloropicon primus | 1764295 | Plants | Plants | 162 | 8.649999999999999e-47 | NR | QDZ22777.1 | 1764295 | g2573 | i0 | 74.2 | 1.89795918367347 | 93 | 24 | 94.9 | 0 | 290 | 12 | 99 | 191 | QDZ22777.1 cathepsin B cysteine protease [Chloropicon primus] | diamond | 558 | 162 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Chloropicophyceae | Chloropicales | Chloropicaceae | Chloropicon | Chloropicon primus | ||
| 27246852 | 27246852 | PRJNA951412_P_NODE_4823_length_250_cov_0.881356_g4738_i0 | PRJNA951412 | 4823 | 250 | 0.881356 | 2.20339 | Chloropicon primus | 1764295 | Plants | Plants | 70.1 | 9.57e-12 | NR | QDZ21461.1 | 1764295 | g4738 | i0 | 75.6 | 1.092 | 45 | 11 | 54 | 0 | 250 | 116 | 729 | 773 | QDZ21461.1 inorganic pyrophosphatase [Chloropicon primus] | diamond | 273 | 70.1 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Chloropicophyceae | Chloropicales | Chloropicaceae | Chloropicon | Chloropicon primus | ||
| 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 | |
| 27657649 | 27657649 | PRJNA951412_P_NODE_2844_length_287_cov_1.224299_g2759_i0 | PRJNA951412 | 2844 | 287 | 1.224299 | 3.51373813 | Micromonas pusilla CCMP1545 | 564608 | Plants | Plants | 142 | 2.24e-37 | NR | XP_003064294.1 | 564608 | g2759 | i0 | 70 | 1.86062717770035 | 90 | 27 | 94.1 | 0 | 2 | 271 | 309 | 398 | XP_003064294.1 papain family cysteine protease [Micromonas pusilla CCMP1545] | diamond | 534 | 142 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas pusilla | ||
| 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 | |
| 29305758 | 29305758 | PRJNA951412_P_NODE_3969_length_254_cov_1.138122_g3884_i0 | PRJNA951412 | 3969 | 254 | 1.138122 | 2.89082988 | Opisthokonta | 33154 | Plants | Plants | 96.7 | 2.4900000000000004e-21 | NR | KAK3261591.1 | 36881 | g3884 | i0 | 55.7 | 1.90157480314961 | 79 | 32 | 89.8 | 1 | 246 | 19 | 270 | 348 | KAK3261591.1 hypothetical protein CYMTET_29506 [Cymbomonas tetramitiformis] | diamond | 483 | 96.7 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 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 | |
| 31517607 | 31517607 | PRJNA951412_P_NODE_2896_length_285_cov_1.457547_g2811_i0 | PRJNA951412 | 2896 | 285 | 1.457547 | 4.15400895 | root | 1 | Root_unresolved | Root_unresolved | 107 | 7.3699999999999985e-28 | NR | XP_002501744.1 | 296587 | g2811 | i0 | 52.2 | 5.83157894736842 | 92 | 44 | 96.8 | 0 | 277 | 2 | 9 | 100 | XP_002501744.1 predicted protein, partial [Micromonas commoda] | diamond | 1662 | 107 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 32017007 | 32017007 | PRJNA951412_P_NODE_2298_length_311_cov_1.197479_g2213_i0 | PRJNA951412 | 2298 | 311 | 1.197479 | 3.72415969 | Cymbomonas tetramitiformis | 36881 | Plants | Plants | 44.3 | 0.0231 | NR | KAK3239804.1 | 36881 | g2213 | i0 | 43.1 | 0.559485530546624 | 58 | 33 | 55.9 | 0 | 1 | 174 | 468 | 525 | KAK3239804.1 hypothetical protein CYMTET_50294 [Cymbomonas tetramitiformis] | diamond | 174 | 44.3 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 32175477 | 32175477 | PRJNA951412_P_NODE_1518_length_365_cov_1.589041_g1433_i0 | PRJNA951412 | 1518 | 365 | 1.589041 | 5.79999965 | Micromonas commoda | 296587 | Plants | Plants | 111 | 1.04e-25 | NR | XP_002501423.1 | 296587 | g1433 | i0 | 43.8 | 1.97260273972603 | 121 | 68 | 99.5 | 0 | 364 | 2 | 91 | 211 | XP_002501423.1 monovalent Cation:Proton antiporter-1 family [Micromonas commoda] | diamond | 720 | 111 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda |
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);;