contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA680334" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26701927 | 26701927 | PRJNA680334_S_NODE_32041_length_220_cov_3.732620_g31555_i0 | PRJNA680334 | 32041 | 220 | 3.73262 | 8.211764 | Mus musculus | 10090 | Chordata | Chordata | 49.3 | 3.24e-5 | NR | EDL14396.1 | 10090 | g31555 | i0 | 57.4 | 0.640909090909091 | 47 | 19 | 64.1 | 1 | 203 | 63 | 57 | 102 | EDL14396.1 mCG145954, partial [Mus musculus] | diamond | 141 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 26955223 | 26955223 | PRJNA680334_S_NODE_26082_length_234_cov_9.835821_g25596_i0 | PRJNA680334 | 26082 | 234 | 9.835821 | 23.01582114 | Staurois parvus | 386267 | Chordata | Chordata | 51.6 | 1.73e-5 | NR | CAI9536211.1 | 386267 | g25596 | i0 | 51.8 | 1.93589743589744 | 56 | 20 | 62.8 | 3 | 49 | 195 | 170 | 225 | CAI9536211.1 unnamed protein product [Staurois parvus] | diamond | 453 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 27176577 | 27176577 | PRJNA680334_S_NODE_91782_length_158_cov_1.840000_g91296_i0 | PRJNA680334 | 91782 | 158 | 1.84 | 2.9072 | Mus musculus | 10090 | Chordata | Chordata | 50.4 | 2.24e-5 | NR | NP_001074891.1 | 10090 | g91296 | i0 | 84.6 | 0.987341772151899 | 52 | 8 | 98.7 | 0 | 2 | 157 | 491 | 542 | NP_001074891.1 biorientation of chromosomes in cell division protein 1-like 1 isoform 1 [Mus musculus] | diamond | 156 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 28009918 | 28009918 | PRJNA680334_S_NODE_41105_length_204_cov_2.233918_g40619_i0 | PRJNA680334 | 41105 | 204 | 2.233918 | 4.55719272 | Rodentia | 9989 | Chordata | Chordata | 102 | 3.049999999999999e-23 | NR | MBZ3891002.1 | 30640 | g40619 | i0 | 98.1 | 5.45588235294118 | 53 | 1 | 77.9 | 0 | 4 | 162 | 1090 | 1142 | MBZ3891002.1 Leucine-rich repeat-containing protein 16C [Sciurus carolinensis] | diamond | 1113 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Sciurus | Sciurus carolinensis | |
| 29967433 | 29967433 | PRJNA680334_S_NODE_63031_length_178_cov_3.510345_g62545_i0 | PRJNA680334 | 63031 | 178 | 3.510345 | 6.2484141 | Rajidae | 30475 | Chordata | Chordata | 41.6 | 0.0392 | NR | XP_055487582.1 | 7782 | g62545 | i0 | 68 | 4.14606741573034 | 25 | 8 | 42.1 | 0 | 3 | 77 | 353 | 377 | XP_055487582.1 uncharacterized protein LOC129694847 [Leucoraja erinaceus] | diamond | 738 | 42 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Rajiformes | Rajidae | Leucoraja | Leucoraja erinaceus | |
| 30081790 | 30081790 | PRJNA680334_S_NODE_64212_length_177_cov_3.062500_g63726_i0 | PRJNA680334 | 64212 | 177 | 3.0625 | 5.420625 | Ailuropoda melanoleuca | 9646 | Chordata | Chordata | 44.3 | 0.00441 | NR | EFB25329.1 | 9646 | g63726 | i0 | 49 | 0.830508474576271 | 49 | 22 | 79.7 | 2 | 34 | 174 | 131 | 178 | EFB25329.1 hypothetical protein PANDA_022217, partial [Ailuropoda melanoleuca] | diamond | 147 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Ursidae | Ailuropoda | Ailuropoda melanoleuca | |
| 30113474 | 30113474 | PRJNA680334_S_NODE_92252_length_157_cov_12.379032_g91766_i0 | PRJNA680334 | 92252 | 157 | 12.379032 | 19.43508024 | Rattus norvegicus | 10116 | Chordata | Chordata | 41.6 | 0.00611 | NR | EDL98840.1 | 10116 | g91766 | i0 | 88.5 | 0.496815286624204 | 26 | 3 | 49.7 | 0 | 91 | 14 | 1 | 26 | EDL98840.1 acidic nuclear phosphoprotein 32 family, member B, isoform CRA_a [Rattus norvegicus] | diamond | 78 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus | |
| 30239973 | 30239973 | PRJNA680334_S_NODE_60132_length_181_cov_2.277027_g59646_i0 | PRJNA680334 | 60132 | 181 | 2.277027 | 4.12141887 | Phacochoerus africanus | 41426 | Chordata | Chordata | 45.4 | 0.00179 | NR | XP_047649697.1 | 41426 | g59646 | i0 | 59.4 | 0.530386740331492 | 32 | 13 | 53 | 0 | 64 | 159 | 269 | 300 | XP_047649697.1 ras-related protein Rab-12 isoform X2 [Phacochoerus africanus] | diamond | 96 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Phacochoerus | Phacochoerus africanus | |
| 30587337 | 30587337 | PRJNA680334_S_NODE_63813_length_177_cov_7.055556_g63327_i0 | PRJNA680334 | 63813 | 177 | 7.055556 | 12.48833412 | Mus musculus | 10090 | Chordata | Chordata | 127 | 3.1499999999999993e-34 | NR | 4M69_A | 10090 | g63327 | i0 | 100 | 2.89830508474576 | 57 | 0 | 96.6 | 0 | 171 | 1 | 236 | 292 | 4M69_A Chain A, Receptor-interacting serine/threonine-protein kinase 3 [Mus musculus] | diamond | 513 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 30682035 | 30682035 | PRJNA680334_S_NODE_43013_length_201_cov_2.922619_g42527_i0 | PRJNA680334 | 43013 | 201 | 2.922619 | 5.87446419 | Balaenoptera physalus | 9770 | Chordata | Chordata | 42.7 | 0.00782 | NR | KAB0401909.1 | 9770 | g42527 | i0 | 53.2 | 1.22388059701493 | 47 | 18 | 67.2 | 2 | 139 | 5 | 13 | 57 | KAB0401909.1 hypothetical protein E2I00_017869, partial [Balaenoptera physalus] | diamond | 246 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Balaenopteridae | Balaenoptera | Balaenoptera physalus | |
| 31136062 | 31136062 | PRJNA680334_S_NODE_25595_length_236_cov_2.837438_g25109_i0 | PRJNA680334 | 25595 | 236 | 2.837438 | 6.69635368 | Carnivora | 33554 | Chordata | Chordata | 62.8 | 2.99e-9 | NR | BAA25253.1 | 9615 | g25109 | i0 | 43.3 | 13.5 | 60 | 34 | 76.3 | 0 | 199 | 20 | 874 | 933 | BAA25253.1 unnamed protein product [Canis lupus familiaris] | diamond | 3186 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 31978480 | 31978480 | PRJNA680334_S_NODE_61118_length_180_cov_2.489796_g60632_i0 | PRJNA680334 | 61118 | 180 | 2.489796 | 4.4816328 | Equus caballus | 9796 | Chordata | Chordata | 58.5 | 4.19e-8 | NR | XP_070102340.1 | 9796 | g60632 | i0 | 70.5 | 0.733333333333333 | 44 | 13 | 73.3 | 0 | 138 | 7 | 78 | 121 | XP_070102340.1 DNA excision repair protein ERCC-8 isoform X2 [Equus caballus] | diamond | 132 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Perissodactyla | Equidae | Equus | Equus caballus | |
| 32073515 | 32073515 | PRJNA680334_S_NODE_41618_length_203_cov_3.270588_g41132_i0 | PRJNA680334 | 41618 | 203 | 3.270588 | 6.63929364 | Suncus etruscus | 109475 | Chordata | Chordata | 42 | 0.0407 | NR | XP_049643246.1 | 109475 | g41132 | i0 | 38.8 | 0.724137931034483 | 49 | 27 | 68 | 1 | 186 | 49 | 50 | 98 | XP_049643246.1 glutaminyl-peptide cyclotransferase-like protein [Suncus etruscus] | diamond | 147 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Soricidae | Suncus | Suncus etruscus | |
| 32894389 | 32894389 | PRJNA680334_S_NODE_67860_length_174_cov_2.666667_g67374_i0 | PRJNA680334 | 67860 | 174 | 2.666667 | 4.64000058 | Choloepus didactylus | 27675 | Chordata | Chordata | 58.9 | 1.84e-8 | NR | XP_037703436.1 | 27675 | g67374 | i0 | 94.3 | 0.603448275862069 | 35 | 2 | 60.3 | 0 | 172 | 68 | 216 | 250 | XP_037703436.1 basic proline-rich protein-like [Choloepus didactylus] | diamond | 105 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Pilosa | Megalonychidae | Choloepus | Choloepus didactylus |
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);;