contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA641991" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3168609 | 3168609 | PRJNA641991_S_NODE_1203_length_481_cov_5.206019_g1084_i0 | PRJNA641991 | 1203 | 481 | 5.206019 | 25.04095139 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 251 | 8.48e-83 | NR | KAI8508455.1 | 7741 | g1084 | i0 | 95.3 | 46.5280665280665 | 129 | 6 | 80.5 | 0 | 3 | 389 | 35 | 163 | KAI8508455.1 Ubiquitin-60S ribosomal protein L40 [Branchiostoma belcheri] | diamond | 22380 | 252 | 0.996031746031746 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 4445423 | 4445423 | PRJNA641991_P_NODE_2284_length_201_cov_1.644737_g2243_i0 | PRJNA641991 | 2284 | 201 | 1.644737 | 3.30592137 | root | 1 | Root_unresolved | Root_unresolved | 108 | 2.38e-28 | NR | KAE8577506.1 | 8364 | g2243 | i0 | 90.7 | 53.1940298507463 | 54 | 5 | 80.6 | 0 | 201 | 40 | 80 | 133 | KAE8577506.1 hypothetical protein XENTR_v10004594 [Xenopus tropicalis] | diamond | 10692 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus tropicalis | |
| 12097218 | 12097218 | PRJNA641991_S_NODE_9430_length_184_cov_1.888889_g9311_i0 | PRJNA641991 | 9430 | 184 | 1.888889 | 3.47555576 | Styela clava | 7725 | Chordata | Chordata | 123 | 8e-31 | NR | XP_039264901.1 | 7725 | g9311 | i0 | 100 | 8.95108695652174 | 61 | 0 | 99.5 | 0 | 183 | 1 | 396 | 456 | XP_039264901.1 putative pre-mRNA-splicing factor ATP-dependent RNA helicase PRP1 [Styela clava] | diamond | 1647 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 27049736 | 27049736 | PRJNA641991_S_NODE_12462_length_166_cov_0.871795_g12343_i0 | PRJNA641991 | 12462 | 166 | 0.871795 | 1.4471797 | Myodes glareolus | 447135 | Chordata | Chordata | 45.8 | 0.00102 | NR | KAK7798099.1 | 447135 | g12343 | i0 | 54 | 4.62650602409639 | 50 | 23 | 90.4 | 0 | 152 | 3 | 151 | 200 | KAK7798099.1 hypothetical protein U0070_011690 [Myodes glareolus] | diamond | 768 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Myodes | Myodes glareolus | |
| 27409824 | 27409824 | PRJNA641991_S_NODE_12903_length_165_cov_0.879310_g12784_i0 | PRJNA641991 | 12903 | 165 | 0.87931 | 1.4508615 | Metazoa | 33208 | Chordata | Chordata | 112 | 4.87e-27 | NR | XP_006169838.1 | 246437 | g12784 | i0 | 94.4 | 51.0545454545455 | 54 | 3 | 98.2 | 0 | 163 | 2 | 534 | 587 | XP_006169838.1 urocanate hydratase [Tupaia chinensis] | diamond | 8424 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Scandentia | Tupaiidae | Tupaia | Tupaia chinensis | |
| 27694084 | 27694084 | PRJNA641991_S_NODE_5304_length_234_cov_1.929730_g5185_i0 | PRJNA641991 | 5304 | 234 | 1.92973 | 4.5155682 | Metazoa | 33208 | Chordata | Chordata | 45.4 | 0.00369 | NR | XP_067962748.1 | 7769 | g5185 | i0 | 60 | 1.20512820512821 | 40 | 16 | 51.3 | 0 | 213 | 94 | 306 | 345 | XP_067962748.1 large ribosomal subunit protein uL4 [Myxine glutinosa] | diamond | 282 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 28028908 | 28028908 | PRJNA641991_S_NODE_105_length_1335_cov_4.807154_g70_i0 | PRJNA641991 | 105 | 1335 | 4.807154 | 64.1755059 | Hyperolius riggenbachi | 752182 | Chordata | Chordata | 154 | 1.21e-38 | NR | XP_068130257.1 | 752182 | g70 | i0 | 29.9 | 0.759550561797753 | 338 | 229 | 75.1 | 4 | 1294 | 293 | 33 | 366 | XP_068130257.1 uncharacterized protein [Hyperolius riggenbachi] | diamond | 1014 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Hyperoliidae | Hyperolius | Hyperolius riggenbachi | |
| 28281170 | 28281170 | PRJNA641991_S_NODE_10846_length_174_cov_0.944000_g10727_i0 | PRJNA641991 | 10846 | 174 | 0.944 | 1.64256 | Myotis myotis | 51298 | Chordata | Chordata | 44.3 | 0.00411 | NR | KAF6319703.1 | 51298 | g10727 | i0 | 51 | 0.844827586206897 | 49 | 24 | 84.5 | 0 | 6 | 152 | 101 | 149 | KAF6319703.1 hypothetical protein mMyoMyo1_008442 [Myotis myotis] | diamond | 147 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Vespertilionidae | Myotis | Myotis myotis | |
| 28534171 | 28534171 | PRJNA641991_P_NODE_307_length_667_cov_4.150485_g272_i0 | PRJNA641991 | 307 | 667 | 4.150485 | 27.68373495 | Hyperolius riggenbachi | 752182 | Chordata | Chordata | 82 | 3.07e-14 | NR | XP_068130257.1 | 752182 | g272 | i0 | 35 | 0.52623688155922 | 117 | 76 | 52.6 | 0 | 619 | 269 | 250 | 366 | XP_068130257.1 uncharacterized protein [Hyperolius riggenbachi] | diamond | 351 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Hyperoliidae | Hyperolius | Hyperolius riggenbachi | |
| 28641169 | 28641169 | PRJNA641991_S_NODE_13027_length_165_cov_0.879310_g12908_i0 | PRJNA641991 | 13027 | 165 | 0.87931 | 1.4508615 | root | 1 | Root_unresolved | Root_unresolved | 99.4 | 3.169999999999999e-23 | NR | XP_035662816.1 | 7739 | g12908 | i0 | 83.3 | 19.6363636363636 | 54 | 9 | 98.2 | 0 | 163 | 2 | 185 | 238 | XP_035662816.1 transaldolase-like [Branchiostoma floridae] | diamond | 3240 | 100 | 0.994 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 28692062 | 28692062 | PRJNA641991_S_NODE_9147_length_187_cov_0.949275_g9028_i0 | PRJNA641991 | 9147 | 187 | 0.949275 | 1.77514425 | Dromiciops gliroides | 33562 | Chordata | Chordata | 57 | 5.74e-8 | NR | XP_043835392.1 | 33562 | g9028 | i0 | 59.3 | 1.89304812834225 | 59 | 24 | 94.7 | 0 | 11 | 187 | 99 | 157 | XP_043835392.1 40S ribosomal protein S14-like [Dromiciops gliroides] | diamond | 354 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Microbiotheria | Microbiotheriidae | Dromiciops | Dromiciops gliroides | |
| 28817822 | 28817822 | PRJNA641991_S_NODE_11968_length_167_cov_1.084746_g11849_i0 | PRJNA641991 | 11968 | 167 | 1.084746 | 1.81152582 | Clavelina lepadiformis | 159417 | Chordata | Chordata | 49.3 | 6.5e-5 | NR | CAK8689709.1 | 159417 | g11849 | i0 | 52.7 | 1.97604790419162 | 55 | 26 | 98.8 | 0 | 165 | 1 | 716 | 770 | CAK8689709.1 unnamed protein product [Clavelina lepadiformis] | diamond | 330 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Aplousobranchia | Clavelinidae | Clavelina | Clavelina lepadiformis | |
| 29355029 | 29355029 | PRJNA641991_S_NODE_6329_length_218_cov_0.840237_g6210_i0 | PRJNA641991 | 6329 | 218 | 0.840237 | 1.83171666 | Naja naja | 35670 | Chordata | Chordata | 67.4 | 5.4e-11 | NR | KAG8126575.1 | 35670 | g6210 | i0 | 57.1 | 0.963302752293578 | 70 | 30 | 96.3 | 0 | 7 | 216 | 158 | 227 | KAG8126575.1 hypothetical protein E2320_021724, partial [Naja naja] | diamond | 210 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Elapidae | Naja | Naja naja | |
| 29777550 | 29777550 | PRJNA641991_S_NODE_11951_length_167_cov_1.169492_g11832_i0 | PRJNA641991 | 11951 | 167 | 1.169492 | 1.95305164 | Chordata | 7711 | Chordata | Chordata | 57.4 | 8.98e-8 | NR | GCB81378.1 | 75743 | g11832 | i0 | 56.4 | 21.7365269461078 | 55 | 24 | 98.8 | 0 | 166 | 2 | 13 | 67 | GCB81378.1 hypothetical protein [Scyliorhinus torazame] | diamond | 3630 | 57.8 | 0.993079584775087 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Carcharhiniformes | Scyliorhinidae | Scyliorhinus | Scyliorhinus torazame | |
| 30554983 | 30554983 | PRJNA641991_S_NODE_13993_length_163_cov_0.885965_g13874_i0 | PRJNA641991 | 13993 | 163 | 0.885965 | 1.44412295 | Tyto alba | 56313 | Chordata | Chordata | 42.7 | 0.0123 | NR | KFV41833.1 | 56313 | g13874 | i0 | 39.2 | 0.938650306748466 | 51 | 31 | 93.9 | 0 | 161 | 9 | 377 | 427 | KFV41833.1 Leucine-rich repeat-containing protein 40, partial [Tyto alba] | diamond | 153 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Strigiformes | Tytonidae | Tyto | Tyto alba | |
| 31610665 | 31610665 | PRJNA641991_S_NODE_14756_length_161_cov_0.910714_g14637_i0 | PRJNA641991 | 14756 | 161 | 0.910714 | 1.46624954 | Mammalia | 40674 | Chordata | Chordata | 60.8 | 4.95e-9 | NR | KAJ8778150.1 | 9764 | g14637 | i0 | 59.6 | 35.7763975155279 | 52 | 20 | 95 | 1 | 6 | 158 | 74 | 125 | KAJ8778150.1 hypothetical protein J1605_013866, partial [Eschrichtius robustus] | diamond | 5760 | 61.2 | 0.993464052287582 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Eschrichtiidae | Eschrichtius | Eschrichtius robustus | |
| 32148426 | 32148426 | PRJNA641991_S_NODE_10538_length_176_cov_1.196850_g10419_i0 | PRJNA641991 | 10538 | 176 | 1.19685 | 2.106456 | Metazoa | 33208 | Chordata | Chordata | 50.1 | 3.93e-5 | NR | XP_035675612.1 | 7739 | g10419 | i0 | 91.7 | 3.68181818181818 | 24 | 2 | 40.9 | 0 | 174 | 103 | 556 | 579 | XP_035675612.1 protein mono-ADP-ribosyltransferase PARP3-like [Branchiostoma floridae] | diamond | 648 | 50.4 | 0.994047619047619 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 32231197 | 32231197 | PRJNA641991_S_NODE_13278_length_164_cov_0.886957_g13159_i0 | PRJNA641991 | 13278 | 164 | 0.886957 | 1.45460948 | Monodon monoceros | 40151 | Chordata | Chordata | 53.9 | 1.05e-7 | NR | TKC37834.1 | 40151 | g13159 | i0 | 59.2 | 3.58536585365854 | 49 | 20 | 89.6 | 0 | 153 | 7 | 18 | 66 | TKC37834.1 hypothetical protein EI555_012850 [Monodon monoceros] | diamond | 588 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Monodontidae | Monodon | Monodon monoceros | |
| 32370039 | 32370039 | PRJNA641991_S_NODE_13279_length_164_cov_0.886957_g13160_i0 | PRJNA641991 | 13279 | 164 | 0.886957 | 1.45460948 | Chordata | 7711 | Chordata | Chordata | 41.6 | 0.0306 | NR | XP_055512776.1 | 7782 | g13160 | i0 | 55.6 | 189.658536585366 | 54 | 24 | 98.8 | 0 | 3 | 164 | 45 | 98 | XP_055512776.1 60S ribosomal protein L19 [Leucoraja erinaceus] | diamond | 31104 | 42 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Rajiformes | Rajidae | Leucoraja | Leucoraja erinaceus | |
| 32547625 | 32547625 | PRJNA641991_S_NODE_14879_length_161_cov_0.910714_g14760_i0 | PRJNA641991 | 14879 | 161 | 0.910714 | 1.46624954 | Rousettus aegyptiacus | 9407 | Chordata | Chordata | 71.2 | 4.79e-13 | NR | KAF6442538.1 | 9407 | g14760 | i0 | 63.8 | 0.875776397515528 | 47 | 17 | 87.6 | 0 | 6 | 146 | 5 | 51 | KAF6442538.1 transducin beta like 3 [Rousettus aegyptiacus] | diamond | 141 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Pteropodidae | Rousettus | Rousettus aegyptiacus | |
| 32579153 | 32579153 | PRJNA641991_S_NODE_14699_length_161_cov_0.910714_g14580_i0 | PRJNA641991 | 14699 | 161 | 0.910714 | 1.46624954 | Hyla sarda | 327740 | Chordata | Chordata | 49.3 | 5.94e-5 | NR | XP_056400904.1 | 327740 | g14580 | i0 | 52.5 | 0.745341614906832 | 40 | 19 | 74.5 | 0 | 1 | 120 | 572 | 611 | XP_056400904.1 heat shock-related 70 kDa protein 2 [Hyla sarda] | diamond | 120 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Hylidae | Hyla | Hyla sarda | |
| 32641666 | 32641666 | PRJNA641991_S_NODE_6020_length_222_cov_1.872832_g5901_i0 | PRJNA641991 | 6020 | 222 | 1.872832 | 4.15768704 | Bufotes viridis | 30338 | Chordata | Chordata | 46.2 | 0.00162 | NR | CAK8629749.1 | 30338 | g5901 | i0 | 50 | 0.486486486486487 | 36 | 18 | 48.6 | 0 | 32 | 139 | 329 | 364 | CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] | diamond | 108 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis |
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);;