contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA560932" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3095822 | 3095822 | PRJNA560932_P_NODE_64263_length_243_cov_0.905882_g63907_i0 | PRJNA560932 | 64263 | 243 | 0.905882 | 2.20129326 | Archaeoglobus sulfaticallidus | 1316941 | Archaea | Archaea | 52.8 | 0.022 | NTclustered | gi|484591393|gb|CP005290.1| | 387631 | g63907 | i0 | 100 | 0.11522633744856 | 28 | 0 | 12 | 0 | 185 | 212 | 1753892 | 1753865 | Archaeoglobus sulfaticallidus PM70-1, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Archaeoglobi | Archaeoglobales | Archaeoglobaceae | Archaeoglobus | Archaeoglobus sulfaticallidus | ||
| 5648709 | 5648709 | PRJNA560932_P_NODE_6725_length_666_cov_1.974705_g6374_i0 | PRJNA560932 | 6725 | 666 | 1.974705 | 13.1515353 | Halorussus vallis | 2953749 | Archaea | Archaea | 56.5 | 0.005 | NTclustered | gi|2263966384|gb|CP100000.1| | 2953749 | g6374 | i0 | 100 | 0.045045045045045 | 30 | 0 | 5 | 0 | 100 | 129 | 2043996 | 2044025 | Halorussus vallis strain XZYJT10 chromosome, complete genome | blastn | 30 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Halorussus | Halorussus vallis | |
| 6922461 | 6922461 | PRJNA560932_P_NODE_16466_length_433_cov_1.188889_g16110_i0 | PRJNA560932 | 16466 | 433 | 1.188889 | 5.14788937 | Halobaculum sp. CBA1158 | 2904243 | Archaea | Archaea | 54.7 | 0.012 | NTclustered | gi|2176093559|gb|CP090371.1| | 2904243 | g16110 | i0 | 92.308 | 0.0900692840646651 | 39 | 1 | 9 | 2 | 163 | 201 | 2507481 | 2507445 | Halobaculum sp. CBA1158 chromosome, complete genome | blastn | 39 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum sp. CBA1158 | |
| 6922801 | 6922801 | PRJNA560932_P_NODE_54846_length_249_cov_1.295455_g54490_i0 | PRJNA560932 | 54846 | 249 | 1.295455 | 3.22568295 | Natronorarus salvus | 3117733 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|2670420129|gb|CP144125.1| | 3117733 | g54490 | i0 | 100 | 0.120481927710843 | 30 | 0 | 12 | 0 | 41 | 70 | 1818078 | 1818107 | Natronorarus salvus strain CGA53 chromosome, complete genome | blastn | 30 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halalkalicoccaceae | Natronorarus | Natronorarus salvus | |
| 10749163 | 10749163 | PRJNA560932_P_NODE_61429_length_245_cov_0.895349_g61073_i0 | PRJNA560932 | 61429 | 245 | 0.895349 | 2.19360505 | Halobacterium wangiae | 2902623 | Archaea | Archaea | 52.8 | 0.022 | NTclustered | gi|2168769890|gb|CP089588.1| | 2902623 | g61073 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 96 | 123 | 2598188 | 2598161 | Halobacterium wangiae strain Gai3-17 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium wangiae | |
| 13298656 | 13298656 | PRJNA560932_P_NODE_29531_length_331_cov_1.399225_g29175_i0 | PRJNA560932 | 29531 | 331 | 1.399225 | 4.63143475 | Natronosalvus caseinilyticus | 2953747 | Archaea | Archaea | 52.8 | 0.031 | NTclustered | gi|2006550273|gb|CP071596.1| | 2953747 | g29175 | i0 | 100 | 0.0845921450151057 | 28 | 0 | 8 | 0 | 120 | 147 | 1765254 | 1765227 | Natronosalvus caseinilyticus strain KZCA101 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronosalvus | Natronosalvus caseinilyticus | |
| 19671416 | 19671416 | PRJNA560932_P_NODE_8756_length_588_cov_1.285437_g8403_i0 | PRJNA560932 | 8756 | 588 | 1.285437 | 7.55836956 | Thermococcus indicus | 2586643 | Archaea | Archaea | 60.2 | 3.47e-4 | NTclustered | gi|1681065834|gb|CP040846.1| | 2586643 | g8403 | i0 | 94.737 | 0.0646258503401361 | 38 | 2 | 6 | 0 | 5 | 42 | 1809298 | 1809335 | Thermococcus indicus strain IOH1 chromosome, complete genome | blastn | 38 | 60.2 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus indicus | ||
| 23496999 | 23496999 | PRJNA560932_P_NODE_32799_length_316_cov_1.983539_g32443_i0 | PRJNA560932 | 32799 | 316 | 1.983539 | 6.26798324 | Thermococcus indicus | 2586643 | Archaea | Archaea | 58.4 | 6.36e-4 | NTclustered | gi|1681065834|gb|CP040846.1| | 2586643 | g32443 | i0 | 94.595 | 0.117088607594937 | 37 | 2 | 12 | 0 | 280 | 316 | 1809298 | 1809334 | Thermococcus indicus strain IOH1 chromosome, complete genome | blastn | 37 | 58.4 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus indicus | ||
| 23497051 | 23497051 | PRJNA560932_P_NODE_38559_length_293_cov_0.986364_g38203_i0 | PRJNA560932 | 38559 | 293 | 0.986364 | 2.89004652 | Natrialba magadii | 13769 | Archaea | Archaea | 52.8 | 0.027 | NTclustered | gi|289532809|gb|CP001933.1| | 547559 | g38203 | i0 | 100 | 0.0955631399317406 | 28 | 0 | 10 | 0 | 215 | 242 | 272225 | 272252 | Natrialba magadii ATCC 43099 plasmid pNMAG01, complete sequence | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrialba | Natrialba magadii | |
| 24771121 | 24771121 | PRJNA560932_P_NODE_61580_length_245_cov_0.895349_g61224_i0 | PRJNA560932 | 61580 | 245 | 0.895349 | 2.19360505 | uncultured Methanoregulaceae archaeon | 1392423 | Archaea | Archaea | 62.1 | 3.67e-5 | NTclustered | gi|2874254037|emb|OY970361.1| | 1392423 | g61224 | i0 | 100 | 0.371428571428571 | 33 | 0 | 13 | 0 | 39 | 71 | 946034 | 946066 | MAG: uncultured Methanoregulaceae archaeon isolate MFD01476.bin.2.40 genome assembly, chromosome: 1 | blastn | 91 | 62.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | uncultured Methanoregulaceae 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);;