contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA725806" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4540105 | 4540105 | PRJNA725806_P_NODE_122424_length_183_cov_1.589041_g122122_i0 | PRJNA725806 | 122424 | 183 | 1.589041 | 2.90794503 | Halococcus salsus | 2162894 | Archaea | Archaea | 119 | 7.849999999999998e-30 | NR | WP_160132789.1 | 2162894 | g122122 | i0 | 96.7 | 0.983606557377049 | 60 | 2 | 98.4 | 0 | 3 | 182 | 55 | 114 | WP_160132789.1 tRNA guanosine(15) transglycosylase TgtA [Halococcus salsus] | diamond | 180 | 119 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus salsus | |
| 27062553 | 27062553 | PRJNA725806_P_NODE_139262_length_174_cov_1.401460_g138960_i0 | PRJNA725806 | 139262 | 174 | 1.40146 | 2.4385404 | Halobacteriales | 2235 | Archaea | Archaea | 106 | 5.19e-25 | NR | WP_120068331.1 | 2321230 | g138960 | i0 | 93 | 4.91379310344828 | 57 | 4 | 98.3 | 0 | 3 | 173 | 374 | 430 | WP_120068331.1 transposase [Halococcus sp. IIIV-5B] | diamond | 855 | 107 | 0.990654205607477 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. IIIV-5B | |
| 27220357 | 27220357 | PRJNA725806_P_NODE_43062_length_260_cov_1.040359_g42765_i0 | PRJNA725806 | 43062 | 260 | 1.040359 | 2.7049334 | Halobacteriales | 2235 | Archaea | Archaea | 108 | 4.28e-25 | NR | MFB6102492.1 | 1961696 | g42765 | i0 | 59.3 | 1.98461538461538 | 86 | 35 | 99.2 | 0 | 260 | 3 | 14 | 99 | MFB6102492.1 NosD domain-containing protein [Haloplanus sp.] | diamond | 516 | 108 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus sp. | |
| 27431756 | 27431756 | PRJNA725806_P_NODE_196083_length_150_cov_1.371681_g195781_i0 | PRJNA725806 | 196083 | 150 | 1.371681 | 2.0575215 | Halococcus sp. IIIV-5B | 2321230 | Archaea | Archaea | 45.8 | 8.31e-4 | NR | WP_120071569.1 | 2321230 | g195781 | i0 | 65.8 | 0.76 | 38 | 13 | 76 | 0 | 142 | 29 | 263 | 300 | WP_120071569.1 hypothetical protein [Halococcus sp. IIIV-5B] | diamond | 114 | 45.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. IIIV-5B | |
| 27747434 | 27747434 | PRJNA725806_P_NODE_174984_length_158_cov_1.272727_g174682_i0 | PRJNA725806 | 174984 | 158 | 1.272727 | 2.01090866 | Halococcus hamelinensis | 332168 | Archaea | Archaea | 118 | 8.289999999999998e-30 | NR | WP_007692859.1 | 332168 | g174682 | i0 | 100 | 1.9746835443038 | 52 | 0 | 98.7 | 0 | 158 | 3 | 162 | 213 | WP_007692859.1 sulfatase-like hydrolase/transferase [Halococcus hamelinensis] | diamond | 312 | 118 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus hamelinensis | |
| 28000055 | 28000055 | PRJNA725806_P_NODE_196265_length_150_cov_1.238938_g195963_i0 | PRJNA725806 | 196265 | 150 | 1.238938 | 1.858407 | Haloferax sp. Atlit-4N | 2077206 | Archaea | Archaea | 58.5 | 2.71e-8 | NR | WP_147302064.1 | 2077206 | g195963 | i0 | 57.4 | 0.94 | 47 | 20 | 94 | 0 | 142 | 2 | 483 | 529 | WP_147302064.1 hypothetical protein [Haloferax sp. Atlit-4N] | diamond | 141 | 58.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax sp. Atlit-4N | |
| 28031507 | 28031507 | PRJNA725806_P_NODE_190845_length_152_cov_1.017391_g190543_i0 | PRJNA725806 | 190845 | 152 | 1.017391 | 1.54643432 | Halococcus sp. IIIV-5B | 2321230 | Archaea | Archaea | 93.6 | 1.27e-20 | NR | WP_147464870.1 | 2321230 | g190543 | i0 | 84 | 0.986842105263158 | 50 | 8 | 98.7 | 0 | 152 | 3 | 291 | 340 | WP_147464870.1 metal-dependent hydrolase [Halococcus sp. IIIV-5B] | diamond | 150 | 93.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. IIIV-5B | |
| 28283761 | 28283761 | PRJNA725806_P_NODE_190366_length_152_cov_1.626087_g190064_i0 | PRJNA725806 | 190366 | 152 | 1.626087 | 2.47165224 | Haladaptatus caseinilyticus | 2993314 | Archaea | Archaea | 75.5 | 1.41e-14 | NR | WP_266082778.1 | 2993314 | g190064 | i0 | 67.3 | 0.967105263157895 | 49 | 16 | 96.7 | 0 | 150 | 4 | 204 | 252 | WP_266082778.1 Bug family tripartite tricarboxylate transporter substrate binding protein [Haladaptatus caseinilyticus] | diamond | 147 | 75.5 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haladaptataceae | Haladaptatus | Haladaptatus caseinilyticus | |
| 29168264 | 29168264 | PRJNA725806_P_NODE_177689_length_157_cov_0.941667_g177387_i0 | PRJNA725806 | 177689 | 157 | 0.941667 | 1.47841719 | Halococcus hamelinensis | 332168 | Archaea | Archaea | 108 | 2.79e-27 | NR | WP_007692660.1 | 332168 | g177387 | i0 | 100 | 0.993630573248408 | 52 | 0 | 99.4 | 0 | 157 | 2 | 31 | 82 | WP_007692660.1 hypothetical protein [Halococcus hamelinensis] | diamond | 156 | 108 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus hamelinensis | |
| 29357581 | 29357581 | PRJNA725806_P_NODE_196389_length_150_cov_1.026549_g196087_i0 | PRJNA725806 | 196389 | 150 | 1.026549 | 1.5398235 | Halococcus hamelinensis | 332168 | Archaea | Archaea | 101 | 8.499999999999999e-24 | NR | WP_007689600.1 | 332168 | g196087 | i0 | 93.9 | 1.96 | 49 | 3 | 98 | 0 | 150 | 4 | 206 | 254 | WP_007689600.1 tyrosine-type recombinase/integrase [Halococcus hamelinensis] | diamond | 294 | 101 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus hamelinensis | |
| 29609763 | 29609763 | PRJNA725806_P_NODE_169930_length_160_cov_1.260163_g169628_i0 | PRJNA725806 | 169930 | 160 | 1.260163 | 2.0162608 | Halococcus qingdaonensis | 224402 | Archaea | Archaea | 47.4 | 5.53e-5 | NR | WP_256687409.1 | 224402 | g169628 | i0 | 76.7 | 0.975 | 30 | 7 | 56.3 | 0 | 90 | 1 | 1 | 30 | WP_256687409.1 AzlD family protein [Halococcus qingdaonensis] | diamond | 156 | 47.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis | |
| 29831094 | 29831094 | PRJNA725806_P_NODE_165371_length_162_cov_0.936000_g165069_i0 | PRJNA725806 | 165371 | 162 | 0.936 | 1.51632 | Halomarina salina | 1872699 | Archaea | Archaea | 68.6 | 9.44e-12 | NR | WP_247421998.1 | 1872699 | g165069 | i0 | 57.7 | 0.962962962962963 | 52 | 22 | 96.3 | 0 | 161 | 6 | 291 | 342 | WP_247421998.1 hypothetical protein [Halomarina salina] | diamond | 156 | 68.6 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halomarina | Halomarina salina | |
| 30209997 | 30209997 | PRJNA725806_P_NODE_190892_length_152_cov_1.000000_g190590_i0 | PRJNA725806 | 190892 | 152 | 1 | 1.52 | Halococcus hamelinensis | 332168 | Archaea | Archaea | 99 | 9.86e-23 | NR | WP_007694694.1 | 332168 | g190590 | i0 | 98 | 0.986842105263158 | 50 | 1 | 98.7 | 0 | 1 | 150 | 190 | 239 | WP_007694694.1 sulfatase-like hydrolase/transferase [Halococcus hamelinensis] | diamond | 150 | 99 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus hamelinensis | |
| 30368658 | 30368658 | PRJNA725806_P_NODE_154192_length_167_cov_1.146154_g153890_i0 | PRJNA725806 | 154192 | 167 | 1.146154 | 1.91407718 | Halococcus sp. IIIV-5B | 2321230 | Archaea | Archaea | 109 | 2.7300000000000003e-26 | NR | WP_199693910.1 | 2321230 | g153890 | i0 | 87.3 | 0.988023952095808 | 55 | 7 | 98.8 | 0 | 167 | 3 | 50 | 104 | WP_199693910.1 transposase [Halococcus sp. IIIV-5B] | diamond | 165 | 109 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. IIIV-5B | |
| 30979047 | 30979047 | PRJNA725806_P_NODE_152014_length_168_cov_1.190840_g151712_i0 | PRJNA725806 | 152014 | 168 | 1.19084 | 2.0006112 | Halobacteriales | 2235 | Archaea | Archaea | 114 | 8.59e-28 | NR | AEN07324.1 | 756883 | g151712 | i0 | 94.6 | 5 | 56 | 3 | 100 | 0 | 1 | 168 | 1016 | 1071 | AEN07324.1 helicase domain-containing protein [halophilic archaeon DL31] | diamond | 840 | 114 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | halophilic archaeon DL31 | |||
| 31316208 | 31316208 | PRJNA725806_P_NODE_167335_length_161_cov_1.556452_g167033_i0 | PRJNA725806 | 167335 | 161 | 1.556452 | 2.50588772 | Halococcus sp. IIIV-5B | 2321230 | Archaea | Archaea | 68.2 | 2.18e-12 | NR | WP_120071579.1 | 2321230 | g167033 | i0 | 68.2 | 0.819875776397516 | 44 | 14 | 82 | 0 | 134 | 3 | 1 | 44 | WP_120071579.1 PH domain-containing protein [Halococcus sp. IIIV-5B] | diamond | 132 | 68.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. IIIV-5B | |
| 31411144 | 31411144 | PRJNA725806_P_NODE_117416_length_186_cov_1.040268_g117114_i0 | PRJNA725806 | 117416 | 186 | 1.040268 | 1.93489848 | Halococcus sp. IIIV-5B | 2321230 | Archaea | Archaea | 122 | 2.3e-31 | NR | WP_120072442.1 | 2321230 | g117114 | i0 | 95.1 | 0.983870967741935 | 61 | 3 | 98.4 | 0 | 2 | 184 | 354 | 414 | WP_120072442.1 right-handed parallel beta-helix repeat-containing protein [Halococcus sp. IIIV-5B] | diamond | 183 | 122 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. IIIV-5B | |
| 31601033 | 31601033 | PRJNA725806_P_NODE_172656_length_159_cov_0.950820_g172354_i0 | PRJNA725806 | 172656 | 159 | 0.95082 | 1.5118038 | Halococcus salsus | 2162894 | Archaea | Archaea | 99.8 | 2.3699999999999998e-23 | NR | WP_160134655.1 | 2162894 | g172354 | i0 | 98.1 | 0.981132075471698 | 52 | 1 | 98.1 | 0 | 3 | 158 | 101 | 152 | WP_160134655.1 Ldh family oxidoreductase [Halococcus salsus] | diamond | 156 | 99.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus salsus | |
| 31642642 | 31642642 | PRJNA725806_P_NODE_156276_length_166_cov_1.201550_g155974_i0 | PRJNA725806 | 156276 | 166 | 1.20155 | 1.994573 | Halococcus | 2249 | Archaea | Archaea | 107 | 6.02e-26 | NR | WP_029601854.1 | 332168 | g155974 | i0 | 96.4 | 2.98192771084337 | 55 | 2 | 99.4 | 0 | 166 | 2 | 199 | 253 | WP_029601854.1 MFS transporter [Halococcus hamelinensis] | diamond | 495 | 107 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus hamelinensis | |
| 31663981 | 31663981 | PRJNA725806_P_NODE_119097_length_185_cov_1.054054_g118795_i0 | PRJNA725806 | 119097 | 185 | 1.054054 | 1.9499999 | Halococcus salsus | 2162894 | Archaea | Archaea | 131 | 1.4599999999999998e-37 | NR | WP_160134317.1 | 2162894 | g118795 | i0 | 96.7 | 0.989189189189189 | 61 | 2 | 98.9 | 0 | 185 | 3 | 69 | 129 | WP_160134317.1 DUF7383 domain-containing protein [Halococcus salsus] | diamond | 183 | 131 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus salsus | |
| 31758978 | 31758978 | PRJNA725806_P_NODE_193637_length_151_cov_1.017544_g193335_i0 | PRJNA725806 | 193637 | 151 | 1.017544 | 1.53649144 | Halococcus sp. IIIV-5B | 2321230 | Archaea | Archaea | 75.1 | 4.15e-14 | NR | WP_120068739.1 | 2321230 | g193335 | i0 | 73.5 | 0.973509933774834 | 49 | 13 | 97.4 | 0 | 1 | 147 | 825 | 873 | WP_120068739.1 type IV secretory system conjugative DNA transfer family protein [Halococcus sp. IIIV-5B] | diamond | 147 | 75.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. IIIV-5B | |
| 32391802 | 32391802 | PRJNA725806_P_NODE_129839_length_179_cov_1.091549_g129537_i0 | PRJNA725806 | 129839 | 179 | 1.091549 | 1.95387271 | Halococcus salsus | 2162894 | Archaea | Archaea | 77 | 1.29e-14 | NR | WP_240145881.1 | 2162894 | g129537 | i0 | 100 | 0.653631284916201 | 39 | 0 | 65.4 | 0 | 62 | 178 | 695 | 733 | WP_240145881.1 hypothetical protein [Halococcus salsus] | diamond | 117 | 77 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus salsus | |
| 32654493 | 32654493 | PRJNA725806_P_NODE_192940_length_151_cov_1.807018_g192638_i0 | PRJNA725806 | 192940 | 151 | 1.807018 | 2.72859718 | Halobacteriales | 2235 | Archaea | Archaea | 103 | 1.38e-26 | NR | WP_006881657.1 | 171164 | g192638 | i0 | 100 | 2.9205298013245 | 49 | 0 | 97.4 | 0 | 3 | 149 | 33 | 81 | WP_006881657.1 hypothetical protein, partial [Halosimplex carlsbadense] | diamond | 441 | 103 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halosimplex | Halosimplex carlsbadense | |
| 32896289 | 32896289 | PRJNA725806_P_NODE_165220_length_162_cov_1.240000_g164918_i0 | PRJNA725806 | 165220 | 162 | 1.24 | 2.0088 | Halococcus hamelinensis | 332168 | Archaea | Archaea | 70.1 | 1.49e-13 | NR | WP_007691478.1 | 332168 | g164918 | i0 | 92.5 | 0.740740740740741 | 40 | 3 | 74.1 | 0 | 1 | 120 | 97 | 136 | WP_007691478.1 hypothetical protein [Halococcus hamelinensis] | diamond | 120 | 70.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus hamelinensis |
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);;