contig_metadata
6 rows where bioproject = "PRJEB6054", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26067162 | 26067162 | PRJEB6054_S_NODE_12213_length_164_cov_1.697674_g12124_i0 | PRJEB6054 | 12213 | 164 | 1.697674 | 2.78418536 | Mus musculus | 10090 | Chordata | Chordata | 54.7 | 0.004 | NTclustered | gi|71533340|gb|AC156162.2| | 10090 | g12124 | i0 | 100 | 0.176829268292683 | 29 | 0 | 18 | 0 | 28 | 56 | 100755 | 100783 | Mus musculus BAC clone RP24-342A17 from chromosome 9, complete sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 26203473 | 26203473 | PRJEB6054_S_NODE_12702_length_162_cov_19.755906_g12613_i0 | PRJEB6054 | 12702 | 162 | 19.755906 | 32.00456772 | Mus musculus | 10090 | Chordata | Chordata | 54.7 | 0.004 | NTclustered | gi|57544729|gb|AC116825.23| | 10090 | g12613 | i0 | 96.97 | 1.41358024691358 | 33 | 0 | 20 | 1 | 131 | 162 | 25802 | 25770 | Mus musculus chromosome 8, clone RP24-367H14, complete sequence | blastn | 229 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 26203562 | 26203562 | PRJEB6054_S_NODE_2070_length_302_cov_7.730337_g1981_i0 | PRJEB6054 | 2070 | 302 | 7.730337 | 23.34561774 | Cairina moschata | 8855 | Chordata | Chordata | 52.8 | 0.028 | NTclustered | gi|2921975556|gb|CP130394.1| | 8855 | g1981 | i0 | 100 | 0.0927152317880795 | 28 | 0 | 9 | 0 | 50 | 77 | 1455432 | 1455405 | Cairina moschata breed yongchun chromosome 17 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Anseriformes | Anatidae | Cairina | Cairina moschata | |
| 26295793 | 26295793 | PRJEB6054_S_NODE_12246_length_164_cov_0.930233_g12157_i0 | PRJEB6054 | 12246 | 164 | 0.930233 | 1.52558212 | Mus | 10088 | Chordata | Chordata | 303 | 3.42e-78 | NTclustered | gi|756142290|gb|KP260515.1| | 10090 | g12157 | i0 | 100 | 100.30487804878 | 164 | 0 | 100 | 0 | 1 | 164 | 1257 | 1094 | Mus musculus strain ME mitochondrion, complete genome | blastn | 16450 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 26339349 | 26339349 | PRJEB6054_S_NODE_2127_length_299_cov_37.416667_g2038_i0 | PRJEB6054 | 2127 | 299 | 37.416667 | 111.87583433 | Leopardus geoffroyi | 46844 | Chordata | Chordata | 56.5 | 0.002 | NTclustered | gi|2166791660|ref|XR_006704252.1| | 46844 | g2038 | i0 | 100 | 0.100334448160535 | 30 | 0 | 10 | 0 | 270 | 299 | 85 | 114 | PREDICTED: Leopardus geoffroyi uncharacterized LOC123582161 (LOC123582161), ncRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Felidae | Leopardus | Leopardus geoffroyi | |
| 33167657 | 33167657 | PRJEB6054_S_NODE_10576_length_173_cov_3.775362_g10487_i0 | PRJEB6054 | 10576 | 173 | 3.775362 | 6.53137626 | Eptesicus fuscus | 29078 | Chordata | Chordata | 42.7 | 0.0141 | NR | XP_054580937.1 | 29078 | g10487 | i0 | 49 | 2.56647398843931 | 49 | 17 | 71.1 | 3 | 173 | 51 | 215 | 263 | XP_054580937.1 60S ribosomal protein L11-like [Eptesicus fuscus] | diamond | 444 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Eptesicus | Eptesicus fuscus |
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);;