contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA999043" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3530478 | 3530478 | PRJNA999043_P_NODE_23463_length_245_cov_0.895349_g23368_i0 | PRJNA999043 | 23463 | 245 | 0.895349 | 2.19360505 | Alectoris rufa | 9079 | Chordata | Chordata | 86.7 | 1.54e-19 | NR | CAK6566519.1 | 9079 | g23368 | i0 | 75 | 2.08163265306122 | 56 | 14 | 68.6 | 0 | 74 | 241 | 80 | 135 | CAK6566519.1 unnamed protein product [Alectoris rufa] | diamond | 510 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Alectoris | Alectoris rufa | |
| 8632982 | 8632982 | PRJNA999043_P_NODE_24087_length_243_cov_0.905882_g23992_i0 | PRJNA999043 | 24087 | 243 | 0.905882 | 2.20129326 | Alectoris rufa | 9079 | Chordata | Chordata | 86.3 | 7.91e-19 | NR | CAK6566476.1 | 9079 | g23992 | i0 | 61.1 | 0.888888888888889 | 72 | 28 | 88.9 | 0 | 15 | 230 | 80 | 151 | CAK6566476.1 unnamed protein product [Alectoris rufa] | diamond | 216 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Alectoris | Alectoris rufa | |
| 15007700 | 15007700 | PRJNA999043_P_NODE_23172_length_246_cov_0.890173_g23077_i0 | PRJNA999043 | 23172 | 246 | 0.890173 | 2.18982558 | Alectoris rufa | 9079 | Chordata | Chordata | 65.9 | 1.04e-10 | NR | CAK6571032.1 | 9079 | g23077 | i0 | 49.2 | 0.74390243902439 | 61 | 31 | 74.4 | 0 | 197 | 15 | 164 | 224 | CAK6571032.1 unnamed protein product [Alectoris rufa] | diamond | 183 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Alectoris | Alectoris rufa | |
| 26684042 | 26684042 | PRJNA999043_P_NODE_24381_length_242_cov_0.911243_g24286_i0 | PRJNA999043 | 24381 | 242 | 0.911243 | 2.20520806 | Phasianidae | 9005 | Chordata | Chordata | 82 | 2.91e-16 | NR | AQM51742.1 | 9043 | g24286 | i0 | 72.4 | 5.03305785123967 | 58 | 16 | 71.9 | 0 | 174 | 1 | 85 | 142 | AQM51742.1 NADH dehydrogenase subunit 2 [Lophura edwardsi] | diamond | 1218 | 82.8 | 0.990338164251208 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Lophura | Lophura edwardsi | |
| 26709618 | 26709618 | PRJNA999043_P_NODE_23261_length_246_cov_0.890173_g23166_i0 | PRJNA999043 | 23261 | 246 | 0.890173 | 2.18982558 | Meleagris gallopavo | 9103 | Chordata | Chordata | 43.1 | 0.0264 | NR | XP_031409115.1 | 9103 | g23166 | i0 | 45.3 | 0.646341463414634 | 53 | 29 | 64.6 | 0 | 62 | 220 | 265 | 317 | XP_031409115.1 protein mono-ADP-ribosyltransferase PARP14-like [Meleagris gallopavo] | diamond | 159 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Meleagris | Meleagris gallopavo | |
| 27632719 | 27632719 | PRJNA999043_P_NODE_24484_length_242_cov_0.911243_g24389_i0 | PRJNA999043 | 24484 | 242 | 0.911243 | 2.20520806 | Chordata | 7711 | Chordata | Chordata | 52.8 | 1.09e-5 | NR | XP_051779371.1 | 27687 | g24389 | i0 | 52.5 | 2.97520661157025 | 40 | 19 | 49.6 | 0 | 241 | 122 | 691 | 730 | XP_051779371.1 probable E3 ubiquitin-protein ligase HERC4 isoform X2 [Erpetoichthys calabaricus] | diamond | 720 | 53.1 | 0.994350282485876 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 27727731 | 27727731 | PRJNA999043_P_NODE_22304_length_249_cov_0.875000_g22209_i0 | PRJNA999043 | 22304 | 249 | 0.875 | 2.17875 | Chordata | 7711 | Chordata | Chordata | 62.4 | 4.97e-9 | NR | XP_039909930.1 | 43150 | g22209 | i0 | 66.7 | 9.21686746987952 | 45 | 15 | 54.2 | 0 | 249 | 115 | 734 | 778 | XP_039909930.1 LOW QUALITY PROTEIN: stAR-related lipid transfer protein 13-like, partial [Hirundo rustica] | diamond | 2295 | 62.8 | 0.993630573248408 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Hirundinidae | Hirundo | Hirundo rustica | |
| 27847691 | 27847691 | PRJNA999043_P_NODE_20924_length_258_cov_0.859459_g20829_i0 | PRJNA999043 | 20924 | 258 | 0.859459 | 2.21740422 | Mycteria americana | 33587 | Chordata | Chordata | 87.4 | 1.04e-18 | NR | KAK4830788.1 | 33587 | g20829 | i0 | 62.5 | 1.67441860465116 | 72 | 27 | 83.7 | 0 | 221 | 6 | 172 | 243 | KAK4830788.1 hypothetical protein QYF61_013621 [Mycteria americana] | diamond | 432 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Ciconiiformes | Ciconiidae | Mycteria | Mycteria americana | |
| 28763369 | 28763369 | PRJNA999043_P_NODE_17367_length_312_cov_0.857741_g17272_i0 | PRJNA999043 | 17367 | 312 | 0.857741 | 2.67615192 | Grus japonensis | 30415 | Chordata | Chordata | 65.9 | 2.14e-10 | NR | GAB0181774.1 | 30415 | g17272 | i0 | 41.1 | 3.43269230769231 | 90 | 53 | 86.5 | 0 | 272 | 3 | 94 | 183 | GAB0181774.1 hypothetical protein GRJ2_000642700 [Grus japonensis] | diamond | 1071 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Gruiformes | Gruidae | Grus | Grus japonensis | |
| 29653055 | 29653055 | PRJNA999043_P_NODE_23510_length_245_cov_0.895349_g23415_i0 | PRJNA999043 | 23510 | 245 | 0.895349 | 2.19360505 | Chordata | 7711 | Chordata | Chordata | 52.4 | 1.5e-5 | NR | XP_006001705.1 | 7897 | g23415 | i0 | 87.5 | 4.99591836734694 | 24 | 3 | 29.4 | 0 | 194 | 123 | 141 | 164 | XP_006001705.1 dual specificity protein kinase CLK2 [Latimeria chalumnae] | diamond | 1224 | 52.8 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Chordata | Coelacanthiformes | Coelacanthidae | Latimeria | Latimeria chalumnae | ||
| 30406088 | 30406088 | PRJNA999043_P_NODE_22533_length_248_cov_0.880000_g22438_i0 | PRJNA999043 | 22533 | 248 | 0.88 | 2.1824 | Ovis aries | 9940 | Chordata | Chordata | 63.5 | 1.82e-9 | NR | XDA77494.1 | 9940 | g22438 | i0 | 52.5 | 0.967741935483871 | 80 | 38 | 96.8 | 0 | 4 | 243 | 236 | 315 | XDA77494.1 hypothetical protein R6Z07_007693 [Ovis aries] | diamond | 240 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis aries | |
| 31638260 | 31638260 | PRJNA999043_P_NODE_24496_length_242_cov_0.911243_g24401_i0 | PRJNA999043 | 24496 | 242 | 0.911243 | 2.20520806 | Alectoris rufa | 9079 | Chordata | Chordata | 47 | 7.54e-4 | NR | CAK6567702.1 | 9079 | g24401 | i0 | 41.9 | 0.768595041322314 | 62 | 29 | 68.2 | 1 | 59 | 223 | 133 | 194 | CAK6567702.1 unnamed protein product [Alectoris rufa] | diamond | 186 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Alectoris | Alectoris rufa | |
| 31859652 | 31859652 | PRJNA999043_P_NODE_16597_length_326_cov_3.189723_g16502_i0 | PRJNA999043 | 16597 | 326 | 3.189723 | 10.398496979999999 | Bufotes viridis | 30338 | Chordata | Chordata | 67 | 8.5e-11 | NR | CAK8641430.1 | 30338 | g16502 | i0 | 48.8 | 2.17177914110429 | 86 | 42 | 78.2 | 2 | 2 | 256 | 136 | 220 | CAK8641430.1 Transposable element Tc3 transposase [Bufotes viridis] | diamond | 708 | 67.4 | 0.99406528189911 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 31986200 | 31986200 | PRJNA999043_P_NODE_23958_length_244_cov_0.888889_g23863_i0 | PRJNA999043 | 23958 | 244 | 0.888889 | 2.16888916 | Alectoris rufa | 9079 | Chordata | Chordata | 48.5 | 8.88e-5 | NR | CAK6566379.1 | 9079 | g23863 | i0 | 64.5 | 0.762295081967213 | 31 | 11 | 38.1 | 0 | 113 | 205 | 77 | 107 | CAK6566379.1 unnamed protein product [Alectoris rufa] | diamond | 186 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Alectoris | Alectoris rufa |
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);;