contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA395690" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26790621 | 26790621 | PRJNA395690_P_NODE_15721_length_205_cov_1.307692_g15569_i0 | PRJNA395690 | 15721 | 205 | 1.307692 | 2.6807686 | Ciona intestinalis | 7719 | Chordata | Chordata | 42 | 0.0443 | NR | XP_026694186.1 | 7719 | g15569 | i0 | 38.3 | 0.878048780487805 | 60 | 32 | 80.5 | 1 | 41 | 205 | 16 | 75 | XP_026694186.1 uncharacterized protein LOC104266555 [Ciona intestinalis] | diamond | 180 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 26948681 | 26948681 | PRJNA395690_P_NODE_12562_length_230_cov_1.392265_g12410_i0 | PRJNA395690 | 12562 | 230 | 1.392265 | 3.2022095 | Eublepharis macularius | 481883 | Chordata | Chordata | 47.4 | 6.78e-4 | NR | XP_054856576.1 | 481883 | g12410 | i0 | 44.8 | 0.756521739130435 | 58 | 32 | 75.7 | 0 | 216 | 43 | 227 | 284 | XP_054856576.1 RAD51-associated protein 1 [Eublepharis macularius] | diamond | 174 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Eublepharidae | Eublepharis | Eublepharis macularius | |
| 28639776 | 28639776 | PRJNA395690_P_NODE_25807_length_173_cov_1.169355_g25655_i0 | PRJNA395690 | 25807 | 173 | 1.169355 | 2.02298415 | Metazoa | 33208 | Chordata | Chordata | 74.3 | 9.39e-14 | NR | AFM87703.1 | 7868 | g25655 | i0 | 63.5 | 6.39884393063584 | 52 | 19 | 90.2 | 0 | 169 | 14 | 217 | 268 | AFM87703.1 antiquitin [Callorhinchus milii] | diamond | 1107 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Chimaeriformes | Callorhinchidae | Callorhinchus | Callorhinchus milii | |
| 28828871 | 28828871 | PRJNA395690_P_NODE_30948_length_165_cov_0.879310_g30796_i0 | PRJNA395690 | 30948 | 165 | 0.87931 | 1.4508615 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 50.1 | 3.48e-5 | NR | KAG9470010.1 | 57060 | g30796 | i0 | 43.6 | 1.90909090909091 | 55 | 31 | 100 | 0 | 165 | 1 | 655 | 709 | KAG9470010.1 hypothetical protein GDO78_019133 [Eleutherodactylus coqui] | diamond | 315 | 50.4 | 0.994047619047619 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Eleutherodactylidae | Eleutherodactylus | Eleutherodactylus coqui | |
| 29064966 | 29064966 | PRJNA395690_P_NODE_33188_length_163_cov_0.894737_g33036_i0 | PRJNA395690 | 33188 | 163 | 0.894737 | 1.45842131 | Grallaria varia | 117165 | Chordata | Chordata | 42.7 | 0.0124 | NR | NXG13368.1 | 117165 | g33036 | i0 | 50 | 6.95705521472393 | 36 | 17 | 64.4 | 1 | 21 | 125 | 349 | 384 | NXG13368.1 LYAM3 protein [Grallaria varia] | diamond | 1134 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Formicariidae | Grallaria | Grallaria varia | |
| 29176525 | 29176525 | PRJNA395690_P_NODE_20149_length_186_cov_1.489051_g19997_i0 | PRJNA395690 | 20149 | 186 | 1.489051 | 2.76963486 | root | 1 | Root_unresolved | Root_unresolved | 126 | 6.72e-33 | NR | KAJ1172809.1 | 8319 | g19997 | i0 | 98.4 | 300.91935483871 | 61 | 1 | 98.4 | 0 | 2 | 184 | 291 | 351 | KAJ1172809.1 hypothetical protein NDU88_004651 [Pleurodeles waltl] | diamond | 55971 | 127 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl | |
| 29222918 | 29222918 | PRJNA395690_P_NODE_5529_length_340_cov_2.704467_g5379_i0 | PRJNA395690 | 5529 | 340 | 2.704467 | 9.1951878 | Ranitomeya imitator | 111125 | Chordata | Chordata | 48.1 | 0.00144 | NR | CAJ0939377.1 | 111125 | g5379 | i0 | 31.2 | 1.93235294117647 | 109 | 49 | 81.2 | 4 | 309 | 34 | 181 | 280 | CAJ0939377.1 unnamed protein product, partial [Ranitomeya imitator] | diamond | 657 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 29460178 | 29460178 | PRJNA395690_P_NODE_18150_length_191_cov_1.436620_g17998_i0 | PRJNA395690 | 18150 | 191 | 1.43662 | 2.7439442 | Metazoa | 33208 | Chordata | Chordata | 87.8 | 2.47e-18 | NR | XP_043938962.1 | 7888 | g17998 | i0 | 97.6 | 13.1937172774869 | 42 | 1 | 66 | 0 | 3 | 128 | 640 | 681 | XP_043938962.1 glutamine--fructose-6-phosphate aminotransferase [isomerizing] 1 [Protopterus annectens] | diamond | 2520 | 88.6 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ceratodontiformes | Protopteridae | Protopterus | Protopterus annectens | ||
| 29492033 | 29492033 | PRJNA395690_P_NODE_35770_length_161_cov_0.910714_g35618_i0 | PRJNA395690 | 35770 | 161 | 0.910714 | 1.46624954 | Aves | 8782 | Chordata | Chordata | 71.6 | 7.82e-13 | NR | XP_068775298.1 | 8801 | g35618 | i0 | 57.7 | 25.0993788819876 | 52 | 22 | 96.9 | 0 | 3 | 158 | 232 | 283 | XP_068775298.1 bifunctional coenzyme A synthase [Struthio camelus] | diamond | 4041 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Struthioniformes | Struthionidae | Struthio | Struthio camelus | |
| 29744414 | 29744414 | PRJNA395690_P_NODE_26110_length_172_cov_1.373984_g25958_i0 | PRJNA395690 | 26110 | 172 | 1.373984 | 2.36325248 | Rodentia | 9989 | Chordata | Chordata | 69.3 | 2.43e-12 | NR | XP_048196323.1 | 214514 | g25958 | i0 | 61.4 | 16.203488372093 | 44 | 17 | 76.7 | 0 | 171 | 40 | 207 | 250 | XP_048196323.1 serine protease 1-like [Perognathus longimembris pacificus] | diamond | 2787 | 69.7 | 0.994261119081779 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Heteromyidae | Perognathus | Perognathus longimembris | |
| 30328658 | 30328658 | PRJNA395690_P_NODE_27612_length_168_cov_1.689076_g27460_i0 | PRJNA395690 | 27612 | 168 | 1.689076 | 2.83764768 | Myotis myotis | 51298 | Chordata | Chordata | 42.7 | 0.0141 | NR | KAF6311472.1 | 51298 | g27460 | i0 | 50 | 0.642857142857143 | 36 | 18 | 64.3 | 0 | 1 | 108 | 475 | 510 | KAF6311472.1 xylulokinase [Myotis myotis] | diamond | 108 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Myotis | Myotis myotis | |
| 30738783 | 30738783 | PRJNA395690_P_NODE_4274_length_382_cov_1.933934_g4125_i0 | PRJNA395690 | 4274 | 382 | 1.933934 | 7.38762788 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 70.5 | 2.39e-11 | NR | XP_051791274.1 | 27687 | g4125 | i0 | 73.5 | 2.35602094240838 | 49 | 12 | 37.7 | 1 | 106 | 249 | 156 | 204 | XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] | diamond | 900 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 30833655 | 30833655 | PRJNA395690_P_NODE_28514_length_167_cov_0.864407_g28362_i0 | PRJNA395690 | 28514 | 167 | 0.864407 | 1.44355969 | Anolis carolinensis | 28377 | Chordata | Chordata | 46.2 | 8e-4 | NR | XP_062822139.1 | 28377 | g28362 | i0 | 55 | 2.2814371257485 | 40 | 17 | 70.1 | 1 | 117 | 1 | 749 | 788 | XP_062822139.1 polyhomeotic-like protein 2 isoform X2 [Anolis carolinensis] | diamond | 381 | 46.6 | 0.991416309012876 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Dactyloidae | Anolis | Anolis carolinensis | |
| 31261235 | 31261235 | PRJNA395690_P_NODE_10695_length_249_cov_1.275000_g10543_i0 | PRJNA395690 | 10695 | 249 | 1.275 | 3.17475 | Mammalia | 40674 | Chordata | Chordata | 85.9 | 5.16e-19 | NR | XP_058138446.1 | 9361 | g10543 | i0 | 65.2 | 70.7228915662651 | 66 | 23 | 79.5 | 0 | 6 | 203 | 93 | 158 | XP_058138446.1 large ribosomal subunit protein uL23-like [Dasypus novemcinctus] | diamond | 17610 | 86.7 | 0.990772779700115 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Cingulata | Dasypodidae | Dasypus | Dasypus novemcinctus | |
| 31813739 | 31813739 | PRJNA395690_P_NODE_26457_length_171_cov_1.647541_g26305_i0 | PRJNA395690 | 26457 | 171 | 1.647541 | 2.81729511 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 64.3 | 3.39e-10 | NR | XP_019623710.1 | 7741 | g26305 | i0 | 67.5 | 2.10526315789474 | 40 | 13 | 70.2 | 0 | 8 | 127 | 147 | 186 | XP_019623710.1 PREDICTED: fibrillin-1-like [Branchiostoma belcheri] | diamond | 360 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 32589973 | 32589973 | PRJNA395690_P_NODE_27019_length_170_cov_1.264463_g26867_i0 | PRJNA395690 | 27019 | 170 | 1.264463 | 2.1495871 | Mammalia | 40674 | Chordata | Chordata | 87 | 2.55e-18 | NR | OWK10815.1 | 46360 | g26867 | i0 | 80.4 | 4.57058823529412 | 51 | 10 | 90 | 0 | 156 | 4 | 63 | 113 | OWK10815.1 hypothetical protein Celaphus_00005060, partial [Cervus elaphus hippelaphus] | diamond | 777 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Cervus | Cervus elaphus | |
| 32841586 | 32841586 | PRJNA395690_P_NODE_6520_length_315_cov_2.285714_g6368_i0 | PRJNA395690 | 6520 | 315 | 2.285714 | 7.1999991 | Metazoa | 33208 | Chordata | Chordata | 84.7 | 1.42e-16 | NR | XP_064126597.1 | 9785 | g6368 | i0 | 77.1 | 7.77142857142857 | 48 | 11 | 45.7 | 0 | 170 | 313 | 16 | 63 | XP_064126597.1 protein disulfide-isomerase isoform X2 [Loxodonta africana] | diamond | 2448 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Proboscidea | Elephantidae | Loxodonta | Loxodonta africana |
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);;