contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA782551" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17341808 | 17341808 | PRJNA782551_P_NODE_13474_length_267_cov_1.396907_g13352_i0 | PRJNA782551 | 13474 | 267 | 1.396907 | 3.72974169 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 136 | 1.31e-38 | NR | KRX03957.1 | 266149 | g13352 | i0 | 83.1 | 0.932584269662921 | 83 | 14 | 93.3 | 0 | 250 | 2 | 61 | 143 | KRX03957.1 hypothetical protein PPERSA_12404 [Pseudocohnilembus persalinus] | diamond | 249 | 136 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 21614715 | 21614715 | PRJNA782551_P_NODE_22697_length_243_cov_0.905882_g22575_i0 | PRJNA782551 | 22697 | 243 | 0.905882 | 2.20129326 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 90.5 | 5.71e-19 | NR | CDW80370.1 | 5949 | g22575 | i0 | 71.2 | 5.16049382716049 | 59 | 17 | 72.8 | 0 | 6 | 182 | 796 | 854 | CDW80370.1 elongation factor domain iv family protein [Stylonychia lemnae] | diamond | 1254 | 90.5 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 26642038 | 26642038 | PRJNA782551_P_NODE_20581_length_246_cov_0.890173_g20459_i0 | PRJNA782551 | 20581 | 246 | 0.890173 | 2.18982558 | Paramecium octaurelia | 43137 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 4.05e-12 | NR | CAD8157626.1 | 43137 | g20459 | i0 | 48.1 | 4.89024390243902 | 81 | 42 | 98.8 | 0 | 2 | 244 | 149 | 229 | CAD8157626.1 unnamed protein product [Paramecium octaurelia] | diamond | 1203 | 70.1 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 27622432 | 27622432 | PRJNA782551_P_NODE_12984_length_271_cov_1.348485_g12862_i0 | PRJNA782551 | 12984 | 271 | 1.348485 | 3.65439435 | Polarella glacialis | 89957 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 2.98e-18 | NR | CAE8638714.1 | 89957 | g12862 | i0 | 54.3 | 0.774907749077491 | 70 | 30 | 75.3 | 1 | 270 | 67 | 869 | 938 | CAE8638714.1 unnamed protein product [Polarella glacialis] | diamond | 210 | 89 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 27695033 | 27695033 | PRJNA782551_P_NODE_16824_length_250_cov_0.870056_g16702_i0 | PRJNA782551 | 16824 | 250 | 0.870056 | 2.17514 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 3.0599999999999998e-24 | NR | CAI2374128.1 | 5936 | g16702 | i0 | 64.9 | 7.104 | 74 | 26 | 88.8 | 0 | 223 | 2 | 164 | 237 | CAI2374128.1 unnamed protein product [Moneuplotes crassus] | diamond | 1776 | 103 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 28957913 | 28957913 | PRJNA782551_P_NODE_22708_length_243_cov_0.905882_g22586_i0 | PRJNA782551 | 22708 | 243 | 0.905882 | 2.20129326 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 82.8 | 2.69e-18 | NR | OMJ66491.1 | 5963 | g22586 | i0 | 69.8 | 1.97530864197531 | 53 | 16 | 65.4 | 0 | 240 | 82 | 62 | 114 | OMJ66491.1 hypothetical protein SteCoe_36649 [Stentor coeruleus] | diamond | 480 | 82.8 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 30338409 | 30338409 | PRJNA782551_P_NODE_16392_length_250_cov_1.740113_g16270_i0 | PRJNA782551 | 16392 | 250 | 1.740113 | 4.3502825 | Polarella glacialis | 89957 | SAR_Eukaryotes | SAR_Eukaryotes | 95.1 | 1.57e-20 | NR | CAK0859889.1 | 89957 | g16270 | i0 | 54.2 | 0.996 | 83 | 37 | 99.6 | 1 | 250 | 2 | 2051 | 2132 | CAK0859889.1 unnamed protein product [Polarella glacialis] | diamond | 249 | 95.1 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 31791782 | 31791782 | PRJNA782551_P_NODE_15597_length_251_cov_1.668539_g15475_i0 | PRJNA782551 | 15597 | 251 | 1.668539 | 4.18803289 | Seminavis robusta | 568900 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 5.65e-19 | NR | CAB9519286.1 | 568900 | g15475 | i0 | 48.2 | 0.99203187250996006 | 83 | 43 | 99.2 | 0 | 1 | 249 | 163 | 245 | CAB9519286.1 Carbonyl reductase [NADPH] 1 [Seminavis robusta] | diamond | 249 | 89 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Naviculaceae | Seminavis | Seminavis robusta |
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);;