contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA772154" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26673128 | 26673128 | PRJNA772154_P_NODE_20261_length_247_cov_0.896552_g20076_i0 | PRJNA772154 | 20261 | 247 | 0.896552 | 2.21448344 | Crocuta crocuta | 9678 | Chordata | Chordata | 42 | 0.0262 | NR | KAF0882019.1 | 9678 | g20076 | i0 | 34.2 | 0.959514170040486 | 79 | 45 | 87.4 | 2 | 247 | 32 | 39 | 117 | KAF0882019.1 LORF2 protein, partial [Crocuta crocuta] | diamond | 237 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Hyaenidae | Crocuta | Crocuta crocuta | |
| 26831841 | 26831841 | PRJNA772154_P_NODE_18561_length_251_cov_0.876404_g18376_i0 | PRJNA772154 | 18561 | 251 | 0.876404 | 2.19977404 | Staurois parvus | 386267 | Chordata | Chordata | 48.5 | 1.33e-5 | NR | CAI9578589.1 | 386267 | g18376 | i0 | 67.9 | 0.669322709163347 | 28 | 9 | 33.5 | 0 | 121 | 38 | 4 | 31 | CAI9578589.1 unnamed protein product [Staurois parvus] | diamond | 168 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 27053371 | 27053371 | PRJNA772154_P_NODE_8762_length_392_cov_0.978056_g8577_i0 | PRJNA772154 | 8762 | 392 | 0.978056 | 3.83397952 | Apodemus speciosus | 105296 | Chordata | Chordata | 47.4 | 0.0041 | NR | GAB1293120.1 | 105296 | g8577 | i0 | 80 | 0.229591836734694 | 30 | 5 | 22.2 | 1 | 122 | 36 | 248 | 277 | GAB1293120.1 Fibrinogen-like protein 1 [Apodemus speciosus] | diamond | 90 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Apodemus | Apodemus speciosus | |
| 27337877 | 27337877 | PRJNA772154_P_NODE_19863_length_248_cov_0.891429_g19678_i0 | PRJNA772154 | 19863 | 248 | 0.891429 | 2.21074392 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 127 | 4.32e-34 | NR | XP_028659365.1 | 27687 | g19678 | i0 | 98.3 | 5.63709677419355 | 58 | 1 | 70.2 | 0 | 176 | 3 | 23 | 80 | XP_028659365.1 acyl-protein thioesterase 1 isoform X1 [Erpetoichthys calabaricus] | diamond | 1398 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 27779972 | 27779972 | PRJNA772154_P_NODE_22024_length_243_cov_2.735294_g21839_i0 | PRJNA772154 | 22024 | 243 | 2.735294 | 6.64676442 | Bombina bombina | 8345 | Chordata | Chordata | 60.1 | 2.19e-8 | NR | XP_053556129.1 | 8345 | g21839 | i0 | 46.6 | 4.60493827160494 | 73 | 39 | 90.1 | 0 | 3 | 221 | 73 | 145 | XP_053556129.1 uncharacterized protein LOC128647369 [Bombina bombina] | diamond | 1119 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bombinatoridae | Bombina | Bombina bombina | |
| 27811637 | 27811637 | PRJNA772154_P_NODE_7584_length_432_cov_0.869081_g7399_i0 | PRJNA772154 | 7584 | 432 | 0.869081 | 3.75442992 | Lynx pardinus | 191816 | Chordata | Chordata | 66.6 | 1.71e-11 | NR | VFV26017.1 | 191816 | g7399 | i0 | 58.6 | 0.986111111111111 | 58 | 19 | 36.8 | 1 | 419 | 261 | 12 | 69 | VFV26017.1 60s ribosomal protein l21-like, partial [Lynx pardinus] | diamond | 426 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Felidae | Lynx | Lynx pardinus | |
| 28348151 | 28348151 | PRJNA772154_P_NODE_4506_length_619_cov_1.851648_g4326_i0 | PRJNA772154 | 4506 | 619 | 1.851648 | 11.46170112 | Staurois parvus | 386267 | Chordata | Chordata | 165 | 1.5399999999999998e-48 | NR | CAI9534117.1 | 386267 | g4326 | i0 | 76.1 | 0.445880452342488 | 92 | 22 | 44.6 | 0 | 537 | 262 | 14 | 105 | CAI9534117.1 unnamed protein product [Staurois parvus] | diamond | 276 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 28506059 | 28506059 | PRJNA772154_P_NODE_21007_length_246_cov_0.901734_g20822_i0 | PRJNA772154 | 21007 | 246 | 0.901734 | 2.21826564 | Polypterus senegalus | 55291 | Chordata | Chordata | 59.3 | 4.95e-8 | NR | KAG2460242.1 | 55291 | g20822 | i0 | 52.4 | 6.81707317073171 | 63 | 29 | 76.8 | 1 | 190 | 2 | 173 | 234 | KAG2460242.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 1677 | 59.7 | 0.993299832495812 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 29579310 | 29579310 | PRJNA772154_P_NODE_21230_length_245_cov_0.906977_g21045_i0 | PRJNA772154 | 21230 | 245 | 0.906977 | 2.22209365 | Aquarana catesbeiana | 8400 | Chordata | Chordata | 46.6 | 1.28e-4 | NR | PIO28982.1 | 8400 | g21045 | i0 | 66.7 | 0.36734693877551 | 30 | 10 | 36.7 | 0 | 98 | 187 | 13 | 42 | PIO28982.1 hypothetical protein AB205_0072350 [Aquarana catesbeiana] | diamond | 90 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Aquarana | Aquarana catesbeiana | |
| 29737187 | 29737187 | PRJNA772154_P_NODE_21070_length_246_cov_0.861272_g20885_i0 | PRJNA772154 | 21070 | 246 | 0.861272 | 2.11872912 | Staurois parvus | 386267 | Chordata | Chordata | 67.8 | 3.99e-12 | NR | CAI9614493.1 | 386267 | g20885 | i0 | 63 | 0.658536585365854 | 54 | 16 | 65.9 | 1 | 52 | 213 | 70 | 119 | CAI9614493.1 unnamed protein product, partial [Staurois parvus] | diamond | 162 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 29990140 | 29990140 | PRJNA772154_P_NODE_21771_length_244_cov_0.912281_g21586_i0 | PRJNA772154 | 21771 | 244 | 0.912281 | 2.22596564 | Meriones unguiculatus | 10047 | Chordata | Chordata | 115 | 5.27e-28 | NR | XP_060232816.1 | 10047 | g21586 | i0 | 68.9 | 2.79098360655738 | 74 | 23 | 91 | 0 | 242 | 21 | 301 | 374 | XP_060232816.1 uncharacterized protein LOC132651748 [Meriones unguiculatus] | diamond | 681 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Meriones | Meriones unguiculatus | |
| 30084752 | 30084752 | PRJNA772154_P_NODE_18272_length_252_cov_0.871508_g18087_i0 | PRJNA772154 | 18272 | 252 | 0.871508 | 2.19620016 | Rhinatrema bivittatum | 194408 | Chordata | Chordata | 107 | 5.98e-25 | NR | XP_029429446.1 | 194408 | g18087 | i0 | 69.9 | 24.702380952381 | 83 | 25 | 98.8 | 0 | 1 | 249 | 390 | 472 | XP_029429446.1 dihydrolipoyllysine-residue acetyltransferase component of pyruvate dehydrogenase complex, mitochondrial isoform X2 [Rhinatrema bivittatum] | diamond | 6225 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Gymnophiona | Rhinatrematidae | Rhinatrema | Rhinatrema bivittatum | |
| 30242977 | 30242977 | PRJNA772154_P_NODE_19492_length_249_cov_0.886364_g19307_i0 | PRJNA772154 | 19492 | 249 | 0.886364 | 2.20704636 | Aquarana catesbeiana | 8400 | Chordata | Chordata | 150 | 1.01e-44 | NR | PIO26410.1 | 8400 | g19307 | i0 | 93.6 | 0.939759036144578 | 78 | 5 | 94 | 0 | 235 | 2 | 1 | 78 | PIO26410.1 hypothetical protein AB205_0071520 [Aquarana catesbeiana] | diamond | 234 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Aquarana | Aquarana catesbeiana | |
| 30338116 | 30338116 | PRJNA772154_P_NODE_12372_length_316_cov_0.967078_g12187_i0 | PRJNA772154 | 12372 | 316 | 0.967078 | 3.05596648 | Bombina bombina | 8345 | Chordata | Chordata | 82 | 6.65e-17 | NR | XP_053549181.1 | 8345 | g12187 | i0 | 46.5 | 2.78164556962025 | 99 | 53 | 94 | 0 | 20 | 316 | 80 | 178 | XP_053549181.1 uncharacterized protein LOC128640785 [Bombina bombina] | diamond | 879 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bombinatoridae | Bombina | Bombina bombina | |
| 30938129 | 30938129 | PRJNA772154_P_NODE_17654_length_253_cov_0.866667_g17469_i0 | PRJNA772154 | 17654 | 253 | 0.866667 | 2.19266751 | Aquarana catesbeiana | 8400 | Chordata | Chordata | 53.5 | 6.39e-6 | NR | PIO38716.1 | 8400 | g17469 | i0 | 69.7 | 0.391304347826087 | 33 | 10 | 39.1 | 0 | 251 | 153 | 189 | 221 | PIO38716.1 hypothetical protein AB205_0103790, partial [Aquarana catesbeiana] | diamond | 99 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Aquarana | Aquarana catesbeiana | |
| 31380644 | 31380644 | PRJNA772154_P_NODE_19436_length_249_cov_0.886364_g19251_i0 | PRJNA772154 | 19436 | 249 | 0.886364 | 2.20704636 | Meles meles | 9662 | Chordata | Chordata | 52 | 2.34e-5 | NR | XP_045881491.1 | 9662 | g19251 | i0 | 40.8 | 3.36144578313253 | 76 | 34 | 78.3 | 2 | 198 | 4 | 567 | 642 | XP_045881491.1 LOW QUALITY PROTEIN: uncharacterized protein LOC123954405 [Meles meles] | diamond | 837 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Mustelidae | Meles | Meles meles | |
| 31706335 | 31706335 | PRJNA772154_P_NODE_22837_length_242_cov_0.923077_g22652_i0 | PRJNA772154 | 22837 | 242 | 0.923077 | 2.23384634 | Chondrichthyes | 7777 | Chordata | Chordata | 160 | 1.8999999999999997e-48 | NR | AAN73378.1 | 7830 | g22652 | i0 | 96.3 | 66.3842975206612 | 80 | 3 | 99.2 | 0 | 3 | 242 | 22 | 101 | AAN73378.1 ribosomal protein L8, partial [Scyliorhinus canicula] | diamond | 16065 | 161 | 0.993788819875776 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Carcharhiniformes | Scyliorhinidae | Scyliorhinus | Scyliorhinus canicula | |
| 31728321 | 31728321 | PRJNA772154_P_NODE_18757_length_250_cov_2.254237_g18572_i0 | PRJNA772154 | 18757 | 250 | 2.254237 | 5.6355925 | Rana temporaria | 8407 | Chordata | Chordata | 62 | 3.47e-9 | NR | XP_040216140.1 | 8407 | g18572 | i0 | 52.6 | 0.912 | 76 | 33 | 87.6 | 1 | 3 | 221 | 173 | 248 | XP_040216140.1 ranaspumin-like [Rana temporaria] | diamond | 228 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Rana | Rana temporaria | |
| 31760000 | 31760000 | PRJNA772154_P_NODE_15817_length_271_cov_1.176768_g15632_i0 | PRJNA772154 | 15817 | 271 | 1.176768 | 3.18904128 | Aquarana catesbeiana | 8400 | Chordata | Chordata | 151 | 1.85e-44 | NR | PIO28092.1 | 8400 | g15632 | i0 | 83.1 | 0.985239852398524 | 89 | 15 | 98.5 | 0 | 271 | 5 | 46 | 134 | PIO28092.1 hypothetical protein AB205_0067730 [Aquarana catesbeiana] | diamond | 267 | 151 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Aquarana | Aquarana catesbeiana | |
| 31791481 | 31791481 | PRJNA772154_P_NODE_18077_length_252_cov_0.871508_g17892_i0 | PRJNA772154 | 18077 | 252 | 0.871508 | 2.19620016 | Cricetulus griseus | 10029 | Chordata | Chordata | 57.4 | 3.04e-7 | NR | ERE67393.1 | 10029 | g17892 | i0 | 84 | 0.595238095238095 | 25 | 4 | 29.8 | 0 | 178 | 252 | 1557 | 1581 | ERE67393.1 cytosolic carboxypeptidase-like protein 5 [Cricetulus griseus] | diamond | 150 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Cricetulus | Cricetulus griseus | |
| 32487901 | 32487901 | PRJNA772154_P_NODE_12299_length_317_cov_1.598361_g12114_i0 | PRJNA772154 | 12299 | 317 | 1.598361 | 5.06680437 | Myodes glareolus | 447135 | Chordata | Chordata | 48.9 | 6.16e-4 | NR | KAK7805727.1 | 447135 | g12114 | i0 | 43.1 | 0.615141955835962 | 65 | 36 | 61.5 | 1 | 232 | 38 | 437 | 500 | KAK7805727.1 hypothetical protein U0070_010948, partial [Myodes glareolus] | diamond | 195 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Myodes | Myodes glareolus | |
| 32551325 | 32551325 | PRJNA772154_P_NODE_7219_length_448_cov_0.768000_g7034_i0 | PRJNA772154 | 7219 | 448 | 0.768 | 3.44064 | Ictidomys tridecemlineatus | 43179 | Chordata | Chordata | 50.1 | 7e-4 | NR | KAG3262610.1 | 43179 | g7034 | i0 | 76.7 | 0.930803571428571 | 30 | 7 | 20.1 | 0 | 50 | 139 | 242 | 271 | KAG3262610.1 DRG1-like [Ictidomys tridecemlineatus] | diamond | 417 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Ictidomys | Ictidomys tridecemlineatus | |
| 32771403 | 32771403 | PRJNA772154_P_NODE_15320_length_277_cov_1.147059_g15135_i0 | PRJNA772154 | 15320 | 277 | 1.147059 | 3.17735343 | Rattus norvegicus | 10116 | Chordata | Chordata | 93.2 | 2.12e-22 | NR | EDL77384.1 | 10116 | g15135 | i0 | 89.6 | 0.51985559566787 | 48 | 5 | 52 | 0 | 1 | 144 | 28 | 75 | EDL77384.1 similar to RIKEN cDNA 1300017J02, isoform CRA_a [Rattus norvegicus] | diamond | 144 | 93.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus |
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);;