contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA753704" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8384263 | 8384263 | PRJNA753704_P_NODE_14827_length_311_cov_1.310924_g14466_i0 | PRJNA753704 | 14827 | 311 | 1.310924 | 4.07697364 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 174 | 7.24e-53 | NR | XP_039249937.1 | 7725 | g14466 | i0 | 89.1 | 135.35691318328 | 92 | 10 | 88.7 | 0 | 35 | 310 | 1 | 92 | XP_039249937.1 ras-related protein Rab-7a-like [Styela clava] | diamond | 42096 | 175 | 0.994285714285714 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 19858010 | 19858010 | PRJNA753704_P_NODE_16036_length_300_cov_1.859031_g15675_i0 | PRJNA753704 | 16036 | 300 | 1.859031 | 5.577093 | Opisthokonta | 33154 | Chordata | Chordata | 121 | 7.5e-33 | NR | XP_009859881.1 | 7719 | g15675 | i0 | 71.4 | 20.24 | 91 | 23 | 88 | 2 | 32 | 295 | 1 | 91 | XP_009859881.1 late histone H2A.2.2 [Ciona intestinalis] | diamond | 6072 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 27821053 | 27821053 | PRJNA753704_P_NODE_27444_length_244_cov_0.912281_g27083_i0 | PRJNA753704 | 27444 | 244 | 0.912281 | 2.22596564 | Metazoa | 33208 | Chordata | Chordata | 57.4 | 7.06e-8 | NR | XP_045010327.1 | 51337 | g27083 | i0 | 38 | 2.63114754098361 | 71 | 40 | 82.4 | 1 | 36 | 236 | 17 | 87 | XP_045010327.1 ADP-sugar pyrophosphatase-like [Jaculus jaculus] | diamond | 642 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Dipodidae | Jaculus | Jaculus jaculus | |
| 28347765 | 28347765 | PRJNA753704_P_NODE_16186_length_299_cov_1.380531_g15825_i0 | PRJNA753704 | 16186 | 299 | 1.380531 | 4.12778769 | Branchiostoma floridae | 7739 | Chordata | Chordata | 55.8 | 1.84e-6 | NR | XP_035688303.1 | 7739 | g15825 | i0 | 42.2 | 1.79598662207358 | 64 | 32 | 61.2 | 2 | 55 | 237 | 141 | 202 | XP_035688303.1 fibrillin-2-like isoform X3 [Branchiostoma floridae] | diamond | 537 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 29105737 | 29105737 | PRJNA753704_P_NODE_23448_length_253_cov_0.866667_g23087_i0 | PRJNA753704 | 23448 | 253 | 0.866667 | 2.19266751 | Branchiostoma lanceolatum | 7740 | Chordata | Chordata | 86.7 | 1.4e-17 | NR | CAH1239779.1 | 7740 | g23087 | i0 | 48.2 | 2.01581027667984 | 85 | 42 | 98.4 | 1 | 5 | 253 | 384 | 468 | CAH1239779.1 PM20D1 [Branchiostoma lanceolatum] | diamond | 510 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 29200481 | 29200481 | PRJNA753704_P_NODE_8169_length_408_cov_1.283582_g7808_i0 | PRJNA753704 | 8169 | 408 | 1.283582 | 5.23701456 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 44.7 | 0.0487 | NR | XP_019623126.1 | 7741 | g7808 | i0 | 31.3 | 0.963235294117647 | 131 | 78 | 96.3 | 3 | 394 | 2 | 1983 | 2101 | XP_019623126.1 PREDICTED: fibrocystin-L-like [Branchiostoma belcheri] | diamond | 393 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 29368082 | 29368082 | PRJNA753704_P_NODE_16329_length_298_cov_1.040000_g15968_i0 | PRJNA753704 | 16329 | 298 | 1.04 | 3.0992 | root | 1 | Root_unresolved | Root_unresolved | 107 | 2.22e-25 | NR | ACS69064.1 | 7765 | g15968 | i0 | 61.2 | 33.8859060402685 | 85 | 27 | 85.6 | 2 | 43 | 297 | 3 | 81 | ACS69064.1 glyceraldehyde-3-phosphate dehydrogenase [Eptatretus stoutii] | diamond | 10098 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Eptatretus | Eptatretus stoutii | |
| 30694633 | 30694633 | PRJNA753704_P_NODE_26793_length_245_cov_1.808140_g26432_i0 | PRJNA753704 | 26793 | 245 | 1.80814 | 4.429943 | Chordata | 7711 | Chordata | Chordata | 62 | 6.09e-9 | NR | XP_038668701.1 | 7830 | g26432 | i0 | 43.2 | 22.0775510204082 | 81 | 34 | 88.2 | 3 | 28 | 243 | 60 | 137 | XP_038668701.1 serine/threonine-protein kinase Chk2 [Scyliorhinus canicula] | diamond | 5409 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Carcharhiniformes | Scyliorhinidae | Scyliorhinus | Scyliorhinus canicula | |
| 30726195 | 30726195 | PRJNA753704_P_NODE_19974_length_272_cov_1.427136_g19613_i0 | PRJNA753704 | 19974 | 272 | 1.427136 | 3.88180992 | Metazoa | 33208 | Chordata | Chordata | 92.4 | 1.76e-19 | NR | XP_067905327.1 | 7792 | g19613 | i0 | 50.6 | 19.3455882352941 | 87 | 42 | 96 | 1 | 270 | 10 | 198 | 283 | XP_067905327.1 conserved oligomeric Golgi complex subunit 8 [Heterodontus francisci] | diamond | 5262 | 93.2 | 0.991416309012876 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Heterodontiformes | Heterodontidae | Heterodontus | Heterodontus francisci | |
| 31095500 | 31095500 | PRJNA753704_P_NODE_9935_length_373_cov_3.903333_g9574_i0 | PRJNA753704 | 9935 | 373 | 3.903333 | 14.55943209 | Staurois parvus | 386267 | Chordata | Chordata | 59.7 | 3.45e-9 | NR | CAI9620946.1 | 386267 | g9574 | i0 | 70.3 | 0.297587131367292 | 37 | 11 | 29.8 | 0 | 80 | 190 | 23 | 59 | CAI9620946.1 unnamed protein product [Staurois parvus] | diamond | 111 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 31253554 | 31253554 | PRJNA753704_P_NODE_17975_length_285_cov_1.297170_g17614_i0 | PRJNA753704 | 17975 | 285 | 1.29717 | 3.6969345 | Rhinolophus sinicus | 89399 | Chordata | Chordata | 51.2 | 6.48e-5 | NR | XP_019605254.1 | 89399 | g17614 | i0 | 42.6 | 0.568421052631579 | 54 | 30 | 55.8 | 1 | 97 | 255 | 545 | 598 | XP_019605254.1 PREDICTED: matrilin-4 isoform X1 [Rhinolophus sinicus] | diamond | 162 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Rhinolophidae | Rhinolophus | Rhinolophus sinicus | |
| 31601682 | 31601682 | PRJNA753704_P_NODE_28316_length_242_cov_0.923077_g27955_i0 | PRJNA753704 | 28316 | 242 | 0.923077 | 2.23384634 | Xenopus laevis | 8355 | Chordata | Chordata | 63.5 | 1.07e-9 | NR | OCU00332.1 | 8355 | g27955 | i0 | 51.8 | 2.03305785123967 | 56 | 27 | 69.4 | 0 | 5 | 172 | 71 | 126 | OCU00332.1 hypothetical protein XELAEV_18006103mg [Xenopus laevis] | diamond | 492 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 32149265 | 32149265 | PRJNA753704_P_NODE_21358_length_264_cov_1.340314_g20997_i0 | PRJNA753704 | 21358 | 264 | 1.340314 | 3.53842896 | Metazoa | 33208 | Chordata | Chordata | 43.9 | 0.0182 | NR | XP_035667135.1 | 7739 | g20997 | i0 | 33.9 | 5.56818181818182 | 59 | 38 | 65.9 | 1 | 262 | 89 | 441 | 499 | XP_035667135.1 ras-specific guanine nucleotide-releasing factor 1-like isoform X2 [Branchiostoma floridae] | diamond | 1470 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 32266153 | 32266153 | PRJNA753704_P_NODE_27798_length_243_cov_1.035294_g27437_i0 | PRJNA753704 | 27798 | 243 | 1.035294 | 2.51576442 | Phodopus roborovskii | 109678 | Chordata | Chordata | 45.4 | 0.0035 | NR | XP_051042541.1 | 109678 | g27437 | i0 | 37.3 | 0.827160493827161 | 67 | 33 | 80.2 | 2 | 228 | 34 | 22 | 81 | XP_051042541.1 LOW QUALITY PROTEIN: glutathione S-transferase theta-2-like [Phodopus roborovskii] | diamond | 201 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Phodopus | Phodopus roborovskii | |
| 32519260 | 32519260 | PRJNA753704_P_NODE_11359_length_351_cov_2.737410_g10998_i0 | PRJNA753704 | 11359 | 351 | 2.73741 | 9.6083091 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 135 | 7.37e-36 | NR | XP_051791274.1 | 27687 | g10998 | i0 | 78.9 | 6.99145299145299 | 90 | 18 | 76.1 | 1 | 41 | 307 | 115 | 204 | XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] | diamond | 2454 | 135 | 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);;