contig_metadata
9 rows where bioproject = "PRJNA798905" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5046254 | 5046254 | PRJNA798905_S_NODE_20224_length_331_cov_2.298450_g19775_i0 | PRJNA798905 | 20224 | 331 | 2.29845 | 7.6078695 | root | 1 | Root_unresolved | Root_unresolved | 606 | 5.299999999999998e-169 | NTclustered | gi|1251766462|dbj|AK448045.1| | 4565 | g19775 | i0 | 99.698 | 99.9214501510574 | 331 | 1 | 100 | 0 | 1 | 331 | 2910 | 3240 | Triticum aestivum mRNA, clone: tplb0045n17, cultivar Chinese Spring | blastn | 33074 | 612 | 0.990196078431373 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 5046342 | 5046342 | PRJNA798905_S_NODE_29444_length_278_cov_11.985366_g28995_i0 | PRJNA798905 | 29444 | 278 | 11.985366 | 33.31931748 | Eukaryota | 2759 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|2917566876|emb|OZ228610.1| | 13385 | g28995 | i0 | 97.059 | 0.856115107913669 | 34 | 0 | 12 | 1 | 143 | 175 | 49713368 | 49713335 | Calluna vulgaris genome assembly, chromosome: 7 | blastn | 238 | 56.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Ericaceae | Calluna | Calluna vulgaris | |
| 5895989 | 5895989 | PRJNA798905_S_NODE_4625_length_618_cov_17.594495_g4184_i0 | PRJNA798905 | 4625 | 618 | 17.594495 | 108.7339791 | Dioscorea cayenensis | 29710 | Plants | Plants | 411 | 8.78e-110 | NTclustered | gi|1221815424|dbj|LC219412.1| | 55577 | g4184 | i0 | 79.615 | 2.02912621359223 | 623 | 88 | 99 | 31 | 1 | 614 | 2035 | 1443 | Dioscorea rotundata mitochondrial DNA, contig: TDr_Mt_scaffold39_size3100, cultivar: TDr96_F1 | blastn | 1254 | 411 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Dioscoreales | Dioscoreaceae | Dioscorea | Dioscorea cayenensis | |
| 13545836 | 13545836 | PRJNA798905_S_NODE_37731_length_246_cov_1.780347_g37282_i0 | PRJNA798905 | 37731 | 246 | 1.780347 | 4.37965362 | Triticum monococcum | 4568 | Plants | Plants | 169 | 2.11e-37 | NTclustered | gi|2581912921|emb|OY737857.1| | 4568 | g37282 | i0 | 97.938 | 25.6707317073171 | 97 | 2 | 43 | 0 | 3 | 99 | 52735431 | 52735335 | Triticum monococcum genome assembly, chromosome: UA | blastn | 6315 | 169 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum monococcum | |
| 19069780 | 19069780 | PRJNA798905_S_NODE_12875_length_395_cov_212.931677_g12426_i0 | PRJNA798905 | 12875 | 395 | 212.931677 | 841.08012415 | Magnoliopsida | 3398 | Plants | Plants | 52.8 | 0.038 | NTclustered | gi|2748510651|gb|CP158653.1| | 3483 | g12426 | i0 | 100 | 0.212658227848101 | 28 | 0 | 7 | 0 | 1 | 28 | 42476467 | 42476440 | Cannabis sativa cultivar ERBxHO40_23 chromosome 1 | blastn | 84 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Cannabis | Cannabis sativa | |
| 19919330 | 19919330 | PRJNA798905_S_NODE_7216_length_499_cov_6.133803_g6767_i0 | PRJNA798905 | 7216 | 499 | 6.133803 | 30.60767697 | Rosa rugosa | 74645 | Plants | Plants | 54.7 | 0.014 | NTclustered | gi|2646215908|ref|XR_009845426.1| | 74645 | g6767 | i0 | 100 | 0.755511022044088 | 29 | 0 | 6 | 0 | 391 | 419 | 2311 | 2339 | PREDICTED: Rosa rugosa uncharacterized LOC133707929 (LOC133707929), transcript variant X8, ncRNA | blastn | 377 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Rosa | Rosa rugosa | |
| 21194404 | 21194404 | PRJNA798905_S_NODE_24397_length_305_cov_2.297414_g23948_i0 | PRJNA798905 | 24397 | 305 | 2.297414 | 7.0071127 | Cryptomeria japonica | 3369 | Plants | Plants | 54.7 | 0.008 | NTclustered | gi|2587837754|dbj|LC313175.1| | 3369 | g23948 | i0 | 87.5 | 0.157377049180328 | 48 | 4 | 16 | 2 | 128 | 175 | 8001 | 8046 | Cryptomeria japonica DNA, BAC clone: BAC754_P17, contig: BAC754_P17_contig00003 | blastn | 48 | 54.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 21620178 | 21620178 | PRJNA798905_S_NODE_14977_length_374_cov_4.720930_g14528_i0 | PRJNA798905 | 14977 | 374 | 4.72093 | 17.6562782 | root | 1 | Root_unresolved | Root_unresolved | 680 | 0 | NTclustered | gi|1251766462|dbj|AK448045.1| | 4565 | g14528 | i0 | 100 | 98.427807486631 | 368 | 0 | 98 | 0 | 1 | 368 | 3828 | 4195 | Triticum aestivum mRNA, clone: tplb0045n17, cultivar Chinese Spring | blastn | 36812 | 680 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum | |
| 23744677 | 23744677 | PRJNA798905_S_NODE_23159_length_312_cov_2.765690_g22710_i0 | PRJNA798905 | 23159 | 312 | 2.76569 | 8.6289528 | Nicotiana plumbaginifolia | 4092 | Plants | Plants | 448 | 3.1799999999999997e-121 | NTclustered | gi|44843907|emb|AJ617157.1| | 4092 | g22710 | i0 | 97.004 | 45.6378205128205 | 267 | 7 | 86 | 1 | 1 | 267 | 100 | 365 | Nicotiana plumbaginifolia cDNA-AFLP fragment, clone Np380 | blastn | 14239 | 448 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Nicotiana | Nicotiana plumbaginifolia |
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);;