contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA330616" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4216946 | 4216946 | PRJNA330616_P_NODE_2264_length_597_cov_2.145985_g1866_i0 | PRJNA330616 | 2264 | 597 | 2.145985 | 12.81153045 | Metazoa | 33208 | Chordata | Chordata | 256 | 1.07e-78 | NR | KAK9394781.1 | 8729 | g1866 | i0 | 67.7 | 57.2562814070352 | 189 | 51 | 95 | 1 | 582 | 16 | 421 | 599 | KAK9394781.1 60S ribosomal protein L11 [Crotalus adamanteus] | diamond | 34182 | 257 | 0.996108949416342 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Viperidae | Crotalus | Crotalus adamanteus | |
| 13143174 | 13143174 | PRJNA330616_P_NODE_19051_length_193_cov_1.402778_g18642_i0 | PRJNA330616 | 19051 | 193 | 1.402778 | 2.70736154 | Branchiostoma floridae | 7739 | Chordata | Chordata | 118 | 4.17e-31 | NR | XP_035694028.1 | 7739 | g18642 | i0 | 87.5 | 0.994818652849741 | 64 | 8 | 99.5 | 0 | 192 | 1 | 11 | 74 | XP_035694028.1 60S ribosomal protein L8-like [Branchiostoma floridae] | diamond | 192 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 26947939 | 26947939 | PRJNA330616_P_NODE_29762_length_163_cov_0.894737_g29353_i0 | PRJNA330616 | 29762 | 163 | 0.894737 | 1.45842131 | Myxine glutinosa | 7769 | Chordata | Chordata | 72.4 | 4.39e-13 | NR | XP_067973508.1 | 7769 | g29353 | i0 | 51 | 1.87730061349693 | 51 | 25 | 93.9 | 0 | 154 | 2 | 40 | 90 | XP_067973508.1 protein kinase C alpha type-like isoform X2 [Myxine glutinosa] | diamond | 306 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 27169176 | 27169176 | PRJNA330616_P_NODE_15342_length_213_cov_1.548780_g14933_i0 | PRJNA330616 | 15342 | 213 | 1.54878 | 3.2989014 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 86.3 | 1.25e-19 | NR | XP_019632425.1 | 7741 | g14933 | i0 | 55.7 | 5.87323943661972 | 70 | 31 | 98.6 | 0 | 1 | 210 | 58 | 127 | XP_019632425.1 PREDICTED: transcription factor BTF3 homolog 4-like [Branchiostoma belcheri] | diamond | 1251 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 27200852 | 27200852 | PRJNA330616_P_NODE_3602_length_454_cov_1.849383_g3195_i0 | PRJNA330616 | 3602 | 454 | 1.849383 | 8.39619882 | Caretta caretta | 8467 | Chordata | Chordata | 87.8 | 3.93e-18 | NR | CAM2107459.1 | 8467 | g3195 | i0 | 53 | 7.84361233480176 | 115 | 53 | 76 | 1 | 94 | 438 | 103 | 216 | CAM2107459.1 unnamed protein product [Caretta caretta] | diamond | 3561 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Caretta | Caretta caretta | ||
| 27959002 | 27959002 | PRJNA330616_P_NODE_32905_length_156_cov_2.392523_g32496_i0 | PRJNA330616 | 32905 | 156 | 2.392523 | 3.73233588 | Bufotes viridis | 30338 | Chordata | Chordata | 46.6 | 5.09e-4 | NR | CAK8609802.1 | 30338 | g32496 | i0 | 56.3 | 1.23076923076923 | 32 | 14 | 61.5 | 0 | 58 | 153 | 1 | 32 | CAK8609802.1 Lamina-associated polypeptide 2, isoform alpha [Bufotes viridis] | diamond | 192 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 28134336 | 28134336 | PRJNA330616_P_NODE_30305_length_163_cov_0.894737_g29896_i0 | PRJNA330616 | 30305 | 163 | 0.894737 | 1.45842131 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 63.2 | 7.87e-10 | NR | CAB3267057.1 | 59560 | g29896 | i0 | 53.8 | 6.49693251533742 | 52 | 24 | 95.7 | 0 | 163 | 8 | 364 | 415 | CAB3267057.1 transmembrane protein 180 [Phallusia mammillata] | diamond | 1059 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Ascidiidae | Phallusia | Phallusia mammillata | |
| 28165813 | 28165813 | PRJNA330616_P_NODE_26165_length_167_cov_0.864407_g25756_i0 | PRJNA330616 | 26165 | 167 | 0.864407 | 1.44355969 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 68.9 | 6.47e-12 | NR | XP_027480201.2 | 9704 | g25756 | i0 | 69.2 | 15.4850299401198 | 52 | 16 | 93.4 | 0 | 2 | 157 | 190 | 241 | XP_027480201.2 uncharacterized protein LOC113938920 [Zalophus californianus] | diamond | 2586 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Otariidae | Zalophus | Zalophus californianus | |
| 28242993 | 28242993 | PRJNA330616_P_NODE_23446_length_174_cov_2.528000_g23037_i0 | PRJNA330616 | 23446 | 174 | 2.528 | 4.39872 | Lamprotornis superbus | 245042 | Chordata | Chordata | 69.7 | 1.35e-12 | NR | KAI1234130.1 | 245042 | g23037 | i0 | 61.1 | 7.72413793103448 | 54 | 19 | 93.1 | 1 | 173 | 12 | 129 | 180 | KAI1234130.1 hypothetical protein IHE44_0003845 [Lamprotornis superbus] | diamond | 1344 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Sturnidae | Lamprotornis | Lamprotornis superbus | |
| 28450092 | 28450092 | PRJNA330616_P_NODE_22246_length_179_cov_1.569231_g21837_i0 | PRJNA330616 | 22246 | 179 | 1.569231 | 2.80892349 | Opisthokonta | 33154 | Chordata | Chordata | 72 | 4.76e-13 | NR | KAJ1123966.1 | 8319 | g21837 | i0 | 57.1 | 8.64804469273743 | 70 | 19 | 98.9 | 1 | 177 | 1 | 38 | 107 | KAJ1123966.1 hypothetical protein NDU88_002433 [Pleurodeles waltl] | diamond | 1548 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl | |
| 28891771 | 28891771 | PRJNA330616_P_NODE_26628_length_166_cov_0.871795_g26219_i0 | PRJNA330616 | 26628 | 166 | 0.871795 | 1.4471797 | Chordata | 7711 | Chordata | Chordata | 41.2 | 0.0479 | NR | XP_044160400.1 | 30331 | g26219 | i0 | 69.2 | 1.44578313253012 | 26 | 8 | 47 | 0 | 2 | 79 | 1302 | 1327 | XP_044160400.1 aldehyde oxidase-like [Bufo gargarizans] | diamond | 240 | 41.6 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufo | Bufo gargarizans | |
| 29001345 | 29001345 | PRJNA330616_P_NODE_27868_length_165_cov_0.879310_g27459_i0 | PRJNA330616 | 27868 | 165 | 0.87931 | 1.4508615 | Suncus etruscus | 109475 | Chordata | Chordata | 84.3 | 5.92e-18 | NR | XP_049637544.1 | 109475 | g27459 | i0 | 67.3 | 107.981818181818 | 55 | 18 | 100 | 0 | 1 | 165 | 75 | 129 | XP_049637544.1 LOW QUALITY PROTEIN: YEATS domain-containing protein 4-like [Suncus etruscus] | diamond | 17817 | 84.7 | 0.995277449822904 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Soricidae | Suncus | Suncus etruscus | |
| 29411325 | 29411325 | PRJNA330616_P_NODE_18309_length_196_cov_5.387755_g17900_i0 | PRJNA330616 | 18309 | 196 | 5.387755 | 10.5599998 | Bombina bombina | 8345 | Chordata | Chordata | 65.5 | 8.46e-12 | NR | XP_053562510.1 | 8345 | g17900 | i0 | 76.2 | 1.92857142857143 | 42 | 10 | 64.3 | 0 | 71 | 196 | 1 | 42 | XP_053562510.1 60S acidic ribosomal protein P2-like [Bombina bombina] | diamond | 378 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bombinatoridae | Bombina | Bombina bombina | |
| 30060155 | 30060155 | PRJNA330616_P_NODE_21291_length_183_cov_1.522388_g20882_i0 | PRJNA330616 | 21291 | 183 | 1.522388 | 2.78597004 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 40.8 | 0.0427 | NR | NP_001087192.1 | 8355 | g20882 | i0 | 64.2 | 3.57377049180328 | 53 | 13 | 83.6 | 2 | 182 | 30 | 81 | 129 | NP_001087192.1 ribosomal protein L24 L homeolog [Xenopus laevis] | diamond | 654 | 41.2 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 30313601 | 30313601 | PRJNA330616_P_NODE_8032_length_293_cov_1.045082_g7623_i0 | PRJNA330616 | 8032 | 293 | 1.045082 | 3.06209026 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 101 | 7.22e-25 | NR | XP_039269693.1 | 7725 | g7623 | i0 | 66.2 | 7.55631399317406 | 74 | 25 | 75.8 | 0 | 279 | 58 | 92 | 165 | XP_039269693.1 60S ribosomal protein L12-like [Styela clava] | diamond | 2214 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 31116983 | 31116983 | PRJNA330616_P_NODE_13855_length_223_cov_3.126437_g13446_i0 | PRJNA330616 | 13855 | 223 | 3.126437 | 6.97195451 | Hyla sarda | 327740 | Chordata | Chordata | 57.8 | 8.73e-8 | NR | XP_056409683.1 | 327740 | g13446 | i0 | 54.4 | 0.766816143497758 | 57 | 20 | 75.3 | 3 | 168 | 1 | 184 | 235 | XP_056409683.1 uncharacterized protein LOC130331736 [Hyla sarda] | diamond | 171 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Hylidae | Hyla | Hyla sarda | |
| 31718137 | 31718137 | PRJNA330616_P_NODE_27957_length_165_cov_0.879310_g27548_i0 | PRJNA330616 | 27957 | 165 | 0.87931 | 1.4508615 | Staurois parvus | 386267 | Chordata | Chordata | 42 | 0.00379 | NR | CAI9540006.1 | 386267 | g27548 | i0 | 52.9 | 0.618181818181818 | 34 | 16 | 61.8 | 0 | 5 | 106 | 3 | 36 | CAI9540006.1 unnamed protein product, partial [Staurois parvus] | diamond | 102 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 31830120 | 31830120 | PRJNA330616_P_NODE_28937_length_164_cov_0.886957_g28528_i0 | PRJNA330616 | 28937 | 164 | 0.886957 | 1.45460948 | Lepidosauria | 8504 | Chordata | Chordata | 42 | 0.0238 | NR | XP_014380302.1 | 38654 | g28528 | i0 | 43.9 | 7.53658536585366 | 41 | 23 | 75 | 0 | 149 | 27 | 246 | 286 | XP_014380302.1 solute carrier family 35 member F6 isoform X2 [Alligator sinensis] | diamond | 1236 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Crocodylia | Alligatoridae | Alligator | Alligator sinensis | ||
| 32178553 | 32178553 | PRJNA330616_P_NODE_9378_length_271_cov_1.900901_g8969_i0 | PRJNA330616 | 9378 | 271 | 1.900901 | 5.15144171 | Metazoa | 33208 | Chordata | Chordata | 144 | 1.2699999999999999e-42 | NR | AFM91059.1 | 7868 | g8969 | i0 | 82.9 | 96.0885608856089 | 82 | 14 | 90.8 | 0 | 269 | 24 | 35 | 116 | AFM91059.1 40S ribosomal protein S20 isoform 2 [Callorhinchus milii] | diamond | 26040 | 145 | 0.993103448275862 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Chimaeriformes | Callorhinchidae | Callorhinchus | Callorhinchus milii | |
| 32382547 | 32382547 | PRJNA330616_P_NODE_25219_length_168_cov_1.033613_g24810_i0 | PRJNA330616 | 25219 | 168 | 1.033613 | 1.73646984 | Bufotes viridis | 30338 | Chordata | Chordata | 43.5 | 0.0071 | NR | CAK8629749.1 | 30338 | g24810 | i0 | 48.6 | 0.625 | 35 | 18 | 62.5 | 0 | 5 | 109 | 329 | 363 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 105 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis |
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);;