contig_metadata
14 rows where bioproject = "PRJDB4470" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1283332 | 1283332 | PRJDB4470_P_NODE_110942_length_165_cov_0.896552_g109787_i0 | PRJDB4470 | 110942 | 165 | 0.896552 | 1.4793108 | Halalkalicoccus salilacus | 3117459 | Archaea | Archaea | 152 | 1.3199999999999998e-32 | NTclustered | gi|2674869203|gb|CP144461.1| | 3117459 | g109787 | i0 | 83.735 | 2.89090909090909 | 166 | 21 | 99 | 5 | 1 | 163 | 1178529 | 1178367 | Halalkalicoccus salilacus strain FCH27 chromosome, complete genome | blastn | 477 | 152 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus salilacus | |
| 2558903 | 2558903 | PRJDB4470_P_NODE_102483_length_168_cov_0.873950_g101328_i0 | PRJDB4470 | 102483 | 168 | 0.87395 | 1.468236 | Halalkalicoccus salilacus | 3117459 | Archaea | Archaea | 196 | 6.16e-46 | NTclustered | gi|2674869206|gb|CP144464.1| | 3117459 | g101328 | i0 | 88.095 | 2 | 168 | 17 | 100 | 2 | 1 | 168 | 28823 | 28987 | Halalkalicoccus salilacus strain FCH27 plasmid unnamed3, complete sequence | blastn | 336 | 196 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus salilacus | |
| 3531837 | 3531837 | PRJDB4470_P_NODE_104683_length_167_cov_0.881356_g103528_i0 | PRJDB4470 | 104683 | 167 | 0.881356 | 1.47186452 | Halomarina | 871740 | Archaea | Archaea | 150 | 4.83e-32 | NTclustered | gi|2270305250|gb|CP100454.1| | 2961599 | g103528 | i0 | 87.121 | 29.6347305389222 | 132 | 17 | 83 | 0 | 1 | 132 | 2795611 | 2795742 | Halomarina pelagica strain BND7 chromosome, complete genome | blastn | 4949 | 150 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halomarina | Halomarina pelagica | |
| 6084436 | 6084436 | PRJDB4470_P_NODE_28365_length_435_cov_4.582902_g27225_i0 | PRJDB4470 | 28365 | 435 | 4.582902 | 19.9356237 | Methanolobus | 2220 | Archaea | Archaea | 54.7 | 0.012 | NTclustered | gi|2621717818|emb|OY776215.1| | 218300 | g27225 | i0 | 96.875 | 2.13333333333333 | 32 | 1 | 7 | 0 | 378 | 409 | 1488584 | 1488553 | MAG: uncultured Methanolobus sp. isolate 56865bd2-6141-42f0-955c-5236203a12ea genome assembly, chromosome: 1 | blastn | 928 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanolobus | uncultured Methanolobus sp. | |
| 10212183 | 10212183 | PRJDB4470_P_NODE_26029_length_460_cov_2.102190_g24893_i0 | PRJDB4470 | 26029 | 460 | 2.10219 | 9.670074 | Natrinema pellirubrum | 69525 | Archaea | Archaea | 52.8 | 0.045 | NTclustered | gi|433304139|gb|CP003372.1| | 797303 | g24893 | i0 | 100 | 0.0608695652173913 | 28 | 0 | 6 | 0 | 65 | 92 | 2724862 | 2724835 | Natrinema pellirubrum DSM 15624, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema pellirubrum | |
| 19134554 | 19134554 | PRJDB4470_P_NODE_102316_length_168_cov_0.873950_g101161_i0 | PRJDB4470 | 102316 | 168 | 0.87395 | 1.468236 | Natronorubrum daqingense | 588898 | Archaea | Archaea | 226 | 7.859999999999997e-55 | NTclustered | gi|1134983310|gb|CP019329.1| | 588898 | g101161 | i0 | 91.018 | 0.994047619047619 | 167 | 15 | 99 | 0 | 1 | 167 | 17259 | 17093 | Natronorubrum daqingense strain JX313T plasmid unnamed2, complete sequence | blastn | 167 | 226 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronorubrum | Natronorubrum daqingense | |
| 19134565 | 19134565 | PRJDB4470_P_NODE_104336_length_167_cov_0.881356_g103181_i0 | PRJDB4470 | 104336 | 167 | 0.881356 | 1.47186452 | Natronorubrum daqingense | 588898 | Archaea | Archaea | 268 | 1.28e-67 | NTclustered | gi|1134979927|gb|CP019327.1| | 588898 | g103181 | i0 | 95.783 | 99.4311377245509 | 166 | 7 | 99 | 0 | 2 | 167 | 1189581 | 1189416 | Natronorubrum daqingense strain JX313, complete sequence | blastn | 16605 | 268 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronorubrum | Natronorubrum daqingense | |
| 28258140 | 28258140 | PRJDB4470_P_NODE_107786_length_166_cov_0.888889_g106631_i0 | PRJDB4470 | 107786 | 166 | 0.888889 | 1.47555574 | Halobacteriales | 2235 | Archaea | Archaea | 102 | 2.08e-24 | NR | WP_340605028.1 | 175632 | g106631 | i0 | 81.8 | 8.94578313253012 | 55 | 10 | 99.4 | 0 | 166 | 2 | 89 | 143 | WP_340605028.1 D-2-hydroxyacid dehydrogenase [Halalkalicoccus tibetensis] | diamond | 1485 | 102 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus tibetensis | |
| 28485284 | 28485284 | PRJDB4470_P_NODE_114567_length_164_cov_0.904348_g113412_i0 | PRJDB4470 | 114567 | 164 | 0.904348 | 1.48313072 | Halalkalicoccus paucihalophilus | 1008153 | Archaea | Archaea | 50.8 | 1.43e-6 | NR | KYH23987.1 | 1008153 | g113412 | i0 | 48.9 | 0.859756097560976 | 47 | 23 | 86 | 1 | 12 | 152 | 16 | 61 | KYH23987.1 hypothetical protein HAPAU_40660 [Halalkalicoccus paucihalophilus] | diamond | 141 | 50.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus paucihalophilus | |
| 29621425 | 29621425 | PRJDB4470_P_NODE_34250_length_384_cov_1.808955_g33101_i0 | PRJDB4470 | 34250 | 384 | 1.808955 | 6.9463872 | Halogranum rubrum | 553466 | Archaea | Archaea | 44.3 | 0.0459 | NR | WP_009367134.1 | 553466 | g33101 | i0 | 41.9 | 0.484375 | 62 | 30 | 43.8 | 2 | 321 | 154 | 226 | 287 | WP_009367134.1 cation:proton antiporter [Halogranum rubrum] | diamond | 186 | 44.3 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halogranum | Halogranum rubrum | |
| 30980531 | 30980531 | PRJDB4470_P_NODE_123354_length_162_cov_0.902655_g122199_i0 | PRJDB4470 | 123354 | 162 | 0.902655 | 1.4623011 | Methanomicrobia archaeon | 2268195 | Archaea | Archaea | 47.8 | 2.16e-4 | NR | NCA96145.1 | 2268195 | g122199 | i0 | 53.5 | 0.796296296296296 | 43 | 20 | 79.6 | 0 | 162 | 34 | 315 | 357 | NCA96145.1 hypothetical protein [Methanomicrobia archaeon] | diamond | 129 | 47.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobia archaeon | ||||
| 31486383 | 31486383 | PRJDB4470_P_NODE_122876_length_162_cov_0.920354_g121721_i0 | PRJDB4470 | 122876 | 162 | 0.920354 | 1.49097348 | Natronococcus sp. A-GB7 | 3037649 | Archaea | Archaea | 65.1 | 7.45e-11 | NR | WP_278305244.1 | 3037649 | g121721 | i0 | 58.5 | 0.981481481481482 | 53 | 22 | 98.1 | 0 | 1 | 159 | 63 | 115 | WP_278305244.1 hypothetical protein [Natronococcus sp. A-GB7] | diamond | 159 | 65.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronococcus | Natronococcus sp. A-GB7 | |
| 31675811 | 31675811 | PRJDB4470_P_NODE_110737_length_165_cov_0.896552_g109582_i0 | PRJDB4470 | 110737 | 165 | 0.896552 | 1.4793108 | Halalkalicoccus sp. | 1973143 | Archaea | Archaea | 87 | 2.92e-18 | NR | MEM4780006.1 | 1973143 | g109582 | i0 | 71.7 | 0.963636363636364 | 53 | 15 | 96.4 | 0 | 163 | 5 | 436 | 488 | MEM4780006.1 alpha-amylase family glycosyl hydrolase [Halalkalicoccus sp.] | diamond | 159 | 87 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus sp. | |
| 32813682 | 32813682 | PRJDB4470_P_NODE_102860_length_168_cov_0.873950_g101705_i0 | PRJDB4470 | 102860 | 168 | 0.87395 | 1.468236 | Halococcus sp. | 29286 | Archaea | Archaea | 87 | 2.58e-19 | NR | HET7323524.1 | 29286 | g101705 | i0 | 72.2 | 0.964285714285714 | 54 | 15 | 96.4 | 0 | 167 | 6 | 29 | 82 | HET7323524.1 hypothetical protein [Halococcus sp.] | diamond | 162 | 87 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. |
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);;