contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA801875" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3351962 | 3351962 | PRJNA801875_P_NODE_1363_length_338_cov_2.759076_g1260_i0 | PRJNA801875 | 1363 | 338 | 2.759076 | 9.32567688 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 133 | 7.22e-37 | NR | CAJ0958198.1 | 111125 | g1260 | i0 | 61.9 | 60.9230769230769 | 118 | 38 | 98.5 | 1 | 337 | 5 | 34 | 151 | CAJ0958198.1 unnamed protein product [Ranitomeya imitator] | diamond | 20592 | 134 | 0.992537313432836 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 12280542 | 12280542 | PRJNA801875_P_NODE_1750_length_283_cov_2.245968_g1647_i0 | PRJNA801875 | 1750 | 283 | 2.245968 | 6.35608944 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 155 | 8.480000000000001e-44 | NR | XP_069481112.1 | 8296 | g1647 | i0 | 84.9 | 92.5123674911661 | 93 | 13 | 97.5 | 1 | 278 | 3 | 16 | 108 | XP_069481112.1 large ribosomal subunit protein uL4 [Ambystoma mexicanum] | diamond | 26181 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Ambystomatidae | Ambystoma | Ambystoma mexicanum | |
| 19073452 | 19073452 | PRJNA801875_P_NODE_2295_length_231_cov_1.979592_g2192_i0 | PRJNA801875 | 2295 | 231 | 1.979592 | 4.57285752 | Aves | 8782 | Chordata | Chordata | 98.2 | 7.39e-23 | NR | XP_009995761.1 | 8897 | g2192 | i0 | 61.8 | 17.7662337662338 | 76 | 28 | 98.7 | 1 | 1 | 228 | 145 | 219 | XP_009995761.1 PREDICTED: dnaJ homolog subfamily A member 2 [Chaetura pelagica] | diamond | 4104 | 98.6 | 0.995943204868154 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Apodiformes | Apodidae | Chaetura | Chaetura pelagica | |
| 26610785 | 26610785 | PRJNA801875_P_NODE_2541_length_214_cov_1.955307_g2438_i0 | PRJNA801875 | 2541 | 214 | 1.955307 | 4.18435698 | Gekko japonicus | 146911 | Chordata | Chordata | 83.6 | 1.06e-16 | NR | XP_015284848.1 | 146911 | g2438 | i0 | 66.1 | 1.68224299065421 | 59 | 20 | 82.7 | 0 | 2 | 178 | 51 | 109 | XP_015284848.1 PREDICTED: thioredoxin reductase 3 isoform X1 [Gekko japonicus] | diamond | 360 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Gekkonidae | Gekko | Gekko japonicus | |
| 26927574 | 26927574 | PRJNA801875_P_NODE_2042_length_252_cov_2.875576_g1939_i0 | PRJNA801875 | 2042 | 252 | 2.875576 | 7.24645152 | Scyliorhinus canicula | 7830 | Chordata | Chordata | 44.7 | 0.00563 | NR | XP_038674818.1 | 7830 | g1939 | i0 | 36.7 | 0.94047619047619 | 79 | 48 | 92.9 | 2 | 1 | 234 | 15 | 92 | XP_038674818.1 selenoprotein J [Scyliorhinus canicula] | diamond | 237 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Carcharhiniformes | Scyliorhinidae | Scyliorhinus | Scyliorhinus canicula | |
| 27726882 | 27726882 | PRJNA801875_P_NODE_2544_length_214_cov_1.776536_g2441_i0 | PRJNA801875 | 2544 | 214 | 1.776536 | 3.80178704 | Opisthokonta | 33154 | Chordata | Chordata | 101 | 3.49e-24 | NR | CAH1273146.1 | 7740 | g2441 | i0 | 71.9 | 1.79439252336449 | 64 | 18 | 89.7 | 0 | 8 | 199 | 204 | 267 | CAH1273146.1 RPS2 [Branchiostoma lanceolatum] | diamond | 384 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 28285679 | 28285679 | PRJNA801875_P_NODE_1666_length_293_cov_1.271318_g1563_i0 | PRJNA801875 | 1666 | 293 | 1.271318 | 3.72496174 | Oikopleura dioica | 34765 | Chordata | Chordata | 44.7 | 0.0144 | NR | CBY09951.1 | 34765 | g1563 | i0 | 42.2 | 1.47440273037543 | 45 | 26 | 46.1 | 0 | 136 | 2 | 323 | 367 | CBY09951.1 unnamed protein product [Oikopleura dioica] | diamond | 432 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Metazoa | Chordata | Appendicularia | Copelata | Oikopleuridae | Oikopleura | Oikopleura dioica | |
| 28570003 | 28570003 | PRJNA801875_P_NODE_2107_length_246_cov_1.507109_g2004_i0 | PRJNA801875 | 2107 | 246 | 1.507109 | 3.70748814 | Marmota monax | 9995 | Chordata | Chordata | 70.1 | 8.58e-12 | NR | VTJ75047.1 | 9995 | g2004 | i0 | 53.2 | 1.51219512195122 | 62 | 29 | 75.6 | 0 | 60 | 245 | 51 | 112 | VTJ75047.1 Hypothetical predicted protein, partial [Marmota monax] | diamond | 372 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Marmota | Marmota monax | |
| 29588956 | 29588956 | PRJNA801875_P_NODE_2610_length_210_cov_2.188571_g2507_i0 | PRJNA801875 | 2610 | 210 | 2.188571 | 4.5959991 | root | 1 | Root_unresolved | Root_unresolved | 42 | 0.0455 | NR | KAB0373609.1 | 9886 | g2507 | i0 | 43.6 | 1.8 | 39 | 22 | 55.7 | 0 | 70 | 186 | 273 | 311 | KAB0373609.1 hypothetical protein FD755_015268 [Muntiacus reevesi] | diamond | 378 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Muntiacus | Muntiacus reevesi | |
| 30180444 | 30180444 | PRJNA801875_P_NODE_1112_length_384_cov_2.183381_g1009_i0 | PRJNA801875 | 1112 | 384 | 2.183381 | 8.38418304 | Mycteria americana | 33587 | Chordata | Chordata | 65.9 | 1.26e-10 | NR | KAK4816150.1 | 33587 | g1009 | i0 | 38.2 | 0.796875 | 102 | 54 | 78.9 | 4 | 42 | 344 | 27 | 120 | KAK4816150.1 hypothetical protein QYF61_011532 [Mycteria americana] | diamond | 306 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Ciconiiformes | Ciconiidae | Mycteria | Mycteria americana | |
| 30433664 | 30433664 | PRJNA801875_P_NODE_2333_length_229_cov_1.072165_g2230_i0 | PRJNA801875 | 2333 | 229 | 1.072165 | 2.45525785 | Bufotes viridis | 30338 | Chordata | Chordata | 60.5 | 1.77e-8 | NR | CAK8660862.1 | 30338 | g2230 | i0 | 48.6 | 2.80349344978166 | 72 | 34 | 94.3 | 2 | 13 | 228 | 242 | 310 | CAK8660862.1 Ribosome biogenesis protein BMS1 homolog [Bufotes viridis] | diamond | 642 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 30505427 | 30505427 | PRJNA801875_P_NODE_1893_length_269_cov_1.888889_g1790_i0 | PRJNA801875 | 1893 | 269 | 1.888889 | 5.08111141 | Branchiostoma | 7737 | Chordata | Chordata | 136 | 5.48e-38 | NR | XP_035673387.1 | 7739 | g1790 | i0 | 68.2 | 5.8996282527881 | 88 | 28 | 98.1 | 0 | 3 | 266 | 41 | 128 | XP_035673387.1 ras-related protein Rab-24-like isoform X1 [Branchiostoma floridae] | diamond | 1587 | 137 | 0.992700729927007 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 31832861 | 31832861 | PRJNA801875_P_NODE_1937_length_263_cov_3.662281_g1834_i0 | PRJNA801875 | 1937 | 263 | 3.662281 | 9.63179903 | Metazoa | 33208 | Chordata | Chordata | 118 | 2.24e-29 | NR | KAJ7415991.1 | 371930 | g1834 | i0 | 64.6 | 5.63498098859316 | 82 | 29 | 93.5 | 0 | 249 | 4 | 169 | 250 | KAJ7415991.1 DnaJ subfamily A member 2 [Pitangus sulphuratus] | diamond | 1482 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Tyrannidae | Pitangus | Pitangus sulphuratus | |
| 32561046 | 32561046 | PRJNA801875_P_NODE_3579_length_173_cov_2.210145_g3476_i0 | PRJNA801875 | 3579 | 173 | 2.210145 | 3.82355085 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 60.1 | 1.11e-8 | NR | XP_069061992.1 | 8319 | g3476 | i0 | 50.9 | 24.606936416185 | 55 | 26 | 95.4 | 1 | 3 | 167 | 4930 | 4983 | XP_069061992.1 probable E3 ubiquitin-protein ligase HERC1 [Pleurodeles waltl] | diamond | 4257 | 60.5 | 0.993388429752066 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl |
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);;