contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA703759" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7062664 | 7062664 | PRJNA703759_P_NODE_17586_length_326_cov_1.849802_g17110_i0 | PRJNA703759 | 17586 | 326 | 1.849802 | 6.03035452 | Metazoa | 33208 | Chordata | Chordata | 87.8 | 1.56e-17 | NR | EGV93871.1 | 10029 | g17110 | i0 | 71.4 | 1.50920245398773 | 70 | 20 | 64.4 | 0 | 115 | 324 | 95 | 164 | EGV93871.1 Period circadian protein-like 1 [Cricetulus griseus] | diamond | 492 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Cricetulus | Cricetulus griseus | |
| 26829760 | 26829760 | PRJNA703759_P_NODE_43521_length_247_cov_0.896552_g43045_i0 | PRJNA703759 | 43521 | 247 | 0.896552 | 2.21448344 | Myxine glutinosa | 7769 | Chordata | Chordata | 43.5 | 0.0199 | NR | XP_067966282.1 | 7769 | g43045 | i0 | 47.6 | 0.850202429149798 | 42 | 17 | 44.9 | 1 | 3 | 113 | 77 | 118 | XP_067966282.1 chymotrypsinogen B-like [Myxine glutinosa] | diamond | 210 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 27145574 | 27145574 | PRJNA703759_P_NODE_20362_length_308_cov_0.995745_g19886_i0 | PRJNA703759 | 20362 | 308 | 0.995745 | 3.0668946 | Branchiostoma floridae | 7739 | Chordata | Chordata | 51.2 | 8.69e-5 | NR | XP_035683683.1 | 7739 | g19886 | i0 | 69.7 | 1.28571428571429 | 33 | 10 | 32.1 | 0 | 169 | 267 | 1298 | 1330 | XP_035683683.1 large proline-rich protein BAG6-like isoform X1 [Branchiostoma floridae] | diamond | 396 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 27272468 | 27272468 | PRJNA703759_P_NODE_40383_length_249_cov_0.886364_g39907_i0 | PRJNA703759 | 40383 | 249 | 0.886364 | 2.20704636 | Marmota marmota marmota | 9994 | Chordata | Chordata | 43.1 | 0.0254 | NR | XP_048655345.1 | 9994 | g39907 | i0 | 37.2 | 1.03614457831325 | 86 | 32 | 95.2 | 5 | 9 | 245 | 55 | 125 | XP_048655345.1 LBH domain-containing protein 2 [Marmota marmota marmota] | diamond | 258 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Sciuridae | Marmota | Marmota marmota | |
| 27410272 | 27410272 | PRJNA703759_P_NODE_50463_length_242_cov_0.923077_g49987_i0 | PRJNA703759 | 50463 | 242 | 0.923077 | 2.23384634 | Chordata | 7711 | Chordata | Chordata | 84.3 | 8.32e-17 | NR | XP_061437485.1 | 7753 | g49987 | i0 | 60.8 | 14.095041322314 | 79 | 31 | 97.9 | 0 | 6 | 242 | 272 | 350 | XP_061437485.1 LOW QUALITY PROTEIN: potassium voltage-gated channel subfamily A member 1-like [Lethenteron reissneri] | diamond | 3411 | 84.7 | 0.995277449822904 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lethenteron | Lethenteron reissneri | |
| 27588439 | 27588439 | PRJNA703759_P_NODE_43684_length_247_cov_0.896552_g43208_i0 | PRJNA703759 | 43684 | 247 | 0.896552 | 2.21448344 | Ranitomeya imitator | 111125 | Chordata | Chordata | 44.7 | 0.00794 | NR | XP_069619144.1 | 111125 | g43208 | i0 | 37.3 | 1.21457489878543 | 51 | 30 | 61.9 | 1 | 155 | 3 | 9 | 57 | XP_069619144.1 E3 ubiquitin/ISG15 ligase TRIM25-like [Ranitomeya imitator] | diamond | 300 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 27777928 | 27777928 | PRJNA703759_P_NODE_9704_length_435_cov_0.803867_g9228_i0 | PRJNA703759 | 9704 | 435 | 0.803867 | 3.49682145 | Petromyzon marinus | 7757 | Chordata | Chordata | 110 | 7.240000000000001e-27 | NR | XP_032823695.1 | 7757 | g9228 | i0 | 64.1 | 1.55862068965517 | 78 | 28 | 53.8 | 0 | 434 | 201 | 148 | 225 | XP_032823695.1 phosphoserine phosphatase [Petromyzon marinus] | diamond | 678 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Petromyzon | Petromyzon marinus | |
| 27809538 | 27809538 | PRJNA703759_P_NODE_37864_length_251_cov_0.876404_g37388_i0 | PRJNA703759 | 37864 | 251 | 0.876404 | 2.19977404 | Rousettus aegyptiacus | 9407 | Chordata | Chordata | 43.1 | 0.0122 | NR | KAF6447397.1 | 9407 | g37388 | i0 | 43.4 | 0.908366533864542 | 76 | 29 | 81.3 | 2 | 28 | 231 | 33 | 102 | KAF6447397.1 hypothetical protein HJG63_011859 [Rousettus aegyptiacus] | diamond | 228 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Pteropodidae | Rousettus | Rousettus aegyptiacus | |
| 28061869 | 28061869 | PRJNA703759_P_NODE_50025_length_243_cov_0.858824_g49549_i0 | PRJNA703759 | 50025 | 243 | 0.858824 | 2.08694232 | Callipepla squamata | 9009 | Chordata | Chordata | 48.1 | 4.84e-4 | NR | OXB65184.1 | 9009 | g49549 | i0 | 41.5 | 1.5679012345679 | 65 | 37 | 79 | 1 | 52 | 243 | 839 | 903 | OXB65184.1 hypothetical protein ASZ78_005300 [Callipepla squamata] | diamond | 381 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Odontophoridae | Callipepla | Callipepla squamata | |
| 28093494 | 28093494 | PRJNA703759_P_NODE_41945_length_248_cov_0.891429_g41469_i0 | PRJNA703759 | 41945 | 248 | 0.891429 | 2.21074392 | Clavelina lepadiformis | 159417 | Chordata | Chordata | 52.4 | 1.56e-5 | NR | CAK8679388.1 | 159417 | g41469 | i0 | 42.6 | 0.82258064516129 | 68 | 36 | 82.3 | 1 | 43 | 246 | 156 | 220 | CAK8679388.1 unnamed protein product [Clavelina lepadiformis] | diamond | 204 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Aplousobranchia | Clavelinidae | Clavelina | Clavelina lepadiformis | |
| 28472531 | 28472531 | PRJNA703759_P_NODE_38786_length_250_cov_0.881356_g38310_i0 | PRJNA703759 | 38786 | 250 | 0.881356 | 2.20339 | Ochotona princeps | 9978 | Chordata | Chordata | 50.4 | 7.96e-5 | NR | XP_004579362.2 | 9978 | g38310 | i0 | 39.5 | 4.836 | 81 | 49 | 97.2 | 0 | 244 | 2 | 150 | 230 | XP_004579362.2 leucine-rich repeat-containing protein 66 [Ochotona princeps] | diamond | 1209 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Ochotonidae | Ochotona | Ochotona princeps | |
| 28977701 | 28977701 | PRJNA703759_P_NODE_12308_length_382_cov_1.666667_g11832_i0 | PRJNA703759 | 12308 | 382 | 1.666667 | 6.36666794 | Clavelina lepadiformis | 159417 | Chordata | Chordata | 53.1 | 4.06e-5 | NR | CAK8684147.1 | 159417 | g11832 | i0 | 50.9 | 4.5 | 57 | 27 | 44 | 1 | 6 | 173 | 163 | 219 | CAK8684147.1 unnamed protein product [Clavelina lepadiformis] | diamond | 1719 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Aplousobranchia | Clavelinidae | Clavelina | Clavelina lepadiformis | |
| 29556893 | 29556893 | PRJNA703759_P_NODE_41670_length_248_cov_0.891429_g41194_i0 | PRJNA703759 | 41670 | 248 | 0.891429 | 2.21074392 | Orectolobiformes | 30503 | Chordata | Chordata | 66.6 | 1.54e-10 | NR | GCC30740.1 | 137246 | g41194 | i0 | 45.1 | 3.95564516129032 | 82 | 42 | 99.2 | 2 | 2 | 247 | 792 | 870 | GCC30740.1 hypothetical protein [Chiloscyllium punctatum] | diamond | 981 | 67 | 0.994029850746269 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Orectolobiformes | Hemiscylliidae | Chiloscyllium | Chiloscyllium punctatum | |
| 29619758 | 29619758 | PRJNA703759_P_NODE_46510_length_245_cov_0.906977_g46034_i0 | PRJNA703759 | 46510 | 245 | 0.906977 | 2.22209365 | Metazoa | 33208 | Chordata | Chordata | 51.2 | 4e-5 | NR | MEE6486147.1 | 8439 | g46034 | i0 | 40.3 | 7.04081632653061 | 72 | 41 | 86.9 | 2 | 224 | 12 | 766 | 836 | MEE6486147.1 hypothetical protein [Ascaphus truei] | diamond | 1725 | 51.6 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ascaphidae | Ascaphus | Ascaphus truei | |
| 29872863 | 29872863 | PRJNA703759_P_NODE_48691_length_243_cov_1.376471_g48215_i0 | PRJNA703759 | 48691 | 243 | 1.376471 | 3.34482453 | Metazoa | 33208 | Chordata | Chordata | 47 | 0.00104 | NR | XP_010978122.3 | 9838 | g48215 | i0 | 31.3 | 3.88888888888889 | 80 | 33 | 98.8 | 2 | 2 | 241 | 10 | 67 | XP_010978122.3 chymotrypsin-like elastase family member 3B [Camelus dromedarius] | diamond | 945 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Camelidae | Camelus | Camelus dromedarius | |
| 30051075 | 30051075 | PRJNA703759_P_NODE_20191_length_309_cov_1.059322_g19715_i0 | PRJNA703759 | 20191 | 309 | 1.059322 | 3.27330498 | Pseudophryne corroboree | 495146 | Chordata | Chordata | 64.3 | 2.23e-9 | NR | XP_063790493.1 | 495146 | g19715 | i0 | 56.5 | 3.95145631067961 | 46 | 19 | 43.7 | 1 | 21 | 155 | 3351 | 3396 | XP_063790493.1 dynein axonemal heavy chain 3 isoform X1 [Pseudophryne corroboree] | diamond | 1221 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Myobatrachidae | Pseudophryne | Pseudophryne corroboree | |
| 30220270 | 30220270 | PRJNA703759_P_NODE_49292_length_243_cov_0.917647_g48816_i0 | PRJNA703759 | 49292 | 243 | 0.917647 | 2.22988221 | Pteropus | 9401 | Chordata | Chordata | 48.1 | 4.63e-4 | NR | XP_024906770.1 | 9402 | g48816 | i0 | 54.3 | 2.67901234567901 | 46 | 16 | 56.8 | 1 | 106 | 243 | 40 | 80 | XP_024906770.1 mitochondrial tRNA-specific 2-thiouridylase 1 isoform X7 [Pteropus alecto] | diamond | 651 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Pteropodidae | Pteropus | Pteropus alecto | |
| 30462371 | 30462371 | PRJNA703759_P_NODE_23253_length_292_cov_1.264840_g22777_i0 | PRJNA703759 | 23253 | 292 | 1.26484 | 3.6933328 | Bufo gargarizans | 30331 | Chordata | Chordata | 58.2 | 2.58e-7 | NR | XP_044136758.1 | 30331 | g22777 | i0 | 65.3 | 1.51027397260274 | 49 | 17 | 50.3 | 0 | 107 | 253 | 463 | 511 | XP_044136758.1 kinesin-like protein KIF3A isoform X1 [Bufo gargarizans] | diamond | 441 | 58.5 | 0.994871794871795 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufo | Bufo gargarizans | |
| 30462373 | 30462373 | PRJNA703759_P_NODE_25173_length_284_cov_1.478673_g24697_i0 | PRJNA703759 | 25173 | 284 | 1.478673 | 4.19943132 | Branchiostoma lanceolatum | 7740 | Chordata | Chordata | 49.3 | 2.99e-4 | NR | CAH1230673.1 | 7740 | g24697 | i0 | 38.8 | 0.707746478873239 | 67 | 41 | 70.8 | 0 | 22 | 222 | 422 | 488 | CAH1230673.1 VKORC1L1 [Branchiostoma lanceolatum] | diamond | 201 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 31294606 | 31294606 | PRJNA703759_P_NODE_25715_length_282_cov_1.392344_g25239_i0 | PRJNA703759 | 25715 | 282 | 1.392344 | 3.92641008 | Metazoa | 33208 | Chordata | Chordata | 52.4 | 2.17e-5 | NR | XP_026921806.2 | 32536 | g25239 | i0 | 56.1 | 1.72340425531915 | 41 | 18 | 43.6 | 0 | 2 | 124 | 243 | 283 | XP_026921806.2 retinol dehydrogenase 12 isoform X1 [Acinonyx jubatus] | diamond | 486 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Felidae | Acinonyx | Acinonyx jubatus | |
| 31294610 | 31294610 | PRJNA703759_P_NODE_49495_length_243_cov_0.917647_g49019_i0 | PRJNA703759 | 49495 | 243 | 0.917647 | 2.22988221 | Metazoa | 33208 | Chordata | Chordata | 85.5 | 3.35e-17 | NR | XP_053555130.1 | 8345 | g49019 | i0 | 55.6 | 6 | 81 | 21 | 100 | 1 | 1 | 243 | 184 | 249 | XP_053555130.1 myotubularin [Bombina bombina] | diamond | 1458 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bombinatoridae | Bombina | Bombina bombina | |
| 31315167 | 31315167 | PRJNA703759_P_NODE_48155_length_244_cov_0.912281_g47679_i0 | PRJNA703759 | 48155 | 244 | 0.912281 | 2.22596564 | Callorhinchus milii | 7868 | Chordata | Chordata | 124 | 9.64e-31 | NR | XP_042197723.1 | 7868 | g47679 | i0 | 66.7 | 3.97131147540984 | 81 | 27 | 99.6 | 0 | 243 | 1 | 593 | 673 | XP_042197723.1 probable ATP-dependent RNA helicase DHX35 [Callorhinchus milii] | diamond | 969 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Chimaeriformes | Callorhinchidae | Callorhinchus | Callorhinchus milii | |
| 31346903 | 31346903 | PRJNA703759_P_NODE_39776_length_249_cov_1.568182_g39300_i0 | PRJNA703759 | 39776 | 249 | 1.568182 | 3.90477318 | Rangifer tarandus platyrhynchus | 3082113 | Chordata | Chordata | 41.6 | 0.0476 | NR | CAI9167457.1 | 3082113 | g39300 | i0 | 37.2 | 0.939759036144578 | 78 | 40 | 85.5 | 2 | 10 | 222 | 46 | 121 | CAI9167457.1 unnamed protein product [Rangifer tarandus platyrhynchus] | diamond | 234 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Rangifer | Rangifer tarandus | |
| 32232819 | 32232819 | PRJNA703759_P_NODE_36658_length_252_cov_0.871508_g36182_i0 | PRJNA703759 | 36658 | 252 | 0.871508 | 2.19620016 | Pogoniulus pusillus | 488313 | Chordata | Chordata | 76.6 | 5.04e-14 | NR | XP_063998029.1 | 488313 | g36182 | i0 | 47 | 3.92857142857143 | 66 | 35 | 78.6 | 0 | 55 | 252 | 684 | 749 | XP_063998029.1 electroneutral sodium bicarbonate exchanger 1-like [Pogoniulus pusillus] | diamond | 990 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Piciformes | Lybiidae | Pogoniulus | Pogoniulus pusillus | |
| 32390771 | 32390771 | PRJNA703759_P_NODE_29659_length_268_cov_1.420513_g29183_i0 | PRJNA703759 | 29659 | 268 | 1.420513 | 3.80697484 | Lampetra fluviatilis | 7748 | Chordata | Chordata | 55.1 | 2.34e-6 | NR | CAL5910232.1 | 7748 | g29183 | i0 | 33.8 | 0.861940298507463 | 77 | 42 | 86.2 | 2 | 19 | 249 | 185 | 252 | CAL5910232.1 unnamed protein product [Lampetra fluviatilis] | diamond | 231 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lampetra | Lampetra fluviatilis | |
| 32623033 | 32623033 | PRJNA703759_P_NODE_21680_length_300_cov_1.374449_g21204_i0 | PRJNA703759 | 21680 | 300 | 1.374449 | 4.123347 | Chordata | 7711 | Chordata | Chordata | 87.4 | 1.03e-17 | NR | DBA16915.1 | 30357 | g21204 | i0 | 76 | 10.02 | 50 | 12 | 50 | 0 | 16 | 165 | 125 | 174 | DBA16915.1 TPA: hypothetical protein GDO54_002442 [Pyxicephalus adspersus] | diamond | 3006 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pyxicephalidae | Pyxicephalus | Pyxicephalus adspersus |
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);;