contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA666695" and tax_phylum = "Thermoplasmatota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26682030 | 26682030 | PRJNA666695_S_NODE_152341_length_176_cov_1.362963_g151247_i0 | PRJNA666695 | 152341 | 176 | 1.362963 | 2.39881488 | root | 1 | Root_unresolved | Root_unresolved | 42.7 | 0.0154 | NR | MCK5290611.1 | 1906666 | g151247 | i0 | 45.1 | 2.76136363636364 | 51 | 27 | 86.9 | 1 | 172 | 20 | 882 | 931 | MCK5290611.1 DUF2791 family P-loop domain-containing protein [Thermoplasmata archaeon] | diamond | 486 | 43.1 | 0.990719257540603 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 26701508 | 26701508 | PRJNA666695_S_NODE_28741_length_362_cov_3.838006_g27648_i0 | PRJNA666695 | 28741 | 362 | 3.838006 | 13.89358172 | Candidatus Thalassarchaeaceae archaeon | 2670411 | Archaea | Archaea | 60.5 | 1.13e-8 | NR | MFL2965254.1 | 2670411 | g27648 | i0 | 43.5 | 1.69060773480663 | 62 | 33 | 51.4 | 1 | 71 | 256 | 26 | 85 | MFL2965254.1 glycine-rich domain-containing protein-like [Candidatus Thalassarchaeaceae archaeon] | diamond | 612 | 60.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Thalassarchaeaceae | Candidatus Thalassarchaeaceae archaeon | |||
| 27176137 | 27176137 | PRJNA666695_S_NODE_178622_length_159_cov_2.728814_g177528_i0 | PRJNA666695 | 178622 | 159 | 2.728814 | 4.33881426 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 42.4 | 0.0133 | NR | MCK4445247.1 | 1906666 | g177528 | i0 | 39.5 | 1.41509433962264 | 38 | 23 | 71.7 | 0 | 158 | 45 | 155 | 192 | MCK4445247.1 TMEM165/GDT1 family protein [Thermoplasmata archaeon] | diamond | 225 | 42.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 27555305 | 27555305 | PRJNA666695_S_NODE_74444_length_250_cov_3.057416_g73350_i0 | PRJNA666695 | 74444 | 250 | 3.057416 | 7.64354 | Candidatus Poseidonia alphae | 1915863 | Archaea | Archaea | 51.2 | 1.55e-5 | NR | MDA7463472.1 | 1915863 | g73350 | i0 | 41.1 | 0.672 | 56 | 33 | 67.2 | 0 | 1 | 168 | 103 | 158 | MDA7463472.1 lipocalin family protein [Candidatus Poseidonia alphae] | diamond | 168 | 51.2 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniaceae | Candidatus Poseidonia | Candidatus Poseidonia alphae | ||
| 27839457 | 27839457 | PRJNA666695_S_NODE_170564_length_164_cov_2.008130_g169470_i0 | PRJNA666695 | 170564 | 164 | 2.00813 | 3.2933332 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 43.1 | 0.00937 | NR | MEE8199220.1 | 1906666 | g169470 | i0 | 45.2 | 1.8109756097561 | 42 | 23 | 76.8 | 0 | 37 | 162 | 4 | 45 | MEE8199220.1 M1 family metallopeptidase [Thermoplasmata archaeon] | diamond | 297 | 43.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 28092241 | 28092241 | PRJNA666695_S_NODE_86245_length_235_cov_1.896907_g85151_i0 | PRJNA666695 | 86245 | 235 | 1.896907 | 4.45773145 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 86.3 | 2.49e-19 | NR | MCD6108611.1 | 1906666 | g85151 | i0 | 62.5 | 4.28936170212766 | 64 | 23 | 81.7 | 1 | 228 | 37 | 69 | 131 | MCD6108611.1 nucleoside-diphosphate kinase [Thermoplasmata archaeon] | diamond | 1008 | 86.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 29398804 | 29398804 | PRJNA666695_S_NODE_97069_length_223_cov_1.478022_g95975_i0 | PRJNA666695 | 97069 | 223 | 1.478022 | 3.29598906 | root | 1 | Root_unresolved | Root_unresolved | 87 | 4.8e-18 | NR | MCK4718664.1 | 1906666 | g95975 | i0 | 45.9 | 10.8565022421525 | 74 | 40 | 99.6 | 0 | 222 | 1 | 300 | 373 | MCK4718664.1 carboxypeptidase M32 [Thermoplasmata archaeon] | diamond | 2421 | 87.4 | 0.995423340961098 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 29840914 | 29840914 | PRJNA666695_S_NODE_137051_length_187_cov_1.575342_g135957_i0 | PRJNA666695 | 137051 | 187 | 1.575342 | 2.94588954 | Archaea | 2157 | Archaea | Archaea | 51.6 | 3.98e-6 | NR | MCK5292717.1 | 1906666 | g135957 | i0 | 47.1 | 2.55080213903743 | 51 | 27 | 81.8 | 0 | 1 | 153 | 60 | 110 | MCK5292717.1 50S ribosomal protein L24 [Thermoplasmata archaeon] | diamond | 477 | 51.6 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 30966398 | 30966398 | PRJNA666695_S_NODE_43254_length_310_cov_7.037175_g42160_i0 | PRJNA666695 | 43254 | 310 | 7.037175 | 21.8152425 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 70.5 | 6.35e-12 | NR | MEF8847968.1 | 2806419 | g42160 | i0 | 39.8 | 4.63548387096774 | 83 | 47 | 77.4 | 1 | 1 | 240 | 152 | 234 | MEF8847968.1 hypothetical protein [Thermoplasmatota archaeon] | diamond | 1437 | 70.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon |
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);;