contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA1111077" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24440451 | 24440451 | PRJNA1111077_P_NODE_17760_length_296_cov_4.121076_g17539_i0 | PRJNA1111077 | 17760 | 296 | 4.121076 | 12.19838496 | Xenopus laevis | 8355 | Chordata | Chordata | 150 | 2.0699999999999998e-42 | NR | AAI53798.1 | 8355 | g17539 | i0 | 53 | 3.40540540540541 | 168 | 9 | 99.3 | 1 | 1 | 294 | 19 | 186 | AAI53798.1 LOC100126647 protein [Xenopus laevis] | diamond | 1008 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 24440769 | 24440769 | PRJNA1111077_P_NODE_31360_length_249_cov_1.409091_g31139_i0 | PRJNA1111077 | 31360 | 249 | 1.409091 | 3.50863659 | Oikopleura dioica | 34765 | Chordata | Chordata | 126 | 2.33e-34 | NR | CBY12761.1 | 34765 | g31139 | i0 | 75.3 | 7.80722891566265 | 81 | 20 | 97.6 | 0 | 247 | 5 | 98 | 178 | CBY12761.1 unnamed protein product [Oikopleura dioica] | diamond | 1944 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Appendicularia | Copelata | Oikopleuridae | Oikopleura | Oikopleura dioica | |
| 26783110 | 26783110 | PRJNA1111077_P_NODE_26221_length_265_cov_2.635417_g26000_i0 | PRJNA1111077 | 26221 | 265 | 2.635417 | 6.98385505 | Orycteropus afer afer | 1230840 | Chordata | Chordata | 45.8 | 0.00394 | NR | XP_042639078.1 | 1230840 | g26000 | i0 | 56.3 | 0.362264150943396 | 32 | 14 | 36.2 | 0 | 2 | 97 | 244 | 275 | XP_042639078.1 zinc finger protein interacting with ribonucleoprotein K-like, partial [Orycteropus afer afer] | diamond | 96 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Tubulidentata | Orycteropodidae | Orycteropus | Orycteropus afer | |
| 27194065 | 27194065 | PRJNA1111077_P_NODE_16422_length_308_cov_1.714894_g16201_i0 | PRJNA1111077 | 16422 | 308 | 1.714894 | 5.28187352 | Microcaecilia unicolor | 1415580 | Chordata | Chordata | 43.1 | 0.0352 | NR | XP_030071224.1 | 1415580 | g16201 | i0 | 32.9 | 0.827922077922078 | 85 | 54 | 82.8 | 2 | 51 | 305 | 39 | 120 | XP_030071224.1 apoptosis regulatory protein Siva [Microcaecilia unicolor] | diamond | 255 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Gymnophiona | Siphonopidae | Microcaecilia | Microcaecilia unicolor | |
| 27375455 | 27375455 | PRJNA1111077_P_NODE_15603_length_310_cov_2.894515_g15382_i0 | PRJNA1111077 | 15603 | 310 | 2.894515 | 8.9729965 | root | 1 | Root_unresolved | Root_unresolved | 45.1 | 0.0117 | NR | XP_041417307.1 | 8355 | g15382 | i0 | 40.8 | 4.8 | 49 | 29 | 47.4 | 0 | 148 | 2 | 250 | 298 | XP_041417307.1 alpha-(1,3)-fucosyltransferase 10 isoform X2 [Xenopus laevis] | diamond | 1488 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 27605043 | 27605043 | PRJNA1111077_P_NODE_8104_length_410_cov_2.652819_g7883_i0 | PRJNA1111077 | 8104 | 410 | 2.652819 | 10.8765579 | Microtus ochrogaster | 79684 | Chordata | Chordata | 98.2 | 4.46e-22 | NR | KAH0514278.1 | 79684 | g7883 | i0 | 51 | 0.731707317073171 | 100 | 31 | 60 | 1 | 410 | 165 | 119 | 218 | KAH0514278.1 60S ribosomal protein L10a [Microtus ochrogaster] | diamond | 300 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Microtus | Microtus ochrogaster | |
| 28606435 | 28606435 | PRJNA1111077_P_NODE_29707_length_252_cov_1.720670_g29486_i0 | PRJNA1111077 | 29707 | 252 | 1.72067 | 4.3360884 | Opisthokonta | 33154 | Chordata | Chordata | 96.7 | 1.18e-22 | NR | MBZ3885739.1 | 30640 | g29486 | i0 | 60.5 | 76.6904761904762 | 76 | 29 | 89.3 | 1 | 251 | 27 | 120 | 195 | MBZ3885739.1 40S ribosomal protein S2 [Sciurus carolinensis] | diamond | 19326 | 97.1 | 0.995880535530381 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Sciurus | Sciurus carolinensis | |
| 28646913 | 28646913 | PRJNA1111077_P_NODE_22947_length_277_cov_1.509804_g22726_i0 | PRJNA1111077 | 22947 | 277 | 1.509804 | 4.18215708 | Polypterus senegalus | 55291 | Chordata | Chordata | 86.3 | 1.18e-17 | NR | KAG2460242.1 | 55291 | g22726 | i0 | 54.1 | 27.2490974729242 | 74 | 33 | 79.1 | 1 | 229 | 11 | 234 | 307 | KAG2460242.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 7548 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 28867786 | 28867786 | PRJNA1111077_P_NODE_21728_length_281_cov_1.562500_g21507_i0 | PRJNA1111077 | 21728 | 281 | 1.5625 | 4.390625 | Rangifer tarandus platyrhynchus | 3082113 | Chordata | Chordata | 67 | 1.53e-10 | NR | CAI9166020.1 | 3082113 | g21507 | i0 | 79.2 | 0.512455516014235 | 48 | 10 | 51.2 | 0 | 276 | 133 | 96 | 143 | CAI9166020.1 unnamed protein product [Rangifer tarandus platyrhynchus] | diamond | 144 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Rangifer | Rangifer tarandus | |
| 29048660 | 29048660 | PRJNA1111077_P_NODE_20108_length_286_cov_2.619718_g19887_i0 | PRJNA1111077 | 20108 | 286 | 2.619718 | 7.49239348 | Metazoa | 33208 | Chordata | Chordata | 63.5 | 1.76e-9 | NR | XP_039265297.1 | 7725 | g19887 | i0 | 48.3 | 5.03496503496504 | 87 | 36 | 91.3 | 2 | 286 | 26 | 175 | 252 | XP_039265297.1 40S ribosomal protein S3a-like [Styela clava] | diamond | 1440 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 29720067 | 29720067 | PRJNA1111077_P_NODE_28510_length_257_cov_1.434783_g28289_i0 | PRJNA1111077 | 28510 | 257 | 1.434783 | 3.68739231 | Neotoma lepida | 56216 | Chordata | Chordata | 48.1 | 5.61e-4 | NR | OBS79006.1 | 56216 | g28289 | i0 | 51.1 | 0.54863813229572 | 47 | 23 | 54.9 | 0 | 60 | 200 | 317 | 363 | OBS79006.1 hypothetical protein A6R68_18616 [Neotoma lepida] | diamond | 141 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Neotoma | Neotoma lepida | |
| 30225706 | 30225706 | PRJNA1111077_P_NODE_38252_length_215_cov_4.267606_g38031_i0 | PRJNA1111077 | 38252 | 215 | 4.267606 | 9.1753529 | Staurois parvus | 386267 | Chordata | Chordata | 60.5 | 8.2e-10 | NR | CAI9618505.1 | 386267 | g38031 | i0 | 56.5 | 0.641860465116279 | 46 | 20 | 64.2 | 0 | 3 | 140 | 6 | 51 | CAI9618505.1 unnamed protein product, partial [Staurois parvus] | diamond | 138 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 30415656 | 30415656 | PRJNA1111077_P_NODE_35453_length_243_cov_0.905882_g35232_i0 | PRJNA1111077 | 35453 | 243 | 0.905882 | 2.20129326 | Equus przewalskii | 9798 | Chordata | Chordata | 77.4 | 2.29e-14 | NR | XP_070443790.1 | 9798 | g35232 | i0 | 50 | 1.97530864197531 | 80 | 40 | 98.8 | 0 | 3 | 242 | 735 | 814 | XP_070443790.1 uncharacterized protein [Equus przewalskii] | diamond | 480 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Perissodactyla | Equidae | Equus | Equus przewalskii | |
| 30731224 | 30731224 | PRJNA1111077_P_NODE_30274_length_251_cov_0.865169_g30053_i0 | PRJNA1111077 | 30274 | 251 | 0.865169 | 2.17157419 | Nyctereutes procyonoides | 34880 | Chordata | Chordata | 45.1 | 0.00401 | NR | CAD7686784.1 | 34880 | g30053 | i0 | 50 | 0.430278884462151 | 36 | 18 | 43 | 0 | 15 | 122 | 129 | 164 | CAD7686784.1 unnamed protein product [Nyctereutes procyonoides] | diamond | 108 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Nyctereutes | Nyctereutes procyonoides | |
| 30975405 | 30975405 | PRJNA1111077_P_NODE_36034_length_242_cov_0.911243_g35813_i0 | PRJNA1111077 | 36034 | 242 | 0.911243 | 2.20520806 | Opisthokonta | 33154 | Chordata | Chordata | 99.4 | 4.5100000000000005e-22 | NR | CAM2104170.1 | 8467 | g35813 | i0 | 53.8 | 9.89256198347107 | 80 | 37 | 99.2 | 0 | 240 | 1 | 1760 | 1839 | CAM2104170.1 unnamed protein product [Caretta caretta] | diamond | 2394 | 100 | 0.994 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Caretta | Caretta caretta | ||
| 31204758 | 31204758 | PRJNA1111077_P_NODE_30135_length_251_cov_0.865169_g29914_i0 | PRJNA1111077 | 30135 | 251 | 0.865169 | 2.17157419 | Ictidomys tridecemlineatus | 43179 | Chordata | Chordata | 44.7 | 0.00423 | NR | KAG3288512.1 | 43179 | g29914 | i0 | 81.8 | 0.657370517928287 | 22 | 4 | 26.3 | 0 | 2 | 67 | 10 | 31 | KAG3288512.1 hypothetical protein H1C71_024518, partial [Ictidomys tridecemlineatus] | diamond | 165 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Ictidomys | Ictidomys tridecemlineatus | |
| 31363497 | 31363497 | PRJNA1111077_P_NODE_34936_length_244_cov_0.900585_g34715_i0 | PRJNA1111077 | 34936 | 244 | 0.900585 | 2.1974274 | Branchiostoma floridae | 7739 | Chordata | Chordata | 104 | 4.059999999999999e-24 | NR | XP_035673863.1 | 7739 | g34715 | i0 | 58.8 | 0.983606557377049 | 80 | 33 | 98.4 | 0 | 241 | 2 | 352 | 431 | XP_035673863.1 protein dcd1A-like [Branchiostoma floridae] | diamond | 240 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 31702502 | 31702502 | PRJNA1111077_P_NODE_18597_length_292_cov_1.319635_g18376_i0 | PRJNA1111077 | 18597 | 292 | 1.319635 | 3.8533342 | root | 1 | Root_unresolved | Root_unresolved | 206 | 2.04e-61 | NR | XP_030110853.2 | 10090 | g18376 | i0 | 97.9 | 15.9246575342466 | 97 | 2 | 99.7 | 0 | 291 | 1 | 205 | 301 | XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus] | diamond | 4650 | 207 | 0.995169082125604 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 31711284 | 31711284 | PRJNA1111077_P_NODE_20297_length_286_cov_1.267606_g20076_i0 | PRJNA1111077 | 20297 | 286 | 1.267606 | 3.62535316 | Xenopus laevis | 8355 | Chordata | Chordata | 125 | 2.15e-31 | NR | XP_041433304.1 | 8355 | g20076 | i0 | 59.1 | 1.95104895104895 | 93 | 38 | 97.6 | 0 | 4 | 282 | 369 | 461 | XP_041433304.1 uncharacterized protein LOC121398305 [Xenopus laevis] | diamond | 558 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 31742778 | 31742778 | PRJNA1111077_P_NODE_33317_length_246_cov_1.485549_g33096_i0 | PRJNA1111077 | 33317 | 246 | 1.485549 | 3.65445054 | Willisornis vidua | 1566151 | Chordata | Chordata | 75.5 | 1.12e-13 | NR | KAJ7425621.1 | 1566151 | g33096 | i0 | 48.8 | 2.92682926829268 | 80 | 40 | 97.6 | 1 | 6 | 245 | 441 | 519 | KAJ7425621.1 Intraflagellar transport protein 80 like protein [Willisornis vidua] | diamond | 720 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Thamnophilidae | Willisornis | Willisornis vidua | |
| 31996030 | 31996030 | PRJNA1111077_P_NODE_24558_length_271_cov_2.681818_g24337_i0 | PRJNA1111077 | 24558 | 271 | 2.681818 | 7.26772678 | Eschrichtius robustus | 9764 | Chordata | Chordata | 71.2 | 4.75e-12 | NR | KAJ8777472.1 | 9764 | g24337 | i0 | 60.9 | 0.763837638376384 | 69 | 14 | 72 | 2 | 269 | 75 | 125 | 184 | KAJ8777472.1 hypothetical protein J1605_014475 [Eschrichtius robustus] | diamond | 207 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Eschrichtiidae | Eschrichtius | Eschrichtius robustus | |
| 32090942 | 32090942 | PRJNA1111077_P_NODE_22678_length_278_cov_1.502439_g22457_i0 | PRJNA1111077 | 22678 | 278 | 1.502439 | 4.17678042 | Castor canadensis | 51338 | Chordata | Chordata | 112 | 3.14e-29 | NR | XP_020010722.1 | 51338 | g22457 | i0 | 66.3 | 15.8848920863309 | 92 | 31 | 99.3 | 0 | 1 | 276 | 26 | 117 | XP_020010722.1 calmodulin-alpha-like [Castor canadensis] | diamond | 4416 | 113 | 0.991150442477876 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Castoridae | Castor | Castor canadensis | |
| 32122736 | 32122736 | PRJNA1111077_P_NODE_24678_length_271_cov_1.555556_g24457_i0 | PRJNA1111077 | 24678 | 271 | 1.555556 | 4.21555676 | Mus musculus | 10090 | Chordata | Chordata | 43.1 | 0.0379 | NR | NP_598754.2 | 10090 | g24457 | i0 | 40 | 0.608856088560886 | 55 | 33 | 60.9 | 0 | 252 | 88 | 2 | 56 | NP_598754.2 periodic tryptophan protein 1 homolog [Mus musculus] | diamond | 165 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 32880338 | 32880338 | PRJNA1111077_P_NODE_32600_length_247_cov_1.770115_g32379_i0 | PRJNA1111077 | 32600 | 247 | 1.770115 | 4.37218405 | Marmota marmota marmota | 9994 | Chordata | Chordata | 43.5 | 0.0125 | NR | XP_048646664.1 | 9994 | g32379 | i0 | 51.3 | 0.473684210526316 | 39 | 15 | 47.4 | 1 | 128 | 244 | 17 | 51 | XP_048646664.1 trafficking protein particle complex subunit 6A isoform X2 [Marmota marmota marmota] | diamond | 117 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Marmota | Marmota marmota |
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);;