contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA575566" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15164895 | 15164895 | PRJNA575566_P_NODE_2772_length_621_cov_2.180357_g2582_i0 | PRJNA575566 | 2772 | 621 | 2.180357 | 13.54001697 | Metazoa | 33208 | Chordata | Chordata | 335 | 1.1199999999999997e-104 | NR | KAI8494249.1 | 7741 | g2582 | i0 | 79.3 | 16.280193236715 | 198 | 41 | 95.7 | 0 | 619 | 26 | 865 | 1062 | KAI8494249.1 Elongation factor 1-alpha 1 [Branchiostoma belcheri] | diamond | 10110 | 335 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 26934891 | 26934891 | PRJNA575566_P_NODE_11242_length_312_cov_1.780876_g11045_i0 | PRJNA575566 | 11242 | 312 | 1.780876 | 5.55633312 | Chordata | 7711 | Chordata | Chordata | 46.2 | 0.0053 | NR | XP_053575473.1 | 8345 | g11045 | i0 | 69 | 0.932692307692308 | 29 | 9 | 27.9 | 0 | 207 | 293 | 1255 | 1283 | XP_053575473.1 LOW QUALITY PROTEIN: hydrocephalus-inducing protein homolog [Bombina bombina] | diamond | 291 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bombinatoridae | Bombina | Bombina bombina | |
| 27441070 | 27441070 | PRJNA575566_P_NODE_3443_length_560_cov_1.158317_g3247_i0 | PRJNA575566 | 3443 | 560 | 1.158317 | 6.4865752 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 51.2 | 9.2e-4 | NR | XP_039766690.1 | 9258 | g3247 | i0 | 47.6 | 1.06607142857143 | 42 | 22 | 22.5 | 0 | 3 | 128 | 1725 | 1766 | XP_039766690.1 LOW QUALITY PROTEIN: proprotein convertase subtilisin/kexin type 5 [Ornithorhynchus anatinus] | diamond | 597 | 51.6 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Monotremata | Ornithorhynchidae | Ornithorhynchus | Ornithorhynchus anatinus | |
| 28387914 | 28387914 | PRJNA575566_P_NODE_27086_length_205_cov_0.888889_g26889_i0 | PRJNA575566 | 27086 | 205 | 0.888889 | 1.82222245 | Opisthokonta | 33154 | Chordata | Chordata | 115 | 1.06e-28 | NR | XP_043933806.1 | 7888 | g26889 | i0 | 80.9 | 116.429268292683 | 68 | 13 | 99.5 | 0 | 204 | 1 | 24 | 91 | XP_043933806.1 60S ribosomal protein L4 [Protopterus annectens] | diamond | 23868 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ceratodontiformes | Protopteridae | Protopterus | Protopterus annectens | ||
| 28406032 | 28406032 | PRJNA575566_P_NODE_29086_length_202_cov_0.907801_g28889_i0 | PRJNA575566 | 29086 | 202 | 0.907801 | 1.83375802 | Serinus canaria | 9135 | Chordata | Chordata | 42 | 0.0359 | NR | XP_050826426.1 | 9135 | g28889 | i0 | 57.1 | 1.33663366336634 | 35 | 15 | 52 | 0 | 38 | 142 | 59 | 93 | XP_050826426.1 R-spondin-2 isoform X2 [Serinus canaria] | diamond | 270 | 42.4 | 0.990566037735849 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Fringillidae | Serinus | Serinus canaria | |
| 30395920 | 30395920 | PRJNA575566_P_NODE_24393_length_209_cov_0.864865_g24196_i0 | PRJNA575566 | 24393 | 209 | 0.864865 | 1.80756785 | Eleutherodactylus coqui | 57060 | Chordata | Chordata | 52.8 | 6.83e-6 | NR | XP_066463888.1 | 57060 | g24196 | i0 | 50 | 0.660287081339713 | 46 | 21 | 66 | 1 | 1 | 138 | 46 | 89 | XP_066463888.1 leukocyte receptor cluster member 9 [Eleutherodactylus coqui] | diamond | 138 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Eleutherodactylidae | Eleutherodactylus | Eleutherodactylus coqui | |
| 30584886 | 30584886 | PRJNA575566_P_NODE_27173_length_205_cov_0.888889_g26976_i0 | PRJNA575566 | 27173 | 205 | 0.888889 | 1.82222245 | Staurois parvus | 386267 | Chordata | Chordata | 83.6 | 5.77e-19 | NR | CAI9618505.1 | 386267 | g26976 | i0 | 68.1 | 1.00975609756098 | 69 | 20 | 99.5 | 2 | 2 | 205 | 25 | 92 | CAI9618505.1 unnamed protein product, partial [Staurois parvus] | diamond | 207 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 30932666 | 30932666 | PRJNA575566_P_NODE_22434_length_219_cov_1.613924_g22237_i0 | PRJNA575566 | 22434 | 219 | 1.613924 | 3.53449356 | Aquarana catesbeiana | 8400 | Chordata | Chordata | 77.8 | 1.74e-16 | NR | ACO51987.1 | 8400 | g22237 | i0 | 56.3 | 9.78082191780822 | 64 | 28 | 87.7 | 0 | 22 | 213 | 1 | 64 | ACO51987.1 60S acidic ribosomal protein P2 [Aquarana catesbeiana] | diamond | 2142 | 78.2 | 0.994884910485933 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Aquarana | Aquarana catesbeiana | |
| 31817858 | 31817858 | PRJNA575566_P_NODE_8557_length_358_cov_2.094276_g8360_i0 | PRJNA575566 | 8557 | 358 | 2.094276 | 7.49750808 | Phascolarctos cinereus | 38626 | Chordata | Chordata | 117 | 5.28e-29 | NR | XP_020844228.1 | 38626 | g8360 | i0 | 50 | 1.95251396648045 | 118 | 47 | 92.2 | 2 | 332 | 3 | 13 | 126 | XP_020844228.1 ADP/ATP translocase 4 [Phascolarctos cinereus] | diamond | 699 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Diprotodontia | Phascolarctidae | Phascolarctos | Phascolarctos cinereus | |
| 32545883 | 32545883 | PRJNA575566_P_NODE_24559_length_209_cov_0.864865_g24362_i0 | PRJNA575566 | 24559 | 209 | 0.864865 | 1.80756785 | Varanus komodoensis | 61221 | Chordata | Chordata | 55.5 | 7.69e-7 | NR | KAF7250664.1 | 61221 | g24362 | i0 | 38.6 | 3.17224880382775 | 57 | 32 | 77.5 | 1 | 46 | 207 | 92 | 148 | KAF7250664.1 Proprotein convertase subtilisin/kexin type 5, partial [Varanus komodoensis] | diamond | 663 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Varanidae | Varanus | Varanus komodoensis | |
| 32608751 | 32608751 | PRJNA575566_P_NODE_27980_length_204_cov_0.895105_g27783_i0 | PRJNA575566 | 27980 | 204 | 0.895105 | 1.8260142 | Pseudonaja textilis | 8673 | Chordata | Chordata | 60.1 | 1.21e-8 | NR | XP_026573509.1 | 8673 | g27783 | i0 | 52.8 | 2.04411764705882 | 72 | 23 | 98.5 | 3 | 202 | 2 | 42 | 107 | XP_026573509.1 cathepsin F [Pseudonaja textilis] | diamond | 417 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Elapidae | Pseudonaja | Pseudonaja textilis |
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);;