contig_metadata
9 rows where bioproject = "PRJNA299585" and tax_phylum = "Chordata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8028585 | 8028585 | PRJNA299585_S_NODE_8267_length_247_cov_7.596330_g8037_i0 | PRJNA299585 | 8267 | 247 | 7.59633 | 18.7629351 | Fringilla coelebs | 37598 | Chordata | Chordata | 52.8 | 0.022 | NTclustered | gi|2917610922|emb|OZ228690.1| | 37598 | g8037 | i0 | 100 | 0.11336032388664 | 28 | 0 | 11 | 0 | 155 | 182 | 63098186 | 63098159 | Fringilla coelebs genome assembly, chromosome: Z | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Fringillidae | Fringilla | Fringilla coelebs | |
| 9303379 | 9303379 | PRJNA299585_S_NODE_9268_length_225_cov_4.438776_g9038_i0 | PRJNA299585 | 9268 | 225 | 4.438776 | 9.987246 | Apteryx mantelli | 2696672 | Chordata | Chordata | 54.7 | 0.006 | NTclustered | gi|840016890|emb|LK066393.1| | 202946 | g9038 | i0 | 100 | 0.128888888888889 | 29 | 0 | 13 | 0 | 179 | 207 | 207549 | 207577 | Apteryx australis mantelli genome assembly AptMant0, scaffold scaffold1803 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Apterygiformes | Apterygidae | Apteryx | Apteryx mantelli | |
| 19501016 | 19501016 | PRJNA299585_S_NODE_10056_length_210_cov_6.027624_g9826_i0 | PRJNA299585 | 10056 | 210 | 6.027624 | 12.6580104 | Spinus spinus | 160760 | Chordata | Chordata | 54.7 | 0.005 | NTclustered | gi|2917663466|emb|OZ228753.1| | 160760 | g9826 | i0 | 94.444 | 0.342857142857143 | 36 | 1 | 17 | 1 | 83 | 117 | 37205157 | 37205122 | Spinus spinus genome assembly, chromosome: 5 | blastn | 72 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Fringillidae | Spinus | Spinus spinus | |
| 21463487 | 21463487 | PRJNA299585_S_NODE_5297_length_350_cov_52.828660_g5067_i0 | PRJNA299585 | 5297 | 350 | 52.82866 | 184.90031 | Cheloniidae | 8465 | Chordata | Chordata | 52.8 | 0.033 | NTclustered | gi|2911500576|emb|OZ223607.1| | 8472 | g5067 | i0 | 100 | 0.24 | 28 | 0 | 8 | 0 | 320 | 347 | 10181252 | 10181279 | Lepidochelys kempii isolate rLepKem1 genome assembly, chromosome: 21 | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Lepidochelys | Lepidochelys kempii | ||
| 27376597 | 27376597 | PRJNA299585_S_NODE_15783_length_151_cov_5.155738_g15553_i0 | PRJNA299585 | 15783 | 151 | 5.155738 | 7.78516438 | Chordata | 7711 | Chordata | Chordata | 73.2 | 3.2e-14 | NR | ADR43854.1 | 7888 | g15553 | i0 | 97.3 | 568.887417218543 | 37 | 1 | 73.5 | 0 | 39 | 149 | 9 | 45 | ADR43854.1 cytochrome oxidase subunit 1, partial [Protopterus annectens] | diamond | 85902 | 73.9 | 0.990527740189445 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ceratodontiformes | Protopteridae | Protopterus | Protopterus annectens | ||
| 27674671 | 27674671 | PRJNA299585_S_NODE_11644_length_188_cov_14.578616_g11414_i0 | PRJNA299585 | 11644 | 188 | 14.578616 | 27.40779808 | Staurois parvus | 386267 | Chordata | Chordata | 43.1 | 0.0086 | NR | CAI9578362.1 | 386267 | g11414 | i0 | 51.5 | 0.526595744680851 | 33 | 11 | 44.7 | 1 | 59 | 142 | 139 | 171 | CAI9578362.1 unnamed protein product [Staurois parvus] | diamond | 99 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 27863796 | 27863796 | PRJNA299585_S_NODE_11785_length_186_cov_14.464968_g11555_i0 | PRJNA299585 | 11785 | 186 | 14.464968 | 26.90484048 | Bufotes viridis | 30338 | Chordata | Chordata | 47.8 | 2.88e-4 | NR | CAK8629749.1 | 30338 | g11555 | i0 | 72.4 | 0.467741935483871 | 29 | 8 | 46.8 | 0 | 32 | 118 | 336 | 364 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 87 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 30927483 | 30927483 | PRJNA299585_S_NODE_3414_length_484_cov_5.751648_g3191_i0 | PRJNA299585 | 3414 | 484 | 5.751648 | 27.83797632 | Actinopterygii environmental sample | 1184603 | Chordata | Chordata | 229 | 2.54e-73 | NR | ASS34268.1 | 1184603 | g3191 | i0 | 96 | 648.607438016529 | 126 | 5 | 78.1 | 0 | 378 | 1 | 88 | 213 | ASS34268.1 cytochrome oxidase subunit 1, partial [Actinopterygii environmental sample] | diamond | 313926 | 229 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Actinopterygii environmental sample | |||||
| 32382191 | 32382191 | PRJNA299585_S_NODE_10739_length_200_cov_13.859649_g10509_i0 | PRJNA299585 | 10739 | 200 | 13.859649 | 27.719298 | Bufotes viridis | 30338 | Chordata | Chordata | 42 | 0.039 | NR | CAK8629749.1 | 30338 | g10509 | i0 | 55.6 | 0.54 | 36 | 16 | 54 | 0 | 169 | 62 | 329 | 364 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 108 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes 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);;