contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA1164198" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5415015 | 5415015 | PRJNA1164198_P_NODE_13465_length_337_cov_2.931818_g13196_i0 | PRJNA1164198 | 13465 | 337 | 2.931818 | 9.88022666 | Chordata | 7711 | Chordata | Chordata | 84.7 | 5.45e-18 | NR | KAB0345139.1 | 9888 | g13196 | i0 | 53.8 | 8.76854599406528 | 93 | 33 | 73.9 | 1 | 8 | 256 | 31 | 123 | KAB0345139.1 hypothetical protein FD754_022065 [Muntiacus muntjak] | diamond | 2955 | 85.5 | 0.990643274853801 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Muntiacus | Muntiacus muntjak | |
| 6689942 | 6689942 | PRJNA1164198_P_NODE_30426_length_243_cov_0.917647_g30157_i0 | PRJNA1164198 | 30426 | 243 | 0.917647 | 2.22988221 | Chordata | 7711 | Chordata | Chordata | 148 | 2.31e-40 | NR | KAG2455313.1 | 55291 | g30157 | i0 | 81.5 | 86 | 81 | 15 | 100 | 0 | 1 | 243 | 182 | 262 | KAG2455313.1 GBLP protein, partial [Polypterus senegalus] | diamond | 20898 | 149 | 0.993288590604027 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 21988660 | 21988660 | PRJNA1164198_P_NODE_10478_length_384_cov_2.408360_g10210_i0 | PRJNA1164198 | 10478 | 384 | 2.40836 | 9.2481024 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 180 | 4.3899999999999996e-54 | NR | CAM2101742.1 | 8467 | g10210 | i0 | 68.8 | 91.3828125 | 125 | 38 | 96.9 | 1 | 11 | 382 | 65 | 189 | CAM2101742.1 unnamed protein product [Caretta caretta] | diamond | 35091 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Caretta | Caretta caretta | ||
| 21988755 | 21988755 | PRJNA1164198_P_NODE_7098_length_471_cov_2.472362_g6837_i0 | PRJNA1164198 | 7098 | 471 | 2.472362 | 11.64482502 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 192 | 2.72e-59 | NR | KAK9406484.1 | 8729 | g6837 | i0 | 66.4 | 84.3566878980892 | 146 | 45 | 91.1 | 2 | 20 | 448 | 38 | 182 | KAK9406484.1 hypothetical protein NXF25_005258 [Crotalus adamanteus] | diamond | 39732 | 193 | 0.994818652849741 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Viperidae | Crotalus | Crotalus adamanteus | |
| 26977098 | 26977098 | PRJNA1164198_P_NODE_10042_length_392_cov_4.213166_g9775_i0 | PRJNA1164198 | 10042 | 392 | 4.213166 | 16.51561072 | Branchiostoma lanceolatum | 7740 | Chordata | Chordata | 97.4 | 3.919999999999999e-23 | NR | XP_066285211.1 | 7740 | g9775 | i0 | 41.6 | 0.956632653061224 | 125 | 71 | 94.1 | 1 | 2 | 370 | 2 | 126 | XP_066285211.1 profilin-1A-like [Branchiostoma lanceolatum] | diamond | 375 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 26996238 | 26996238 | PRJNA1164198_P_NODE_13162_length_341_cov_1.746269_g12893_i0 | PRJNA1164198 | 13162 | 341 | 1.746269 | 5.95477729 | Metazoa | 33208 | Chordata | Chordata | 82 | 1.64e-17 | NR | XP_005987634.1 | 7897 | g12893 | i0 | 50.6 | 3.34310850439883 | 77 | 38 | 67.7 | 0 | 329 | 99 | 1 | 77 | XP_005987634.1 60S acidic ribosomal protein P2 [Latimeria chalumnae] | diamond | 1140 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Coelacanthiformes | Coelacanthidae | Latimeria | Latimeria chalumnae | ||
| 27470659 | 27470659 | PRJNA1164198_P_NODE_18063_length_291_cov_1.431193_g17794_i0 | PRJNA1164198 | 18063 | 291 | 1.431193 | 4.16477163 | Mammalia | 40674 | Chordata | Chordata | 102 | 7.02e-25 | NR | XP_037679824.1 | 27675 | g17794 | i0 | 60.9 | 14.0412371134021 | 92 | 35 | 94.8 | 1 | 14 | 289 | 61 | 151 | XP_037679824.1 40S ribosomal protein S15 [Choloepus didactylus] | diamond | 4086 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Pilosa | Megalonychidae | Choloepus | Choloepus didactylus | |
| 27502307 | 27502307 | PRJNA1164198_P_NODE_22503_length_262_cov_1.142857_g22234_i0 | PRJNA1164198 | 22503 | 262 | 1.142857 | 2.99428534 | Chordata | 7711 | Chordata | Chordata | 98.6 | 7.99e-22 | NR | XP_069478496.1 | 8296 | g22234 | i0 | 48.3 | 12.9618320610687 | 87 | 45 | 99.6 | 0 | 261 | 1 | 374 | 460 | XP_069478496.1 adenylyl cyclase-associated protein 1 [Ambystoma mexicanum] | diamond | 3396 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Ambystomatidae | Ambystoma | Ambystoma mexicanum | |
| 28114185 | 28114185 | PRJNA1164198_P_NODE_21905_length_266_cov_0.808290_g21636_i0 | PRJNA1164198 | 21905 | 266 | 0.80829 | 2.1500514 | Buphagus erythrorhynchus | 245048 | Chordata | Chordata | 46.6 | 1.27e-4 | NR | NXU06048.1 | 245048 | g21636 | i0 | 47.4 | 2.18796992481203 | 38 | 20 | 42.9 | 0 | 9 | 122 | 11 | 48 | NXU06048.1 ZBT17 protein [Buphagus erythrorhynchus] | diamond | 582 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Sturnidae | Buphagus | Buphagus erythrorhynchus | |
| 28828066 | 28828066 | PRJNA1164198_P_NODE_2808_length_745_cov_2.127976_g2595_i0 | PRJNA1164198 | 2808 | 745 | 2.127976 | 15.8534212 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 271 | 6.479999999999997e-88 | NR | AAZ38987.1 | 8668 | g2595 | i0 | 56.6 | 54.1731543624161 | 244 | 93 | 97 | 2 | 737 | 15 | 2 | 235 | AAZ38987.1 40S ribosomal protein S2, partial [Oxyuranus scutellatus] | diamond | 40359 | 273 | 0.992673992673993 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Elapidae | Oxyuranus | Oxyuranus scutellatus | |
| 28935331 | 28935331 | PRJNA1164198_P_NODE_27688_length_247_cov_0.896552_g27419_i0 | PRJNA1164198 | 27688 | 247 | 0.896552 | 2.21448344 | Hyperolius riggenbachi | 752182 | Chordata | Chordata | 65.9 | 2.78e-10 | NR | XP_068115012.1 | 752182 | g27419 | i0 | 56.6 | 1.28744939271255 | 53 | 23 | 64.4 | 0 | 230 | 72 | 55 | 107 | XP_068115012.1 guanylate cyclase 2G-like [Hyperolius riggenbachi] | diamond | 318 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Hyperoliidae | Hyperolius | Hyperolius riggenbachi | |
| 29049347 | 29049347 | PRJNA1164198_P_NODE_26508_length_249_cov_0.886364_g26239_i0 | PRJNA1164198 | 26508 | 249 | 0.886364 | 2.20704636 | Bufonidae | 8382 | Chordata | Chordata | 89.7 | 1.14e-18 | NR | XP_044147138.1 | 30331 | g26239 | i0 | 51.9 | 8.68674698795181 | 81 | 39 | 97.6 | 0 | 3 | 245 | 215 | 295 | XP_044147138.1 uncharacterized protein LOC122935434 [Bufo gargarizans] | diamond | 2163 | 90.1 | 0.995560488346282 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufo | Bufo gargarizans | |
| 29365068 | 29365068 | PRJNA1164198_P_NODE_26109_length_250_cov_0.881356_g25840_i0 | PRJNA1164198 | 26109 | 250 | 0.881356 | 2.20339 | root | 1 | Root_unresolved | Root_unresolved | 55.1 | 9.71e-7 | NR | XP_070318000.1 | 9874 | g25840 | i0 | 57.4 | 3.024 | 54 | 22 | 63.6 | 1 | 248 | 90 | 44 | 97 | XP_070318000.1 LINE-1 type transposase domain-containing protein 1 [Odocoileus virginianus] | diamond | 756 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Odocoileus | Odocoileus virginianus | |
| 29471707 | 29471707 | PRJNA1164198_P_NODE_28490_length_246_cov_0.901734_g28221_i0 | PRJNA1164198 | 28490 | 246 | 0.901734 | 2.21826564 | Heterodontus francisci | 7792 | Chordata | Chordata | 73.2 | 7.08e-13 | NR | XP_067908860.1 | 7792 | g28221 | i0 | 55.2 | 0.707317073170732 | 58 | 26 | 70.7 | 0 | 226 | 53 | 309 | 366 | XP_067908860.1 ornithine decarboxylase-like [Heterodontus francisci] | diamond | 174 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Heterodontiformes | Heterodontidae | Heterodontus | Heterodontus francisci | |
| 30040450 | 30040450 | PRJNA1164198_P_NODE_17291_length_297_cov_1.602679_g17022_i0 | PRJNA1164198 | 17291 | 297 | 1.602679 | 4.75995663 | Chinchilla lanigera | 34839 | Chordata | Chordata | 43.5 | 0.0366 | NR | XP_013364948.1 | 34839 | g17022 | i0 | 60 | 0.353535353535354 | 35 | 14 | 35.4 | 0 | 184 | 288 | 350 | 384 | XP_013364948.1 PREDICTED: LOW QUALITY PROTEIN: protein DEK [Chinchilla lanigera] | diamond | 105 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Chinchillidae | Chinchilla | Chinchilla lanigera | |
| 30609052 | 30609052 | PRJNA1164198_P_NODE_27093_length_248_cov_0.891429_g26824_i0 | PRJNA1164198 | 27093 | 248 | 0.891429 | 2.21074392 | Alligator mississippiensis | 8496 | Chordata | Chordata | 45.4 | 0.00449 | NR | XP_059586823.1 | 8496 | g26824 | i0 | 58.3 | 0.834677419354839 | 36 | 14 | 42.3 | 1 | 3 | 107 | 59 | 94 | XP_059586823.1 espin-like protein isoform X3 [Alligator mississippiensis] | diamond | 207 | 45.8 | 0.991266375545852 | Eukaryota | Opisthokonta | Metazoa | Chordata | Crocodylia | Alligatoridae | Alligator | Alligator mississippiensis | ||
| 30767164 | 30767164 | PRJNA1164198_P_NODE_17234_length_298_cov_1.031111_g16965_i0 | PRJNA1164198 | 17234 | 298 | 1.0311110000000001 | 3.07271078 | Hyperolius riggenbachi | 752182 | Chordata | Chordata | 58.9 | 1.48e-7 | NR | XP_068115012.1 | 752182 | g16965 | i0 | 51 | 2.00335570469799 | 51 | 25 | 51.3 | 0 | 158 | 6 | 57 | 107 | XP_068115012.1 guanylate cyclase 2G-like [Hyperolius riggenbachi] | diamond | 597 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Hyperoliidae | Hyperolius | Hyperolius riggenbachi | |
| 30893693 | 30893693 | PRJNA1164198_P_NODE_19734_length_279_cov_1.184466_g19465_i0 | PRJNA1164198 | 19734 | 279 | 1.184466 | 3.30466014 | Eublepharis macularius | 481883 | Chordata | Chordata | 62.8 | 5.2e-9 | NR | XP_054846670.1 | 481883 | g19465 | i0 | 39.4 | 5.34408602150538 | 71 | 43 | 76.3 | 0 | 3 | 215 | 83 | 153 | XP_054846670.1 serine/threonine-protein kinase MRCK gamma isoform X4 [Eublepharis macularius] | diamond | 1491 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Eublepharidae | Eublepharis | Eublepharis macularius | |
| 31196762 | 31196762 | PRJNA1164198_P_NODE_14315_length_327_cov_1.535433_g14046_i0 | PRJNA1164198 | 14315 | 327 | 1.535433 | 5.02086591 | Passeriformes | 9126 | Chordata | Chordata | 106 | 1.17e-26 | NR | XP_016157899.1 | 59894 | g14046 | i0 | 59.1 | 13.6422018348624 | 93 | 38 | 85.3 | 0 | 324 | 46 | 57 | 149 | XP_016157899.1 PREDICTED: 60S ribosomal protein L35 [Ficedula albicollis] | diamond | 4461 | 107 | 0.990654205607477 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Muscicapidae | Ficedula | Ficedula albicollis | |
| 31557646 | 31557646 | PRJNA1164198_P_NODE_30696_length_242_cov_0.923077_g30427_i0 | PRJNA1164198 | 30696 | 242 | 0.923077 | 2.23384634 | Emys orbicularis | 82168 | Chordata | Chordata | 45.4 | 0.00427 | NR | XP_065276831.1 | 82168 | g30427 | i0 | 60.6 | 3.60743801652893 | 33 | 13 | 40.9 | 0 | 105 | 7 | 822 | 854 | XP_065276831.1 LOW QUALITY PROTEIN: uncharacterized protein LOC135892976, partial [Emys orbicularis] | diamond | 873 | 45.8 | 0.991266375545852 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Emydidae | Emys | Emys orbicularis | ||
| 31620628 | 31620628 | PRJNA1164198_P_NODE_21996_length_265_cov_1.447917_g21727_i0 | PRJNA1164198 | 21996 | 265 | 1.447917 | 3.83698005 | Mus musculus | 10090 | Chordata | Chordata | 44.3 | 0.012 | NR | BAC28802.1 | 10090 | g21727 | i0 | 38.9 | 0.815094339622642 | 72 | 42 | 81.5 | 1 | 46 | 261 | 131 | 200 | BAC28802.1 unnamed protein product, partial [Mus musculus] | diamond | 216 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 31841901 | 31841901 | PRJNA1164198_P_NODE_30317_length_243_cov_0.917647_g30048_i0 | PRJNA1164198 | 30317 | 243 | 0.917647 | 2.22988221 | Phacochoerus africanus | 41426 | Chordata | Chordata | 45.8 | 0.00278 | NR | XP_047654103.1 | 41426 | g30048 | i0 | 55 | 0.493827160493827 | 40 | 18 | 49.4 | 0 | 167 | 48 | 175 | 214 | XP_047654103.1 translation initiation factor IF-2-like [Phacochoerus africanus] | diamond | 120 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Phacochoerus | Phacochoerus africanus | |
| 32051222 | 32051222 | PRJNA1164198_P_NODE_24998_length_252_cov_0.871508_g24729_i0 | PRJNA1164198 | 24998 | 252 | 0.871508 | 2.19620016 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47.8 | 7.18e-4 | NR | NP_001072831.1 | 8364 | g24729 | i0 | 58.6 | 2.27380952380952 | 29 | 12 | 34.5 | 0 | 166 | 252 | 40 | 68 | NP_001072831.1 adenine DNA glycosylase [Xenopus tropicalis] | diamond | 573 | 48.1 | 0.993762993762994 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 32853117 | 32853117 | PRJNA1164198_P_NODE_29680_length_244_cov_0.912281_g29411_i0 | PRJNA1164198 | 29680 | 244 | 0.912281 | 2.22596564 | Rana temporaria | 8407 | Chordata | Chordata | 45.1 | 0.00569 | NR | XP_040185054.1 | 8407 | g29411 | i0 | 30.5 | 1.90573770491803 | 82 | 53 | 95.9 | 2 | 240 | 7 | 106 | 187 | XP_040185054.1 5-hydroxytryptamine receptor 3A-like [Rana temporaria] | diamond | 465 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Rana | Rana temporaria |
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);;