contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA508758" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26665364 | 26665364 | PRJNA508758_P_NODE_28441_length_379_cov_2.810458_g27393_i0 | PRJNA508758 | 28441 | 379 | 2.810458 | 10.65163582 | Chrysophaeum taylorii | 2483200 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 2.26e-11 | NR | KAJ8601885.1 | 2483200 | g27393 | i0 | 62.7 | 0.467018469656992 | 59 | 22 | 46.7 | 0 | 63 | 239 | 416 | 474 | KAJ8601885.1 hypothetical protein CTAYLR_002641 [Chrysophaeum taylorii] | diamond | 177 | 70.9 | 1 | Eukaryota | Sar | Pelagophyceae | Pelagomonadales | Pelagomonadaceae | Chrysophaeum | Chrysophaeum taylorii | |||
| 27614378 | 27614378 | PRJNA508758_P_NODE_51164_length_297_cov_1.375000_g50116_i0 | PRJNA508758 | 51164 | 297 | 1.375 | 4.08375 | Saprolegnia diclina VS2 | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 58.9 | 1.43e-7 | NR | XP_008605336.1 | 1156394 | g50116 | i0 | 33.6 | 3.12121212121212 | 107 | 60 | 97 | 2 | 294 | 7 | 158 | 264 | XP_008605336.1 CK1/TTBK protein kinase [Saprolegnia diclina VS20] | diamond | 927 | 58.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 28277141 | 28277141 | PRJNA508758_P_NODE_90126_length_227_cov_3.077922_g89078_i0 | PRJNA508758 | 90126 | 227 | 3.077922 | 6.98688294 | Symbiodinium natans | 878477 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 3.89e-4 | NR | CAE7495486.1 | 878477 | g89078 | i0 | 33.3 | 0.951541850220264 | 72 | 42 | 93.8 | 3 | 226 | 14 | 399 | 465 | CAE7495486.1 gefF [Symbiodinium natans] | diamond | 216 | 48.1 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium natans | |||
| 28387356 | 28387356 | PRJNA508758_P_NODE_34626_length_349_cov_1.242754_g33578_i0 | PRJNA508758 | 34626 | 349 | 1.242754 | 4.33721146 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 68.9 | 7.17e-11 | NR | XP_012899324.1 | 12968 | g33578 | i0 | 46.8 | 3.49856733524355 | 79 | 42 | 67.9 | 0 | 262 | 26 | 66 | 144 | XP_012899324.1 uncharacterized protein [Blastocystis hominis] | diamond | 1221 | 69.3 | 0.994227994227994 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis hominis | |||
| 28624805 | 28624805 | PRJNA508758_P_NODE_7787_length_812_cov_2.834912_g6897_i0 | PRJNA508758 | 7787 | 812 | 2.834912 | 23.01948544 | Nannochloropsis gaditana | 72520 | SAR_Eukaryotes | SAR_Eukaryotes | 86.7 | 4.04e-15 | NR | EWM30533.1 | 72520 | g6897 | i0 | 44.3 | 0.358374384236453 | 97 | 53 | 35.5 | 1 | 10 | 297 | 361 | 457 | EWM30533.1 transcription initiation factor tfiid subunit 5 [Nannochloropsis gaditana] | diamond | 291 | 86.7 | 1 | Eukaryota | Sar | Eustigmatophyceae | Eustigmatales | Monodopsidaceae | Nannochloropsis | Nannochloropsis gaditana | |||
| 29193082 | 29193082 | PRJNA508758_P_NODE_43589_length_318_cov_1.257143_g42541_i0 | PRJNA508758 | 43589 | 318 | 1.257143 | 3.99771474 | Blastocystis hominis | 12968 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.0493 | NR | XP_012897472.1 | 12968 | g42541 | i0 | 34.5 | 0.547169811320755 | 58 | 33 | 50 | 1 | 195 | 37 | 10 | 67 | XP_012897472.1 uncharacterized protein [Blastocystis hominis] | diamond | 174 | 42.7 | 1 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis hominis | |||
| 29950811 | 29950811 | PRJNA508758_P_NODE_88591_length_241_cov_0.916667_g87543_i0 | PRJNA508758 | 88591 | 241 | 0.916667 | 2.20916747 | Symbiodinium sp. CCMP2592 | 631055 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.0485 | NR | CAE7251447.1 | 631055 | g87543 | i0 | 34.3 | 0.83402489626556 | 67 | 43 | 82.2 | 1 | 217 | 20 | 285 | 351 | CAE7251447.1 unnamed protein product [Symbiodinium sp. CCMP2592] | diamond | 201 | 42.4 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium sp. CCMP2592 | |||
| 32005422 | 32005422 | PRJNA508758_P_NODE_40618_length_327_cov_1.311024_g39570_i0 | PRJNA508758 | 40618 | 327 | 1.311024 | 4.28704848 | Symbiodinium microadriaticum | 2951 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 8.52e-9 | NR | CAE7489375.1 | 2951 | g39570 | i0 | 36.1 | 0.889908256880734 | 97 | 61 | 88.1 | 1 | 11 | 298 | 157 | 253 | CAE7489375.1 POLA2, partial [Symbiodinium microadriaticum] | diamond | 291 | 62.8 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum | |||
| 32369075 | 32369075 | PRJNA508758_P_NODE_18379_length_470_cov_2.236776_g17332_i0 | PRJNA508758 | 18379 | 470 | 2.236776 | 10.5128472 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 73.6 | 1.8e-12 | NR | KAH9183547.1 | 100861 | g17332 | i0 | 39.4 | 4.5 | 104 | 59 | 66.4 | 2 | 109 | 420 | 103 | 202 | KAH9183547.1 hypothetical protein AeNC1_014477 [Aphanomyces euteiches] | diamond | 2115 | 74.3 | 0.990578734858681 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches |
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);;