contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA675042" and tax_clade = "Methanomada group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1921843 | 1921843 | PRJNA675042_P_NODE_101362_length_256_cov_1.333333_g100912_i0 | PRJNA675042 | 101362 | 256 | 1.333333 | 3.41333248 | Methanobrevibacter sp. AbM4 | 224719 | Archaea | Archaea | 58.4 | 5e-4 | NTclustered | gi|509083678|gb|CP004050.1| | 224719 | g100912 | i0 | 100 | 0.12109375 | 31 | 0 | 12 | 0 | 30 | 60 | 342168 | 342198 | Methanobrevibacter sp. AbM4, complete genome | blastn | 31 | 58.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. AbM4 | |
| 4473748 | 4473748 | PRJNA675042_P_NODE_108324_length_251_cov_0.865169_g107874_i0 | PRJNA675042 | 108324 | 251 | 0.865169 | 2.17157419 | Methanobrevibacter arboriphilus | 39441 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|2047640843|dbj|AP019779.1| | 39441 | g107874 | i0 | 96.875 | 0.127490039840637 | 32 | 0 | 13 | 1 | 88 | 119 | 2138680 | 2138710 | Methanobrevibacter arboriphilus SA DNA, complete genome | blastn | 32 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter arboriphilus | |
| 4474714 | 4474714 | PRJNA675042_P_NODE_25664_length_388_cov_0.977778_g25214_i0 | PRJNA675042 | 25664 | 388 | 0.977778 | 3.79377864 | Methanocaldococcus lauensis | 2546128 | Archaea | Archaea | 52.8 | 0.037 | NTclustered | gi|2045106419|emb|LR792632.1| | 2546128 | g25214 | i0 | 100 | 0.0721649484536082 | 28 | 0 | 7 | 0 | 252 | 279 | 191670 | 191643 | Methanocaldococcus sp. SG7 genome assembly, chromosome: I | blastn | 28 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanocaldococcaceae | Methanocaldococcus | Methanocaldococcus lauensis | |
| 7025664 | 7025664 | PRJNA675042_P_NODE_43726_length_336_cov_1.000000_g43276_i0 | PRJNA675042 | 43726 | 336 | 1 | 3.36 | Methanococcus voltae | 2188 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|2891705001|gb|CP178160.1| | 523842 | g43276 | i0 | 92.5 | 0.119047619047619 | 40 | 2 | 12 | 1 | 253 | 291 | 1672777 | 1672738 | Methanococcus voltae PS chromosome, complete genome | blastn | 40 | 56.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanococcaceae | Methanococcus | Methanococcus voltae | |
| 10850271 | 10850271 | PRJNA675042_P_NODE_147909_length_245_cov_0.895349_g147459_i0 | PRJNA675042 | 147909 | 245 | 0.895349 | 2.19360505 | Methanococcus voltae | 2188 | Archaea | Archaea | 54.7 | 0.006 | NTclustered | gi|2891705001|gb|CP178160.1| | 523842 | g147459 | i0 | 94.444 | 0.146938775510204 | 36 | 1 | 15 | 1 | 16 | 51 | 209946 | 209980 | Methanococcus voltae PS chromosome, complete genome | blastn | 36 | 54.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanococcaceae | Methanococcus | Methanococcus voltae | |
| 13400172 | 13400172 | PRJNA675042_P_NODE_135351_length_247_cov_0.885057_g134901_i0 | PRJNA675042 | 135351 | 247 | 0.885057 | 2.18609079 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 52.8 | 0.022 | NTclustered | gi|1294447101|gb|CP017803.1| | 2173 | g134901 | i0 | 100 | 0.340080971659919 | 28 | 0 | 11 | 0 | 198 | 225 | 795102 | 795075 | Methanobrevibacter smithii strain KB11 chromosome, complete genome | blastn | 84 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 17225556 | 17225556 | PRJNA675042_P_NODE_84714_length_275_cov_1.202970_g84264_i0 | PRJNA675042 | 84714 | 275 | 1.20297 | 3.3081675 | Methanobrevibacter arboriphilus | 39441 | Archaea | Archaea | 54.7 | 0.007 | NTclustered | gi|2047640843|dbj|AP019779.1| | 39441 | g84264 | i0 | 100 | 0.105454545454545 | 29 | 0 | 11 | 0 | 185 | 213 | 2022776 | 2022748 | Methanobrevibacter arboriphilus SA DNA, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter arboriphilus | |
| 22324331 | 22324331 | PRJNA675042_P_NODE_40458_length_343_cov_0.911111_g40008_i0 | PRJNA675042 | 40458 | 343 | 0.911111 | 3.12511073 | Methanocaldococcus villosus | 667126 | Archaea | Archaea | 52.8 | 0.032 | NTclustered | gi|2891703609|gb|CP178163.1| | 1069083 | g40008 | i0 | 96.875 | 0.0932944606413994 | 32 | 0 | 9 | 1 | 51 | 81 | 760352 | 760321 | Methanocaldococcus villosus KIN24-T80 chromosome, complete genome | blastn | 32 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanocaldococcaceae | Methanocaldococcus | Methanocaldococcus villosus |
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);;