contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA641707" and tax_phylum = "Thermoproteota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26840635 | 26840635 | PRJNA641707_P_NODE_315461_length_159_cov_8.936364_g312798_i0 | PRJNA641707 | 315461 | 159 | 8.936364 | 14.20881876 | Archaea | 2157 | Archaea | Archaea | 63.9 | 3.89e-10 | NR | MEM1633972.1 | 2268200 | g312798 | i0 | 57.1 | 1.84905660377358 | 49 | 20 | 92.5 | 1 | 9 | 155 | 594 | 641 | MEM1633972.1 hypothetical protein [Sulfolobales archaeon] | diamond | 294 | 63.9 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobales archaeon | ||||
| 27535921 | 27535921 | PRJNA641707_P_NODE_114543_length_246_cov_2.187817_g111880_i0 | PRJNA641707 | 114543 | 246 | 2.187817 | 5.38202982 | Thermoproteati | 1783275 | Archaea | Archaea | 72.4 | 2.96e-13 | NR | MDP9498592.1 | 2056631 | g111880 | i0 | 100 | 1.20731707317073 | 33 | 0 | 40.2 | 0 | 3 | 101 | 127 | 159 | MDP9498592.1 Glu/Leu/Phe/Val dehydrogenase [Thermoproteota archaeon] | diamond | 297 | 72.4 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28628859 | 28628859 | PRJNA641707_P_NODE_323627_length_156_cov_7.794393_g320964_i0 | PRJNA641707 | 323627 | 156 | 7.794393 | 12.15925308 | Desulfurococcaceae archaeon | 2184738 | Archaea | Archaea | 69.7 | 1.51e-12 | NR | MEM4557784.1 | 2184738 | g320964 | i0 | 73.5 | 0.942307692307692 | 49 | 13 | 94.2 | 0 | 5 | 151 | 14 | 62 | MEM4557784.1 hypothetical protein [Desulfurococcaceae archaeon] | diamond | 147 | 69.7 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcaceae | Desulfurococcaceae archaeon | |||
| 30334400 | 30334400 | PRJNA641707_P_NODE_65652_length_260_cov_14.573460_g62989_i0 | PRJNA641707 | 65652 | 260 | 14.57346 | 37.890996 | Sulfolobus sp. SCGC AB-777_L | 2288 | Archaea | Archaea | 42.7 | 0.0426 | NR | PVU70735.1 | 1987492 | g62989 | i0 | 39.2 | 0.588461538461538 | 51 | 31 | 58.8 | 0 | 1 | 153 | 218 | 268 | PVU70735.1 hypothetical protein DDW09_01750, partial [Sulfolobus sp. SCGC AB-777_L09] | diamond | 153 | 42.7 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Sulfolobus | Sulfolobus sp. SCGC AB-777_L09 | ||
| 31642030 | 31642030 | PRJNA641707_P_NODE_75056_length_246_cov_14.421320_g72393_i0 | PRJNA641707 | 75056 | 246 | 14.42132 | 35.4764472 | Thermoproteati | 1783275 | Archaea | Archaea | 67.8 | 1.98e-11 | NR | MDQ5868985.1 | 2056631 | g72393 | i0 | 100 | 1.17073170731707 | 32 | 0 | 39 | 0 | 5 | 100 | 1 | 32 | MDQ5868985.1 nucleotidyltransferase family protein [Thermoproteota archaeon] | diamond | 288 | 67.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 31882733 | 31882733 | PRJNA641707_P_NODE_280817_length_170_cov_3.578512_g278154_i0 | PRJNA641707 | 280817 | 170 | 3.578512 | 6.0834704 | Pyrobaculum sp. | 2004705 | Archaea | Archaea | 63.9 | 4.59e-10 | NR | MEM0369681.1 | 2004705 | g278154 | i0 | 48.2 | 5.85882352941176 | 56 | 29 | 98.8 | 0 | 169 | 2 | 302 | 357 | MEM0369681.1 serine/threonine-protein kinase [Pyrobaculum sp.] | diamond | 996 | 63.9 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum sp. | ||
| 32767732 | 32767732 | PRJNA641707_P_NODE_300840_length_164_cov_3.139130_g298177_i0 | PRJNA641707 | 300840 | 164 | 3.13913 | 5.1481732 | Thermofilaceae archaeon | 2268203 | Archaea | Archaea | 78.2 | 4.08e-15 | NR | MEM2591090.1 | 2268203 | g298177 | i0 | 71.7 | 0.969512195121951 | 53 | 15 | 97 | 0 | 5 | 163 | 672 | 724 | MEM2591090.1 TonB-dependent receptor [Thermofilaceae archaeon] | diamond | 159 | 78.2 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermofilales | Thermofilaceae | Thermofilaceae 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);;