contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA807347" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1222497 | 1222497 | PRJNA807347_P_NODE_14721_length_246_cov_1.040462_g14618_i0 | PRJNA807347 | 14721 | 246 | 1.040462 | 2.55953652 | Nyctereutes procyonoides | 34880 | Chordata | Chordata | 63.2 | 1.34e-9 | NR | XP_055162229.1 | 34880 | g14618 | i0 | 69 | 1.5609756097561 | 42 | 13 | 51.2 | 0 | 127 | 2 | 207 | 248 | XP_055162229.1 translation initiation factor IF-2-like isoform X1 [Nyctereutes procyonoides] | diamond | 384 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Nyctereutes | Nyctereutes procyonoides | |
| 27022538 | 27022538 | PRJNA807347_P_NODE_7942_length_291_cov_1.137615_g7839_i0 | PRJNA807347 | 7942 | 291 | 1.137615 | 3.31045965 | Polypterus senegalus | 55291 | Chordata | Chordata | 44.7 | 0.0132 | NR | KAG2459877.1 | 55291 | g7839 | i0 | 65.7 | 1.10309278350515 | 35 | 12 | 36.1 | 0 | 111 | 7 | 204 | 238 | KAG2459877.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 321 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 27906749 | 27906749 | PRJNA807347_P_NODE_14565_length_247_cov_0.879310_g14462_i0 | PRJNA807347 | 14565 | 247 | 0.87931 | 2.1718957 | Myxine glutinosa | 7769 | Chordata | Chordata | 58.9 | 5.09e-8 | NR | XP_067986719.1 | 7769 | g14462 | i0 | 80.6 | 2.5748987854251 | 36 | 6 | 43.7 | 1 | 110 | 3 | 2 | 36 | XP_067986719.1 uncharacterized protein [Myxine glutinosa] | diamond | 636 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Myxini | Myxiniformes | Myxinidae | Myxine | Myxine glutinosa | |
| 28159818 | 28159818 | PRJNA807347_P_NODE_10925_length_259_cov_1.645161_g10822_i0 | PRJNA807347 | 10925 | 259 | 1.645161 | 4.26096699 | Hypanus sabinus | 79690 | Chordata | Chordata | 52 | 1.33e-5 | NR | XP_059846139.1 | 79690 | g10822 | i0 | 84.6 | 3.50965250965251 | 26 | 4 | 30.1 | 0 | 257 | 180 | 170 | 195 | XP_059846139.1 uncharacterized protein LOC132405391 isoform X1 [Hypanus sabinus] | diamond | 909 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Myliobatiformes | Dasyatidae | Hypanus | Hypanus sabinus | |
| 28231353 | 28231353 | PRJNA807347_P_NODE_12706_length_250_cov_1.762712_g12603_i0 | PRJNA807347 | 12706 | 250 | 1.762712 | 4.40678 | Felidae | 9681 | Chordata | Chordata | 62.8 | 3.47e-9 | NR | XP_047697379.1 | 61388 | g12603 | i0 | 60.3 | 1.032 | 58 | 16 | 61.2 | 2 | 154 | 2 | 300 | 357 | XP_047697379.1 interleukin enhancer-binding factor 2 isoform X2 [Prionailurus viverrinus] | diamond | 258 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Felidae | Prionailurus | Prionailurus viverrinus | |
| 28633404 | 28633404 | PRJNA807347_P_NODE_16087_length_244_cov_0.900585_g15984_i0 | PRJNA807347 | 16087 | 244 | 0.900585 | 2.1974274 | Malurus melanocephalus | 175006 | Chordata | Chordata | 68.2 | 4.06e-11 | NR | XP_057242091.1 | 175006 | g15984 | i0 | 83.8 | 2.23770491803279 | 37 | 6 | 45.5 | 0 | 3 | 113 | 79 | 115 | XP_057242091.1 dipeptidyl peptidase 9 isoform X5 [Malurus melanocephalus] | diamond | 546 | 68.6 | 0.994169096209913 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Maluridae | Malurus | Malurus melanocephalus | |
| 29517163 | 29517163 | PRJNA807347_P_NODE_7410_length_300_cov_1.110132_g7307_i0 | PRJNA807347 | 7410 | 300 | 1.110132 | 3.330396 | Limosa lapponica baueri | 1758121 | Chordata | Chordata | 55.1 | 3.37e-6 | NR | PKU37802.1 | 1758121 | g7307 | i0 | 86.2 | 0.29 | 29 | 3 | 28 | 1 | 85 | 2 | 1 | 29 | PKU37802.1 syntaxin-binding protein hypothetical protein [Limosa lapponica baueri] | diamond | 87 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Charadriiformes | Scolopacidae | Limosa | Limosa lapponica | |
| 29683686 | 29683686 | PRJNA807347_P_NODE_15270_length_245_cov_0.906977_g15167_i0 | PRJNA807347 | 15270 | 245 | 0.906977 | 2.22209365 | Chordata | 7711 | Chordata | Chordata | 43.5 | 0.0194 | NR | KAG2462375.1 | 55291 | g15167 | i0 | 70.8 | 4.99591836734694 | 24 | 7 | 29.4 | 0 | 20 | 91 | 185 | 208 | KAG2462375.1 TC1A transposase, partial [Polypterus senegalus] | diamond | 1224 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 29810192 | 29810192 | PRJNA807347_P_NODE_13131_length_250_cov_0.864407_g13028_i0 | PRJNA807347 | 13131 | 250 | 0.864407 | 2.1610175 | Artiodactyla | 91561 | Chordata | Chordata | 67.8 | 4.81e-11 | NR | XP_070317002.1 | 9874 | g13028 | i0 | 74.4 | 19.428 | 43 | 11 | 51.6 | 0 | 225 | 97 | 95 | 137 | XP_070317002.1 SPRY domain-containing SOCS box protein 3 isoform X3 [Odocoileus virginianus] | diamond | 4857 | 68.2 | 0.994134897360704 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Odocoileus | Odocoileus virginianus | |
| 30307431 | 30307431 | PRJNA807347_P_NODE_16652_length_243_cov_0.905882_g16549_i0 | PRJNA807347 | 16652 | 243 | 0.905882 | 2.20129326 | Ambystoma mexicanum | 8296 | Chordata | Chordata | 70.5 | 6.36e-12 | NR | XP_069490531.1 | 8296 | g16549 | i0 | 55.7 | 1.53086419753086 | 61 | 25 | 75.3 | 1 | 192 | 10 | 346 | 404 | XP_069490531.1 bifunctional coenzyme A synthase isoform X1 [Ambystoma mexicanum] | diamond | 372 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Ambystomatidae | Ambystoma | Ambystoma mexicanum | |
| 31326928 | 31326928 | PRJNA807347_P_NODE_17995_length_208_cov_4.081481_g17892_i0 | PRJNA807347 | 17995 | 208 | 4.081481 | 8.48948048 | Chondrichthyes | 7777 | Chordata | Chordata | 58.2 | 8.73e-8 | NR | XP_055512691.1 | 7782 | g17892 | i0 | 100 | 18.5769230769231 | 28 | 0 | 40.4 | 0 | 207 | 124 | 554 | 581 | XP_055512691.1 soluble guanylate cyclase 88E-like [Leucoraja erinaceus] | diamond | 3864 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Rajiformes | Rajidae | Leucoraja | Leucoraja erinaceus | |
| 31358735 | 31358735 | PRJNA807347_P_NODE_12336_length_251_cov_1.000000_g12233_i0 | PRJNA807347 | 12336 | 251 | 1 | 2.51 | Amphibia | 8292 | Chordata | Chordata | 58.2 | 1.45e-7 | NR | XP_069483860.1 | 8296 | g12233 | i0 | 49.1 | 2.53386454183267 | 53 | 27 | 63.3 | 0 | 1 | 159 | 27 | 79 | XP_069483860.1 uncharacterized protein [Ambystoma mexicanum] | diamond | 636 | 58.5 | 0.994871794871795 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Ambystomatidae | Ambystoma | Ambystoma mexicanum | |
| 31508051 | 31508051 | PRJNA807347_P_NODE_13576_length_249_cov_0.875000_g13473_i0 | PRJNA807347 | 13576 | 249 | 0.875 | 2.17875 | Ranitomeya imitator | 111125 | Chordata | Chordata | 42.7 | 0.0386 | NR | CAJ0933740.1 | 111125 | g13473 | i0 | 52.5 | 0.481927710843373 | 40 | 19 | 48.2 | 0 | 193 | 74 | 99 | 138 | CAJ0933740.1 unnamed protein product [Ranitomeya imitator] | diamond | 120 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 32108943 | 32108943 | PRJNA807347_P_NODE_13098_length_250_cov_0.870056_g12995_i0 | PRJNA807347 | 13098 | 250 | 0.870056 | 2.17514 | Bufotes viridis | 30338 | Chordata | Chordata | 46.6 | 0.00173 | NR | CAK8634393.1 | 30338 | g12995 | i0 | 50 | 0.996 | 40 | 20 | 48 | 0 | 120 | 239 | 518 | 557 | CAK8634393.1 LINE-1 retrotransposable element ORF2 protein [Bufotes viridis] | diamond | 249 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis |
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);;