contig_metadata
10 rows where bioproject = "PRJNA1111146" and tax_kingdom = "Thermoproteati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5319176 | 5319176 | PRJNA1111146_P_NODE_296565_length_187_cov_2.276119_g295427_i0 | PRJNA1111146 | 296565 | 187 | 2.276119 | 4.25634253 | Pyrobaculum aerophilum | 13773 | Archaea | Archaea | 346 | 6.56e-91 | NTclustered | gi|18308975|gb|AE009441.1| | 178306 | g295427 | i0 | 100 | 1 | 187 | 0 | 100 | 0 | 1 | 187 | 661081 | 661267 | Pyrobaculum aerophilum str. IM2, complete genome | blastn | 187 | 346 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum aerophilum | ||
| 12970723 | 12970723 | PRJNA1111146_P_NODE_418531_length_178_cov_0.904000_g417393_i0 | PRJNA1111146 | 418531 | 178 | 0.904 | 1.60912 | Pyrobaculum aerophilum | 13773 | Archaea | Archaea | 329 | 6.21e-86 | NTclustered | gi|18308975|gb|AE009441.1| | 178306 | g417393 | i0 | 100 | 1.15730337078652 | 178 | 0 | 100 | 0 | 1 | 178 | 1209044 | 1208867 | Pyrobaculum aerophilum str. IM2, complete genome | blastn | 206 | 329 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum aerophilum | ||
| 27447282 | 27447282 | PRJNA1111146_P_NODE_338023_length_183_cov_0.876923_g336885_i0 | PRJNA1111146 | 338023 | 183 | 0.876923 | 1.60476909 | Sulfolobales archaeon | 2268200 | Archaea | Archaea | 128 | 2.5e-34 | NR | MEM2204469.1 | 2268200 | g336885 | i0 | 100 | 1 | 61 | 0 | 100 | 0 | 1 | 183 | 132 | 192 | MEM2204469.1 DNA methyltransferase [Sulfolobales archaeon] | diamond | 183 | 128 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobales archaeon | ||||
| 27532965 | 27532965 | PRJNA1111146_P_NODE_336183_length_183_cov_0.876923_g335045_i0 | PRJNA1111146 | 336183 | 183 | 0.876923 | 1.60476909 | Thermoproteati | 1783275 | Archaea | Archaea | 122 | 3.94e-34 | NR | HWS20938.1 | 1971748 | g335045 | i0 | 96.7 | 2.95081967213115 | 60 | 2 | 98.4 | 0 | 182 | 3 | 64 | 123 | HWS20938.1 hypothetical protein [Nitrososphaera sp.] | diamond | 540 | 123 | 0.991869918699187 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 28173135 | 28173135 | PRJNA1111146_P_NODE_390046_length_180_cov_0.881890_g388908_i0 | PRJNA1111146 | 390046 | 180 | 0.88189 | 1.587402 | Desulfurococcaceae archaeon | 2184738 | Archaea | Archaea | 115 | 1.3199999999999999e-28 | NR | PWV36622.1 | 2184738 | g388908 | i0 | 94.9 | 0.983333333333333 | 59 | 3 | 98.3 | 0 | 179 | 3 | 318 | 376 | PWV36622.1 MAG: amidase [Desulfurococcaceae archaeon] | diamond | 177 | 115 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcaceae | Desulfurococcaceae archaeon | |||
| 29152384 | 29152384 | PRJNA1111146_P_NODE_297729_length_187_cov_1.694030_g296591_i0 | PRJNA1111146 | 297729 | 187 | 1.69403 | 3.1678361 | Candidatus Caldarchaeum sp. | 2972665 | Archaea | Archaea | 65.1 | 4.23e-11 | NR | MEM4301557.1 | 2972665 | g296591 | i0 | 96.9 | 0.513368983957219 | 32 | 1 | 51.3 | 0 | 97 | 2 | 1 | 32 | MEM4301557.1 hypothetical protein [Candidatus Caldarchaeum sp.] | diamond | 96 | 65.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Caldarchaeales | Candidatus Caldarchaeaceae | Candidatus Caldarchaeum | Candidatus Caldarchaeum sp. | |||
| 29499267 | 29499267 | PRJNA1111146_P_NODE_235030_length_199_cov_1.561644_g233892_i0 | PRJNA1111146 | 235030 | 199 | 1.561644 | 3.10767156 | Candidatus Caldarchaeales archaeon | 3071590 | Archaea | Archaea | 76.3 | 2e-14 | NR | MDT7877103.1 | 3071590 | g233892 | i0 | 84.6 | 0.587939698492462 | 39 | 6 | 58.8 | 0 | 82 | 198 | 1 | 39 | MDT7877103.1 polysaccharide pyruvyl transferase family protein [Candidatus Caldarchaeales archaeon] | diamond | 117 | 76.3 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Caldarchaeales | Candidatus Caldarchaeales archaeon | |||||
| 31426619 | 31426619 | PRJNA1111146_P_NODE_405316_length_179_cov_0.888889_g404178_i0 | PRJNA1111146 | 405316 | 179 | 0.888889 | 1.59111131 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 110 | 1.06e-26 | NR | HYJ02854.1 | 2169593 | g404178 | i0 | 96.6 | 3.95530726256983 | 59 | 2 | 98.9 | 0 | 2 | 178 | 188 | 246 | HYJ02854.1 ArsB/NhaD family transporter [Nitrososphaeraceae archaeon] | diamond | 708 | 110 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 31616396 | 31616396 | PRJNA1111146_P_NODE_277016_length_191_cov_1.579710_g275878_i0 | PRJNA1111146 | 277016 | 191 | 1.57971 | 3.0172461 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 115 | 4.4699999999999995e-30 | NR | MDQ5868535.1 | 2056631 | g275878 | i0 | 84.1 | 0.989528795811518 | 63 | 10 | 99 | 0 | 2 | 190 | 17 | 79 | MDQ5868535.1 sulfurtransferase [Thermoproteota archaeon] | diamond | 189 | 115 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 32027713 | 32027713 | PRJNA1111146_P_NODE_221598_length_202_cov_1.369128_g220460_i0 | PRJNA1111146 | 221598 | 202 | 1.369128 | 2.76563856 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 52.8 | 5.41e-6 | NR | HVD07366.1 | 2169593 | g220460 | i0 | 43.8 | 1.78217821782178 | 64 | 36 | 95 | 0 | 6 | 197 | 180 | 243 | HVD07366.1 retropepsin-like aspartic protease [Nitrososphaeraceae archaeon] | diamond | 360 | 52.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae 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);;