contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA864829" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26674976 | 26674976 | PRJNA864829_S_NODE_10281_length_197_cov_1.804054_g10195_i0 | PRJNA864829 | 10281 | 197 | 1.804054 | 3.55398638 | Dama dama | 30532 | Chordata | Chordata | 107 | 1.95e-25 | NR | XP_060991375.1 | 30532 | g10195 | i0 | 78.5 | 0.989847715736041 | 65 | 14 | 99 | 0 | 2 | 196 | 89 | 153 | XP_060991375.1 syncytin-2-like [Dama dama] | diamond | 195 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Dama | Dama dama | |
| 27118103 | 27118103 | PRJNA864829_S_NODE_6702_length_236_cov_2.272727_g6616_i0 | PRJNA864829 | 6702 | 236 | 2.272727 | 5.36363572 | Callorhinus ursinus | 34884 | Chordata | Chordata | 46.2 | 0.00188 | NR | XP_025706513.1 | 34884 | g6616 | i0 | 53.3 | 1.11864406779661 | 45 | 20 | 57.2 | 1 | 236 | 102 | 198 | 241 | XP_025706513.1 ectodysplasin-A receptor-associated adapter protein-like isoform X1 [Callorhinus ursinus] | diamond | 264 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Otariidae | Callorhinus | Callorhinus ursinus | |
| 28318389 | 28318389 | PRJNA864829_S_NODE_11106_length_191_cov_1.119718_g11020_i0 | PRJNA864829 | 11106 | 191 | 1.119718 | 2.13866138 | Physeter macrocephalus | 9755 | Chordata | Chordata | 44.3 | 0.00403 | NR | XP_028352051.1 | 9755 | g11020 | i0 | 68.8 | 1.00523560209424 | 32 | 10 | 50.3 | 0 | 153 | 58 | 154 | 185 | XP_028352051.1 uncharacterized protein [Physeter macrocephalus] | diamond | 192 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Physeteridae | Physeter | Physeter macrocephalus | |
| 28444884 | 28444884 | PRJNA864829_S_NODE_5786_length_250_cov_1.343284_g5700_i0 | PRJNA864829 | 5786 | 250 | 1.343284 | 3.35821 | Polypterus senegalus | 55291 | Chordata | Chordata | 64.3 | 1.04e-9 | NR | XP_039598328.1 | 55291 | g5700 | i0 | 96.9 | 5.856 | 32 | 1 | 38.4 | 0 | 154 | 249 | 556 | 587 | XP_039598328.1 U5 small nuclear ribonucleoprotein 200 kDa helicase-like [Polypterus senegalus] | diamond | 1464 | 64.7 | 0.993817619783617 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 29084443 | 29084443 | PRJNA864829_S_NODE_10928_length_192_cov_1.860140_g10842_i0 | PRJNA864829 | 10928 | 192 | 1.86014 | 3.5714688 | Artiodactyla | 91561 | Chordata | Chordata | 47 | 6.13e-4 | NR | XP_033717309.1 | 9739 | g10842 | i0 | 59 | 1.28125 | 39 | 12 | 54.7 | 1 | 186 | 82 | 364 | 402 | XP_033717309.1 solute carrier family 22 member 18 isoform X19 [Tursiops truncatus] | diamond | 246 | 47.4 | 0.991561181434599 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Delphinidae | Tursiops | Tursiops truncatus | |
| 30126226 | 30126226 | PRJNA864829_S_NODE_9632_length_202_cov_2.810458_g9546_i0 | PRJNA864829 | 9632 | 202 | 2.810458 | 5.67712516 | Artiodactyla | 91561 | Chordata | Chordata | 42.7 | 0.0211 | NR | XP_028355588.2 | 9755 | g9546 | i0 | 40.7 | 5.13861386138614 | 54 | 26 | 80.2 | 2 | 25 | 186 | 230 | 277 | XP_028355588.2 GATOR complex protein NPRL3-like isoform X1 [Physeter macrocephalus] | diamond | 1038 | 43.1 | 0.990719257540603 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Physeteridae | Physeter | Physeter macrocephalus | |
| 30253037 | 30253037 | PRJNA864829_S_NODE_4412_length_277_cov_1.390351_g4326_i0 | PRJNA864829 | 4412 | 277 | 1.390351 | 3.85127227 | root | 1 | Root_unresolved | Root_unresolved | 186 | 5.21e-54 | NR | XP_030110853.2 | 10090 | g4326 | i0 | 98.9 | 15.942238267148 | 92 | 1 | 99.6 | 0 | 1 | 276 | 123 | 214 | XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus] | diamond | 4416 | 186 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 31232109 | 31232109 | PRJNA864829_S_NODE_10835_length_193_cov_1.048611_g10749_i0 | PRJNA864829 | 10835 | 193 | 1.048611 | 2.02381923 | Mammalia | 40674 | Chordata | Chordata | 75.5 | 2.32e-14 | NR | KAJ1059607.1 | 9925 | g10749 | i0 | 68.6 | 7.13471502590674 | 51 | 16 | 79.3 | 0 | 155 | 3 | 105 | 155 | KAJ1059607.1 hypothetical protein K5549_020973, partial [Capra hircus] | diamond | 1377 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Capra | Capra hircus | |
| 31983228 | 31983228 | PRJNA864829_S_NODE_6498_length_239_cov_2.026316_g6412_i0 | PRJNA864829 | 6498 | 239 | 2.026316 | 4.84289524 | Ovis ammon polii | 230172 | Chordata | Chordata | 60.8 | 7.01e-9 | NR | KAI4549249.1 | 230172 | g6412 | i0 | 53.6 | 0.702928870292887 | 56 | 26 | 70.3 | 0 | 236 | 69 | 34 | 89 | KAI4549249.1 hypothetical protein MG293_001579 [Ovis ammon polii] | diamond | 168 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis ammon | |
| 31983230 | 31983230 | PRJNA864829_S_NODE_8478_length_214_cov_1.436364_g8392_i0 | PRJNA864829 | 8478 | 214 | 1.436364 | 3.07381896 | Canis lupus dingo | 286419 | Chordata | Chordata | 42 | 0.0457 | NR | XP_048960176.1 | 286419 | g8392 | i0 | 70.8 | 0.336448598130841 | 24 | 7 | 33.6 | 0 | 90 | 161 | 276 | 299 | XP_048960176.1 methionyl-tRNA formyltransferase, mitochondrial isoform X2 [Canis lupus dingo] | diamond | 72 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Canidae | Canis | Canis lupus | |
| 32204885 | 32204885 | PRJNA864829_S_NODE_11378_length_189_cov_1.071429_g11292_i0 | PRJNA864829 | 11378 | 189 | 1.071429 | 2.02500081 | Muntiacus muntjak | 9888 | Chordata | Chordata | 43.1 | 0.008 | NR | KAB0346507.1 | 9888 | g11292 | i0 | 77.4 | 0.492063492063492 | 31 | 7 | 49.2 | 0 | 3 | 95 | 6 | 36 | KAB0346507.1 hypothetical protein FD754_011364 [Muntiacus muntjak] | diamond | 93 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Muntiacus | Muntiacus muntjak | |
| 32710284 | 32710284 | PRJNA864829_S_NODE_2780_length_325_cov_1.916667_g2694_i0 | PRJNA864829 | 2780 | 325 | 1.916667 | 6.22916775 | Rana temporaria | 8407 | Chordata | Chordata | 45.1 | 0.0132 | NR | XP_040204626.1 | 8407 | g2694 | i0 | 41.9 | 0.396923076923077 | 43 | 25 | 39.7 | 0 | 6 | 134 | 163 | 205 | XP_040204626.1 uncharacterized protein LOC120936402 [Rana temporaria] | diamond | 129 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Rana | Rana temporaria | |
| 32867735 | 32867735 | PRJNA864829_S_NODE_15160_length_167_cov_1.974576_g15074_i0 | PRJNA864829 | 15160 | 167 | 1.974576 | 3.29754192 | Camelus bactrianus | 9837 | Chordata | Chordata | 59.3 | 1.03e-8 | NR | XP_045371645.1 | 9837 | g15074 | i0 | 74.4 | 0.70059880239521 | 39 | 10 | 70.1 | 0 | 16 | 132 | 193 | 231 | XP_045371645.1 uncharacterized protein LOC123616465 [Camelus bactrianus] | diamond | 117 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Camelidae | Camelus | Camelus bactrianus |
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);;