contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA1002570" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7805234 | 7805234 | PRJNA1002570_P_NODE_7387_length_413_cov_3.326471_g7193_i0 | PRJNA1002570 | 7387 | 413 | 3.326471 | 13.73832523 | Sus scrofa | 9823 | Chordata | Chordata | 226 | 5.64e-69 | NR | XP_020938199.1 | 9823 | g7193 | i0 | 100 | 2.46246973365617 | 113 | 0 | 82.1 | 0 | 411 | 73 | 407 | 519 | XP_020938199.1 ribonuclease inhibitor isoform X2 [Sus scrofa] | diamond | 1017 | 226 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 26876477 | 26876477 | PRJNA1002570_P_NODE_26381_length_276_cov_2.000000_g26186_i0 | PRJNA1002570 | 26381 | 276 | 2 | 5.52 | Polypterus senegalus | 55291 | Chordata | Chordata | 80.9 | 1.85e-16 | NR | XP_039631340.1 | 55291 | g26186 | i0 | 55.7 | 1.97826086956522 | 61 | 27 | 66.3 | 0 | 252 | 70 | 112 | 172 | XP_039631340.1 uncharacterized protein C7orf50 homolog isoform X2 [Polypterus senegalus] | diamond | 546 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 27128790 | 27128790 | PRJNA1002570_P_NODE_27802_length_273_cov_1.370000_g27607_i0 | PRJNA1002570 | 27802 | 273 | 1.37 | 3.7401 | Anas acuta | 28680 | Chordata | Chordata | 43.1 | 0.0375 | NR | XP_068526470.1 | 28680 | g27607 | i0 | 35.9 | 0.857142857142857 | 78 | 42 | 76.9 | 3 | 218 | 9 | 298 | 375 | XP_068526470.1 paired box protein Pax-4 isoform X1 [Anas acuta] | diamond | 234 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Anseriformes | Anatidae | Anas | Anas acuta | |
| 28013787 | 28013787 | PRJNA1002570_P_NODE_42825_length_242_cov_2.650888_g42630_i0 | PRJNA1002570 | 42825 | 242 | 2.650888 | 6.41514896 | Phrynosoma platyrhinos | 52577 | Chordata | Chordata | 70.5 | 6.29e-12 | NR | KAH0627017.1 | 52577 | g42630 | i0 | 62.2 | 3.18595041322314 | 45 | 17 | 55.8 | 0 | 135 | 1 | 66 | 110 | KAH0627017.1 hypothetical protein JD844_002377, partial [Phrynosoma platyrhinos] | diamond | 771 | 70.9 | 0.994358251057828 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Phrynosomatidae | Phrynosoma | Phrynosoma platyrhinos | |
| 28802680 | 28802680 | PRJNA1002570_P_NODE_29888_length_267_cov_3.432990_g29693_i0 | PRJNA1002570 | 29888 | 267 | 3.43299 | 9.1660833 | Suncus etruscus | 109475 | Chordata | Chordata | 57 | 4.73e-7 | NR | XP_049633682.1 | 109475 | g29693 | i0 | 48.5 | 4.47191011235955 | 66 | 34 | 74.2 | 0 | 65 | 262 | 170 | 235 | XP_049633682.1 pendrin [Suncus etruscus] | diamond | 1194 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Soricidae | Suncus | Suncus etruscus | |
| 29395448 | 29395448 | PRJNA1002570_P_NODE_15109_length_310_cov_5.700422_g14914_i0 | PRJNA1002570 | 15109 | 310 | 5.700422 | 17.6713082 | Chordata | 7711 | Chordata | Chordata | 50.4 | 1.99e-5 | NR | AAH26581.1 | 10090 | g14914 | i0 | 78.4 | 1.87741935483871 | 37 | 8 | 35.8 | 0 | 197 | 307 | 55 | 91 | AAH26581.1 Ube2m protein [Mus musculus] | diamond | 582 | 50.8 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 29655038 | 29655038 | PRJNA1002570_P_NODE_43270_length_242_cov_0.911243_g43075_i0 | PRJNA1002570 | 43270 | 242 | 0.911243 | 2.20520806 | Styela clava | 7725 | Chordata | Chordata | 56.2 | 6.61e-7 | NR | XP_039262600.1 | 7725 | g43075 | i0 | 42.1 | 5.28099173553719 | 76 | 43 | 93 | 1 | 242 | 18 | 772 | 847 | XP_039262600.1 slit homolog 2 protein-like isoform X1 [Styela clava] | diamond | 1278 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Stolidobranchia | Styelidae | Styela | Styela clava | |
| 29869095 | 29869095 | PRJNA1002570_P_NODE_31751_length_262_cov_2.529101_g31556_i0 | PRJNA1002570 | 31751 | 262 | 2.529101 | 6.62624462 | root | 1 | Root_unresolved | Root_unresolved | 93.2 | 1.53e-20 | NR | XP_038672598.1 | 7830 | g31556 | i0 | 51.2 | 11.3702290076336 | 82 | 40 | 93.9 | 0 | 261 | 16 | 102 | 183 | XP_038672598.1 uncharacterized protein LOC119976269 [Scyliorhinus canicula] | diamond | 2979 | 93.6 | 0.995726495726496 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Carcharhiniformes | Scyliorhinidae | Scyliorhinus | Scyliorhinus canicula | |
| 30855879 | 30855879 | PRJNA1002570_P_NODE_42334_length_243_cov_1.358824_g42139_i0 | PRJNA1002570 | 42334 | 243 | 1.358824 | 3.30194232 | Lipotes vexillifer | 118797 | Chordata | Chordata | 42.7 | 0.0378 | NR | XP_007469789.1 | 118797 | g42139 | i0 | 39.4 | 0.814814814814815 | 66 | 32 | 79 | 5 | 8 | 199 | 542 | 601 | XP_007469789.1 PREDICTED: LOW QUALITY PROTEIN: kielin/chordin-like protein [Lipotes vexillifer] | diamond | 198 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Lipotidae | Lipotes | Lipotes vexillifer | |
| 31108507 | 31108507 | PRJNA1002570_P_NODE_26995_length_275_cov_1.316832_g26800_i0 | PRJNA1002570 | 26995 | 275 | 1.316832 | 3.621288 | Microcaecilia unicolor | 1415580 | Chordata | Chordata | 79.3 | 7.36e-15 | NR | XP_030071142.1 | 1415580 | g26800 | i0 | 66.1 | 7.74545454545455 | 62 | 21 | 67.6 | 0 | 273 | 88 | 93 | 154 | XP_030071142.1 striatin-3 isoform X3 [Microcaecilia unicolor] | diamond | 2130 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Gymnophiona | Siphonopidae | Microcaecilia | Microcaecilia unicolor | |
| 32279211 | 32279211 | PRJNA1002570_P_NODE_31019_length_264_cov_3.068063_g30824_i0 | PRJNA1002570 | 31019 | 264 | 3.068063 | 8.09968632 | Peromyscus leucopus | 10041 | Chordata | Chordata | 45.4 | 0.00551 | NR | XP_028716152.1 | 10041 | g30824 | i0 | 37.5 | 0.727272727272727 | 64 | 40 | 72.7 | 0 | 14 | 205 | 895 | 958 | XP_028716152.1 LOW QUALITY PROTEIN: fibronectin type III domain-containing protein 1 [Peromyscus leucopus] | diamond | 192 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Peromyscus | Peromyscus leucopus | |
| 32626649 | 32626649 | PRJNA1002570_P_NODE_35280_length_252_cov_2.351955_g35085_i0 | PRJNA1002570 | 35280 | 252 | 2.351955 | 5.9269266 | Pygoscelis adeliae | 9238 | Chordata | Chordata | 46.6 | 0.00185 | NR | XP_009333557.1 | 9238 | g35085 | i0 | 42.6 | 1.83333333333333 | 68 | 35 | 81 | 2 | 40 | 243 | 164 | 227 | XP_009333557.1 PREDICTED: acetyl-CoA acetyltransferase, mitochondrial [Pygoscelis adeliae] | diamond | 462 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Sphenisciformes | Spheniscidae | Pygoscelis | Pygoscelis adeliae |
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);;