contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA1218818" and tax_clade = "Embryophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9261824 | 9261824 | PRJNA1218818_P_NODE_28288_length_242_cov_0.911243_g28221_i0 | PRJNA1218818 | 28288 | 242 | 0.911243 | 2.20520806 | Prunus speciosa | 378228 | Plants | Plants | 62.4 | 5.8e-10 | NR | BFG23786.1 | 378228 | g28221 | i0 | 49.2 | 6.71900826446281 | 65 | 33 | 80.6 | 0 | 37 | 231 | 22 | 86 | BFG23786.1 hypothetical protein CerSpe_100590 [Prunus speciosa] | diamond | 1626 | 62.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Prunus | Prunus speciosa | |
| 13087516 | 13087516 | PRJNA1218818_P_NODE_27471_length_244_cov_0.900585_g27404_i0 | PRJNA1218818 | 27471 | 244 | 0.900585 | 2.1974274 | Magnoliopsida | 3398 | Plants | Plants | 132 | 1.54e-33 | NR | XP_022957583.1 | 3662 | g27404 | i0 | 73.1 | 109.217213114754 | 78 | 21 | 95.9 | 0 | 244 | 11 | 454 | 531 | XP_022957583.1 2-oxoglutarate dehydrogenase, mitochondrial-like [Cucurbita moschata] | diamond | 26649 | 133 | 0.992481203007519 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cucurbitales | Cucurbitaceae | Cucurbita | Cucurbita moschata | |
| 29270236 | 29270236 | PRJNA1218818_P_NODE_28309_length_242_cov_0.911243_g28242_i0 | PRJNA1218818 | 28309 | 242 | 0.911243 | 2.20520806 | Magnoliopsida | 3398 | Plants | Plants | 125 | 1.12e-34 | NR | CAA7404197.1 | 51605 | g28242 | i0 | 71.8 | 3.89256198347107 | 78 | 22 | 96.7 | 0 | 237 | 4 | 7 | 84 | CAA7404197.1 unnamed protein product [Spirodela intermedia] | diamond | 942 | 125 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Alismatales | Araceae | Spirodela | Spirodela intermedia | |
| 29554422 | 29554422 | PRJNA1218818_P_NODE_27550_length_244_cov_0.900585_g27483_i0 | PRJNA1218818 | 27550 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | Plants | Plants | 139 | 2.18e-40 | NR | XP_043621716.1 | 72917 | g27483 | i0 | 79 | 15.922131147541 | 81 | 17 | 99.6 | 0 | 2 | 244 | 19 | 99 | XP_043621716.1 40S ribosomal protein S16-like [Erigeron canadensis] | diamond | 3885 | 139 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Erigeron | Erigeron canadensis | |
| 30799265 | 30799265 | PRJNA1218818_P_NODE_27534_length_244_cov_0.900585_g27467_i0 | PRJNA1218818 | 27534 | 244 | 0.900585 | 2.1974274 | Sphagnum troendelagicum | 128251 | Plants | Plants | 61.2 | 8.64e-10 | NR | CAK9201008.1 | 128251 | g27467 | i0 | 52.8 | 3.25819672131148 | 53 | 24 | 65.2 | 1 | 222 | 64 | 16 | 67 | CAK9201008.1 unnamed protein product [Sphagnum troendelagicum] | diamond | 795 | 61.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Sphagnopsida | Sphagnales | Sphagnaceae | Sphagnum | Sphagnum troendelagicum | |
| 30913133 | 30913133 | PRJNA1218818_P_NODE_17434_length_299_cov_1.057522_g17367_i0 | PRJNA1218818 | 17434 | 299 | 1.057522 | 3.16199078 | Eukaryota | 2759 | Plants | Plants | 161 | 6.129999999999998e-47 | NR | KAK1315382.1 | 4465 | g17367 | i0 | 80.8 | 158.929765886288 | 99 | 19 | 99.3 | 0 | 298 | 2 | 65 | 163 | KAK1315382.1 40S ribosomal protein S3-3 [Acorus calamus] | diamond | 47520 | 162 | 0.993827160493827 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Acorales | Acoraceae | Acorus | Acorus calamus | |
| 32082942 | 32082942 | PRJNA1218818_P_NODE_28358_length_242_cov_0.911243_g28291_i0 | PRJNA1218818 | 28358 | 242 | 0.911243 | 2.20520806 | Eukaryota | 2759 | Plants | Plants | 52.8 | 1.02e-5 | NR | NP_001150062.1 | 4577 | g28291 | i0 | 41.9 | 7.52479338842975 | 62 | 36 | 76.9 | 0 | 236 | 51 | 37 | 98 | NP_001150062.1 thiol protease SEN102 precursor [Zea mays] | diamond | 1821 | 53.1 | 0.994350282485876 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Zea | Zea mays | |
| 32651862 | 32651862 | PRJNA1218818_P_NODE_25460_length_248_cov_0.880000_g25393_i0 | PRJNA1218818 | 25460 | 248 | 0.88 | 2.1824 | Streptophyta | 35493 | Plants | Plants | 72 | 1.93e-12 | NR | XP_006841407.1 | 13333 | g25393 | i0 | 43.9 | 3.0241935483871 | 82 | 43 | 99.2 | 1 | 246 | 1 | 367 | 445 | XP_006841407.1 pyrophosphate-energized vacuolar membrane proton pump 1 [Amborella trichopoda] | diamond | 750 | 72 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Amborellales | Amborellaceae | Amborella | Amborella trichopoda | |
| 32727955 | 32727955 | PRJNA1218818_P_NODE_26860_length_245_cov_0.895349_g26793_i0 | PRJNA1218818 | 26860 | 245 | 0.895349 | 2.19360505 | Vanilla planifolia | 51239 | Plants | Plants | 73.6 | 5.2e-13 | NR | KAG0490418.1 | 51239 | g26793 | i0 | 45.7 | 11.9020408163265 | 81 | 43 | 99.2 | 1 | 243 | 1 | 87 | 166 | KAG0490418.1 hypothetical protein HPP92_007281 [Vanilla planifolia] | diamond | 2916 | 73.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asparagales | Orchidaceae | Vanilla | Vanilla planifolia |
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);;