contig_metadata
7 rows where bioproject = "PRJNA1262902" and tax_clade = "Stenosarchaea 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 363475 | 363475 | PRJNA1262902_P_NODE_10921_length_244_cov_0.900585_g10879_i0 | PRJNA1262902 | 10921 | 244 | 0.900585 | 2.1974274 | Natronobacterium gregoryi | 44930 | Archaea | Archaea | 451 | 1.86e-122 | NTclustered | gi|429134263|gb|CP003377.1| | 797304 | g10879 | i0 | 100 | 1 | 244 | 0 | 100 | 0 | 1 | 244 | 3681733 | 3681976 | Natronobacterium gregoryi SP2, complete genome | blastn | 244 | 451 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobacterium | Natronobacterium gregoryi | |
| 2914222 | 2914222 | PRJNA1262902_P_NODE_11963_length_242_cov_0.911243_g11921_i0 | PRJNA1262902 | 11963 | 242 | 0.911243 | 2.20520806 | Natronobacterium gregoryi | 44930 | Archaea | Archaea | 448 | 2.3799999999999995e-121 | NTclustered | gi|429134263|gb|CP003377.1| | 797304 | g11921 | i0 | 100 | 17.6239669421488 | 242 | 0 | 100 | 0 | 1 | 242 | 1353613 | 1353854 | Natronobacterium gregoryi SP2, complete genome | blastn | 4265 | 448 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobacterium | Natronobacterium gregoryi | |
| 8016885 | 8016885 | PRJNA1262902_P_NODE_11427_length_243_cov_0.905882_g11385_i0 | PRJNA1262902 | 11427 | 243 | 0.905882 | 2.20129326 | Natronobacterium gregoryi | 44930 | Archaea | Archaea | 449 | 6.65e-122 | NTclustered | gi|429134263|gb|CP003377.1| | 797304 | g11385 | i0 | 100 | 2.98353909465021 | 243 | 0 | 100 | 0 | 1 | 243 | 1891124 | 1891366 | Natronobacterium gregoryi SP2, complete genome | blastn | 725 | 449 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobacterium | Natronobacterium gregoryi | |
| 9291721 | 9291721 | PRJNA1262902_P_NODE_8808_length_248_cov_0.880000_g8766_i0 | PRJNA1262902 | 8808 | 248 | 0.88 | 2.1824 | Natronobacterium gregoryi | 44930 | Archaea | Archaea | 459 | 1.13e-124 | NTclustered | gi|429134263|gb|CP003377.1| | 797304 | g8766 | i0 | 100 | 10.8709677419355 | 248 | 0 | 100 | 0 | 1 | 248 | 1491891 | 1491644 | Natronobacterium gregoryi SP2, complete genome | blastn | 2696 | 459 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobacterium | Natronobacterium gregoryi | |
| 14392750 | 14392750 | PRJNA1262902_P_NODE_8992_length_248_cov_0.880000_g8950_i0 | PRJNA1262902 | 8992 | 248 | 0.88 | 2.1824 | Natronobacterium gregoryi | 44930 | Archaea | Archaea | 453 | 5.2600000000000005e-123 | NTclustered | gi|429134263|gb|CP003377.1| | 797304 | g8950 | i0 | 99.597 | 10.3870967741935 | 248 | 1 | 100 | 0 | 1 | 248 | 1692903 | 1692656 | Natronobacterium gregoryi SP2, complete genome | blastn | 2576 | 453 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobacterium | Natronobacterium gregoryi | |
| 18215250 | 18215250 | PRJNA1262902_P_NODE_11915_length_242_cov_0.911243_g11873_i0 | PRJNA1262902 | 11915 | 242 | 0.911243 | 2.20520806 | Natronobacterium gregoryi | 44930 | Archaea | Archaea | 448 | 2.3799999999999995e-121 | NTclustered | gi|429134263|gb|CP003377.1| | 797304 | g11873 | i0 | 100 | 2.10330578512397 | 242 | 0 | 100 | 0 | 1 | 242 | 1830039 | 1830280 | Natronobacterium gregoryi SP2, complete genome | blastn | 509 | 448 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobacterium | Natronobacterium gregoryi | |
| 22040209 | 22040209 | PRJNA1262902_P_NODE_4278_length_289_cov_1.425926_g4236_i0 | PRJNA1262902 | 4278 | 289 | 1.425926 | 4.12092614 | Natronobacterium gregoryi | 44930 | Archaea | Archaea | 534 | 2.18e-147 | NTclustered | gi|429134263|gb|CP003377.1| | 797304 | g4236 | i0 | 100 | 2.43944636678201 | 289 | 0 | 100 | 0 | 1 | 289 | 3400925 | 3401213 | Natronobacterium gregoryi SP2, complete genome | blastn | 705 | 534 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobacterium | Natronobacterium gregoryi |
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);;