contig_metadata
11 rows where bioproject = "PRJNA994052" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 976630 | 976630 | PRJNA994052_P_NODE_57781_length_229_cov_41.897436_g56525_i0 | PRJNA994052 | 57781 | 229 | 41.897436 | 95.94512844 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 374 | 3.8399999999999996e-99 | NTclustered | gi|2221489803|gb|CP095005.1| | 179637 | g56525 | i0 | 96.07 | 4.93886462882096 | 229 | 9 | 100 | 0 | 1 | 229 | 871094 | 870866 | Halococcus dombrowskii strain H4 chromosome, complete genome | blastn | 1131 | 374 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 14027122 | 14027122 | PRJNA994052_P_NODE_79831_length_201_cov_7.937500_g78574_i0 | PRJNA994052 | 79831 | 201 | 7.9375 | 15.954375 | Halobaculum | 43927 | Archaea | Archaea | 331 | 2.01e-86 | NTclustered | gi|2511735787|gb|CP126156.1| | 3031998 | g78574 | i0 | 96.954 | 22.2039800995025 | 197 | 6 | 98 | 0 | 2 | 198 | 1519652 | 1519848 | Halobaculum litoreum strain DT92 chromosome, complete genome | blastn | 4463 | 331 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobaculum | Halobaculum litoreum | |
| 16575745 | 16575745 | PRJNA994052_P_NODE_48933_length_243_cov_10.011765_g47681_i0 | PRJNA994052 | 48933 | 243 | 10.011765 | 24.32858895 | Halobacteriales | 2235 | Archaea | Archaea | 132 | 2.7300000000000003e-26 | NTclustered | gi|2168244610|gb|CP089468.1| | 223182 | g47681 | i0 | 93.258 | 7.72839506172839 | 89 | 6 | 37 | 0 | 2 | 90 | 2317265 | 2317353 | Halobacterium noricense strain JCM 15102 chromosome, complete genome | blastn | 1878 | 132 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halobacterium | Halobacterium noricense | |
| 20103110 | 20103110 | PRJNA994052_P_NODE_55796_length_232_cov_29.352201_g54541_i0 | PRJNA994052 | 55796 | 232 | 29.352201 | 68.09710632 | Halorubrum salinarum | 2739057 | Archaea | Archaea | 283 | 6.76e-72 | NTclustered | gi|1848526000|gb|CP053941.1| | 2739057 | g54541 | i0 | 89.427 | 7.84913793103448 | 227 | 20 | 97 | 4 | 4 | 228 | 580219 | 580443 | Halorubrum salinarum strain RHB-C chromosome, complete genome | blastn | 1821 | 283 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halorubrum | Halorubrum salinarum | |
| 22653560 | 22653560 | PRJNA994052_P_NODE_42518_length_254_cov_6.613260_g41271_i0 | PRJNA994052 | 42518 | 254 | 6.61326 | 16.7976804 | Halococcus qingdaonensis | 224402 | Archaea | Archaea | 459 | 1.1599999999999999e-124 | NTclustered | gi|2281256326|gb|CP101943.1| | 224402 | g41271 | i0 | 99.213 | 108.322834645669 | 254 | 2 | 100 | 0 | 1 | 254 | 1948811 | 1949064 | Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome | blastn | 27514 | 459 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis | |
| 23928655 | 23928655 | PRJNA994052_P_NODE_15959_length_312_cov_22.677824_g14738_i0 | PRJNA994052 | 15959 | 312 | 22.677824 | 70.75481088 | Halobellus inordinatus | 1126236 | Archaea | Archaea | 159 | 1.67e-34 | NTclustered | gi|2279714123|gb|CP101825.1| | 1126236 | g14738 | i0 | 86.713 | 2.375 | 143 | 19 | 46 | 0 | 162 | 304 | 2163824 | 2163966 | Halobellus inordinatus strain DSM 26177 chromosome, complete genome | blastn | 741 | 159 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halobellus | Halobellus inordinatus | |
| 27152456 | 27152456 | PRJNA994052_P_NODE_47702_length_245_cov_9.244186_g46451_i0 | PRJNA994052 | 47702 | 245 | 9.244186 | 22.6482557 | Methanobacterium sp. | 2164 | Archaea | Archaea | 58.5 | 8.11e-8 | NR | MEN6294369.1 | 2164 | g46451 | i0 | 34.5 | 1.42040816326531 | 116 | 39 | 96.7 | 1 | 5 | 241 | 80 | 195 | MEN6294369.1 hypothetical protein [Methanobacterium sp.] | diamond | 348 | 58.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 28510862 | 28510862 | PRJNA994052_P_NODE_72787_length_209_cov_16.536765_g71531_i0 | PRJNA994052 | 72787 | 209 | 16.536765 | 34.56183885 | Methanoculleus sp. | 90427 | Archaea | Archaea | 114 | 4.01e-28 | NR | WP_292561231.1 | 90427 | g71531 | i0 | 76.9 | 0.933014354066986 | 65 | 15 | 93.3 | 0 | 2 | 196 | 178 | 242 | WP_292561231.1 PBSX family phage terminase large subunit [Methanoculleus sp.] | diamond | 195 | 114 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanoculleus | Methanoculleus sp. | |
| 31891362 | 31891362 | PRJNA994052_P_NODE_29997_length_282_cov_5.899522_g28755_i0 | PRJNA994052 | 29997 | 282 | 5.899522 | 16.63665204 | Candidatus Poseidonia alphae | 1915863 | Archaea | Archaea | 72.8 | 6.03e-13 | NR | MDA7464330.1 | 1915863 | g28755 | i0 | 42.4 | 0.904255319148936 | 85 | 42 | 83 | 1 | 234 | 1 | 61 | 145 | MDA7464330.1 alpha-1,2-fucosyltransferase [Candidatus Poseidonia alphae] | diamond | 255 | 72.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniaceae | Candidatus Poseidonia | Candidatus Poseidonia alphae | ||
| 32239689 | 32239689 | PRJNA994052_P_NODE_78938_length_202_cov_9.038760_g77681_i0 | PRJNA994052 | 78938 | 202 | 9.03876 | 18.2582952 | Halomarina salina | 1872699 | Archaea | Archaea | 55.8 | 1.36e-7 | NR | WP_247415064.1 | 1872699 | g77681 | i0 | 62.2 | 0.668316831683168 | 45 | 13 | 60.9 | 2 | 127 | 5 | 1 | 45 | WP_247415064.1 hypothetical protein [Halomarina salina] | diamond | 135 | 55.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Halomarina | Halomarina salina | |
| 32902107 | 32902107 | PRJNA994052_P_NODE_64400_length_220_cov_4.884354_g63144_i0 | PRJNA994052 | 64400 | 220 | 4.884354 | 10.7455788 | Natronobeatus ordinarius | 2963433 | Archaea | Archaea | 42 | 0.0482 | NR | WP_255191692.1 | 2963433 | g63144 | i0 | 50 | 0.381818181818182 | 28 | 14 | 38.2 | 0 | 101 | 18 | 193 | 220 | WP_255191692.1 esterase/lipase family protein [Natronobeatus ordinarius] | diamond | 84 | 42 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobeatus | Natronobeatus ordinarius |
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);;