contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA745553" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22401776 | 22401776 | PRJNA745553_S_NODE_2998_length_588_cov_9.669903_g2815_i0 | PRJNA745553 | 2998 | 588 | 9.669903 | 56.85902964 | Metazoa | 33208 | Chordata | Chordata | 151 | 2.28e-38 | NR | KAI5935658.1 | 9974 | g2815 | i0 | 57.4 | 12.7857142857143 | 148 | 60 | 74 | 1 | 550 | 116 | 927 | 1074 | KAI5935658.1 Neuronal PAS domain-containing protein 2 [Manis javanica] | diamond | 7518 | 151 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Pholidota | Manidae | Manis | Manis javanica | |
| 28252854 | 28252854 | PRJNA745553_S_NODE_22666_length_260_cov_1.647059_g22471_i0 | PRJNA745553 | 22666 | 260 | 1.647059 | 4.2823534 | Euleptes europaea | 460621 | Chordata | Chordata | 48.9 | 3.08e-4 | NR | XP_056720257.1 | 460621 | g22471 | i0 | 69 | 0.334615384615385 | 29 | 9 | 33.5 | 0 | 260 | 174 | 643 | 671 | XP_056720257.1 ADP-ribosylhydrolase ARH1-like [Euleptes europaea] | diamond | 87 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Lepidosauria | Squamata | Sphaerodactylidae | Euleptes | Euleptes europaea | |
| 28357438 | 28357438 | PRJNA745553_S_NODE_6326_length_463_cov_5.915385_g6132_i0 | PRJNA745553 | 6326 | 463 | 5.915385 | 27.38823255 | root | 1 | Root_unresolved | Root_unresolved | 167 | 1.14e-44 | NR | 7YSJ_A | 10116 | g6132 | i0 | 65.9 | 58.7041036717063 | 132 | 45 | 85.5 | 0 | 67 | 462 | 842 | 973 | 7YSJ_A Chain A, Glutamate receptor [Rattus norvegicus] | diamond | 27180 | 168 | 0.994047619047619 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus | |
| 28452472 | 28452472 | PRJNA745553_S_NODE_17946_length_291_cov_4.357798_g17751_i0 | PRJNA745553 | 17946 | 291 | 4.357798 | 12.68119218 | Mammalia | 40674 | Chordata | Chordata | 85.5 | 2.04e-18 | NR | XP_054937577.1 | 9755 | g17751 | i0 | 75.9 | 24.9484536082474 | 54 | 13 | 55.7 | 0 | 67 | 228 | 124 | 177 | XP_054937577.1 uncharacterized protein, partial [Physeter macrocephalus] | diamond | 7260 | 86.3 | 0.990730011587486 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Physeteridae | Physeter | Physeter macrocephalus | |
| 28663486 | 28663486 | PRJNA745553_S_NODE_19727_length_278_cov_6.321951_g19532_i0 | PRJNA745553 | 19727 | 278 | 6.321951 | 17.57502378 | Branchiostoma belcheri | 7741 | Chordata | Chordata | 52.8 | 7.87e-6 | NR | KAI8520055.1 | 7741 | g19532 | i0 | 64.5 | 0.334532374100719 | 31 | 11 | 33.5 | 0 | 30 | 122 | 154 | 184 | KAI8520055.1 Peptidyl-prolyl cis-trans isomerase cyp8 [Branchiostoma belcheri] | diamond | 93 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 28673394 | 28673394 | PRJNA745553_S_NODE_14167_length_327_cov_2.342520_g13972_i0 | PRJNA745553 | 14167 | 327 | 2.34252 | 7.6600404 | Chordata | 7711 | Chordata | Chordata | 72.8 | 3.67e-13 | NR | AAH99273.1 | 8355 | g13972 | i0 | 52.4 | 16.1926605504587 | 63 | 30 | 57.8 | 0 | 287 | 99 | 134 | 196 | AAH99273.1 Unknown (protein for IMAGE:6932755), partial [Xenopus laevis] | diamond | 5295 | 73.2 | 0.994535519125683 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 29178670 | 29178670 | PRJNA745553_S_NODE_24669_length_249_cov_5.647727_g24474_i0 | PRJNA745553 | 24669 | 249 | 5.647727 | 14.06284023 | Anura | 8342 | Chordata | Chordata | 53.5 | 6.33e-6 | NR | XP_018418199.1 | 125878 | g24474 | i0 | 55.3 | 2.8433734939759 | 47 | 19 | 54.2 | 1 | 231 | 97 | 449 | 495 | XP_018418199.1 PREDICTED: CWF19-like protein 1 isoform X3 [Nanorana parkeri] | diamond | 708 | 53.9 | 0.992578849721707 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dicroglossidae | Nanorana | Nanorana parkeri | |
| 29873212 | 29873212 | PRJNA745553_S_NODE_4531_length_521_cov_4.370536_g4341_i0 | PRJNA745553 | 4531 | 521 | 4.370536 | 22.77049256 | root | 1 | Root_unresolved | Root_unresolved | 211 | 6.4e-60 | NR | 7YSJ_A | 10116 | g4341 | i0 | 69.3 | 255.869481765835 | 153 | 47 | 88.1 | 0 | 17 | 475 | 842 | 994 | 7YSJ_A Chain A, Glutamate receptor [Rattus norvegicus] | diamond | 133308 | 213 | 0.990610328638498 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Rattus | Rattus norvegicus | |
| 29926533 | 29926533 | PRJNA745553_S_NODE_24991_length_248_cov_2.388571_g24796_i0 | PRJNA745553 | 24991 | 248 | 2.3885710000000002 | 5.92365608 | Geotrypetes seraphini | 260995 | Chordata | Chordata | 66.6 | 4.74e-11 | NR | XP_033777160.1 | 260995 | g24796 | i0 | 34.6 | 5.05645161290323 | 81 | 48 | 98 | 1 | 5 | 247 | 90 | 165 | XP_033777160.1 esterase OVCA2 [Geotrypetes seraphini] | diamond | 1254 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Gymnophiona | Dermophiidae | Geotrypetes | Geotrypetes seraphini | |
| 31221565 | 31221565 | PRJNA745553_S_NODE_10315_length_377_cov_11.000000_g10120_i0 | PRJNA745553 | 10315 | 377 | 11 | 41.47 | Physeter macrocephalus | 9755 | Chordata | Chordata | 43.5 | 0.0218 | NR | XP_028341699.1 | 9755 | g10120 | i0 | 34.1 | 0.652519893899204 | 82 | 49 | 65.3 | 1 | 359 | 114 | 29 | 105 | XP_028341699.1 ras and Rab interactor 3, partial [Physeter macrocephalus] | diamond | 246 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Physeteridae | Physeter | Physeter macrocephalus | |
| 31453330 | 31453330 | PRJNA745553_S_NODE_4976_length_505_cov_3.608796_g4782_i0 | PRJNA745553 | 4976 | 505 | 3.608796 | 18.2244198 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 51.2 | 6.19e-4 | NR | XP_019618423.1 | 7741 | g4782 | i0 | 40 | 1.64554455445545 | 45 | 27 | 26.7 | 0 | 474 | 340 | 1620 | 1664 | XP_019618423.1 PREDICTED: LOW QUALITY PROTEIN: uncharacterized protein LOC109465508 [Branchiostoma belcheri] | diamond | 831 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Leptocardii | Amphioxiformes | Branchiostomatidae | Branchiostoma | Branchiostoma belcheri | |
| 32560719 | 32560719 | PRJNA745553_S_NODE_24639_length_249_cov_16.034091_g24444_i0 | PRJNA745553 | 24639 | 249 | 16.034091 | 39.92488659 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 84.7 | 2.35e-19 | NR | XP_043549936.1 | 36176 | g24444 | i0 | 72.2 | 14.289156626506 | 54 | 15 | 65.1 | 0 | 2 | 163 | 33 | 86 | XP_043549936.1 acyl-CoA-binding protein [Chiloscyllium plagiosum] | diamond | 3558 | 85.1 | 0.995299647473561 | Eukaryota | Opisthokonta | Metazoa | Chordata | Chondrichthyes | Orectolobiformes | Hemiscylliidae | Chiloscyllium | Chiloscyllium plagiosum | |
| 32802374 | 32802374 | PRJNA745553_S_NODE_4680_length_515_cov_4.486425_g4489_i0 | PRJNA745553 | 4680 | 515 | 4.486425 | 23.10508875 | Ornithorhynchus anatinus | 9258 | Chordata | Chordata | 64.7 | 7.34e-9 | NR | XP_028912553.1 | 9258 | g4489 | i0 | 62.5 | 3.4252427184466 | 48 | 18 | 28 | 0 | 330 | 187 | 206 | 253 | XP_028912553.1 endonuclease V [Ornithorhynchus anatinus] | diamond | 1764 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Monotremata | Ornithorhynchidae | Ornithorhynchus | Ornithorhynchus anatinus |
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);;