contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA993416" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27474750 | 27474750 | PRJNA993416_P_NODE_15683_length_242_cov_0.952663_g15578_i0 | PRJNA993416 | 15683 | 242 | 0.952663 | 2.30544446 | Anura | 8342 | Chordata | Chordata | 62 | 5.94e-9 | NR | XP_053548577.1 | 8345 | g15578 | i0 | 52.9 | 66.8181818181818 | 70 | 33 | 86.8 | 0 | 13 | 222 | 551 | 620 | XP_053548577.1 ubiquitin thioesterase ZRANB1 [Bombina bombina] | diamond | 16170 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bombinatoridae | Bombina | Bombina bombina | |
| 28384504 | 28384504 | PRJNA993416_P_NODE_2806_length_511_cov_6.374429_g2701_i0 | PRJNA993416 | 2806 | 511 | 6.374429 | 32.57333219 | Bufotes viridis | 30338 | Chordata | Chordata | 80.5 | 4.64e-15 | NR | CAK8641430.1 | 30338 | g2701 | i0 | 53.8 | 0.469667318982387 | 80 | 35 | 46.4 | 2 | 1 | 237 | 142 | 220 | CAK8641430.1 Transposable element Tc3 transposase [Bufotes viridis] | diamond | 240 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 28731900 | 28731900 | PRJNA993416_P_NODE_10287_length_271_cov_2.318182_g10182_i0 | PRJNA993416 | 10287 | 271 | 2.318182 | 6.28227322 | Apaloderma vittatum | 57397 | Chordata | Chordata | 59.3 | 9.7e-9 | NR | XP_009873761.1 | 57397 | g10182 | i0 | 58.3 | 0.929889298892989 | 84 | 35 | 93 | 0 | 15 | 266 | 1 | 84 | XP_009873761.1 PREDICTED: F-box/LRR-repeat protein 14, partial [Apaloderma vittatum] | diamond | 252 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Trogoniformes | Trogonidae | Apaloderma | Apaloderma vittatum | |
| 28858049 | 28858049 | PRJNA993416_P_NODE_2008_length_609_cov_3.503731_g1906_i0 | PRJNA993416 | 2008 | 609 | 3.503731 | 21.33772179 | Bufotes viridis | 30338 | Chordata | Chordata | 110 | 5.35e-26 | NR | CAK8641430.1 | 30338 | g1906 | i0 | 52.3 | 0.916256157635468 | 111 | 51 | 54.2 | 2 | 6 | 335 | 111 | 220 | CAK8641430.1 Transposable element Tc3 transposase [Bufotes viridis] | diamond | 558 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 28895490 | 28895490 | PRJNA993416_P_NODE_12748_length_250_cov_0.870056_g12643_i0 | PRJNA993416 | 12748 | 250 | 0.870056 | 2.17514 | Chordata | 7711 | Chordata | Chordata | 169 | 6.78e-48 | NR | KAJ1131131.1 | 8319 | g12643 | i0 | 100 | 113.16 | 82 | 0 | 98.4 | 0 | 248 | 3 | 265 | 346 | KAJ1131131.1 hypothetical protein NDU88_009474 [Pleurodeles waltl] | diamond | 28290 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl | |
| 29047705 | 29047705 | PRJNA993416_P_NODE_12388_length_251_cov_0.865169_g12283_i0 | PRJNA993416 | 12388 | 251 | 0.865169 | 2.17157419 | Manis pentadactyla | 143292 | Chordata | Chordata | 108 | 5.899999999999999e-26 | NR | KAI5133326.1 | 143292 | g12283 | i0 | 63.4 | 40.1832669322709 | 82 | 30 | 98 | 0 | 1 | 246 | 262 | 343 | KAI5133326.1 Tubulin Alpha-3D Chain [Manis pentadactyla] | diamond | 10086 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Pholidota | Manidae | Manis | Manis pentadactyla | |
| 29394967 | 29394967 | PRJNA993416_P_NODE_2009_length_609_cov_3.324627_g1906_i1 | PRJNA993416 | 2009 | 609 | 3.324627 | 20.24697843 | Bufotes viridis | 30338 | Chordata | Chordata | 110 | 5.35e-26 | NR | CAK8641430.1 | 30338 | g1906 | i1 | 52.3 | 0.916256157635468 | 111 | 51 | 54.2 | 2 | 6 | 335 | 111 | 220 | CAK8641430.1 Transposable element Tc3 transposase [Bufotes viridis] | diamond | 558 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 30057932 | 30057932 | PRJNA993416_P_NODE_16591_length_229_cov_2.448718_g16486_i0 | PRJNA993416 | 16591 | 229 | 2.448718 | 5.60756422 | Polypterus senegalus | 55291 | Chordata | Chordata | 148 | 1.9e-39 | NR | KAG2469874.1 | 55291 | g16486 | i0 | 100 | 25.5458515283843 | 75 | 0 | 98.3 | 0 | 227 | 3 | 2122 | 2196 | KAG2469874.1 SPTN1 protein, partial [Polypterus senegalus] | diamond | 5850 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 30253820 | 30253820 | PRJNA993416_P_NODE_12072_length_253_cov_4.211111_g11967_i0 | PRJNA993416 | 12072 | 253 | 4.211111 | 10.65411083 | Amphibia | 8292 | Chordata | Chordata | 102 | 1.87e-23 | NR | KAJ1132056.1 | 8319 | g11967 | i0 | 65.1 | 36.4150197628459 | 83 | 29 | 98.4 | 0 | 3 | 251 | 162 | 244 | KAJ1132056.1 hypothetical protein NDU88_010386 [Pleurodeles waltl] | diamond | 9213 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl | |
| 30406039 | 30406039 | PRJNA993416_P_NODE_9953_length_274_cov_3.129353_g9848_i0 | PRJNA993416 | 9953 | 274 | 3.129353 | 8.57442722 | Polypterus senegalus | 55291 | Chordata | Chordata | 111 | 2.25e-26 | NR | KAG2463490.1 | 55291 | g9848 | i0 | 65.2 | 68.6058394160584 | 89 | 31 | 97.4 | 0 | 269 | 3 | 101 | 189 | KAG2463490.1 PRPS1 pyrophosphokinase, partial [Polypterus senegalus] | diamond | 18798 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 31069344 | 31069344 | PRJNA993416_P_NODE_16335_length_241_cov_0.821429_g16230_i0 | PRJNA993416 | 16335 | 241 | 0.821429 | 1.97964389 | Rhinatrema bivittatum | 194408 | Chordata | Chordata | 61.6 | 7.99e-9 | NR | XP_029463040.1 | 194408 | g16230 | i0 | 52.3 | 7.28215767634855 | 65 | 31 | 80.9 | 0 | 240 | 46 | 188 | 252 | XP_029463040.1 methionine--tRNA ligase, mitochondrial isoform X2 [Rhinatrema bivittatum] | diamond | 1755 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Gymnophiona | Rhinatrematidae | Rhinatrema | Rhinatrema bivittatum | |
| 31195111 | 31195111 | PRJNA993416_P_NODE_15655_length_242_cov_1.366864_g15550_i0 | PRJNA993416 | 15655 | 242 | 1.366864 | 3.30781088 | Bufotes viridis | 30338 | Chordata | Chordata | 173 | 2.0099999999999998e-52 | NR | CAK8659804.1 | 30338 | g15550 | i0 | 97.5 | 18.8057851239669 | 80 | 2 | 99.2 | 0 | 241 | 2 | 115 | 194 | CAK8659804.1 Proteasome subunit beta type-3, partial [Bufotes viridis] | diamond | 4551 | 174 | 0.994252873563218 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 31796258 | 31796258 | PRJNA993416_P_NODE_14397_length_246_cov_0.890173_g14292_i0 | PRJNA993416 | 14397 | 246 | 0.890173 | 2.18982558 | Monodon monoceros | 40151 | Chordata | Chordata | 119 | 1.16e-31 | NR | TKC53834.1 | 40151 | g14292 | i0 | 88.6 | 61.8780487804878 | 70 | 6 | 85.4 | 1 | 246 | 37 | 82 | 149 | TKC53834.1 hypothetical protein EI555_018584, partial [Monodon monoceros] | diamond | 15222 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Monodontidae | Monodon | Monodon monoceros | |
| 31897263 | 31897263 | PRJNA993416_P_NODE_12717_length_250_cov_1.305085_g12612_i0 | PRJNA993416 | 12717 | 250 | 1.305085 | 3.2627125 | Aves | 8782 | Chordata | Chordata | 116 | 1.7699999999999999e-28 | NR | XP_040431241.1 | 8869 | g12612 | i0 | 94.4 | 12.792 | 54 | 3 | 64.8 | 0 | 88 | 249 | 114 | 167 | XP_040431241.1 actin-related protein 2/3 complex subunit 1B isoform X1 [Cygnus olor] | diamond | 3198 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Anseriformes | Anatidae | Cygnus | Cygnus olor | |
| 32467065 | 32467065 | PRJNA993416_P_NODE_16619_length_227_cov_3.474026_g16514_i0 | PRJNA993416 | 16619 | 227 | 3.474026 | 7.88603902 | Mammalia | 40674 | Chordata | Chordata | 77.4 | 1.52e-14 | NR | XP_006895653.1 | 28737 | g16514 | i0 | 58.1 | 233.484581497797 | 74 | 31 | 97.8 | 0 | 2 | 223 | 172 | 245 | XP_006895653.1 PREDICTED: tubulin alpha-4A chain-like [Elephantulus edwardii] | diamond | 53001 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Macroscelidea | Macroscelididae | Elephantulus | Elephantulus edwardii | |
| 32876570 | 32876570 | PRJNA993416_P_NODE_8520_length_287_cov_1.079439_g8415_i0 | PRJNA993416 | 8520 | 287 | 1.079439 | 3.09798993 | Zosterops | 36298 | Chordata | Chordata | 183 | 1.3799999999999999e-52 | NR | TRZ09930.1 | 364589 | g8415 | i0 | 88.4 | 24.8257839721254 | 95 | 11 | 99.3 | 0 | 2 | 286 | 426 | 520 | TRZ09930.1 hypothetical protein HGM15179_017189 [Zosterops borbonicus] | diamond | 7125 | 184 | 0.994565217391304 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Zosteropidae | Zosterops | Zosterops borbonicus |
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);;