contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA773247" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10953229 | 10953229 | PRJNA773247_P_NODE_7569_length_599_cov_3.062738_g7486_i0 | PRJNA773247 | 7569 | 599 | 3.062738 | 18.34580062 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 1003 | 0 | NTclustered | gi|299126453|gb|CP002064.1| | 795797 | g7486 | i0 | 96.985 | 0.996661101836394 | 597 | 18 | 99 | 0 | 3 | 599 | 265780 | 265184 | Halalkalicoccus jeotgali B3 plasmid 2, complete sequence | blastn | 597 | 1003 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 10953258 | 10953258 | PRJNA773247_P_NODE_8929_length_536_cov_3.436285_g8846_i0 | PRJNA773247 | 8929 | 536 | 3.436285 | 18.4184876 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 405 | 3.51e-108 | NTclustered | gi|299123054|gb|CP002062.1| | 795797 | g8846 | i0 | 80.561 | 2.26119402985075 | 535 | 97 | 99 | 7 | 6 | 536 | 214886 | 215417 | Halalkalicoccus jeotgali B3, complete genome | blastn | 1212 | 405 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 12686632 | 12686632 | PRJNA773247_P_NODE_25130_length_279_cov_6.519417_g25046_i0 | PRJNA773247 | 25130 | 279 | 6.519417 | 18.18917343 | Halorubrum | 56688 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|1848526000|gb|CP053941.1| | 2739057 | g25046 | i0 | 97.059 | 0.372759856630824 | 34 | 0 | 12 | 1 | 47 | 80 | 1531636 | 1531604 | Halorubrum salinarum strain RHB-C chromosome, complete genome | blastn | 104 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum salinarum | |
| 14777553 | 14777553 | PRJNA773247_P_NODE_15852_length_371_cov_2.402685_g15768_i0 | PRJNA773247 | 15852 | 371 | 2.402685 | 8.91396135 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 414 | 3.91e-111 | NTclustered | gi|299123054|gb|CP002062.1| | 795797 | g15768 | i0 | 86.828 | 81.9137466307278 | 372 | 47 | 100 | 2 | 1 | 371 | 2029083 | 2029453 | Halalkalicoccus jeotgali B3, complete genome | blastn | 30390 | 414 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 16051314 | 16051314 | PRJNA773247_P_NODE_15173_length_381_cov_6.344156_g15089_i0 | PRJNA773247 | 15173 | 381 | 6.344156 | 24.17123436 | Haloterrigena salifodinae | 2675099 | Archaea | Archaea | 52.8 | 0.036 | NTclustered | gi|1988313350|gb|CP069188.1| | 2675099 | g15089 | i0 | 100 | 0.073490813648294 | 28 | 0 | 7 | 0 | 14 | 41 | 121443 | 121470 | Haloterrigena salifodinae strain BOL5-1 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Haloterrigena | Haloterrigena salifodinae | |
| 21151594 | 21151594 | PRJNA773247_P_NODE_35117_length_240_cov_3.143713_g35033_i0 | PRJNA773247 | 35117 | 240 | 3.143713 | 7.5449112 | Halobellus limi | 699433 | Archaea | Archaea | 62.1 | 3.59e-5 | NTclustered | gi|1621075116|gb|CP031311.1| | 699433 | g35033 | i0 | 97.297 | 1.4 | 37 | 0 | 15 | 1 | 98 | 134 | 2957913 | 2957878 | Halobellus limi strain CGMCC 1.10331 chromosome, complete genome | blastn | 336 | 62.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobellus | Halobellus limi | |
| 22426036 | 22426036 | PRJNA773247_P_NODE_14218_length_397_cov_2.484568_g14134_i0 | PRJNA773247 | 14218 | 397 | 2.484568 | 9.86373496 | Haloprofundus salinisoli | 2876193 | Archaea | Archaea | 52.8 | 0.038 | NTclustered | gi|2099489100|gb|CP083663.1| | 2876193 | g14134 | i0 | 100 | 0.0705289672544081 | 28 | 0 | 7 | 0 | 89 | 116 | 2107044 | 2107017 | Haloprofundus salinisoli strain SQT7-1 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloprofundus | Haloprofundus salinisoli | |
| 23701823 | 23701823 | PRJNA773247_P_NODE_23279_length_292_cov_4.684932_g23195_i0 | PRJNA773247 | 23279 | 292 | 4.684932 | 13.68000144 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 54.7 | 0.008 | NTclustered | gi|299123054|gb|CP002062.1| | 795797 | g23195 | i0 | 100 | 0.0993150684931507 | 29 | 0 | 10 | 0 | 126 | 154 | 2143302 | 2143274 | Halalkalicoccus jeotgali B3, complete genome | blastn | 29 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 23701998 | 23701998 | PRJNA773247_P_NODE_36479_length_227_cov_3.655844_g36395_i0 | PRJNA773247 | 36479 | 227 | 3.655844 | 8.29876588 | Natronobacterium lacisalsi | 229731 | Archaea | Archaea | 54.7 | 0.006 | NTclustered | gi|1134496220|gb|CP019285.1| | 358396 | g36395 | i0 | 96.875 | 0.140969162995595 | 32 | 1 | 14 | 0 | 159 | 190 | 577095 | 577126 | Halobiforma lacisalsi AJ5, complete genome | blastn | 32 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobacterium | Natronobacterium lacisalsi |
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);;