contig_metadata
17 rows where bioproject = "PRJNA473799" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 445747 | 445747 | PRJNA473799_P_NODE_34421_length_251_cov_1.500000_g34147_i0 | PRJNA473799 | 34421 | 251 | 1.5 | 3.765 | Natronomonas moolapensis | 416273 | Archaea | Archaea | 326 | 1.21e-84 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g34147 | i0 | 90.04 | 12.0597609561753 | 251 | 25 | 100 | 0 | 1 | 251 | 577230 | 577480 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 3027 | 326 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 445948 | 445948 | PRJNA473799_P_NODE_47441_length_244_cov_1.444444_g47167_i0 | PRJNA473799 | 47441 | 244 | 1.444444 | 3.52444336 | Salinarchaeum laminariae | 869888 | Archaea | Archaea | 56.5 | 0.002 | NTclustered | gi|2232746502|gb|CP096270.1| | 869888 | g47167 | i0 | 75.556 | 2.56147540983607 | 135 | 21 | 53 | 9 | 115 | 243 | 725028 | 724900 | Salinarchaeum laminariae strain R26 chromosome | blastn | 625 | 56.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronoarchaeaceae | Salinarchaeum | Salinarchaeum laminariae | |
| 1720505 | 1720505 | PRJNA473799_P_NODE_32602_length_254_cov_1.701657_g32328_i0 | PRJNA473799 | 32602 | 254 | 1.701657 | 4.32220878 | Halorubrum sp. CBA1229 | 1853699 | Archaea | Archaea | 425 | 1.18e-114 | NTclustered | gi|1861358827|gb|CP054585.1| | 1853699 | g32328 | i0 | 96.85 | 99.7755905511811 | 254 | 8 | 100 | 0 | 1 | 254 | 551534 | 551787 | Halorubrum sp. CBA1229 chromosome, complete genome | blastn | 25343 | 425 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum sp. CBA1229 | |
| 2996170 | 2996170 | PRJNA473799_P_NODE_22643_length_273_cov_1.255000_g22369_i0 | PRJNA473799 | 22643 | 273 | 1.255 | 3.42615 | haloarchaeon 3A1-DGR | 1071085 | Archaea | Archaea | 132 | 3.1300000000000003e-26 | NTclustered | gi|1804090075|gb|CP048032.1| | 1071085 | g22369 | i0 | 95.181 | 0.608058608058608 | 83 | 4 | 30 | 0 | 191 | 273 | 2706754 | 2706672 | Haloarchaeon 3A1-DGR strain 3A1-DGR chromosome, complete genome | blastn | 166 | 132 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | haloarchaeon 3A1-DGR | |||
| 5549132 | 5549132 | PRJNA473799_P_NODE_20465_length_277_cov_1.828431_g20191_i0 | PRJNA473799 | 20465 | 277 | 1.828431 | 5.06475387 | Halococcus | 2249 | Archaea | Archaea | 145 | 1.2899999999999999e-39 | NR | WP_004053181.1 | 2250 | g20191 | i0 | 86.4 | 2.87003610108303 | 88 | 12 | 95.3 | 0 | 3 | 266 | 300 | 387 | WP_004053181.1 DNA polymerase IV [Halococcus morrhuae] | diamond | 795 | 146 | 0.993150684931507 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus morrhuae | |
| 14474094 | 14474094 | PRJNA473799_P_NODE_20132_length_278_cov_1.302439_g19858_i0 | PRJNA473799 | 20132 | 278 | 1.302439 | 3.62078042 | Halococcus qingdaonensis | 224402 | Archaea | Archaea | 381 | 2.869999999999999e-101 | NTclustered | gi|2281256326|gb|CP101943.1| | 224402 | g19858 | i0 | 91.367 | 1 | 278 | 24 | 100 | 0 | 1 | 278 | 264859 | 265136 | Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome | blastn | 278 | 381 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis | |
| 14474160 | 14474160 | PRJNA473799_P_NODE_25832_length_267_cov_1.036082_g25558_i0 | PRJNA473799 | 25832 | 267 | 1.036082 | 2.76633894 | Halococcus qingdaonensis | 224402 | Archaea | Archaea | 355 | 1.66e-93 | NTclustered | gi|2281256326|gb|CP101943.1| | 224402 | g25558 | i0 | 90.637 | 2.00374531835206 | 267 | 25 | 100 | 0 | 1 | 267 | 815560 | 815826 | Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome | blastn | 535 | 355 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis | |
| 15748586 | 15748586 | PRJNA473799_P_NODE_49733_length_243_cov_0.905882_g49459_i0 | PRJNA473799 | 49733 | 243 | 0.905882 | 2.20129326 | Haloferacaceae archaeon 50 | 3384156 | Archaea | Archaea | 263 | 9.3e-66 | NTclustered | gi|2869714876|gb|CP175567.1| | 3384156 | g49459 | i0 | 86.42 | 42.7119341563786 | 243 | 29 | 99 | 4 | 3 | 243 | 716200 | 715960 | Haloferacaceae archaeon 50 chromosome, complete genome | blastn | 10379 | 263 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferacaceae archaeon 50 | ||
| 18297439 | 18297439 | PRJNA473799_P_NODE_44595_length_246_cov_0.890173_g44321_i0 | PRJNA473799 | 44595 | 246 | 0.890173 | 2.18982558 | Haladaptatus paucihalophilus | 367189 | Archaea | Archaea | 134 | 2.32e-35 | NR | WP_007977179.1 | 367189 | g44321 | i0 | 86.4 | 5.92682926829268 | 81 | 11 | 98.8 | 0 | 244 | 2 | 181 | 261 | WP_007977179.1 ABC transporter ATP-binding protein [Haladaptatus paucihalophilus] | diamond | 1458 | 134 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus paucihalophilus | |
| 19571733 | 19571733 | PRJNA473799_P_NODE_55256_length_238_cov_3.490909_g54982_i0 | PRJNA473799 | 55256 | 238 | 3.490909 | 8.30836342 | Haloarcula regularis | 3033392 | Archaea | Archaea | 206 | 1.5499999999999998e-48 | NTclustered | gi|2463595545|gb|CP119794.1| | 3033392 | g54982 | i0 | 86.082 | 16.3655462184874 | 194 | 23 | 81 | 3 | 47 | 238 | 2100617 | 2100808 | Haloarcula regularis strain SYNS111 chromosome, complete genome | blastn | 3895 | 206 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula regularis | |
| 21497426 | 21497426 | PRJNA473799_P_NODE_17937_length_283_cov_1.000000_g17663_i0 | PRJNA473799 | 17937 | 283 | 1 | 2.83 | Halobaculum | 43927 | Archaea | Archaea | 150 | 8.999999999999999e-32 | NTclustered | gi|2087953847|gb|CP081958.1| | 1017351 | g17663 | i0 | 81.522 | 2.85512367491166 | 184 | 32 | 65 | 2 | 96 | 278 | 2132308 | 2132490 | Halobaculum magnesiiphilum strain NBRC 109044 chromosome, complete genome | blastn | 808 | 150 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum magnesiiphilum | |
| 26823181 | 26823181 | PRJNA473799_P_NODE_54421_length_241_cov_0.916667_g54147_i0 | PRJNA473799 | 54421 | 241 | 0.916667 | 2.20916747 | Methanocorpusculum sp. | 2058474 | Archaea | Archaea | 130 | 6.02e-37 | NR | MBO5368031.1 | 2058474 | g54147 | i0 | 100 | 0.809128630705394 | 65 | 0 | 80.9 | 0 | 2 | 196 | 80 | 144 | MBO5368031.1 GxxExxY protein [Methanocorpusculum sp.] | diamond | 195 | 130 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocorpusculaceae | Methanocorpusculum | Methanocorpusculum sp. | |
| 29239783 | 29239783 | PRJNA473799_P_NODE_55169_length_239_cov_2.493976_g54895_i0 | PRJNA473799 | 55169 | 239 | 2.493976 | 5.96060264 | Halococcus | 2249 | Archaea | Archaea | 110 | 1.19e-29 | NR | WP_244706887.1 | 179637 | g54895 | i0 | 68.4 | 1.92050209205021 | 79 | 23 | 99.2 | 1 | 1 | 237 | 21 | 97 | WP_244706887.1 hypothetical protein [Halococcus dombrowskii] | diamond | 459 | 111 | 0.990990990990991 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 30044502 | 30044502 | PRJNA473799_P_NODE_27691_length_263_cov_1.489474_g27417_i0 | PRJNA473799 | 27691 | 263 | 1.489474 | 3.91731662 | Halococcus thailandensis | 335952 | Archaea | Archaea | 134 | 7.23e-39 | NR | WP_007736898.1 | 335952 | g27417 | i0 | 92.8 | 0.787072243346008 | 69 | 5 | 78.7 | 0 | 262 | 56 | 36 | 104 | WP_007736898.1 hypothetical protein [Halococcus thailandensis] | diamond | 207 | 134 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus thailandensis | |
| 31530109 | 31530109 | PRJNA473799_P_NODE_27776_length_263_cov_1.294737_g27502_i0 | PRJNA473799 | 27776 | 263 | 1.294737 | 3.40515831 | Halobacteriaceae archaeon | 1931997 | Archaea | Archaea | 114 | 1.87e-28 | NR | MFB6120523.1 | 1931997 | g27502 | i0 | 58.8 | 0.96958174904943 | 85 | 35 | 97 | 0 | 9 | 263 | 32 | 116 | MFB6120523.1 ADP-ribosylglycohydrolase family protein [Halobacteriaceae archaeon] | diamond | 255 | 114 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacteriaceae archaeon | ||
| 31719724 | 31719724 | PRJNA473799_P_NODE_37157_length_250_cov_0.870056_g36883_i0 | PRJNA473799 | 37157 | 250 | 0.870056 | 2.17514 | Halococcus sediminicola | 1264579 | Archaea | Archaea | 73.9 | 1.59e-13 | NR | WP_049998096.1 | 1264579 | g36883 | i0 | 68.5 | 0.648 | 54 | 17 | 64.8 | 0 | 87 | 248 | 1 | 54 | WP_049998096.1 hypothetical protein [Halococcus sediminicola] | diamond | 162 | 73.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sediminicola | |
| 31909524 | 31909524 | PRJNA473799_P_NODE_49097_length_243_cov_2.247059_g48823_i0 | PRJNA473799 | 49097 | 243 | 2.247059 | 5.46035337 | Halobacteriales archaeon QS_8_65_32 | 1919186 | Archaea | Archaea | 149 | 5.59e-40 | NR | PSQ21896.1 | 1919186 | g48823 | i0 | 96.2 | 0.962962962962963 | 78 | 3 | 96.3 | 0 | 236 | 3 | 398 | 475 | PSQ21896.1 MAG: formate dehydrogenase subunit alpha [Halobacteriales archaeon QS_8_65_32] | diamond | 234 | 149 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriales archaeon QS_8_65_32 |
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);;