contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA681822" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 651747 | 651747 | PRJNA681822_P_NODE_132881_length_356_cov_1.088339_g131394_i0 | PRJNA681822 | 132881 | 356 | 1.088339 | 3.87448684 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 80.5 | 1.55e-10 | NTclustered | gi|299123054|gb|CP002062.1| | 795797 | g131394 | i0 | 80.342 | 0.328651685393258 | 117 | 13 | 31 | 6 | 248 | 356 | 1407639 | 1407753 | Halalkalicoccus jeotgali B3, complete genome | blastn | 117 | 80.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 3205679 | 3205679 | PRJNA681822_P_NODE_365643_length_256_cov_1.322404_g364154_i0 | PRJNA681822 | 365643 | 256 | 1.322404 | 3.38535424 | Halalkalicoccus salilacus | 3117459 | Archaea | Archaea | 259 | 1.28e-64 | NTclustered | gi|2674869203|gb|CP144461.1| | 3117459 | g364154 | i0 | 88.372 | 8.77734375 | 215 | 25 | 84 | 0 | 4 | 218 | 3226108 | 3225894 | Halalkalicoccus salilacus strain FCH27 chromosome, complete genome | blastn | 2247 | 259 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus salilacus | |
| 3722437 | 3722437 | PRJNA681822_P_NODE_374663_length_253_cov_1.627778_g373174_i0 | PRJNA681822 | 374663 | 253 | 1.627778 | 4.11827834 | Natrialbaceae | 1644061 | Archaea | Archaea | 206 | 1.67e-48 | NTclustered | gi|2110956531|gb|CP084472.1| | 2878680 | g373174 | i0 | 81.967 | 4.54940711462451 | 244 | 42 | 96 | 2 | 9 | 251 | 1401413 | 1401171 | Natrinema sp. DC36 chromosome, complete genome | blastn | 1151 | 206 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema sp. DC36 | |
| 4481944 | 4481944 | PRJNA681822_P_NODE_291984_length_276_cov_1.517241_g290495_i0 | PRJNA681822 | 291984 | 276 | 1.517241 | 4.18758516 | Salinarchaeum sp. Harcht-Bsk1 | 1333523 | Archaea | Archaea | 52.8 | 0.025 | NTclustered | gi|507914357|gb|CP005962.1| | 1333523 | g290495 | i0 | 100 | 0.101449275362319 | 28 | 0 | 10 | 0 | 238 | 265 | 2589815 | 2589842 | Salinarchaeum sp. Harcht-Bsk1, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronoarchaeaceae | Salinarchaeum | Salinarchaeum sp. Harcht-Bsk1 | |
| 5756921 | 5756921 | PRJNA681822_P_NODE_234745_length_290_cov_1.373272_g233256_i0 | PRJNA681822 | 234745 | 290 | 1.373272 | 3.9824888 | Haloferax volcanii | 2246 | Archaea | Archaea | 211 | 4.19e-50 | NTclustered | gi|2459773771|gb|CP104741.1| | 2246 | g233256 | i0 | 81.273 | 21.0103448275862 | 267 | 44 | 94 | 6 | 6 | 269 | 1020393 | 1020130 | Haloferax volcanii strain SVX82 chromosome, complete genome | blastn | 6093 | 211 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax volcanii | |
| 5758890 | 5758890 | PRJNA681822_P_NODE_399525_length_249_cov_2.164773_g398036_i0 | PRJNA681822 | 399525 | 249 | 2.164773 | 5.39028477 | Halomarina pelagica | 2961599 | Archaea | Archaea | 460 | 3.16e-125 | NTclustered | gi|2270305250|gb|CP100454.1| | 2961599 | g398036 | i0 | 100 | 1.99196787148594 | 249 | 0 | 100 | 0 | 1 | 249 | 3316389 | 3316637 | Halomarina pelagica strain BND7 chromosome, complete genome | blastn | 496 | 460 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halomarina | Halomarina pelagica | |
| 5759813 | 5759813 | PRJNA681822_P_NODE_471085_length_242_cov_0.911243_g469595_i0 | PRJNA681822 | 471085 | 242 | 0.911243 | 2.20520806 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 183 | 7.41e-42 | NTclustered | gi|299123054|gb|CP002062.1| | 795797 | g469595 | i0 | 80.498 | 2.80578512396694 | 241 | 45 | 99 | 2 | 1 | 240 | 1173786 | 1173547 | Halalkalicoccus jeotgali B3, complete genome | blastn | 679 | 183 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 6274867 | 6274867 | PRJNA681822_P_NODE_445405_length_245_cov_0.895349_g443916_i0 | PRJNA681822 | 445405 | 245 | 0.895349 | 2.19360505 | Halobacteriales | 2235 | Archaea | Archaea | 147 | 9.86e-31 | NTclustered | gi|299123054|gb|CP002062.1| | 795797 | g443916 | i0 | 81.564 | 5.75510204081633 | 179 | 31 | 73 | 2 | 58 | 235 | 2642678 | 2642855 | Halalkalicoccus jeotgali B3, complete genome | blastn | 1410 | 148 | 0.993243243243243 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 12650135 | 12650135 | PRJNA681822_P_NODE_410970_length_248_cov_1.480000_g409481_i0 | PRJNA681822 | 410970 | 248 | 1.48 | 3.6704 | Haladaptatus | 367188 | Archaea | Archaea | 180 | 9.859999999999999e-41 | NTclustered | gi|2463595529|gb|CP119782.1| | 3033384 | g409481 | i0 | 80.081 | 2.97983870967742 | 246 | 45 | 98 | 4 | 5 | 248 | 1146211 | 1145968 | Haladaptatus sp. YSMS36 chromosome, complete genome | blastn | 739 | 180 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus sp. YSMS36 | |
| 13408057 | 13408057 | PRJNA681822_P_NODE_304951_length_273_cov_1.220000_g303462_i0 | PRJNA681822 | 304951 | 273 | 1.22 | 3.3306 | Halalkalicoccus salilacus | 3117459 | Archaea | Archaea | 315 | 2.9e-81 | NTclustered | gi|2674869203|gb|CP144461.1| | 3117459 | g303462 | i0 | 87.5 | 0.996336996336996 | 272 | 34 | 99 | 0 | 1 | 272 | 434096 | 434367 | Halalkalicoccus salilacus strain FCH27 chromosome, complete genome | blastn | 272 | 315 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus salilacus | |
| 14683577 | 14683577 | PRJNA681822_P_NODE_337532_length_264_cov_1.413613_g336043_i0 | PRJNA681822 | 337532 | 264 | 1.413613 | 3.73193832 | Halorarius halobius | 2962671 | Archaea | Archaea | 320 | 5.99e-83 | NTclustered | gi|2273560674|gb|CP101161.1| | 2962671 | g336043 | i0 | 88.593 | 0.996212121212121 | 263 | 30 | 99 | 0 | 1 | 263 | 3550245 | 3550507 | Halorarius halobius strain ZY10 chromosome, complete genome | blastn | 263 | 320 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halorarius | Halorarius halobius | |
| 15954653 | 15954653 | PRJNA681822_P_NODE_139073_length_350_cov_1.826715_g137585_i0 | PRJNA681822 | 139073 | 350 | 1.826715 | 6.3935025 | Halobaculum lipolyticum | 3032001 | Archaea | Archaea | 56.5 | 0.003 | NTclustered | gi|2511738008|gb|CP126154.1| | 3032001 | g137585 | i0 | 100 | 0.0857142857142857 | 30 | 0 | 9 | 0 | 163 | 192 | 2151638 | 2151609 | Halobaculum lipolyticum strain DT31 chromosome, complete genome | blastn | 30 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum lipolyticum | |
| 18507192 | 18507192 | PRJNA681822_P_NODE_384155_length_251_cov_0.865169_g382666_i0 | PRJNA681822 | 384155 | 251 | 0.865169 | 2.17157419 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 291 | 4.43e-74 | NTclustered | gi|299123054|gb|CP002062.1| | 795797 | g382666 | i0 | 87.6 | 43.0119521912351 | 250 | 31 | 99 | 0 | 2 | 251 | 754888 | 755137 | Halalkalicoccus jeotgali B3, complete genome | blastn | 10796 | 291 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali | |
| 19781131 | 19781131 | PRJNA681822_P_NODE_316376_length_270_cov_1.192893_g314887_i0 | PRJNA681822 | 316376 | 270 | 1.192893 | 3.2208111 | Halosimplex aquaticum | 3026162 | Archaea | Archaea | 104 | 6.74e-18 | NTclustered | gi|2446562038|gb|CP118158.1| | 3026162 | g314887 | i0 | 88.636 | 39.7296296296296 | 88 | 7 | 32 | 3 | 116 | 201 | 2366958 | 2366872 | Halosimplex aquaticum strain XZYJT29 chromosome, complete genome | blastn | 10727 | 104 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halosimplex | Halosimplex aquaticum | |
| 19782654 | 19782654 | PRJNA681822_P_NODE_436576_length_246_cov_0.890173_g435087_i0 | PRJNA681822 | 436576 | 246 | 0.890173 | 2.18982558 | Halopiger xanaduensis | 387343 | Archaea | Archaea | 171 | 5.879999999999999e-38 | NTclustered | gi|335336085|gb|CP002839.1| | 797210 | g435087 | i0 | 85.714 | 2.2520325203252 | 161 | 23 | 65 | 0 | 54 | 214 | 1851905 | 1851745 | Halopiger xanaduensis SH-6, complete genome | blastn | 554 | 171 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Halopiger | Halopiger xanaduensis | |
| 21058283 | 21058283 | PRJNA681822_P_NODE_434957_length_246_cov_0.890173_g433468_i0 | PRJNA681822 | 434957 | 246 | 0.890173 | 2.18982558 | Natronosalvus caseinilyticus | 2953747 | Archaea | Archaea | 154 | 5.9200000000000005e-33 | NTclustered | gi|2006550273|gb|CP071596.1| | 2953747 | g433468 | i0 | 82.123 | 0.727642276422764 | 179 | 32 | 73 | 0 | 1 | 179 | 129959 | 129781 | Natronosalvus caseinilyticus strain KZCA101 chromosome, complete genome | blastn | 179 | 154 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronosalvus | Natronosalvus caseinilyticus | |
| 24880955 | 24880955 | PRJNA681822_P_NODE_359780_length_257_cov_2.836957_g358291_i0 | PRJNA681822 | 359780 | 257 | 2.836957 | 7.29097949 | Halorubrum hochsteinianum | 2949307 | Archaea | Archaea | 152 | 2.24e-32 | NTclustered | gi|2251941869|gb|CP098415.1| | 2949307 | g358291 | i0 | 78 | 0.972762645914397 | 250 | 49 | 96 | 6 | 1 | 247 | 894055 | 893809 | Halorubrum hochsteinianum strain 1-13-28 chromosome, complete genome | blastn | 250 | 152 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum hochsteinianum | |
| 24881794 | 24881794 | PRJNA681822_P_NODE_426320_length_247_cov_0.885057_g424831_i0 | PRJNA681822 | 426320 | 247 | 0.885057 | 2.18609079 | Halalkalicoccus jeotgali | 413810 | Archaea | Archaea | 145 | 3.58e-30 | NTclustered | gi|299126090|gb|CP002063.1| | 795797 | g424831 | i0 | 77.912 | 1.58704453441296 | 249 | 44 | 98 | 9 | 4 | 246 | 72037 | 72280 | Halalkalicoccus jeotgali B3 plasmid 1, complete sequence | blastn | 392 | 145 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus jeotgali |
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);;