contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA1123309" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4105207 | 4105207 | PRJNA1123309_P_NODE_21984_length_340_cov_1.250936_g21605_i0 | PRJNA1123309 | 21984 | 340 | 1.250936 | 4.2531824 | Phallusia mammillata | 59560 | Chordata | Chordata | 152 | 1.75e-41 | NR | CAB3267494.1 | 59560 | g21605 | i0 | 66.1 | 1.95882352941176 | 112 | 37 | 98.8 | 1 | 3 | 338 | 86 | 196 | CAB3267494.1 UDP-glucose 6-dehydrogenase [Phallusia mammillata] | diamond | 666 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Ascidiidae | Phallusia | Phallusia mammillata | |
| 26975228 | 26975228 | PRJNA1123309_P_NODE_62222_length_244_cov_0.912281_g61842_i0 | PRJNA1123309 | 62222 | 244 | 0.912281 | 2.22596564 | Engystomops pustulosus | 76066 | Chordata | Chordata | 86.3 | 1.77e-17 | NR | KAG8571490.1 | 76066 | g61842 | i0 | 55.4 | 4.52459016393443 | 74 | 33 | 91 | 0 | 12 | 233 | 957 | 1030 | KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus] | diamond | 1104 | 87 | 0.991954022988506 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 27101730 | 27101730 | PRJNA1123309_P_NODE_36182_length_280_cov_1.270531_g35802_i0 | PRJNA1123309 | 36182 | 280 | 1.270531 | 3.5574868 | Phallusia mammillata | 59560 | Chordata | Chordata | 77.4 | 3.5e-15 | NR | CAB3249045.1 | 59560 | g35802 | i0 | 41.9 | 0.921428571428571 | 86 | 50 | 92.1 | 0 | 264 | 7 | 23 | 108 | CAB3249045.1 DNA replication complex GINS protein PSF1 [Phallusia mammillata] | diamond | 258 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Ascidiidae | Phallusia | Phallusia mammillata | |
| 27659809 | 27659809 | PRJNA1123309_P_NODE_22024_length_340_cov_0.891386_g21645_i0 | PRJNA1123309 | 22024 | 340 | 0.891386 | 3.0307124 | Passeriformes | 9126 | Chordata | Chordata | 71.2 | 4.14e-13 | NR | NXS23194.1 | 98133 | g21645 | i0 | 45.3 | 1.51764705882353 | 86 | 38 | 75.9 | 2 | 3 | 260 | 54 | 130 | NXS23194.1 CALMS protein [Mystacornis crossleyi] | diamond | 516 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Timaliidae | Mystacornis | Mystacornis crossleyi | |
| 27975334 | 27975334 | PRJNA1123309_P_NODE_43905_length_261_cov_0.946809_g43525_i0 | PRJNA1123309 | 43905 | 261 | 0.946809 | 2.47117149 | Anura | 8342 | Chordata | Chordata | 53.1 | 9.67e-6 | NR | XP_041429831.1 | 8355 | g43525 | i0 | 44.8 | 3.14942528735632 | 67 | 37 | 77 | 0 | 248 | 48 | 311 | 377 | XP_041429831.1 uncharacterized protein LOC121397286 [Xenopus laevis] | diamond | 822 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 28417623 | 28417623 | PRJNA1123309_P_NODE_51846_length_250_cov_1.378531_g51466_i0 | PRJNA1123309 | 51846 | 250 | 1.378531 | 3.4463275 | Polypteridae | 8289 | Chordata | Chordata | 55.8 | 9.7e-7 | NR | XP_051788734.1 | 27687 | g51466 | i0 | 69.4 | 5.112 | 36 | 11 | 43.2 | 0 | 129 | 22 | 157 | 192 | XP_051788734.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] | diamond | 1278 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 28428293 | 28428293 | PRJNA1123309_P_NODE_50606_length_251_cov_0.876404_g50226_i0 | PRJNA1123309 | 50606 | 251 | 0.876404 | 2.19977404 | Staurois parvus | 386267 | Chordata | Chordata | 61.6 | 1.38e-10 | NR | CAI9622145.1 | 386267 | g50226 | i0 | 74.4 | 0.956175298804781 | 39 | 10 | 46.6 | 0 | 250 | 134 | 7 | 45 | CAI9622145.1 unnamed protein product [Staurois parvus] | diamond | 240 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 28480581 | 28480581 | PRJNA1123309_P_NODE_60966_length_245_cov_0.906977_g60586_i0 | PRJNA1123309 | 60966 | 245 | 0.906977 | 2.22209365 | root | 1 | Root_unresolved | Root_unresolved | 88.6 | 2.89e-19 | NR | POI22351.1 | 9083 | g60586 | i0 | 60 | 14.8285714285714 | 80 | 32 | 98 | 0 | 2 | 241 | 136 | 215 | POI22351.1 hypothetical protein CIB84_013902, partial [Bambusicola thoracicus] | diamond | 3633 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Bambusicola | Bambusicola thoracicus | |
| 28617813 | 28617813 | PRJNA1123309_P_NODE_55607_length_248_cov_0.891429_g55227_i0 | PRJNA1123309 | 55607 | 248 | 0.891429 | 2.21074392 | Regulus satrapa | 13245 | Chordata | Chordata | 43.9 | 0.00142 | NR | NWR50751.1 | 13245 | g55227 | i0 | 47.1 | 0.616935483870968 | 51 | 24 | 61.7 | 1 | 17 | 169 | 6 | 53 | NWR50751.1 ZNF85 protein [Regulus satrapa] | diamond | 153 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Regulidae | Regulus | Regulus satrapa | |
| 29280547 | 29280547 | PRJNA1123309_P_NODE_34269_length_285_cov_0.971698_g33889_i0 | PRJNA1123309 | 34269 | 285 | 0.971698 | 2.7693393 | Callorhinchus milii | 7868 | Chordata | Chordata | 76.6 | 7.46e-14 | NR | XP_042189895.1 | 7868 | g33889 | i0 | 43.9 | 0.863157894736842 | 82 | 45 | 86.3 | 1 | 280 | 35 | 747 | 827 | XP_042189895.1 alpha-mannosidase 2 [Callorhinchus milii] | diamond | 246 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Chimaeriformes | Callorhinchidae | Callorhinchus | Callorhinchus milii | |
| 29806554 | 29806554 | PRJNA1123309_P_NODE_26231_length_315_cov_1.243802_g25851_i0 | PRJNA1123309 | 26231 | 315 | 1.243802 | 3.9179763 | Ascidiacea | 7713 | Chordata | Chordata | 107 | 1.73e-24 | NR | XP_002124785.3 | 7719 | g25851 | i0 | 49 | 4.80952380952381 | 100 | 51 | 95.2 | 0 | 311 | 12 | 193 | 292 | XP_002124785.3 unconventional myosin-If [Ciona intestinalis] | diamond | 1515 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 30891835 | 30891835 | PRJNA1123309_P_NODE_51974_length_250_cov_1.124294_g51594_i0 | PRJNA1123309 | 51974 | 250 | 1.124294 | 2.810735 | Myxine glutinosa | 7769 | Chordata | Chordata | 63.2 | 2.54e-9 | NR | XP_067957627.1 | 7769 | g51594 | i0 | 60.4 | 1.272 | 53 | 21 | 63.6 | 0 | 14 | 172 | 291 | 343 | XP_067957627.1 tryptophan--tRNA ligase, cytoplasmic isoform X2 [Myxine glutinosa] | diamond | 318 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 31702879 | 31702879 | PRJNA1123309_P_NODE_54657_length_249_cov_0.886364_g54277_i0 | PRJNA1123309 | 54657 | 249 | 0.886364 | 2.20704636 | Chordata | 7711 | Chordata | Chordata | 63.5 | 1.81e-9 | NR | XP_053568518.1 | 8345 | g54277 | i0 | 58.1 | 27.8915662650602 | 62 | 20 | 73.5 | 2 | 244 | 62 | 152 | 208 | XP_053568518.1 calpain-8-like isoform X2 [Bombina bombina] | diamond | 6945 | 63.9 | 0.993740219092332 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bombinatoridae | Bombina | Bombina bombina | |
| 31734311 | 31734311 | PRJNA1123309_P_NODE_44897_length_258_cov_1.491892_g44517_i0 | PRJNA1123309 | 44897 | 258 | 1.491892 | 3.84908136 | Metazoa | 33208 | Chordata | Chordata | 54.7 | 2.73e-6 | NR | XP_065451455.1 | 8478 | g44517 | i0 | 45.5 | 9.84883720930233 | 77 | 42 | 89.5 | 0 | 1 | 231 | 75 | 151 | XP_065451455.1 uncharacterized protein LOC135983429 [Chrysemys picta bellii] | diamond | 2541 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Emydidae | Chrysemys | Chrysemys picta | ||
| 31840043 | 31840043 | PRJNA1123309_P_NODE_13677_length_414_cov_4.146628_g13300_i0 | PRJNA1123309 | 13677 | 414 | 4.146628 | 17.16703992 | Staurois parvus | 386267 | Chordata | Chordata | 57.8 | 1.2e-7 | NR | CAI9533415.1 | 386267 | g13300 | i0 | 40 | 3.00724637681159 | 110 | 47 | 65.9 | 4 | 287 | 15 | 1 | 110 | CAI9533415.1 unnamed protein product [Staurois parvus] | diamond | 1245 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 32061653 | 32061653 | PRJNA1123309_P_NODE_43538_length_262_cov_0.883598_g43158_i0 | PRJNA1123309 | 43538 | 262 | 0.883598 | 2.31502676 | Xenopus laevis | 8355 | Chordata | Chordata | 48.5 | 4.12e-4 | NR | XP_041429831.1 | 8355 | g43158 | i0 | 39.5 | 0.984732824427481 | 86 | 52 | 98.5 | 0 | 3 | 260 | 342 | 427 | XP_041429831.1 uncharacterized protein LOC121397286 [Xenopus laevis] | diamond | 258 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 32504863 | 32504863 | PRJNA1123309_P_NODE_47199_length_253_cov_0.866667_g46819_i0 | PRJNA1123309 | 47199 | 253 | 0.866667 | 2.19266751 | Staurois parvus | 386267 | Chordata | Chordata | 50.8 | 5.03e-6 | NR | CAI9618608.1 | 386267 | g46819 | i0 | 48.5 | 0.782608695652174 | 66 | 34 | 78.3 | 0 | 21 | 218 | 19 | 84 | CAI9618608.1 unnamed protein product [Staurois parvus] | diamond | 198 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 32746165 | 32746165 | PRJNA1123309_P_NODE_11400_length_450_cov_0.899204_g11024_i0 | PRJNA1123309 | 11400 | 450 | 0.899204 | 4.046418 | Chordata | 7711 | Chordata | Chordata | 49.7 | 0.00123 | NR | KAF7250773.1 | 61221 | g11024 | i0 | 59.1 | 2.36 | 44 | 18 | 29.3 | 0 | 12 | 143 | 686 | 729 | KAF7250773.1 M-phase phosphoprotein 8 [Varanus komodoensis] | diamond | 1062 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Varanidae | Varanus | Varanus komodoensis | |
| 32788224 | 32788224 | PRJNA1123309_P_NODE_59780_length_246_cov_0.901734_g59400_i0 | PRJNA1123309 | 59780 | 246 | 0.901734 | 2.21826564 | Podarcis raffonei | 65483 | Chordata | Chordata | 42.4 | 0.0474 | NR | XP_053220310.1 | 65483 | g59400 | i0 | 35.7 | 0.682926829268293 | 56 | 36 | 68.3 | 0 | 200 | 33 | 31 | 86 | XP_053220310.1 5-demethoxyubiquinone hydroxylase, mitochondrial [Podarcis raffonei] | diamond | 168 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Lacertidae | Podarcis | Podarcis raffonei |
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);;