contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA556992" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4955859 | 4955859 | PRJNA556992_P_NODE_870744_length_242_cov_2.254438_g868554_i0 | PRJNA556992 | 870744 | 242 | 2.254438 | 5.45573996 | Candidatus Aciduliprofundum | 379546 | Archaea | Archaea | 165 | 2.68e-36 | NTclustered | gi|470485990|ref|NR_076728.1| | 379547 | g868554 | i0 | 82.143 | 27.8801652892562 | 196 | 32 | 80 | 3 | 25 | 218 | 2441 | 2247 | Aciduliprofundum boonei strain T469 23S ribosomal RNA gene, complete sequence | blastn | 6747 | 165 | 1 | Archaea | DHVE2 group | Methanobacteriati | Thermoplasmatota | Candidatus Aciduliprofundum | Candidatus Aciduliprofundum boonei | ||||
| 12604313 | 12604313 | PRJNA556992_P_NODE_203630_length_325_cov_2.400794_g201442_i0 | PRJNA556992 | 203630 | 325 | 2.400794 | 7.8025805 | Candidatus Methanogranum | 1577789 | Archaea | Archaea | 586 | 6.769999999999998e-163 | NTclustered | gi|2621784480|emb|OY780938.1| | 2093355 | g201442 | i0 | 99.381 | 18.6584615384615 | 323 | 2 | 99 | 0 | 3 | 325 | 1493103 | 1492781 | MAG: uncultured Candidatus Methanogranum sp. isolate 9d90576e-3f35-4afd-8682-ecdb60e67c32 genome assembly, chromosome: 1 | blastn | 6064 | 586 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Candidatus Methanogranum | uncultured Candidatus Methanogranum sp. | ||
| 18376639 | 18376639 | PRJNA556992_P_NODE_170175_length_344_cov_4.564576_g167987_i0 | PRJNA556992 | 170175 | 344 | 4.564576 | 15.70214144 | uncultured Candidatus Methanogranum sp. | 2093355 | Archaea | Archaea | 630 | 3.289999999999999e-176 | NTclustered | gi|2621784480|emb|OY780938.1| | 2093355 | g167987 | i0 | 99.709 | 15.7441860465116 | 344 | 1 | 100 | 0 | 1 | 344 | 1494729 | 1494386 | MAG: uncultured Candidatus Methanogranum sp. isolate 9d90576e-3f35-4afd-8682-ecdb60e67c32 genome assembly, chromosome: 1 | blastn | 5416 | 630 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Candidatus Methanogranum | uncultured Candidatus Methanogranum sp. | ||
| 18376879 | 18376879 | PRJNA556992_P_NODE_184175_length_336_cov_1.984791_g181987_i0 | PRJNA556992 | 184175 | 336 | 1.984791 | 6.66889776 | uncultured Candidatus Methanogranum sp. | 2093355 | Archaea | Archaea | 621 | 1.9299999999999997e-173 | NTclustered | gi|2621784480|emb|OY780938.1| | 2093355 | g181987 | i0 | 100 | 193.119047619048 | 336 | 0 | 100 | 0 | 1 | 336 | 1493782 | 1493447 | MAG: uncultured Candidatus Methanogranum sp. isolate 9d90576e-3f35-4afd-8682-ecdb60e67c32 genome assembly, chromosome: 1 | blastn | 64888 | 621 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Candidatus Methanogranum | uncultured Candidatus Methanogranum sp. | ||
| 18383233 | 18383233 | PRJNA556992_P_NODE_650075_length_255_cov_1.489011_g647886_i0 | PRJNA556992 | 650075 | 255 | 1.489011 | 3.79697805 | Cuniculiplasma divulgatum | 1673428 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|2573965583|gb|CP133595.1| | 1673428 | g647886 | i0 | 100 | 0.109803921568627 | 28 | 0 | 11 | 0 | 148 | 175 | 1831325 | 1831298 | MAG: Cuniculiplasma divulgatum isolate BR_06 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Cuniculiplasmataceae | Cuniculiplasma | Cuniculiplasma divulgatum | ||
| 20931964 | 20931964 | PRJNA556992_P_NODE_536337_length_264_cov_2.000000_g534148_i0 | PRJNA556992 | 536337 | 264 | 2 | 5.28 | uncultured Candidatus Methanogranum sp. | 2093355 | Archaea | Archaea | 483 | 7.219999999999998e-132 | NTclustered | gi|2621784480|emb|OY780938.1| | 2093355 | g534148 | i0 | 99.621 | 133.128787878788 | 264 | 1 | 100 | 0 | 1 | 264 | 1495099 | 1494836 | MAG: uncultured Candidatus Methanogranum sp. isolate 9d90576e-3f35-4afd-8682-ecdb60e67c32 genome assembly, chromosome: 1 | blastn | 35146 | 483 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Candidatus Methanogranum | uncultured Candidatus Methanogranum 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);;