contig_metadata
11 rows where bioproject = "PRJNA774958" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2028619 | 2028619 | PRJNA774958_P_NODE_3262_length_887_cov_2.904177_g3076_i0 | PRJNA774958 | 3262 | 887 | 2.904177 | 25.76004999 | Eukaryota | 2759 | Plants | Plants | 214 | 8.88e-62 | NR | KAK9803851.1 | 706552 | g3076 | i0 | 41 | 12.608793686584 | 293 | 161 | 96.7 | 5 | 887 | 30 | 200 | 487 | KAK9803851.1 hypothetical protein WJX73_008551 [Symbiochloris irregularis] | diamond | 11184 | 216 | 0.990740740740741 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 3303596 | 3303596 | PRJNA774958_P_NODE_13843_length_437_cov_2.129121_g13596_i0 | PRJNA774958 | 13843 | 437 | 2.129121 | 9.30425877 | Eukaryota | 2759 | Plants | Plants | 104 | 1.9e-23 | NR | KAI3428667.1 | 3077 | g13596 | i0 | 55.8 | 9.80320366132723 | 86 | 38 | 59 | 0 | 260 | 3 | 76 | 161 | KAI3428667.1 hypothetical protein D9Q98_007490 [Chlorella vulgaris] | diamond | 4284 | 104 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 9681097 | 9681097 | PRJNA774958_P_NODE_24068_length_318_cov_0.942857_g23821_i0 | PRJNA774958 | 24068 | 318 | 0.942857 | 2.99828526 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 220 | 7.7199999999999995e-53 | NTclustered | gi|2082244743|ref|XM_001698671.2| | 3055 | g23821 | i0 | 82.422 | 11.9905660377358 | 256 | 41 | 80 | 4 | 38 | 291 | 753 | 500 | Chlamydomonas reinhardtii ribosomal protein L23 (CHLRE_04g211800v5), mRNA | blastn | 3813 | 220 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 13962262 | 13962262 | PRJNA774958_P_NODE_7711_length_592_cov_23.566474_g7477_i0 | PRJNA774958 | 7711 | 592 | 23.566474 | 139.51352608 | Chlorella desiccata (nom. nud.) | 1650286 | Plants | Plants | 293 | 1.24e-98 | NR | KAG7669139.1 | 1650286 | g7477 | i0 | 82.6 | 7.59628378378378 | 172 | 24 | 84.1 | 1 | 542 | 45 | 1 | 172 | KAG7669139.1 hypothetical protein KSW81_007300 [Chlorella desiccata (nom. nud.)] | diamond | 4497 | 293 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 27473708 | 27473708 | PRJNA774958_P_NODE_1363_length_1269_cov_2.124582_g1250_i0 | PRJNA774958 | 1363 | 1269 | 2.124582 | 26.96094558 | Eukaryota | 2759 | Plants | Plants | 85.9 | 9.83e-14 | NR | KAJ9510115.1 | 44745 | g1250 | i0 | 46.7 | 1.23404255319149 | 75 | 40 | 17.7 | 0 | 746 | 970 | 80 | 154 | KAJ9510115.1 hypothetical protein QJQ45_015595 [Haematococcus lacustris] | diamond | 1566 | 86.7 | 0.990772779700115 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 27694989 | 27694989 | PRJNA774958_P_NODE_30624_length_268_cov_1.410256_g30377_i0 | PRJNA774958 | 30624 | 268 | 1.410256 | 3.77948608 | Eukaryota | 2759 | Plants | Plants | 70.5 | 7.01e-12 | NR | XP_002948806.1 | 3068 | g30377 | i0 | 54.4 | 7.6455223880597 | 79 | 25 | 76.1 | 1 | 3 | 206 | 286 | 364 | XP_002948806.1 uncharacterized protein VOLCADRAFT_104016 [Volvox carteri f. nagariensis] | diamond | 2049 | 70.9 | 0.994358251057828 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 28547431 | 28547431 | PRJNA774958_P_NODE_18027_length_380_cov_1.003257_g17780_i0 | PRJNA774958 | 18027 | 380 | 1.003257 | 3.8123766 | Eukaryota | 2759 | Plants | Plants | 45.4 | 0.0173 | NR | KAF5829472.1 | 3046 | g17780 | i0 | 32.7 | 1.48421052631579 | 52 | 35 | 41.1 | 0 | 9 | 164 | 312 | 363 | KAF5829472.1 quinon protein alcohol dehydrogenase-like superfamily [Dunaliella salina] | diamond | 564 | 45.8 | 0.991266375545852 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 29557411 | 29557411 | PRJNA774958_P_NODE_31590_length_262_cov_1.222222_g31343_i0 | PRJNA774958 | 31590 | 262 | 1.222222 | 3.20222164 | Eukaryota | 2759 | Plants | Plants | 137 | 3.3699999999999996e-35 | NR | PRW20811.1 | 3076 | g31343 | i0 | 76.7 | 29.5534351145038 | 86 | 20 | 98.5 | 0 | 3 | 260 | 204 | 289 | PRW20811.1 Receptor of activated kinase C component of 40S small ribosomal subunit isoform C [Chlorella sorokiniana] | diamond | 7743 | 137 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 31507315 | 31507315 | PRJNA774958_P_NODE_24576_length_313_cov_5.483333_g24329_i0 | PRJNA774958 | 24576 | 313 | 5.483333 | 17.16283229 | Trebouxia sp. C | 2796353 | Plants | Plants | 97.8 | 8.04e-24 | NR | KAL3152508.1 | 3373145 | g24329 | i0 | 68.1 | 1.37060702875399 | 72 | 23 | 69 | 0 | 72 | 287 | 46 | 117 | KAL3152508.1 60S ribosomal protein L38 [Trebouxia sp. C0010 RCD-2024] | diamond | 429 | 97.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0010 RCD-2024 | |
| 32654791 | 32654791 | PRJNA774958_P_NODE_32780_length_253_cov_1.711111_g32533_i0 | PRJNA774958 | 32780 | 253 | 1.711111 | 4.32911083 | Eukaryota | 2759 | Plants | Plants | 45.1 | 0.00657 | NR | KAI3438618.1 | 3077 | g32533 | i0 | 45.5 | 5.60869565217391 | 44 | 24 | 52.2 | 0 | 14 | 145 | 492 | 535 | KAI3438618.1 hypothetical protein D9Q98_001041 [Chlorella vulgaris] | diamond | 1419 | 45.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 32749544 | 32749544 | PRJNA774958_P_NODE_13940_length_436_cov_1.526171_g13693_i0 | PRJNA774958 | 13940 | 436 | 1.526171 | 6.65410556 | Chlorellales | 35460 | Plants | Plants | 85.9 | 2.06e-16 | NR | CAL5227702.1 | 1274662 | g13693 | i0 | 39 | 4.80275229357798 | 146 | 83 | 99.8 | 2 | 435 | 1 | 93 | 233 | CAL5227702.1 g10710 [Coccomyxa viridis] | diamond | 2094 | 85.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis |
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);;