contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA942359" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27221453 | 27221453 | PRJNA942359_P_NODE_14002_length_252_cov_0.871508_g13887_i0 | PRJNA942359 | 14002 | 252 | 0.871508 | 2.19620016 | Mammalia | 40674 | Chordata | Chordata | 44.3 | 0.0111 | NR | CAD7667460.1 | 34880 | g13887 | i0 | 51.4 | 0.904761904761905 | 37 | 18 | 44 | 0 | 230 | 120 | 18 | 54 | CAD7667460.1 unnamed protein product [Nyctereutes procyonoides] | diamond | 228 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Nyctereutes | Nyctereutes procyonoides | |
| 27467791 | 27467791 | PRJNA942359_P_NODE_14383_length_251_cov_0.876404_g14268_i0 | PRJNA942359 | 14383 | 251 | 0.876404 | 2.19977404 | Hippopotamus amphibius kiboko | 575201 | Chordata | Chordata | 52 | 5.43e-6 | NR | XP_057554635.1 | 575201 | g14268 | i0 | 45 | 0.717131474103586 | 60 | 33 | 71.7 | 0 | 18 | 197 | 74 | 133 | XP_057554635.1 heat shock factor-binding protein 1-like protein 1 isoform X1 [Hippopotamus amphibius kiboko] | diamond | 180 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Hippopotamidae | Hippopotamus | Hippopotamus amphibius | |
| 28067540 | 28067540 | PRJNA942359_P_NODE_13725_length_252_cov_0.871508_g13610_i0 | PRJNA942359 | 13725 | 252 | 0.871508 | 2.19620016 | Eschrichtius robustus | 9764 | Chordata | Chordata | 135 | 1.52e-36 | NR | KAJ8798166.1 | 9764 | g13610 | i0 | 81.7 | 0.976190476190476 | 82 | 13 | 95.2 | 1 | 11 | 250 | 39 | 120 | KAJ8798166.1 hypothetical protein J1605_016799 [Eschrichtius robustus] | diamond | 246 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Eschrichtiidae | Eschrichtius | Eschrichtius robustus | |
| 28099081 | 28099081 | PRJNA942359_P_NODE_14945_length_250_cov_0.881356_g14830_i0 | PRJNA942359 | 14945 | 250 | 0.881356 | 2.20339 | Muntiacus reevesi | 9886 | Chordata | Chordata | 43.1 | 0.0299 | NR | XP_065769915.1 | 9886 | g14830 | i0 | 39.3 | 0.672 | 56 | 34 | 67.2 | 0 | 63 | 230 | 68 | 123 | XP_065769915.1 solute carrier family 9 member C1 [Muntiacus reevesi] | diamond | 168 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Muntiacus | Muntiacus reevesi | |
| 29053316 | 29053316 | PRJNA942359_P_NODE_18348_length_245_cov_0.906977_g18233_i0 | PRJNA942359 | 18348 | 245 | 0.906977 | 2.22209365 | Mammalia | 40674 | Chordata | Chordata | 43.5 | 0.0197 | NR | XP_055448526.1 | 48139 | g18233 | i0 | 44.2 | 3.93061224489796 | 52 | 28 | 63.7 | 1 | 176 | 21 | 33 | 83 | XP_055448526.1 WD repeat domain phosphoinositide-interacting protein 3 [Psammomys obesus] | diamond | 963 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Psammomys | Psammomys obesus | |
| 30632208 | 30632208 | PRJNA942359_P_NODE_15053_length_250_cov_0.881356_g14938_i0 | PRJNA942359 | 15053 | 250 | 0.881356 | 2.20339 | Chordata | 7711 | Chordata | Chordata | 55.8 | 9.44e-7 | NR | XP_042194610.1 | 7868 | g14938 | i0 | 96 | 13.104 | 25 | 1 | 30 | 0 | 248 | 174 | 508 | 532 | XP_042194610.1 CTP synthase 1 isoform X2 [Callorhinchus milii] | diamond | 3276 | 56.2 | 0.99288256227758 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Chimaeriformes | Callorhinchidae | Callorhinchus | Callorhinchus milii | |
| 31668682 | 31668682 | PRJNA942359_P_NODE_19857_length_242_cov_0.923077_g19742_i0 | PRJNA942359 | 19857 | 242 | 0.923077 | 2.23384634 | Monodon monoceros | 40151 | Chordata | Chordata | 44.3 | 0.011 | NR | TKC37999.1 | 40151 | g19742 | i0 | 71 | 0.384297520661157 | 31 | 8 | 37.2 | 1 | 182 | 93 | 1747 | 1777 | TKC37999.1 hypothetical protein EI555_002844, partial [Monodon monoceros] | diamond | 93 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Monodontidae | Monodon | Monodon monoceros | |
| 32837955 | 32837955 | PRJNA942359_P_NODE_19140_length_243_cov_1.835294_g19025_i0 | PRJNA942359 | 19140 | 243 | 1.835294 | 4.45976442 | Oryctolagus cuniculus | 9986 | Chordata | Chordata | 161 | 7.61e-49 | NR | XP_002715572.2 | 9986 | g19025 | i0 | 98.8 | 79.0123456790123 | 80 | 1 | 98.8 | 0 | 243 | 4 | 2 | 81 | XP_002715572.2 large ribosomal subunit protein eL43-like [Oryctolagus cuniculus] | diamond | 19200 | 162 | 0.993827160493827 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Lagomorpha | Leporidae | Oryctolagus | Oryctolagus cuniculus |
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);;