contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA188516" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22731951 | 22731951 | PRJNA188516_P_NODE_1638_length_279_cov_0.900000_g1588_i0 | PRJNA188516 | 1638 | 279 | 0.9 | 2.511 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 114 | 2e-29 | NR | OCT94035.1 | 8355 | g1588 | i0 | 71.4 | 105.043010752688 | 77 | 22 | 82.8 | 0 | 49 | 279 | 108 | 184 | OCT94035.1 hypothetical protein XELAEV_18011698mg [Xenopus laevis] | diamond | 29307 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Xenopus | Xenopus laevis | |
| 26743182 | 26743182 | PRJNA188516_P_NODE_3201_length_190_cov_1.475177_g3151_i0 | PRJNA188516 | 3201 | 190 | 1.475177 | 2.8028363 | Artiodactyla | 91561 | Chordata | Chordata | 80.5 | 8.87e-16 | NR | TKC36767.1 | 40151 | g3151 | i0 | 66.1 | 8.30526315789474 | 62 | 21 | 97.9 | 0 | 3 | 188 | 732 | 793 | TKC36767.1 hypothetical protein EI555_004718, partial [Monodon monoceros] | diamond | 1578 | 80.9 | 0.995055624227441 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Monodontidae | Monodon | Monodon monoceros | |
| 26915717 | 26915717 | PRJNA188516_P_NODE_5802_length_163_cov_0.912281_g5752_i0 | PRJNA188516 | 5802 | 163 | 0.912281 | 1.48701803 | Bufotes viridis | 30338 | Chordata | Chordata | 44.7 | 0.00268 | NR | CAK8639140.1 | 30338 | g5752 | i0 | 53.7 | 1.50920245398773 | 41 | 19 | 75.5 | 0 | 1 | 123 | 522 | 562 | CAK8639140.1 B-cell lymphoma 6 protein homolog [Bufotes viridis] | diamond | 246 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 27706150 | 27706150 | PRJNA188516_P_NODE_2564_length_214_cov_1.260606_g2514_i0 | PRJNA188516 | 2564 | 214 | 1.260606 | 2.69769684 | Lepidochelys olivacea | 27788 | Chordata | Chordata | 59.3 | 3.49e-8 | NR | CAJ90462.1 | 27788 | g2514 | i0 | 44.9 | 7.80841121495327 | 69 | 38 | 96.7 | 0 | 212 | 6 | 261 | 329 | CAJ90462.1 NADH dehydrogenase subunit 4 [Lepidochelys olivacea] | diamond | 1671 | 59.7 | 0.993299832495812 | Eukaryota | Opisthokonta | Metazoa | Chordata | Testudines | Cheloniidae | Lepidochelys | Lepidochelys olivacea | ||
| 28179105 | 28179105 | PRJNA188516_P_NODE_6066_length_162_cov_0.920354_g6016_i0 | PRJNA188516 | 6066 | 162 | 0.920354 | 1.49097348 | Taeniopygia guttata | 59729 | Chordata | Chordata | 39.7 | 0.0355 | NR | ACH44493.1 | 59729 | g6016 | i0 | 58.8 | 0.62962962962963 | 34 | 11 | 57.4 | 1 | 147 | 55 | 7 | 40 | ACH44493.1 putative inosine triphosphatase isoform variant 2 [Taeniopygia guttata] | diamond | 102 | 39.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Estrildidae | Taeniopygia | Taeniopygia guttata | |
| 29852881 | 29852881 | PRJNA188516_P_NODE_3791_length_174_cov_0.832000_g3741_i0 | PRJNA188516 | 3791 | 174 | 0.832 | 1.44768 | Engystomops pustulosus | 76066 | Chordata | Chordata | 41.6 | 0.0107 | NR | KAG8554186.1 | 76066 | g3741 | i0 | 71.4 | 1.44827586206897 | 28 | 8 | 48.3 | 0 | 167 | 84 | 73 | 100 | KAG8554186.1 hypothetical protein GDO81_003707 [Engystomops pustulosus] | diamond | 252 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Leptodactylidae | Engystomops | Engystomops pustulosus | |
| 30628639 | 30628639 | PRJNA188516_P_NODE_1633_length_279_cov_2.143478_g1583_i0 | PRJNA188516 | 1633 | 279 | 2.143478 | 5.98030362 | Chordata | 7711 | Chordata | Chordata | 42.4 | 0.0295 | NR | CAK8685383.1 | 159417 | g1583 | i0 | 52.5 | 1.33333333333333 | 40 | 19 | 43 | 0 | 189 | 70 | 60 | 99 | CAK8685383.1 unnamed protein product [Clavelina lepadiformis] | diamond | 372 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Ascidiacea | Aplousobranchia | Clavelinidae | Clavelina | Clavelina lepadiformis | |
| 31116345 | 31116345 | PRJNA188516_P_NODE_5775_length_163_cov_0.912281_g5725_i0 | PRJNA188516 | 5775 | 163 | 0.912281 | 1.48701803 | Oreolalax omeimontis | 445777 | Chordata | Chordata | 57.8 | 5.84e-8 | NR | WDD39345.1 | 445777 | g5725 | i0 | 66.7 | 7.95092024539877 | 54 | 18 | 99.4 | 0 | 163 | 2 | 105 | 158 | WDD39345.1 NADH dehydrogenase subunit 1 [Oreolalax omeimontis] | diamond | 1296 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Megophryidae | Oreolalax | Oreolalax omeimontis | |
| 31369763 | 31369763 | PRJNA188516_P_NODE_6056_length_162_cov_0.920354_g6006_i0 | PRJNA188516 | 6056 | 162 | 0.920354 | 1.49097348 | Polypterus senegalus | 55291 | Chordata | Chordata | 75.1 | 3.19e-14 | NR | KAG2460242.1 | 55291 | g6006 | i0 | 60.4 | 0.981481481481482 | 53 | 21 | 98.1 | 0 | 3 | 161 | 231 | 283 | KAG2460242.1 TCB1 transposase, partial [Polypterus senegalus] | diamond | 159 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 31559495 | 31559495 | PRJNA188516_P_NODE_6196_length_159_cov_3.809091_g6146_i0 | PRJNA188516 | 6196 | 159 | 3.809091 | 6.05645469 | Cavia porcellus | 10141 | Chordata | Chordata | 41.2 | 0.0392 | NR | XP_003470245.2 | 10141 | g6146 | i0 | 83.3 | 1.43396226415094 | 24 | 4 | 45.3 | 0 | 88 | 159 | 69 | 92 | XP_003470245.2 eukaryotic translation initiation factor 1A, X-chromosomal-like [Cavia porcellus] | diamond | 228 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Caviidae | Cavia | Cavia porcellus | |
| 32558149 | 32558149 | PRJNA188516_P_NODE_6119_length_162_cov_0.920354_g6069_i0 | PRJNA188516 | 6119 | 162 | 0.920354 | 1.49097348 | Metazoa | 33208 | Chordata | Chordata | 60.1 | 7.4e-10 | NR | KAG8520360.1 | 202257 | g6069 | i0 | 63 | 59.037037037037 | 54 | 18 | 100 | 1 | 162 | 1 | 10 | 61 | KAG8520360.1 60S ribosomal protein L27 [Galemys pyrenaicus] | diamond | 9564 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Eulipotyphla | Talpidae | Galemys | Galemys pyrenaicus |
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);;