contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA811714" and tax_kingdom = "Metazoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27307289 | 27307289 | PRJNA811714_P_NODE_12263_length_285_cov_2.179245_g12070_i0 | PRJNA811714 | 12263 | 285 | 2.179245 | 6.21084825 | Amblyraja radiata | 386614 | Chordata | Chordata | 47.8 | 9.6e-4 | NR | XP_032872135.1 | 386614 | g12070 | i0 | 66.7 | 0.284210526315789 | 27 | 9 | 28.4 | 0 | 2 | 82 | 4 | 30 | XP_032872135.1 zinc finger protein 239-like, partial [Amblyraja radiata] | diamond | 81 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Rajiformes | Rajidae | Amblyraja | Amblyraja radiata | |
| 29201775 | 29201775 | PRJNA811714_P_NODE_15589_length_265_cov_4.656250_g15396_i0 | PRJNA811714 | 15589 | 265 | 4.65625 | 12.3390625 | Dermacentor andersoni | 34620 | Arthropoda | Arthropoda | 42.7 | 0.0461 | NR | XP_054934251.1 | 34620 | g15396 | i0 | 47.1 | 0.577358490566038 | 51 | 25 | 57.7 | 1 | 243 | 91 | 15 | 63 | XP_054934251.1 polycystic kidney disease protein 1-like 3 isoform X2 [Dermacentor andersoni] | diamond | 153 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Ixodida | Ixodidae | Dermacentor | Dermacentor andersoni | |
| 29368368 | 29368368 | PRJNA811714_P_NODE_19909_length_247_cov_3.517241_g19716_i0 | PRJNA811714 | 19909 | 247 | 3.517241 | 8.68758527 | Insecta | 50557 | Arthropoda | Arthropoda | 75.5 | 5.12e-14 | NR | XP_021919457.1 | 136037 | g19716 | i0 | 51.9 | 5.79352226720648 | 79 | 38 | 96 | 0 | 242 | 6 | 217 | 295 | XP_021919457.1 N-acetylneuraminate lyase-like isoform X3 [Zootermopsis nevadensis] | diamond | 1431 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Blattodea | Termopsidae | Zootermopsis | Zootermopsis nevadensis | |
| 29391210 | 29391210 | PRJNA811714_P_NODE_24769_length_233_cov_2.887500_g24576_i0 | PRJNA811714 | 24769 | 233 | 2.8875 | 6.727875 | Staurois parvus | 386267 | Chordata | Chordata | 63.9 | 4.39e-11 | NR | CAI9547784.1 | 386267 | g24576 | i0 | 56.8 | 1.13304721030043 | 44 | 19 | 56.7 | 0 | 2 | 133 | 6 | 49 | CAI9547784.1 unnamed protein product, partial [Staurois parvus] | diamond | 264 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 29801447 | 29801447 | PRJNA811714_P_NODE_18951_length_250_cov_7.322034_g18758_i0 | PRJNA811714 | 18951 | 250 | 7.322034 | 18.305085 | Harpegnathos saltator | 610380 | Arthropoda | Arthropoda | 48.5 | 2.97e-4 | NR | XP_011137057.1 | 610380 | g18758 | i0 | 73.3 | 0.36 | 30 | 8 | 36 | 0 | 34 | 123 | 1 | 30 | XP_011137057.1 uncharacterized protein LOC105181771 [Harpegnathos saltator] | diamond | 90 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Formicidae | Harpegnathos | Harpegnathos saltator | |
| 29991123 | 29991123 | PRJNA811714_P_NODE_12431_length_284_cov_2.175355_g12238_i0 | PRJNA811714 | 12431 | 284 | 2.175355 | 6.1780082 | Triturus pygmaeus | 171367 | Chordata | Chordata | 40 | 0.0483 | NR | ABU95988.1 | 171367 | g12238 | i0 | 100 | 0.950704225352113 | 18 | 0 | 19 | 0 | 284 | 231 | 16 | 33 | ABU95988.1 cytochrome oxidase subunit I, partial [Triturus pygmaeus] | diamond | 270 | 40 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Triturus | Triturus pygmaeus | |
| 30054090 | 30054090 | PRJNA811714_P_NODE_16471_length_261_cov_2.457447_g16278_i0 | PRJNA811714 | 16471 | 261 | 2.457447 | 6.41393667 | Podarcis lilfordi | 74358 | Chordata | Chordata | 60.5 | 2.74e-8 | NR | CAI5775279.1 | 74358 | g16278 | i0 | 52.3 | 0.747126436781609 | 65 | 22 | 69 | 2 | 261 | 82 | 745 | 805 | CAI5775279.1 Sin3A associated protein 130 [Podarcis lilfordi] | diamond | 195 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Lacertidae | Podarcis | Podarcis lilfordi | |
| 30465335 | 30465335 | PRJNA811714_P_NODE_12653_length_282_cov_3.803828_g12460_i0 | PRJNA811714 | 12653 | 282 | 3.803828 | 10.72679496 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 43.1 | 0.0435 | NR | CAK5069761.1 | 390850 | g12460 | i0 | 35.1 | 1.57446808510638 | 74 | 43 | 78.7 | 2 | 47 | 268 | 728 | 796 | CAK5069761.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 444 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 30559564 | 30559564 | PRJNA811714_P_NODE_21933_length_241_cov_2.750000_g21740_i0 | PRJNA811714 | 21933 | 241 | 2.75 | 6.6275 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 98.2 | 1.1200000000000002e-21 | NR | XP_070570488.1 | 63121 | g21740 | i0 | 67.6 | 13.2946058091286 | 68 | 22 | 84.6 | 0 | 16 | 219 | 691 | 758 | XP_070570488.1 histone-lysine N-methyltransferase EZH2-like isoform X4 [Ptychodera flava] | diamond | 3204 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 31413114 | 31413114 | PRJNA811714_P_NODE_29056_length_218_cov_5.337931_g28863_i0 | PRJNA811714 | 29056 | 218 | 5.337931 | 11.63668958 | Bufotes viridis | 30338 | Chordata | Chordata | 43.5 | 0.014 | NR | CAK8629749.1 | 30338 | g28863 | i0 | 63.3 | 1.27981651376147 | 30 | 11 | 41.3 | 0 | 90 | 1 | 331 | 360 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 279 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 32393849 | 32393849 | PRJNA811714_P_NODE_9519_length_313_cov_2.950000_g9326_i0 | PRJNA811714 | 9519 | 313 | 2.95 | 9.2335 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 97.1 | 6.860000000000001e-21 | NR | PIK55251.1 | 307972 | g9326 | i0 | 51 | 2.93290734824281 | 102 | 50 | 97.8 | 0 | 3 | 308 | 486 | 587 | PIK55251.1 hypothetical protein BSL78_07847 [Apostichopus japonicus] | diamond | 918 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 32488934 | 32488934 | PRJNA811714_P_NODE_30779_length_208_cov_5.733333_g30586_i0 | PRJNA811714 | 30779 | 208 | 5.733333 | 11.92533264 | Staurois parvus | 386267 | Chordata | Chordata | 71.6 | 2.99e-14 | NR | CAI9547784.1 | 386267 | g30586 | i0 | 46.4 | 0.995192307692308 | 69 | 37 | 99.5 | 0 | 2 | 208 | 8 | 76 | CAI9547784.1 unnamed protein product, partial [Staurois parvus] | diamond | 207 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 32615086 | 32615086 | PRJNA811714_P_NODE_27660_length_226_cov_3.019608_g27467_i0 | PRJNA811714 | 27660 | 226 | 3.019608 | 6.82431408 | Engystomops pustulosus | 76066 | Chordata | Chordata | 44.7 | 0.00647 | NR | KAG8571490.1 | 76066 | g27467 | i0 | 56.8 | 10.5663716814159 | 37 | 16 | 49.1 | 0 | 117 | 7 | 982 | 1018 | KAG8571490.1 hypothetical protein GDO81_011667 [Engystomops pustulosus] | diamond | 2388 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 32709412 | 32709412 | PRJNA811714_P_NODE_32040_length_201_cov_6.984375_g31847_i0 | PRJNA811714 | 32040 | 201 | 6.984375 | 14.03859375 | Mesorhabditis belari | 2138241 | Nematoda | Nematoda | 43.1 | 0.0156 | NR | CAJ0961864.1 | 2138241 | g31847 | i0 | 30.4 | 1.02985074626866 | 69 | 45 | 98.5 | 1 | 3 | 200 | 190 | 258 | CAJ0961864.1 unnamed protein product, partial [Mesorhabditis belari] | diamond | 207 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis belari |
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);;