contig_metadata
6 rows where bioproject = "PRJNA986481", tax_clade = "Methanomada group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2249179 | 2249179 | PRJNA986481_P_NODE_59562_length_242_cov_1.046632_g59037_i0 | PRJNA986481 | 59562 | 242 | 1.046632 | 2.53284944 | Methanobrevibacter sp. YE315 | 1609968 | Archaea | Archaea | 392 | 1.1299999999999999e-104 | NTclustered | gi|985614202|gb|CP010834.1| | 1609968 | g59037 | i0 | 95.868 | 10.9876033057851 | 242 | 10 | 100 | 0 | 1 | 242 | 219271 | 219030 | Methanobrevibacter sp. YE315, complete genome | blastn | 2659 | 392 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. YE315 | |
| 13727130 | 13727130 | PRJNA986481_P_NODE_32951_length_285_cov_1.233051_g32426_i0 | PRJNA986481 | 32951 | 285 | 1.233051 | 3.51419535 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 152 | 1.99e-41 | NR | WP_405289692.1 | 66852 | g32426 | i0 | 77.7 | 2.96842105263158 | 94 | 20 | 98.9 | 1 | 284 | 3 | 26 | 118 | WP_405289692.1 molecular chaperone DnaK, partial [Methanobrevibacter sp.] | diamond | 846 | 152 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 27342660 | 27342660 | PRJNA986481_P_NODE_10963_length_494_cov_4.656180_g10441_i0 | PRJNA986481 | 10963 | 494 | 4.65618 | 23.0015292 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 228 | 4.49e-67 | NR | WP_295614768.1 | 253161 | g10441 | i0 | 73.6 | 0.874493927125506 | 144 | 38 | 87.4 | 0 | 3 | 434 | 677 | 820 | WP_295614768.1 GTP-binding protein [uncultured Methanobrevibacter sp.] | diamond | 432 | 228 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 28258027 | 28258027 | PRJNA986481_P_NODE_56506_length_245_cov_1.030612_g55981_i0 | PRJNA986481 | 56506 | 245 | 1.030612 | 2.5249994 | Methanobacterium sp. | 2164 | Archaea | Archaea | 128 | 2.09e-33 | NR | TMS43079.1 | 2164 | g55981 | i0 | 75.9 | 1.93469387755102 | 79 | 19 | 96.7 | 0 | 238 | 2 | 21 | 99 | TMS43079.1 MAG: DUF2117 domain-containing protein [Methanobacterium sp.] | diamond | 474 | 128 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 28794716 | 28794716 | PRJNA986481_P_NODE_39467_length_264_cov_2.083721_g38942_i0 | PRJNA986481 | 39467 | 264 | 2.083721 | 5.50102344 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 48.9 | 1.36e-4 | NR | MEE3444538.1 | 66852 | g38942 | i0 | 46.4 | 0.636363636363636 | 56 | 29 | 62.5 | 1 | 258 | 94 | 108 | 163 | MEE3444538.1 40S ribosomal protein S19 [Methanobrevibacter sp.] | diamond | 168 | 48.9 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 30026538 | 30026538 | PRJNA986481_P_NODE_40331_length_263_cov_1.345794_g39806_i0 | PRJNA986481 | 40331 | 263 | 1.345794 | 3.53943822 | Methanococcus voltae | 2188 | Archaea | Archaea | 48.5 | 4.37e-4 | NR | WP_013180395.1 | 2188 | g39806 | i0 | 42.9 | 1.42585551330798 | 63 | 28 | 69.6 | 2 | 226 | 44 | 635 | 691 | WP_013180395.1 protease inhibitor I42 family protein [Methanococcus voltae] | diamond | 375 | 48.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanococcaceae | Methanococcus | Methanococcus voltae |
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);;