contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJEB75227" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26781113 | 26781113 | PRJEB75227_P_NODE_8761_length_251_cov_1.151685_g8590_i0 | PRJEB75227 | 8761 | 251 | 1.151685 | 2.89072935 | Staurois parvus | 386267 | Chordata | Chordata | 39.7 | 0.0472 | NR | CAI9587454.1 | 386267 | g8590 | i0 | 72.2 | 0.215139442231076 | 18 | 5 | 21.5 | 0 | 250 | 197 | 16 | 33 | CAI9587454.1 unnamed protein product, partial [Staurois parvus] | diamond | 54 | 39.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 26939091 | 26939091 | PRJEB75227_P_NODE_10802_length_245_cov_0.906977_g10631_i0 | PRJEB75227 | 10802 | 245 | 0.906977 | 2.22209365 | Callorhinchus milii | 7868 | Chordata | Chordata | 114 | 2.53e-27 | NR | XP_007900036.2 | 7868 | g10631 | i0 | 68.8 | 8.82857142857143 | 80 | 25 | 98 | 0 | 243 | 4 | 1746 | 1825 | XP_007900036.2 LOW QUALITY PROTEIN: acetyl-CoA carboxylase [Callorhinchus milii] | diamond | 2163 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Chimaeriformes | Callorhinchidae | Callorhinchus | Callorhinchus milii | |
| 28708138 | 28708138 | PRJEB75227_P_NODE_1787_length_583_cov_1.868627_g1616_i0 | PRJEB75227 | 1787 | 583 | 1.868627 | 10.89409541 | Leucoraja erinaceus | 7782 | Chordata | Chordata | 47.8 | 0.0101 | NR | XP_055487001.1 | 7782 | g1616 | i0 | 48.5 | 1.19897084048027 | 66 | 30 | 32.9 | 3 | 186 | 377 | 152 | 215 | XP_055487001.1 E3 ubiquitin-protein ligase TRIM47-like isoform X1 [Leucoraja erinaceus] | diamond | 699 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Rajiformes | Rajidae | Leucoraja | Leucoraja erinaceus | |
| 29458220 | 29458220 | PRJEB75227_P_NODE_5150_length_309_cov_0.991525_g4979_i0 | PRJEB75227 | 5150 | 309 | 0.991525 | 3.06381225 | Metazoa | 33208 | Chordata | Chordata | 179 | 4.809999999999999e-54 | NR | XP_021239395.1 | 8996 | g4979 | i0 | 86.3 | 12.7961165048544 | 102 | 14 | 99 | 0 | 3 | 308 | 39 | 140 | XP_021239395.1 serine/threonine-protein phosphatase 2A 65 kDa regulatory subunit A alpha isoform-like [Numida meleagris] | diamond | 3954 | 179 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Numididae | Numida | Numida meleagris | |
| 31488128 | 31488128 | PRJEB75227_P_NODE_11276_length_243_cov_1.376471_g11105_i0 | PRJEB75227 | 11276 | 243 | 1.376471 | 3.34482453 | Sus scrofa | 9823 | Chordata | Chordata | 43.5 | 0.0205 | NR | XP_020946894.1 | 9823 | g11105 | i0 | 43.9 | 1.74074074074074 | 66 | 27 | 69.1 | 1 | 16 | 183 | 679 | 744 | XP_020946894.1 collagen alpha-2(I) chain-like [Sus scrofa] | diamond | 423 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 32081610 | 32081610 | PRJEB75227_P_NODE_11358_length_243_cov_0.917647_g11187_i0 | PRJEB75227 | 11358 | 243 | 0.917647 | 2.22988221 | Metazoa | 33208 | Chordata | Chordata | 57.8 | 1.87e-7 | NR | MEE6504714.1 | 8439 | g11187 | i0 | 49.2 | 2.20987654320988 | 59 | 26 | 72.8 | 1 | 62 | 238 | 393 | 447 | MEE6504714.1 hypothetical protein [Ascaphus truei] | diamond | 537 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ascaphidae | Ascaphus | Ascaphus truei | |
| 32113439 | 32113439 | PRJEB75227_P_NODE_8878_length_251_cov_0.876404_g8707_i0 | PRJEB75227 | 8878 | 251 | 0.876404 | 2.19977404 | Metazoa | 33208 | Chordata | Chordata | 47.4 | 8.21e-4 | NR | XP_013030783.2 | 8845 | g8707 | i0 | 33.9 | 4.13545816733068 | 56 | 37 | 66.9 | 0 | 204 | 37 | 198 | 253 | XP_013030783.2 mannose-binding protein [Anser cygnoides] | diamond | 1038 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Anseriformes | Anatidae | Anser | Anser cygnoides |
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);;