contig_metadata
7 rows where bioproject = "PRJNA615351", tax_phylum = "Thermoproteota" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12629019 | 12629019 | PRJNA615351_P_NODE_170850_length_164_cov_2.620155_g156750_i0 | PRJNA615351 | 170850 | 164 | 2.620155 | 4.2970542 | Archaea | 2157 | Archaea | Archaea | 303 | 3.42e-78 | NTclustered | gi|156106317|gb|EU098073.1| | 29281 | g156750 | i0 | 100 | 100 | 164 | 0 | 100 | 0 | 1 | 164 | 332 | 495 | Uncultured crenarchaeote clone Gua2_12 16S ribosomal RNA gene, partial sequence | blastn | 16400 | 303 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 19722203 | 19722203 | PRJNA615351_P_NODE_147876_length_193_cov_1.734177_g133776_i0 | PRJNA615351 | 147876 | 193 | 1.734177 | 3.34696161 | uncultured crenarchaeote | 29281 | Archaea | Archaea | 318 | 1.4899999999999995e-82 | NTclustered | gi|42557759|emb|AJ627422.1| | 29281 | g133776 | i0 | 96.373 | 8.5699481865285 | 193 | 7 | 100 | 0 | 1 | 193 | 40846 | 40654 | Uncultured crenarchaeote genomic fragment 54d9 | blastn | 1654 | 318 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 24821784 | 24821784 | PRJNA615351_P_NODE_153340_length_185_cov_1.853333_g139240_i0 | PRJNA615351 | 153340 | 185 | 1.853333 | 3.42866605 | Vulcanisaeta moutnovskia | 985052 | Archaea | Archaea | 52.8 | 0.016 | NTclustered | gi|323706731|gb|CP002529.1| | 985053 | g139240 | i0 | 100 | 0.151351351351351 | 28 | 0 | 15 | 0 | 154 | 181 | 336100 | 336127 | Vulcanisaeta moutnovskia 768-28, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Vulcanisaeta | Vulcanisaeta moutnovskia | ||
| 26744858 | 26744858 | PRJNA615351_P_NODE_55261_length_655_cov_1.590323_g42506_i0 | PRJNA615351 | 55261 | 655 | 1.590323 | 10.41661565 | Thermoprotei | 183924 | Archaea | Archaea | 47.8 | 0.0189 | NR | HID80588.1 | 2268142 | g42506 | i0 | 36.1 | 1.97862595419847 | 72 | 45 | 32.5 | 1 | 422 | 634 | 84 | 155 | HID80588.1 V-type ATP synthase subunit B [Ignisphaera sp.] | diamond | 1296 | 47.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcaceae | Ignisphaera | Ignisphaera sp. | ||
| 28217184 | 28217184 | PRJNA615351_P_NODE_39926_length_901_cov_24.670901_g17385_i6 | PRJNA615351 | 39926 | 901 | 24.670901 | 222.28481801 | Thermogladius calderae | 1200300 | Archaea | Archaea | 192 | 5.43e-54 | NR | WP_014737200.1 | 1200300 | g17385 | i6 | 40 | 5.62708102108768 | 280 | 150 | 93.2 | 4 | 852 | 13 | 7 | 268 | WP_014737200.1 translation elongation factor EF-1 subunit alpha [Thermogladius calderae] | diamond | 5070 | 192 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcaceae | Thermogladius | Thermogladius calderae | ||
| 31850437 | 31850437 | PRJNA615351_P_NODE_47937_length_758_cov_2.195021_g36163_i0 | PRJNA615351 | 47937 | 758 | 2.195021 | 16.63825918 | Candidatus Methanosuratincola sp. | 2495426 | Archaea | Archaea | 63.2 | 1.37e-7 | NR | MEM2126491.1 | 2495426 | g36163 | i0 | 36.9 | 1.23087071240106 | 130 | 70 | 48.3 | 5 | 554 | 189 | 52 | 177 | MEM2126491.1 hypothetical protein [Candidatus Methanosuratincola sp.] | diamond | 933 | 63.2 | 1 | Archaea | Thermoproteati | Thermoproteota | Methanosuratincolia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanosuratincola (ex Vanwonterghem et al. 2016) | Candidatus Methanosuratincola sp. | ||
| 31958215 | 31958215 | PRJNA615351_P_NODE_120477_length_249_cov_1.556075_g106377_i0 | PRJNA615351 | 120477 | 249 | 1.556075 | 3.87462675 | Archaea | 2157 | Archaea | Archaea | 48.5 | 3.45e-4 | NR | NPA69613.1 | 2056631 | g106377 | i0 | 32.4 | 3.3855421686747 | 74 | 45 | 89.2 | 2 | 26 | 247 | 9 | 77 | NPA69613.1 hypothetical protein [Thermoproteota archaeon] | diamond | 843 | 48.5 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota 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);;