contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA672101" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26733195 | 26733195 | PRJNA672101_S_NODE_33881_length_237_cov_3.500000_g33850_i0 | PRJNA672101 | 33881 | 237 | 3.5 | 8.295 | Bos mutus | 72004 | Chordata | Chordata | 77 | 1.63e-16 | NR | MXQ97301.1 | 72004 | g33850 | i0 | 100 | 0.455696202531646 | 36 | 0 | 45.6 | 0 | 1 | 108 | 24 | 59 | MXQ97301.1 hypothetical protein [Bos mutus] | diamond | 108 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Bos | Bos mutus | |
| 26986698 | 26986698 | PRJNA672101_S_NODE_5582_length_398_cov_1.658462_g5551_i0 | PRJNA672101 | 5582 | 398 | 1.658462 | 6.60067876 | Pleurodeles waltl | 8319 | Chordata | Chordata | 176 | 5.35e-48 | NR | XP_069073832.1 | 8319 | g5551 | i0 | 70.9 | 7.07035175879397 | 117 | 34 | 88.2 | 0 | 398 | 48 | 600 | 716 | XP_069073832.1 ATP-binding cassette sub-family C member 12 [Pleurodeles waltl] | diamond | 2814 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl | |
| 27113184 | 27113184 | PRJNA672101_S_NODE_19802_length_286_cov_3.272300_g19771_i0 | PRJNA672101 | 19802 | 286 | 3.2723 | 9.358778 | Rubrisciurus rubriventer | 226573 | Chordata | Chordata | 54.7 | 1.31e-6 | NR | ALP86271.1 | 226573 | g19771 | i0 | 47.2 | 2.41258741258741 | 72 | 38 | 75.5 | 0 | 19 | 234 | 27 | 98 | ALP86271.1 NADH dehydrogenase subunit 6 [Rubrisciurus rubriventer] | diamond | 690 | 55.1 | 0.992740471869329 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Rubrisciurus | Rubrisciurus rubriventer | |
| 27113185 | 27113185 | PRJNA672101_S_NODE_32042_length_244_cov_0.900585_g32011_i0 | PRJNA672101 | 32042 | 244 | 0.900585 | 2.1974274 | Mus musculus | 10090 | Chordata | Chordata | 42.7 | 0.0288 | NR | EDL00966.1 | 10090 | g32011 | i0 | 85.7 | 0.258196721311475 | 21 | 3 | 25.8 | 0 | 93 | 31 | 2 | 22 | EDL00966.1 zinc finger, CCHC domain containing 9, isoform CRA_b, partial [Mus musculus] | diamond | 63 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 27271376 | 27271376 | PRJNA672101_S_NODE_20943_length_281_cov_1.697115_g20912_i0 | PRJNA672101 | 20943 | 281 | 1.697115 | 4.76889315 | Marmota monax | 9995 | Chordata | Chordata | 52.4 | 2.07e-5 | NR | KAF7486720.1 | 9995 | g20912 | i0 | 68.4 | 0.405693950177936 | 38 | 12 | 40.6 | 0 | 4 | 117 | 253 | 290 | KAF7486720.1 hypothetical protein GHT09_000934 [Marmota monax] | diamond | 114 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Marmota | Marmota monax | |
| 27587373 | 27587373 | PRJNA672101_S_NODE_11544_length_336_cov_1.171103_g11513_i0 | PRJNA672101 | 11544 | 336 | 1.171103 | 3.93490608 | Capra hircus | 9925 | Chordata | Chordata | 62.4 | 6.32e-9 | NR | KAJ1061846.1 | 9925 | g11513 | i0 | 73.3 | 0.401785714285714 | 45 | 12 | 40.2 | 0 | 3 | 137 | 195 | 239 | KAJ1061846.1 hypothetical protein K5549_002881 [Capra hircus] | diamond | 135 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Capra | Capra hircus | |
| 28060788 | 28060788 | PRJNA672101_S_NODE_3165_length_452_cov_1.875989_g3134_i0 | PRJNA672101 | 3165 | 452 | 1.875989 | 8.47947028 | Mus musculus | 10090 | Chordata | Chordata | 43.9 | 0.0101 | NR | EDL36967.1 | 10090 | g3134 | i0 | 68 | 0.165929203539823 | 25 | 8 | 16.6 | 0 | 130 | 56 | 44 | 68 | EDL36967.1 mCG148273 [Mus musculus] | diamond | 75 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 28376503 | 28376503 | PRJNA672101_S_NODE_30306_length_247_cov_1.327586_g30275_i0 | PRJNA672101 | 30306 | 247 | 1.327586 | 3.27913742 | Canis lupus familiaris | 9615 | Chordata | Chordata | 65.1 | 1.86e-10 | NR | XP_038295596.1 | 9615 | g30275 | i0 | 69.2 | 0.631578947368421 | 52 | 15 | 63.2 | 1 | 2 | 157 | 172 | 222 | XP_038295596.1 uncharacterized protein LOC106557927 [Canis lupus familiaris] | diamond | 156 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 28957095 | 28957095 | PRJNA672101_S_NODE_5868_length_393_cov_4.478125_g5837_i0 | PRJNA672101 | 5868 | 393 | 4.478125 | 17.59903125 | Artiodactyla | 91561 | Chordata | Chordata | 60.1 | 8.76e-8 | NR | KAB0394371.1 | 9770 | g5837 | i0 | 93.1 | 0.66412213740458 | 29 | 2 | 22.1 | 0 | 25 | 111 | 43 | 71 | KAB0394371.1 hypothetical protein E2I00_003629, partial [Balaenoptera physalus] | diamond | 261 | 60.5 | 0.993388429752066 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Balaenopteridae | Balaenoptera | Balaenoptera physalus | |
| 29051817 | 29051817 | PRJNA672101_S_NODE_22668_length_273_cov_5.775000_g22637_i0 | PRJNA672101 | 22668 | 273 | 5.775 | 15.76575 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 65.1 | 7.48e-10 | NR | XP_040821418.1 | 130825 | g22637 | i0 | 44.4 | 4.0989010989011 | 72 | 38 | 79.1 | 1 | 41 | 256 | 312 | 381 | XP_040821418.1 sodium channel protein type 10 subunit alpha isoform X3 [Ochotona curzoniae] | diamond | 1119 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Ochotonidae | Ochotona | Ochotona curzoniae | |
| 29083262 | 29083262 | PRJNA672101_S_NODE_7108_length_377_cov_3.621711_g7077_i0 | PRJNA672101 | 7108 | 377 | 3.621711 | 13.65385047 | Mammalia | 40674 | Chordata | Chordata | 60.5 | 8.15e-8 | NR | XP_003467041.2 | 10141 | g7077 | i0 | 37.3 | 3.62864721485411 | 118 | 66 | 90.7 | 2 | 367 | 26 | 151 | 264 | XP_003467041.2 homologous-pairing protein 2 homolog isoform X4 [Cavia porcellus] | diamond | 1368 | 60.8 | 0.995065789473684 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Caviidae | Cavia | Cavia porcellus | |
| 29229319 | 29229319 | PRJNA672101_S_NODE_30489_length_247_cov_0.885057_g30458_i0 | PRJNA672101 | 30489 | 247 | 0.885057 | 2.18609079 | Phyllostomus discolor | 89673 | Chordata | Chordata | 42.4 | 0.0279 | NR | KAF6104115.1 | 89673 | g30458 | i0 | 38.3 | 0.57085020242915 | 47 | 29 | 57.1 | 0 | 92 | 232 | 104 | 150 | KAF6104115.1 hypothetical protein HJG60_011162 [Phyllostomus discolor] | diamond | 141 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Phyllostomidae | Phyllostomus | Phyllostomus discolor | |
| 29335795 | 29335795 | PRJNA672101_S_NODE_35169_length_212_cov_4.482014_g35138_i0 | PRJNA672101 | 35169 | 212 | 4.482014 | 9.50186968 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 73.9 | 2.48e-13 | NR | XP_040217508.1 | 8407 | g35138 | i0 | 50 | 5.95754716981132 | 58 | 29 | 82.1 | 0 | 17 | 190 | 195 | 252 | XP_040217508.1 NHL repeat-containing protein 2 isoform X2 [Rana temporaria] | diamond | 1263 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Rana | Rana temporaria | |
| 29797287 | 29797287 | PRJNA672101_S_NODE_24411_length_266_cov_4.922280_g24380_i0 | PRJNA672101 | 24411 | 266 | 4.92228 | 13.0932648 | Engystomops pustulosus | 76066 | Chordata | Chordata | 89.7 | 1.49e-18 | NR | KAG8571490.1 | 76066 | g24380 | i0 | 52.8 | 14.3458646616541 | 106 | 31 | 98.1 | 2 | 265 | 5 | 1005 | 1110 | KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus] | diamond | 3816 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 30871578 | 30871578 | PRJNA672101_S_NODE_31574_length_245_cov_0.895349_g31543_i0 | PRJNA672101 | 31574 | 245 | 0.895349 | 2.19360505 | Cricetulus griseus | 10029 | Chordata | Chordata | 51.6 | 2.18e-6 | NR | ERE74288.1 | 10029 | g31543 | i0 | 60.5 | 0.942857142857143 | 38 | 11 | 41.6 | 1 | 1 | 102 | 10 | 47 | ERE74288.1 E3 ubiquitin-protein ligase [Cricetulus griseus] | diamond | 231 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Cricetulus | Cricetulus griseus | |
| 30903299 | 30903299 | PRJNA672101_S_NODE_5074_length_406_cov_3.042042_g5043_i0 | PRJNA672101 | 5074 | 406 | 3.042042 | 12.35069052 | Galemys pyrenaicus | 202257 | Chordata | Chordata | 53.9 | 2.16e-5 | NR | KAG8507815.1 | 202257 | g5043 | i0 | 60 | 0.332512315270936 | 45 | 18 | 33.3 | 0 | 2 | 136 | 158 | 202 | KAG8507815.1 Folliculin-interacting protein 1, partial [Galemys pyrenaicus] | diamond | 135 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Talpidae | Galemys | Galemys pyrenaicus | |
| 31199069 | 31199069 | PRJNA672101_S_NODE_28775_length_250_cov_2.610169_g28744_i0 | PRJNA672101 | 28775 | 250 | 2.610169 | 6.5254225 | Mammalia | 40674 | Chordata | Chordata | 49.7 | 1.51e-4 | NR | XP_057170311.1 | 9644 | g28744 | i0 | 38.9 | 2.16 | 90 | 41 | 91.2 | 3 | 10 | 237 | 570 | 659 | XP_057170311.1 granule associated Rac and RHOG effector protein 1 isoform X1 [Ursus arctos] | diamond | 540 | 50.1 | 0.992015968063872 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Ursidae | Ursus | Ursus arctos | |
| 31282353 | 31282353 | PRJNA672101_S_NODE_35055_length_216_cov_4.307692_g35024_i0 | PRJNA672101 | 35055 | 216 | 4.307692 | 9.30461472 | Pteropus alecto | 9402 | Chordata | Chordata | 68.2 | 2.88e-11 | NR | ELK06828.1 | 9402 | g35024 | i0 | 51.6 | 0.888888888888889 | 64 | 31 | 88.9 | 0 | 25 | 216 | 2 | 65 | ELK06828.1 hypothetical protein PAL_GLEAN10011960 [Pteropus alecto] | diamond | 192 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Pteropodidae | Pteropus | Pteropus alecto | |
| 31314049 | 31314049 | PRJNA672101_S_NODE_20415_length_283_cov_4.033333_g20384_i0 | PRJNA672101 | 20415 | 283 | 4.033333 | 11.41433239 | Scyliorhinus canicula | 7830 | Chordata | Chordata | 47.8 | 0.00106 | NR | XP_038631011.1 | 7830 | g20384 | i0 | 41.2 | 1.74911660777385 | 51 | 29 | 53 | 1 | 86 | 235 | 133 | 183 | XP_038631011.1 centromere protein I-like isoform X3 [Scyliorhinus canicula] | diamond | 495 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Carcharhiniformes | Scyliorhinidae | Scyliorhinus | Scyliorhinus canicula | |
| 32010036 | 32010036 | PRJNA672101_S_NODE_26958_length_256_cov_4.065574_g26927_i0 | PRJNA672101 | 26958 | 256 | 4.065574 | 10.40786944 | Sagmatias obliquidens | 3371155 | Chordata | Chordata | 68.2 | 4.53e-11 | NR | XP_026938942.1 | 3371155 | g26927 | i0 | 63.6 | 1.546875 | 66 | 19 | 71.5 | 1 | 193 | 11 | 60 | 125 | XP_026938942.1 LOW QUALITY PROTEIN: protein SET-like [Sagmatias obliquidens] | diamond | 396 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Delphinidae | Sagmatias | Sagmatias obliquidens | |
| 32263385 | 32263385 | PRJNA672101_S_NODE_26378_length_259_cov_1.241935_g26347_i0 | PRJNA672101 | 26378 | 259 | 1.241935 | 3.21661165 | Eschrichtius robustus | 9764 | Chordata | Chordata | 50.1 | 1.11e-4 | NR | KAJ8787875.1 | 9764 | g26347 | i0 | 66.7 | 0.382239382239382 | 33 | 11 | 38.2 | 0 | 64 | 162 | 99 | 131 | KAJ8787875.1 hypothetical protein J1605_022676 [Eschrichtius robustus] | diamond | 99 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Eschrichtiidae | Eschrichtius | Eschrichtius robustus | |
| 32433490 | 32433490 | PRJNA672101_S_NODE_34859_length_223_cov_4.586667_g34828_i0 | PRJNA672101 | 34859 | 223 | 4.586667 | 10.22826741 | root | 1 | Root_unresolved | Root_unresolved | 156 | 5.2499999999999986e-43 | NR | XP_030110853.2 | 10090 | g34828 | i0 | 97.3 | 15.9282511210762 | 74 | 2 | 99.6 | 0 | 1 | 222 | 149 | 222 | XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus] | diamond | 3552 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus |
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);;