contig_metadata
10 rows where bioproject = "PRJNA474426" and tax_kingdom = "Methanobacteriati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20849044 | 20849044 | PRJNA474426_P_NODE_14077_length_278_cov_1.816594_g13872_i0 | PRJNA474426 | 14077 | 278 | 1.816594 | 5.05013132 | uncultured Candidatus Methanogranum sp. | 2093355 | Archaea | Archaea | 412 | 1.0199999999999999e-110 | NTclustered | gi|2621784480|emb|OY780938.1| | 2093355 | g13872 | i0 | 93.502 | 1.99280575539568 | 277 | 18 | 99 | 0 | 1 | 277 | 1307016 | 1307292 | MAG: uncultured Candidatus Methanogranum sp. isolate 9d90576e-3f35-4afd-8682-ecdb60e67c32 genome assembly, chromosome: 1 | blastn | 554 | 412 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Candidatus Methanogranum | uncultured Candidatus Methanogranum sp. | ||
| 26854984 | 26854984 | PRJNA474426_P_NODE_19981_length_224_cov_0.880000_g19776_i0 | PRJNA474426 | 19981 | 224 | 0.88 | 1.9712 | Methanosarcina sp. | 2213 | Archaea | Archaea | 87 | 6.81e-18 | NR | HET8687757.1 | 2213 | g19776 | i0 | 51.4 | 0.964285714285714 | 72 | 34 | 95.1 | 1 | 213 | 1 | 353 | 424 | HET8687757.1 toprim domain-containing protein [Methanosarcina sp.] | diamond | 216 | 87 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 28750034 | 28750034 | PRJNA474426_P_NODE_17707_length_241_cov_2.166667_g17502_i0 | PRJNA474426 | 17707 | 241 | 2.166667 | 5.22166747 | Methanoculleus sp. 7T | 2937282 | Archaea | Archaea | 66.2 | 3.61e-11 | NR | WP_248535981.1 | 2937282 | g17502 | i0 | 47.6 | 1.0207468879668 | 82 | 38 | 95.9 | 1 | 241 | 11 | 43 | 124 | WP_248535981.1 hypothetical protein [Methanoculleus sp. 7T] | diamond | 246 | 66.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus sp. 7T | |
| 28907622 | 28907622 | PRJNA474426_P_NODE_12388_length_300_cov_1.569721_g12183_i0 | PRJNA474426 | 12388 | 300 | 1.569721 | 4.709163 | Methanogenium sp. | 2196 | Archaea | Archaea | 136 | 5.88e-39 | NR | MFA5395027.1 | 2196 | g12183 | i0 | 68.2 | 0.85 | 85 | 27 | 85 | 0 | 293 | 39 | 55 | 139 | MFA5395027.1 hypothetical protein [Methanogenium sp.] | diamond | 255 | 136 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanogenium | Methanogenium sp. | |
| 29855198 | 29855198 | PRJNA474426_P_NODE_5931_length_444_cov_4.362025_g5728_i0 | PRJNA474426 | 5931 | 444 | 4.362025 | 19.367391 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 66.2 | 9.74e-11 | NR | MBO7735300.1 | 66852 | g5728 | i0 | 51.7 | 0.391891891891892 | 58 | 27 | 38.5 | 1 | 12 | 182 | 64 | 121 | MBO7735300.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 174 | 66.2 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 30424227 | 30424227 | PRJNA474426_P_NODE_8313_length_375_cov_1.469325_g8108_i0 | PRJNA474426 | 8313 | 375 | 1.469325 | 5.50996875 | Methanosarcina sp. | 2213 | Archaea | Archaea | 60.1 | 5.59e-9 | NR | HET8689601.1 | 2213 | g8108 | i0 | 40.2 | 0.696 | 87 | 46 | 64.8 | 2 | 362 | 120 | 6 | 92 | HET8689601.1 hypothetical protein [Methanosarcina sp.] | diamond | 261 | 60.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 30518583 | 30518583 | PRJNA474426_P_NODE_14733_length_270_cov_4.190045_g14528_i0 | PRJNA474426 | 14733 | 270 | 4.190045 | 11.3131215 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 52.4 | 1.97e-5 | NR | HUV84265.1 | 2250255 | g14528 | i0 | 39.7 | 0.755555555555556 | 68 | 39 | 75.6 | 1 | 50 | 253 | 145 | 210 | HUV84265.1 hypothetical protein [Methanosarcinales archaeon] | diamond | 204 | 52.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 30676425 | 30676425 | PRJNA474426_P_NODE_23213_length_204_cov_2.980645_g23008_i0 | PRJNA474426 | 23213 | 204 | 2.980645 | 6.0805158 | Methanopyrus sp. SNP6 | 1937005 | Archaea | Archaea | 42 | 0.0411 | NR | WP_148689199.1 | 1937005 | g23008 | i0 | 45.2 | 0.617647058823529 | 42 | 23 | 61.8 | 0 | 26 | 151 | 380 | 421 | WP_148689199.1 acetate--CoA ligase family protein [Methanopyrus sp. SNP6] | diamond | 126 | 42 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanopyri | Methanopyrales | Methanopyraceae | Methanopyrus | Methanopyrus sp. SNP6 | |
| 31656315 | 31656315 | PRJNA474426_P_NODE_15137_length_266_cov_1.290323_g14932_i0 | PRJNA474426 | 15137 | 266 | 1.290323 | 3.43225918 | Methanosarcina sp. | 2213 | Archaea | Archaea | 103 | 8.779999999999999e-25 | NR | HET8689803.1 | 2213 | g14932 | i0 | 59 | 0.93609022556391 | 83 | 34 | 93.6 | 0 | 1 | 249 | 112 | 194 | HET8689803.1 tRNA(His) guanylyltransferase Thg1 family protein [Methanosarcina sp.] | diamond | 249 | 103 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 31972836 | 31972836 | PRJNA474426_P_NODE_18618_length_233_cov_2.467391_g18413_i0 | PRJNA474426 | 18618 | 233 | 2.467391 | 5.74902103 | Methanosarcina sp. | 2213 | Archaea | Archaea | 114 | 4.9199999999999993e-29 | NR | HET8687130.1 | 2213 | g18413 | i0 | 69.4 | 1.85407725321888 | 72 | 22 | 92.7 | 0 | 231 | 16 | 196 | 267 | HET8687130.1 hypothetical protein [Methanosarcina sp.] | diamond | 432 | 114 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. |
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);;