contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA451191" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23392367 | 23392367 | PRJNA451191_P_NODE_2259_length_1171_cov_3.692793_g2078_i0 | PRJNA451191 | 2259 | 1171 | 3.692793 | 43.24260603 | Branchiostoma lanceolatum | 7740 | Chordata | Chordata | 303 | 1.38e-90 | NR | CAH1247945.1 | 7740 | g2078 | i0 | 45.8 | 0.922288642186166 | 360 | 190 | 92.2 | 1 | 1105 | 26 | 36 | 390 | CAH1247945.1 TRMT11 [Branchiostoma lanceolatum] | diamond | 1080 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 27123619 | 27123619 | PRJNA451191_P_NODE_49722_length_207_cov_0.890411_g49451_i0 | PRJNA451191 | 49722 | 207 | 0.890411 | 1.84315077 | Metazoa | 33208 | Chordata | Chordata | 43.5 | 0.0119 | NR | KAI8513518.1 | 7741 | g49451 | i0 | 53.7 | 1.65217391304348 | 41 | 17 | 56.5 | 1 | 152 | 36 | 125 | 165 | KAI8513518.1 hypothetical protein Bbelb_101570 [Branchiostoma belcheri] | diamond | 342 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 27549927 | 27549927 | PRJNA451191_P_NODE_51724_length_205_cov_0.902778_g51453_i0 | PRJNA451191 | 51724 | 205 | 0.902778 | 1.8506949 | Cnephaeus nilssonii | 3371016 | Chordata | Chordata | 68.2 | 8.95e-13 | NR | KAK1337430.1 | 3371016 | g51453 | i0 | 57.7 | 5.48780487804878 | 52 | 22 | 76.1 | 0 | 157 | 2 | 44 | 95 | KAK1337430.1 hypothetical protein QTO34_002057, partial [Cnephaeus nilssonii] | diamond | 1125 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Cnephaeus | Cnephaeus nilssonii | |
| 27598016 | 27598016 | PRJNA451191_P_NODE_16004_length_364_cov_1.729373_g15733_i0 | PRJNA451191 | 16004 | 364 | 1.729373 | 6.29491772 | Metazoa | 33208 | Chordata | Chordata | 48.1 | 0.0018 | NR | XP_059807923.1 | 79690 | g15733 | i0 | 30.8 | 4.16208791208791 | 107 | 65 | 87.4 | 4 | 363 | 46 | 126 | 224 | XP_059807923.1 uncharacterized protein LOC132382078 [Hypanus sabinus] | diamond | 1515 | 48.5 | 0.991752577319588 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Myliobatiformes | Dasyatidae | Hypanus | Hypanus sabinus | |
| 27960454 | 27960454 | PRJNA451191_P_NODE_23685_length_293_cov_1.176724_g23414_i0 | PRJNA451191 | 23685 | 293 | 1.176724 | 3.44780132 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 65.9 | 5.08e-10 | NR | KAI8486194.1 | 7741 | g23414 | i0 | 45 | 5.20136518771331 | 80 | 42 | 79.9 | 1 | 1 | 234 | 649 | 728 | KAI8486194.1 hypothetical protein Bbelb_360940 [Branchiostoma belcheri] | diamond | 1524 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 28307880 | 28307880 | PRJNA451191_P_NODE_25186_length_283_cov_2.968468_g24915_i0 | PRJNA451191 | 25186 | 283 | 2.968468 | 8.40076444 | Suncus etruscus | 109475 | Chordata | Chordata | 72.8 | 1.73e-12 | NR | XP_049640071.1 | 109475 | g24915 | i0 | 33.3 | 3.95406360424028 | 96 | 61 | 99.6 | 2 | 1 | 282 | 2486 | 2580 | XP_049640071.1 LOW QUALITY PROTEIN: maltase-glucoamylase [Suncus etruscus] | diamond | 1119 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Soricidae | Suncus | Suncus etruscus | |
| 28655187 | 28655187 | PRJNA451191_P_NODE_44267_length_213_cov_3.026316_g43996_i0 | PRJNA451191 | 44267 | 213 | 3.026316 | 6.44605308 | Branchiostoma lanceolatum | 7740 | Chordata | Chordata | 63.9 | 8.41e-10 | NR | XP_066288343.1 | 7740 | g43996 | i0 | 47.5 | 8.54929577464789 | 59 | 31 | 83.1 | 0 | 212 | 36 | 764 | 822 | XP_066288343.1 uncharacterized protein [Branchiostoma lanceolatum] | diamond | 1821 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 28686961 | 28686961 | PRJNA451191_P_NODE_41127_length_222_cov_1.614907_g40856_i0 | PRJNA451191 | 41127 | 222 | 1.614907 | 3.58509354 | Branchiostoma lanceolatum | 7740 | Chordata | Chordata | 51.6 | 1.58e-5 | NR | XP_066292857.1 | 7740 | g40856 | i0 | 37.7 | 0.824324324324324 | 61 | 33 | 75.7 | 1 | 214 | 47 | 142 | 202 | XP_066292857.1 uncharacterized protein [Branchiostoma lanceolatum] | diamond | 183 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 30360917 | 30360917 | PRJNA451191_P_NODE_53152_length_204_cov_0.874126_g52881_i0 | PRJNA451191 | 53152 | 204 | 0.874126 | 1.78321704 | Pantherophis guttatus | 94885 | Chordata | Chordata | 42.4 | 0.0302 | NR | XP_060546878.1 | 94885 | g52881 | i0 | 45.2 | 0.617647058823529 | 42 | 23 | 61.8 | 0 | 194 | 69 | 38 | 79 | XP_060546878.1 zinc-binding protein A33-like [Pantherophis guttatus] | diamond | 126 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Colubridae | Pantherophis | Pantherophis guttatus | |
| 31071932 | 31071932 | PRJNA451191_P_NODE_53815_length_203_cov_0.915493_g53544_i0 | PRJNA451191 | 53815 | 203 | 0.915493 | 1.85845079 | Metazoa | 33208 | Chordata | Chordata | 53.9 | 2.51e-6 | NR | KAI8486085.1 | 7741 | g53544 | i0 | 48.1 | 5.66009852216749 | 52 | 27 | 76.8 | 0 | 47 | 202 | 300 | 351 | KAI8486085.1 hypothetical protein Bbelb_361850 [Branchiostoma belcheri] | diamond | 1149 | 54.3 | 0.992633517495396 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 31245099 | 31245099 | PRJNA451191_P_NODE_13675_length_399_cov_1.428994_g13404_i0 | PRJNA451191 | 13675 | 399 | 1.428994 | 5.70168606 | Ambystoma mexicanum | 8296 | Chordata | Chordata | 111 | 2.29e-25 | NR | XP_069486975.1 | 8296 | g13404 | i0 | 44.1 | 1.66917293233083 | 111 | 62 | 83.5 | 0 | 7 | 339 | 447 | 557 | XP_069486975.1 zinc finger MYM-type protein 1-like [Ambystoma mexicanum] | diamond | 666 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Ambystomatidae | Ambystoma | Ambystoma mexicanum | |
| 31403463 | 31403463 | PRJNA451191_P_NODE_45436_length_211_cov_1.346667_g45165_i0 | PRJNA451191 | 45436 | 211 | 1.346667 | 2.84146737 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 57.8 | 1.21e-7 | NR | KAI8503532.1 | 7741 | g45165 | i0 | 48.2 | 14.6729857819905 | 56 | 29 | 79.6 | 0 | 211 | 44 | 327 | 382 | KAI8503532.1 hypothetical protein Bbelb_185030 [Branchiostoma belcheri] | diamond | 3096 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 31751108 | 31751108 | PRJNA451191_P_NODE_41917_length_220_cov_1.484277_g41646_i0 | PRJNA451191 | 41917 | 220 | 1.484277 | 3.2654094 | Clavelina lepadiformis | 159417 | Chordata | Chordata | 58.2 | 1.04e-7 | NR | CAK8678053.1 | 159417 | g41646 | i0 | 44.8 | 1.58181818181818 | 58 | 32 | 79.1 | 0 | 190 | 17 | 885 | 942 | CAK8678053.1 unnamed protein product [Clavelina lepadiformis] | diamond | 348 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Aplousobranchia | Clavelinidae | Clavelina | Clavelina lepadiformis | |
| 31846004 | 31846004 | PRJNA451191_P_NODE_46897_length_210_cov_0.872483_g46626_i0 | PRJNA451191 | 46897 | 210 | 0.872483 | 1.8322143 | Ambystoma mexicanum | 8296 | Chordata | Chordata | 94 | 2.19e-20 | NR | XP_069486975.1 | 8296 | g46626 | i0 | 62.3 | 1.97142857142857 | 69 | 26 | 98.6 | 0 | 2 | 208 | 473 | 541 | XP_069486975.1 zinc finger MYM-type protein 1-like [Ambystoma mexicanum] | diamond | 414 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Ambystomatidae | Ambystoma | Ambystoma mexicanum | |
| 31909409 | 31909409 | PRJNA451191_P_NODE_49297_length_207_cov_1.356164_g49026_i0 | PRJNA451191 | 49297 | 207 | 1.356164 | 2.80725948 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 59.3 | 3.25e-8 | NR | KAI8482492.1 | 7741 | g49026 | i0 | 55.6 | 1.30434782608696 | 45 | 20 | 65.2 | 0 | 136 | 2 | 376 | 420 | KAI8482492.1 hypothetical protein Bbelb_397280 [Branchiostoma belcheri] | diamond | 270 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 31972660 | 31972660 | PRJNA451191_P_NODE_44118_length_214_cov_1.503268_g43847_i0 | PRJNA451191 | 44118 | 214 | 1.503268 | 3.21699352 | Hypanus sabinus | 79690 | Chordata | Chordata | 50.1 | 6.69e-5 | NR | XP_059816063.1 | 79690 | g43847 | i0 | 38.2 | 0.953271028037383 | 68 | 37 | 88.3 | 1 | 204 | 16 | 137 | 204 | XP_059816063.1 uncharacterized protein LOC132387718 [Hypanus sabinus] | diamond | 204 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Myliobatiformes | Dasyatidae | Hypanus | Hypanus sabinus | |
| 32067501 | 32067501 | PRJNA451191_P_NODE_48598_length_208_cov_0.884354_g48327_i0 | PRJNA451191 | 48598 | 208 | 0.884354 | 1.83945632 | Hyla sarda | 327740 | Chordata | Chordata | 55.1 | 5.84e-7 | NR | XP_056395303.1 | 327740 | g48327 | i0 | 50 | 0.692307692307692 | 48 | 24 | 69.2 | 0 | 3 | 146 | 56 | 103 | XP_056395303.1 zinc finger BED domain-containing protein 5-like [Hyla sarda] | diamond | 144 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Hylidae | Hyla | Hyla sarda | |
| 32289482 | 32289482 | PRJNA451191_P_NODE_27299_length_272_cov_1.478673_g27028_i0 | PRJNA451191 | 27299 | 272 | 1.478673 | 4.02199056 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 87.8 | 4.92e-18 | NR | XP_051782582.1 | 27687 | g27028 | i0 | 75 | 1.23529411764706 | 56 | 14 | 61.8 | 0 | 54 | 221 | 216 | 271 | XP_051782582.1 zinc finger BED domain-containing protein 5-like, partial [Erpetoichthys calabaricus] | diamond | 336 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 32510882 | 32510882 | PRJNA451191_P_NODE_10439_length_465_cov_3.643564_g10168_i0 | PRJNA451191 | 10439 | 465 | 3.643564 | 16.9425726 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 158 | 3.75e-44 | NR | XP_051791274.1 | 27687 | g10168 | i0 | 62.3 | 5.65161290322581 | 146 | 27 | 93.5 | 2 | 435 | 1 | 115 | 233 | XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] | diamond | 2628 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus |
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);;