contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA798905" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26746108 | 26746108 | PRJNA798905_S_NODE_40161_length_240_cov_2.485030_g39712_i0 | PRJNA798905 | 40161 | 240 | 2.48503 | 5.964072 | Muntiacus | 9885 | Chordata | Chordata | 79 | 6.44e-15 | NR | KAB0373699.1 | 9886 | g39712 | i0 | 52.6 | 16.575 | 78 | 33 | 92.5 | 1 | 222 | 1 | 53 | 130 | KAB0373699.1 hypothetical protein FD755_013955 [Muntiacus reevesi] | diamond | 3978 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Muntiacus | Muntiacus reevesi | |
| 27969928 | 27969928 | PRJNA798905_S_NODE_19705_length_334_cov_5.708812_g19256_i0 | PRJNA798905 | 19705 | 334 | 5.708812 | 19.06743208 | Hymenochirus boettgeri | 247094 | Chordata | Chordata | 43.5 | 0.0465 | NR | KAG8440169.1 | 247094 | g19256 | i0 | 36.3 | 0.718562874251497 | 80 | 42 | 66.5 | 2 | 88 | 309 | 152 | 228 | KAG8440169.1 hypothetical protein GDO86_006102 [Hymenochirus boettgeri] | diamond | 240 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Pipidae | Hymenochirus | Hymenochirus boettgeri | |
| 28096261 | 28096261 | PRJNA798905_S_NODE_30465_length_274_cov_1.532338_g30016_i0 | PRJNA798905 | 30465 | 274 | 1.532338 | 4.19860612 | Lagenorhynchus albirostris | 27610 | Chordata | Chordata | 47.8 | 5.36e-4 | NR | XP_059984459.1 | 27610 | g30016 | i0 | 87.5 | 0.525547445255474 | 24 | 3 | 26.3 | 0 | 200 | 271 | 149 | 172 | XP_059984459.1 ubiquitin-conjugating enzyme E2 W isoform X2 [Lagenorhynchus albirostris] | diamond | 144 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Delphinidae | Lagenorhynchus | Lagenorhynchus albirostris | |
| 29327564 | 29327564 | PRJNA798905_S_NODE_33429_length_260_cov_3.128342_g32980_i0 | PRJNA798905 | 33429 | 260 | 3.128342 | 8.1336892 | Ovis ammon polii x Ovis aries | 2918886 | Chordata | Chordata | 70.1 | 2.08e-12 | NR | KAI4577098.1 | 2918886 | g32980 | i0 | 94.1 | 0.773076923076923 | 34 | 2 | 39.2 | 0 | 102 | 1 | 85 | 118 | KAI4577098.1 hypothetical protein MJT46_002933 [Ovis ammon polii x Ovis aries] | diamond | 201 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis ammon polii x Ovis aries | |
| 29579966 | 29579966 | PRJNA798905_S_NODE_24010_length_307_cov_2.752137_g23561_i0 | PRJNA798905 | 24010 | 307 | 2.752137 | 8.44906059 | Phyllostomus discolor | 89673 | Chordata | Chordata | 60.5 | 1.05e-8 | NR | KAF6088414.1 | 89673 | g23561 | i0 | 51.7 | 1.14332247557003 | 60 | 28 | 58.6 | 1 | 76 | 255 | 67 | 125 | KAF6088414.1 hypothetical protein HJG60_008239 [Phyllostomus discolor] | diamond | 351 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Phyllostomidae | Phyllostomus | Phyllostomus discolor | |
| 30591039 | 30591039 | PRJNA798905_S_NODE_27033_length_291_cov_1.059633_g26584_i0 | PRJNA798905 | 27033 | 291 | 1.059633 | 3.08353203 | Muntiacus muntjak | 9888 | Chordata | Chordata | 62.8 | 5.83e-9 | NR | KAB0351662.1 | 9888 | g26584 | i0 | 55.2 | 2.96907216494845 | 67 | 29 | 68 | 1 | 6 | 203 | 381 | 447 | KAB0351662.1 hypothetical protein FD754_016519 [Muntiacus muntjak] | diamond | 864 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Cervidae | Muntiacus | Muntiacus muntjak | |
| 30789661 | 30789661 | PRJNA798905_S_NODE_27414_length_289_cov_1.425926_g26965_i0 | PRJNA798905 | 27414 | 289 | 1.425926 | 4.12092614 | root | 1 | Root_unresolved | Root_unresolved | 200 | 2.18e-59 | NR | XP_030110853.2 | 10090 | g26965 | i0 | 97.9 | 15.7785467128028 | 95 | 2 | 98.6 | 0 | 287 | 3 | 154 | 248 | XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus] | diamond | 4560 | 200 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Muridae | Mus | Mus musculus | |
| 31349673 | 31349673 | PRJNA798905_S_NODE_30376_length_274_cov_3.024876_g29927_i0 | PRJNA798905 | 30376 | 274 | 3.024876 | 8.28816024 | Balaenoptera physalus | 9770 | Chordata | Chordata | 68.6 | 8.67e-12 | NR | KAB0406035.1 | 9770 | g29927 | i0 | 78 | 0.996350364963504 | 91 | 18 | 97.4 | 1 | 268 | 2 | 1 | 91 | KAB0406035.1 hypothetical protein E2I00_012731, partial [Balaenoptera physalus] | diamond | 273 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Balaenopteridae | Balaenoptera | Balaenoptera physalus | |
| 31444425 | 31444425 | PRJNA798905_S_NODE_32816_length_263_cov_1.621053_g32367_i0 | PRJNA798905 | 32816 | 263 | 1.621053 | 4.26336939 | Mesoplodon densirostris | 48708 | Chordata | Chordata | 65.9 | 3.26e-10 | NR | XP_059952282.1 | 48708 | g32367 | i0 | 50.7 | 1.55133079847909 | 73 | 31 | 77.6 | 2 | 43 | 246 | 304 | 376 | XP_059952282.1 LOW QUALITY PROTEIN: pyroglutamylated RF-amide peptide receptor [Mesoplodon densirostris] | diamond | 408 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Ziphiidae | Mesoplodon | Mesoplodon densirostris | |
| 31453616 | 31453616 | PRJNA798905_S_NODE_21656_length_321_cov_7.322581_g21207_i0 | PRJNA798905 | 21656 | 321 | 7.322581 | 23.50548501 | Aves | 8782 | Chordata | Chordata | 93.2 | 1.52e-19 | NR | NXG10333.1 | 419690 | g21207 | i0 | 87.8 | 3.85981308411215 | 49 | 6 | 45.8 | 0 | 223 | 77 | 448 | 496 | NXG10333.1 C43BP protein [Sakesphorus luctuosus] | diamond | 1239 | 93.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Thamnophilidae | Sakesphorus | Sakesphorus luctuosus | |
| 32740858 | 32740858 | PRJNA798905_S_NODE_13060_length_393_cov_10.028125_g12611_i0 | PRJNA798905 | 13060 | 393 | 10.028125 | 39.41053125 | Ranitomeya imitator | 111125 | Chordata | Chordata | 45.4 | 0.02 | NR | CAJ0965772.1 | 111125 | g12611 | i0 | 46 | 0.480916030534351 | 63 | 30 | 45 | 1 | 217 | 41 | 320 | 382 | CAJ0965772.1 unnamed protein product [Ranitomeya imitator] | diamond | 189 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Dendrobatidae | Ranitomeya | Ranitomeya imitator | |
| 32803602 | 32803602 | PRJNA798905_S_NODE_42040_length_230_cov_3.757962_g41591_i0 | PRJNA798905 | 42040 | 230 | 3.757962 | 8.6433126 | Mirounga angustirostris | 9716 | Chordata | Chordata | 43.5 | 0.0169 | NR | XP_064428521.1 | 9716 | g41591 | i0 | 46 | 0.652173913043478 | 50 | 27 | 65.2 | 0 | 161 | 12 | 571 | 620 | XP_064428521.1 WD repeat-containing and planar cell polarity effector protein fritz homolog isoform X17 [Mirounga angustirostris] | diamond | 150 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Phocidae | Mirounga | Mirounga angustirostris |
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);;