contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA643700" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4445957 | 4445957 | PRJNA643700_P_NODE_408904_length_165_cov_0.896552_g407348_i0 | PRJNA643700 | 408904 | 165 | 0.896552 | 1.4793108 | Methanobrevibacter olleyae | 294671 | Archaea | Archaea | 58.4 | 2.97e-4 | NTclustered | gi|998157363|gb|CP014265.1| | 294671 | g407348 | i0 | 100 | 0.187878787878788 | 31 | 0 | 19 | 0 | 65 | 95 | 382332 | 382362 | Methanobrevibacter olleyae strain YLM1 chromosome, complete genome | blastn | 31 | 58.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter olleyae | |
| 6996658 | 6996658 | PRJNA643700_P_NODE_203606_length_275_cov_1.840708_g202050_i0 | PRJNA643700 | 203606 | 275 | 1.840708 | 5.061947 | Methanobrevibacter arboriphilus | 39441 | Archaea | Archaea | 54.7 | 0.007 | NTclustered | gi|2047640843|dbj|AP019779.1| | 39441 | g202050 | i0 | 100 | 0.105454545454545 | 29 | 0 | 11 | 0 | 62 | 90 | 2275136 | 2275108 | Methanobrevibacter arboriphilus SA DNA, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter arboriphilus | |
| 6996874 | 6996874 | PRJNA643700_P_NODE_413126_length_164_cov_1.191304_g411570_i0 | PRJNA643700 | 413126 | 164 | 1.191304 | 1.95373856 | Methanocaldococcus fervens | 83171 | Archaea | Archaea | 52.8 | 0.014 | NTclustered | gi|256793173|gb|CP001696.1| | 573064 | g411570 | i0 | 100 | 0.170731707317073 | 28 | 0 | 17 | 0 | 92 | 119 | 1360328 | 1360355 | Methanocaldococcus fervens AG86, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanocaldococcaceae | Methanocaldococcus | Methanocaldococcus fervens | |
| 10822495 | 10822495 | PRJNA643700_P_NODE_400689_length_166_cov_2.487179_g399133_i0 | PRJNA643700 | 400689 | 166 | 2.487179 | 4.12871714 | Methanobacterium sp. BAmetb5 | 2025351 | Archaea | Archaea | 52.8 | 0.014 | NTclustered | gi|1473089901|gb|CP022706.1| | 2025351 | g399133 | i0 | 100 | 0.168674698795181 | 28 | 0 | 17 | 0 | 109 | 136 | 770463 | 770436 | MAG: Methanobacterium sp. BAmetb5 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. BAmetb5 | |
| 16461412 | 16461412 | PRJNA643700_P_NODE_248233_length_241_cov_1.078125_g246677_i0 | PRJNA643700 | 248233 | 241 | 1.078125 | 2.59828125 | Halalkalicoccus | 332246 | Archaea | Archaea | 351 | 1.91e-92 | NTclustered | gi|507148368|ref|NR_103171.1| | 413810 | g246677 | i0 | 92.946 | 108.336099585062 | 241 | 17 | 100 | 0 | 1 | 241 | 1440 | 1680 | Halalkalicoccus jeotgali strain B3 23S ribosomal RNA gene, complete sequence | blastn | 26109 | 351 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 19744901 | 19744901 | PRJNA643700_P_NODE_118276_length_381_cov_1.825301_g116721_i0 | PRJNA643700 | 118276 | 381 | 1.825301 | 6.95439681 | uncultured Thermoplasmata archaeon | 376542 | Archaea | Archaea | 52.8 | 0.036 | NTclustered | gi|2874253895|emb|OY970070.1| | 376542 | g116721 | i0 | 100 | 0.073490813648294 | 28 | 0 | 7 | 0 | 338 | 365 | 1484957 | 1484930 | MAG: uncultured Thermoplasmata archaeon isolate MFD04408.bin.c.5 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | uncultured Thermoplasmata 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);;