contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA512103" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4312983 | 4312983 | PRJNA512103_P_NODE_2724_length_1028_cov_1.429009_g2454_i0 | PRJNA512103 | 2724 | 1028 | 1.429009 | 14.69021252 | Chondrichthyes | 7777 | Chordata | Chordata | 243 | 4.719999999999998e-69 | NR | XP_048459070.1 | 259920 | g2454 | i0 | 56.1 | 9.30058365758755 | 214 | 92 | 62.5 | 1 | 3 | 644 | 384 | 595 | XP_048459070.1 WD repeat-containing protein 3 isoform X2 [Rhincodon typus] | diamond | 9561 | 243 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Orectolobiformes | Rhincodontidae | Rhincodon | Rhincodon typus | |
| 11964577 | 11964577 | PRJNA512103_P_NODE_21250_length_207_cov_1.006329_g20838_i0 | PRJNA512103 | 21250 | 207 | 1.006329 | 2.08310103 | Branchiostoma | 7737 | Chordata | Chordata | 57.4 | 1.62e-7 | NR | CAH1272651.1 | 7740 | g20838 | i0 | 57.8 | 13.8550724637681 | 45 | 16 | 60.9 | 1 | 207 | 82 | 508 | 552 | CAH1272651.1 ZNF569 [Branchiostoma lanceolatum] | diamond | 2868 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 22162227 | 22162227 | PRJNA512103_P_NODE_10818_length_352_cov_1.686469_g10406_i0 | PRJNA512103 | 10818 | 352 | 1.686469 | 5.93637088 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 203 | 7.7e-62 | NR | KAK9393150.1 | 8729 | g10406 | i0 | 78.9 | 141.213068181818 | 114 | 24 | 97.2 | 0 | 350 | 9 | 195 | 308 | KAK9393150.1 Ras-related C3 botulinum toxin substrate 1 [Crotalus adamanteus] | diamond | 49707 | 205 | 0.990243902439024 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Viperidae | Crotalus | Crotalus adamanteus | |
| 26902911 | 26902911 | PRJNA512103_P_NODE_11881_length_326_cov_0.913357_g11469_i0 | PRJNA512103 | 11881 | 326 | 0.913357 | 2.97754382 | Chordata | 7711 | Chordata | Chordata | 214 | 7.23e-68 | NR | NP_001080171.1 | 8355 | g11469 | i0 | 96.2 | 43.0674846625767 | 106 | 4 | 97.5 | 0 | 7 | 324 | 1 | 106 | NP_001080171.1 ribosomal protein S6 L homeolog [Xenopus laevis] | diamond | 14040 | 215 | 0.995348837209302 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 26965968 | 26965968 | PRJNA512103_P_NODE_32262_length_166_cov_0.888889_g31850_i0 | PRJNA512103 | 32262 | 166 | 0.888889 | 1.47555574 | Chordata | 7711 | Chordata | Chordata | 109 | 1.55e-27 | NR | KAG6940506.1 | 8475 | g31850 | i0 | 100 | 29.2771084337349 | 54 | 0 | 97.6 | 0 | 3 | 164 | 214 | 267 | KAG6940506.1 proteasome subunit alpha 2, partial [Chelydra serpentina] | diamond | 4860 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Chelydridae | Chelydra | Chelydra serpentina | ||
| 26982232 | 26982232 | PRJNA512103_P_NODE_19722_length_217_cov_0.791667_g19310_i0 | PRJNA512103 | 19722 | 217 | 0.791667 | 1.71791739 | Bufotes viridis | 30338 | Chordata | Chordata | 42 | 0.0492 | NR | CAK8629749.1 | 30338 | g19310 | i0 | 64.3 | 0.387096774193548 | 28 | 10 | 38.7 | 0 | 5 | 88 | 335 | 362 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 84 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 27045575 | 27045575 | PRJNA512103_P_NODE_31182_length_168_cov_0.873950_g30770_i0 | PRJNA512103 | 31182 | 168 | 0.87395 | 1.468236 | Scyliorhinus torazame | 75743 | Chordata | Chordata | 107 | 1.27e-26 | NR | GCB81313.1 | 75743 | g30770 | i0 | 98.2 | 74.6428571428571 | 55 | 1 | 98.2 | 0 | 167 | 3 | 150 | 204 | GCB81313.1 hypothetical protein [Scyliorhinus torazame] | diamond | 12540 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Carcharhiniformes | Scyliorhinidae | Scyliorhinus | Scyliorhinus torazame | |
| 27123857 | 27123857 | PRJNA512103_P_NODE_24842_length_189_cov_1.128571_g24430_i0 | PRJNA512103 | 24842 | 189 | 1.128571 | 2.13299919 | Metazoa | 33208 | Chordata | Chordata | 48.1 | 2.33e-4 | NR | KAI8518019.1 | 7741 | g24430 | i0 | 56.5 | 2.17460317460317 | 46 | 20 | 73 | 0 | 46 | 183 | 569 | 614 | KAI8518019.1 hypothetical protein Bbelb_040360 [Branchiostoma belcheri] | diamond | 411 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 27393380 | 27393380 | PRJNA512103_P_NODE_18843_length_224_cov_1.000000_g18431_i0 | PRJNA512103 | 18843 | 224 | 1 | 2.24 | Bufotes viridis | 30338 | Chordata | Chordata | 42.4 | 0.0396 | NR | CAK8609802.1 | 30338 | g18431 | i0 | 60 | 0.709821428571429 | 30 | 12 | 40.2 | 0 | 94 | 5 | 1 | 30 | CAK8609802.1 Lamina-associated polypeptide 2, isoform alpha [Bufotes viridis] | diamond | 159 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 27408888 | 27408888 | PRJNA512103_P_NODE_13483_length_292_cov_1.032922_g13071_i0 | PRJNA512103 | 13483 | 292 | 1.032922 | 3.01613224 | Anura | 8342 | Chordata | Chordata | 191 | 1.03e-59 | NR | NP_001080766.1 | 8355 | g13071 | i0 | 92.8 | 12.9452054794521 | 97 | 7 | 99.7 | 0 | 291 | 1 | 51 | 147 | NP_001080766.1 ribosomal protein L15 L homeolog [Xenopus laevis] | diamond | 3780 | 192 | 0.994791666666667 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 27913646 | 27913646 | PRJNA512103_P_NODE_17745_length_233_cov_1.021739_g17333_i0 | PRJNA512103 | 17745 | 233 | 1.021739 | 2.38065187 | Aves | 8782 | Chordata | Chordata | 96.7 | 9.82e-22 | NR | CAK6565781.1 | 9079 | g17333 | i0 | 64.4 | 22.0815450643777 | 73 | 26 | 94 | 0 | 226 | 8 | 125 | 197 | CAK6565781.1 unnamed protein product [Alectoris rufa] | diamond | 5145 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Alectoris | Alectoris rufa | |
| 30123956 | 30123956 | PRJNA512103_P_NODE_25932_length_185_cov_0.911765_g25520_i0 | PRJNA512103 | 25932 | 185 | 0.911765 | 1.68676525 | Anura | 8342 | Chordata | Chordata | 119 | 8.909999999999998e-32 | NR | KAE8633244.1 | 8364 | g25520 | i0 | 90.2 | 24.6486486486486 | 61 | 6 | 98.9 | 0 | 3 | 185 | 103 | 163 | KAE8633244.1 hypothetical protein XENTR_v10001824 [Xenopus tropicalis] | diamond | 4560 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 30471834 | 30471834 | PRJNA512103_P_NODE_16233_length_248_cov_4.341709_g15821_i0 | PRJNA512103 | 16233 | 248 | 4.341709 | 10.76743832 | Chordata | 7711 | Chordata | Chordata | 83.2 | 2.2e-16 | NR | NP_033640.1 | 7748 | g15821 | i0 | 94.7 | 223.838709677419 | 38 | 2 | 46 | 0 | 215 | 102 | 237 | 274 | NP_033640.1 cytochrome c oxidase subunit I [Lampetra fluviatilis] | diamond | 55512 | 83.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lampetra | Lampetra fluviatilis | |
| 30534858 | 30534858 | PRJNA512103_P_NODE_12213_length_318_cov_1.539033_g11801_i0 | PRJNA512103 | 12213 | 318 | 1.539033 | 4.89412494 | Chordata | 7711 | Chordata | Chordata | 196 | 3.55e-61 | NR | XP_025783231.1 | 9696 | g11801 | i0 | 97.1 | 37.6415094339623 | 105 | 3 | 99.1 | 0 | 2 | 316 | 102 | 206 | XP_025783231.1 40S ribosomal protein S7 [Puma concolor] | diamond | 11970 | 197 | 0.99492385786802 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Felidae | Puma | Puma concolor | |
| 30977385 | 30977385 | PRJNA512103_P_NODE_26314_length_183_cov_1.395522_g25902_i0 | PRJNA512103 | 26314 | 183 | 1.395522 | 2.55380526 | Aves | 8782 | Chordata | Chordata | 46.2 | 9.74e-4 | NR | XP_054699623.1 | 9117 | g25902 | i0 | 40 | 14.7540983606557 | 60 | 32 | 98.4 | 1 | 3 | 182 | 299 | 354 | XP_054699623.1 UPF0488 protein C8orf33 homolog isoform X2 [Grus americana] | diamond | 2700 | 46.6 | 0.991416309012876 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Gruiformes | Gruidae | Grus | Grus americana | |
| 31293201 | 31293201 | PRJNA512103_P_NODE_17255_length_237_cov_1.888298_g16843_i0 | PRJNA512103 | 17255 | 237 | 1.888298 | 4.47526626 | Chordata | 7711 | Chordata | Chordata | 97.1 | 8.71e-24 | NR | AAL08597.1 | 7892 | g16843 | i0 | 96 | 183.911392405063 | 50 | 2 | 63.3 | 0 | 33 | 182 | 28 | 77 | AAL08597.1 NADH dehydrogenase subunit 3 [Neoceratodus forsteri] | diamond | 43587 | 97.8 | 0.992842535787321 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ceratodontiformes | Ceratodontidae | Neoceratodus | Neoceratodus forsteri | ||
| 32132124 | 32132124 | PRJNA512103_P_NODE_30138_length_170_cov_1.181818_g29726_i0 | PRJNA512103 | 30138 | 170 | 1.181818 | 2.0090906 | Polypterus senegalus | 55291 | Chordata | Chordata | 97.4 | 1.61e-22 | NR | KAG2455457.1 | 55291 | g29726 | i0 | 98 | 14.6823529411765 | 49 | 1 | 86.5 | 0 | 3 | 149 | 281 | 329 | KAG2455457.1 RS11 protein, partial [Polypterus senegalus] | diamond | 2496 | 98.2 | 0.991853360488798 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 32274120 | 32274120 | PRJNA512103_P_NODE_30458_length_169_cov_1.300000_g30046_i0 | PRJNA512103 | 30458 | 169 | 1.3 | 2.197 | Chordata | 7711 | Chordata | Chordata | 100 | 2.5399999999999998e-24 | NR | XP_055512776.1 | 7782 | g30046 | i0 | 94.5 | 42.9585798816568 | 55 | 3 | 97.6 | 0 | 167 | 3 | 100 | 154 | XP_055512776.1 60S ribosomal protein L19 [Leucoraja erinaceus] | diamond | 7260 | 101 | 0.99009900990099 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Rajiformes | Rajidae | Leucoraja | Leucoraja erinaceus |
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);;