contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA274362" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2921473 | 2921473 | PRJNA274362_S_NODE_35943_length_164_cov_0.904348_g35823_i0 | PRJNA274362 | 35943 | 164 | 0.904348 | 1.48313072 | Chordata | 7711 | Chordata | Chordata | 112 | 9.959999999999999e-29 | NR | XP_038662558.1 | 7830 | g35823 | i0 | 85.2 | 34.2256097560976 | 54 | 8 | 98.8 | 0 | 1 | 162 | 213 | 266 | XP_038662558.1 cytochrome b-c1 complex subunit Rieske, mitochondrial [Scyliorhinus canicula] | diamond | 5613 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Carcharhiniformes | Scyliorhinidae | Scyliorhinus | Scyliorhinus canicula | |
| 8023966 | 8023966 | PRJNA274362_S_NODE_2567_length_509_cov_2.332609_g2450_i0 | PRJNA274362 | 2567 | 509 | 2.332609 | 11.87297981 | Opisthokonta | 33154 | Chordata | Chordata | 130 | 4.09e-34 | NR | XP_019638574.1 | 7741 | g2450 | i0 | 56.5 | 3.18860510805501 | 138 | 58 | 80.7 | 2 | 509 | 99 | 108 | 244 | XP_019638574.1 PREDICTED: 40S ribosomal protein S6 [Branchiostoma belcheri] | diamond | 1623 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 11849195 | 11849195 | PRJNA274362_S_NODE_23710_length_192_cov_1.454545_g23590_i0 | PRJNA274362 | 23710 | 192 | 1.454545 | 2.7927264 | Chordata | 7711 | Chordata | Chordata | 114 | 1.76e-30 | NR | NP_001027678.1 | 7719 | g23590 | i0 | 93.1 | 16.453125 | 58 | 4 | 90.6 | 0 | 17 | 190 | 1 | 58 | NP_001027678.1 small ribosomal subunit protein uS15 [Ciona intestinalis] | diamond | 3159 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 22046981 | 22046981 | PRJNA274362_S_NODE_19598_length_208_cov_0.981132_g19478_i0 | PRJNA274362 | 19598 | 208 | 0.981132 | 2.04075456 | Heptranchias perlo | 212740 | Chordata | Chordata | 115 | 5.56e-29 | NR | XP_067845628.1 | 212740 | g19478 | i0 | 78.3 | 13.9326923076923 | 69 | 15 | 99.5 | 0 | 1 | 207 | 116 | 184 | XP_067845628.1 malate dehydrogenase 1Ab, NAD (soluble) [Heptranchias perlo] | diamond | 2898 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Hexanchiformes | Hexanchidae | Heptranchias | Heptranchias perlo | |
| 26789350 | 26789350 | PRJNA274362_S_NODE_37461_length_162_cov_0.920354_g37341_i0 | PRJNA274362 | 37461 | 162 | 0.920354 | 1.49097348 | Styela clava | 7725 | Chordata | Chordata | 59.3 | 1.82e-8 | NR | XP_039248744.1 | 7725 | g37341 | i0 | 65.2 | 2.62962962962963 | 46 | 16 | 85.2 | 0 | 16 | 153 | 1566 | 1611 | XP_039248744.1 rootletin-like isoform X3 [Styela clava] | diamond | 426 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 28179238 | 28179238 | PRJNA274362_S_NODE_37086_length_162_cov_1.840708_g36966_i0 | PRJNA274362 | 37086 | 162 | 1.840708 | 2.98194696 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 55.8 | 7.58e-8 | NR | XP_019642967.1 | 7741 | g36966 | i0 | 52.5 | 2.96296296296296 | 40 | 19 | 74.1 | 0 | 1 | 120 | 114 | 153 | XP_019642967.1 PREDICTED: eukaryotic translation initiation factor 5A-1-like [Branchiostoma belcheri] | diamond | 480 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 28432120 | 28432120 | PRJNA274362_S_NODE_37466_length_162_cov_0.920354_g37346_i0 | PRJNA274362 | 37466 | 162 | 0.920354 | 1.49097348 | Suncus etruscus | 109475 | Chordata | Chordata | 68.6 | 5.02e-12 | NR | XP_049637544.1 | 109475 | g37346 | i0 | 63 | 106.962962962963 | 54 | 20 | 100 | 0 | 1 | 162 | 84 | 137 | XP_049637544.1 LOW QUALITY PROTEIN: YEATS domain-containing protein 4-like [Suncus etruscus] | diamond | 17328 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Soricidae | Suncus | Suncus etruscus | |
| 29063676 | 29063676 | PRJNA274362_S_NODE_16648_length_222_cov_1.456647_g16528_i0 | PRJNA274362 | 16648 | 222 | 1.456647 | 3.23375634 | Vombatus ursinus | 29139 | Chordata | Chordata | 85.1 | 5.8e-18 | NR | XP_027699060.1 | 29139 | g16528 | i0 | 59.4 | 2.55405405405405 | 64 | 24 | 83.8 | 1 | 35 | 220 | 11 | 74 | XP_027699060.1 chymotrypsinogen B-like [Vombatus ursinus] | diamond | 567 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Diprotodontia | Vombatidae | Vombatus | Vombatus ursinus | |
| 29302297 | 29302297 | PRJNA274362_S_NODE_21869_length_199_cov_1.040000_g21749_i0 | PRJNA274362 | 21869 | 199 | 1.04 | 2.0696 | Branchiostoma | 7737 | Chordata | Chordata | 81.3 | 5.42e-16 | NR | XP_035687059.1 | 7739 | g21749 | i0 | 60.6 | 3.01507537688442 | 66 | 25 | 98 | 1 | 2 | 196 | 34 | 99 | XP_035687059.1 polyamine oxidase 7-like [Branchiostoma floridae] | diamond | 600 | 81.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 29586146 | 29586146 | PRJNA274362_S_NODE_4590_length_389_cov_1.355882_g4470_i0 | PRJNA274362 | 4590 | 389 | 1.355882 | 5.27438098 | Metazoa | 33208 | Chordata | Chordata | 58.5 | 5.24e-7 | NR | XP_064286476.1 | 48849 | g4470 | i0 | 47.8 | 5.69151670951157 | 67 | 34 | 51.7 | 1 | 2 | 202 | 401 | 466 | XP_064286476.1 voltage-dependent anion-selective channel protein 2 [Passer domesticus] | diamond | 2214 | 58.9 | 0.99320882852292 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Passeridae | Passer | Passer domesticus | |
| 29680844 | 29680844 | PRJNA274362_S_NODE_33970_length_166_cov_1.333333_g33850_i0 | PRJNA274362 | 33970 | 166 | 1.333333 | 2.21333278 | Opisthokonta | 33154 | Chordata | Chordata | 98.2 | 4.959999999999999e-23 | NR | XP_032830674.1 | 7757 | g33850 | i0 | 79.6 | 18.5602409638554 | 54 | 11 | 97.6 | 0 | 162 | 1 | 37 | 90 | XP_032830674.1 40S ribosomal protein SA [Petromyzon marinus] | diamond | 3081 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Petromyzon | Petromyzon marinus | |
| 29884671 | 29884671 | PRJNA274362_S_NODE_16351_length_224_cov_1.074286_g16231_i0 | PRJNA274362 | 16351 | 224 | 1.074286 | 2.40640064 | Callorhinchus milii | 7868 | Chordata | Chordata | 78.2 | 3.92e-15 | NR | NP_001279040.1 | 7868 | g16231 | i0 | 59.5 | 9.91071428571429 | 74 | 23 | 99.1 | 1 | 222 | 1 | 217 | 283 | NP_001279040.1 60S ribosomal protein L5b [Callorhinchus milii] | diamond | 2220 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Chimaeriformes | Callorhinchidae | Callorhinchus | Callorhinchus milii | |
| 30105543 | 30105543 | PRJNA274362_S_NODE_1112_length_728_cov_2.416789_g1026_i0 | PRJNA274362 | 1112 | 728 | 2.416789 | 17.59422392 | Styela clava | 7725 | Chordata | Chordata | 175 | 8.329999999999999e-52 | NR | XP_039257366.1 | 7725 | g1026 | i0 | 58.2 | 2.18406593406593 | 141 | 59 | 58.1 | 0 | 635 | 213 | 1 | 141 | XP_039257366.1 40S ribosomal protein S12-like [Styela clava] | diamond | 1590 | 175 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 30597161 | 30597161 | PRJNA274362_S_NODE_36333_length_163_cov_1.403509_g36213_i0 | PRJNA274362 | 36333 | 163 | 1.403509 | 2.28771967 | Anura | 8342 | Chordata | Chordata | 66.2 | 6.28e-11 | NR | MEE6481935.1 | 8439 | g36213 | i0 | 66.7 | 20.6503067484663 | 51 | 17 | 93.9 | 0 | 163 | 11 | 176 | 226 | MEE6481935.1 hypothetical protein [Ascaphus truei] | diamond | 3366 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ascaphidae | Ascaphus | Ascaphus truei | |
| 30863848 | 30863848 | PRJNA274362_S_NODE_14714_length_234_cov_1.259459_g14594_i0 | PRJNA274362 | 14714 | 234 | 1.259459 | 2.9471340600000002 | Branchiostoma floridae | 7739 | Chordata | Chordata | 70.5 | 3.8e-12 | NR | XP_035669233.1 | 7739 | g14594 | i0 | 73.9 | 7.78205128205128 | 46 | 11 | 59 | 1 | 1 | 138 | 273 | 317 | XP_035669233.1 guanine nucleotide-binding protein subunit beta-2-like 1 [Branchiostoma floridae] | diamond | 1821 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma floridae | |
| 31292386 | 31292386 | PRJNA274362_S_NODE_2935_length_480_cov_1.628770_g2816_i0 | PRJNA274362 | 2935 | 480 | 1.62877 | 7.818096 | Opisthokonta | 33154 | Chordata | Chordata | 158 | 1.94e-46 | NR | XP_066263347.1 | 7740 | g2816 | i0 | 67.3 | 5.55625 | 110 | 36 | 68.8 | 0 | 476 | 147 | 7 | 116 | XP_066263347.1 small ribosomal subunit protein eS26-like isoform X2 [Branchiostoma lanceolatum] | diamond | 2667 | 159 | 0.993710691823899 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma lanceolatum | |
| 31608788 | 31608788 | PRJNA274362_S_NODE_5236_length_365_cov_2.778481_g5116_i0 | PRJNA274362 | 5236 | 365 | 2.778481 | 10.14145565 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 176 | 2.4499999999999994e-52 | NR | XP_069097964.1 | 8319 | g5116 | i0 | 78 | 45.8547945205479 | 109 | 24 | 89.6 | 0 | 336 | 10 | 1 | 109 | XP_069097964.1 large ribosomal subunit protein uL18B-like [Pleurodeles waltl] | diamond | 16737 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl | |
| 32146612 | 32146612 | PRJNA274362_S_NODE_35218_length_165_cov_0.896552_g35098_i0 | PRJNA274362 | 35218 | 165 | 0.896552 | 1.4793108 | Chordata | 7711 | Chordata | Chordata | 79.7 | 1.17e-15 | NR | XP_018667949.1 | 7719 | g35098 | i0 | 64.2 | 4.72727272727273 | 53 | 17 | 94.5 | 2 | 163 | 8 | 1417 | 1468 | XP_018667949.1 maltase-glucoamylase, intestinal [Ciona intestinalis] | diamond | 780 | 80.5 | 0.990062111801242 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Phlebobranchia | Cionidae | Ciona | Ciona intestinalis | |
| 32872741 | 32872741 | PRJNA274362_S_NODE_37780_length_162_cov_0.867257_g37660_i0 | PRJNA274362 | 37780 | 162 | 0.867257 | 1.40495634 | Anura | 8342 | Chordata | Chordata | 41.2 | 0.0428 | NR | XP_040200730.1 | 8407 | g37660 | i0 | 85.7 | 3 | 21 | 3 | 38.9 | 0 | 99 | 161 | 47 | 67 | XP_040200730.1 heterogeneous nuclear ribonucleoprotein A/B isoform X2 [Rana temporaria] | diamond | 486 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Rana | Rana temporaria |
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);;