contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA846086" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3383651 | 3383651 | PRJNA846086_P_NODE_2563_length_263_cov_5.847368_g2497_i0 | PRJNA846086 | 2563 | 263 | 5.847368 | 15.37857784 | Olea europaea | 4146 | Plants | Plants | 303 | 6e-78 | NTclustered | gi|1279025397|ref|XM_023016129.1| | 158386 | g2497 | i0 | 97.727 | 81.5513307984791 | 176 | 4 | 67 | 0 | 88 | 263 | 1 | 176 | PREDICTED: Olea europaea var. sylvestris uncharacterized LOC111390994 (LOC111390994), mRNA | blastn | 21448 | 303 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Oleaceae | Olea | Olea europaea | |
| 5936064 | 5936064 | PRJNA846086_P_NODE_465_length_555_cov_1.483402_g399_i0 | PRJNA846086 | 465 | 555 | 1.483402 | 8.2328811 | Wurfbainia villosa | 199627 | Plants | Plants | 54.7 | 0.015 | NTclustered | gi|1000829444|gb|KU572444.1| | 199627 | g399 | i0 | 100 | 0.104504504504505 | 29 | 0 | 5 | 0 | 38 | 66 | 379 | 407 | Amomum villosum HMGR protein (HMGR) mRNA, complete cds | blastn | 58 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Zingiberales | Zingiberaceae | Wurfbainia | Wurfbainia villosa | |
| 8485673 | 8485673 | PRJNA846086_P_NODE_1927_length_284_cov_1.360190_g1861_i0 | PRJNA846086 | 1927 | 284 | 1.36019 | 3.8629396 | Zea mays | 4577 | Plants | Plants | 394 | 3.78e-105 | NTclustered | gi|55741072|gb|AY664416.1| | 4577 | g1861 | i0 | 91.901 | 385.37676056338 | 284 | 20 | 99 | 2 | 1 | 281 | 144670 | 144953 | Zea mays cultivar Mo17 locus bz, complete sequence | blastn | 109447 | 394 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Zea | Zea mays | |
| 14860757 | 14860757 | PRJNA846086_P_NODE_2772_length_258_cov_1.664865_g2706_i0 | PRJNA846086 | 2772 | 258 | 1.664865 | 4.2953517 | Raphanus sativus | 3726 | Plants | Plants | 460 | 3.29e-125 | NTclustered | gi|2515515931|ref|XM_018616845.2| | 3726 | g2706 | i0 | 98.837 | 75.8565891472868 | 258 | 3 | 100 | 0 | 1 | 258 | 60 | 317 | PREDICTED: Raphanus sativus hypersensitive-induced response protein 2 (LOC108843614), transcript variant X3, mRNA | blastn | 19571 | 460 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Raphanus | Raphanus sativus | |
| 18684114 | 18684114 | PRJNA846086_P_NODE_2435_length_268_cov_1.071795_g2369_i0 | PRJNA846086 | 2435 | 268 | 1.071795 | 2.8724106 | Brassica napus | 3708 | Plants | Plants | 496 | 9.429999999999999e-136 | NTclustered | gi|2258186511|ref|XR_007339525.1| | 3708 | g2369 | i0 | 100 | 5.04850746268657 | 268 | 0 | 100 | 0 | 1 | 268 | 1626 | 1893 | PREDICTED: Brassica napus uncharacterized LOC125609017 (LOC125609017), ncRNA | blastn | 1353 | 496 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica napus | |
| 24182826 | 24182826 | PRJNA846086_P_NODE_4779_length_244_cov_0.900585_g4713_i0 | PRJNA846086 | 4779 | 244 | 0.900585 | 2.1974274 | root | 1 | Root_unresolved | Root_unresolved | 446 | 8.639999999999999e-121 | NTclustered | gi|417451531|gb|KC129717.1| | 75702 | g4713 | i0 | 99.59 | 98.4795081967213 | 244 | 1 | 100 | 0 | 1 | 244 | 986 | 1229 | Populus euphratica clone BIBAC2A1F6, complete sequence | blastn | 24029 | 446 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Populus | Populus euphratica | |
| 25457810 | 25457810 | PRJNA846086_P_NODE_3700_length_248_cov_1.760000_g3634_i0 | PRJNA846086 | 3700 | 248 | 1.76 | 4.3648 | Brassica | 3705 | Plants | Plants | 418 | 1.9199999999999994e-112 | NTclustered | gi|2258155075|ref|XM_048746290.1| | 3708 | g3634 | i0 | 97.177 | 42.2661290322581 | 248 | 6 | 100 | 1 | 1 | 248 | 2241 | 1995 | PREDICTED: Brassica napus probable E3 ubiquitin-protein ligase RZFP34 (LOC106382650), transcript variant X2, mRNA | blastn | 10482 | 418 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica napus |
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);;