contig_metadata
18 rows where bioproject = "PRJNA591127" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 565120 | 565120 | PRJNA591127_P_NODE_26121_length_162_cov_5.112000_g25952_i0 | PRJNA591127 | 26121 | 162 | 5.112 | 8.28144 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 294 | 2.03e-75 | NTclustered | gi|2221492933|gb|CP095007.1| | 179637 | g25952 | i0 | 99.383 | 136.395061728395 | 162 | 1 | 100 | 0 | 1 | 162 | 130205 | 130366 | Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence | blastn | 22096 | 294 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 3116060 | 3116060 | PRJNA591127_P_NODE_29943_length_151_cov_3.289474_g29774_i0 | PRJNA591127 | 29943 | 151 | 3.289474 | 4.96710574 | Thermococcus sp. 9oN-7 | 103799 | Archaea | Archaea | 145 | 1.98e-30 | NTclustered | gi|1197451|gb|U47108.1|TSU47108 | 103799 | g29774 | i0 | 100 | 11.2781456953642 | 78 | 0 | 100 | 0 | 74 | 151 | 2089 | 2166 | Thermococcus sp. DNA polymerase A (PolA) gene, complete cds | blastn | 1703 | 145 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Thermococcus | Thermococcus sp. 9oN-7 | ||
| 4966892 | 4966892 | PRJNA591127_P_NODE_2244_length_466_cov_2.832168_g2082_i0 | PRJNA591127 | 2244 | 466 | 2.832168 | 13.19790288 | Halococcus | 2249 | Archaea | Archaea | 822 | 0 | NTclustered | gi|2221492933|gb|CP095007.1| | 179637 | g2082 | i0 | 98.498 | 171.759656652361 | 466 | 7 | 100 | 0 | 1 | 466 | 130206 | 129741 | Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence | blastn | 80040 | 822 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 8218333 | 8218333 | PRJNA591127_P_NODE_31307_length_150_cov_5.017699_g31138_i0 | PRJNA591127 | 31307 | 150 | 5.017699 | 7.5265485 | Methanocaldococcus jannaschii | 2190 | Archaea | Archaea | 58.4 | 2.63e-4 | NTclustered | gi|6626255|gb|L77117.1| | 243232 | g31138 | i0 | 100 | 0.58 | 31 | 0 | 21 | 0 | 118 | 148 | 994216 | 994186 | Methanocaldococcus jannaschii DSM 2661, complete genome | blastn | 87 | 58.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanocaldococcaceae | Methanocaldococcus | Methanocaldococcus jannaschii | |
| 8791754 | 8791754 | PRJNA591127_P_NODE_807_length_706_cov_3.748879_g688_i0 | PRJNA591127 | 807 | 706 | 3.748879 | 26.46708574 | Halococcus | 2249 | Archaea | Archaea | 1188 | 0 | NTclustered | gi|2851472922|gb|PP407498.2| | 29286 | g688 | i0 | 97.025 | 99.0977337110482 | 706 | 21 | 100 | 0 | 1 | 706 | 744 | 1449 | Halococcus sp. strain AFM35 16S ribosomal RNA gene, partial sequence | blastn | 69963 | 1188 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus sp. | |
| 9493486 | 9493486 | PRJNA591127_P_NODE_25668_length_165_cov_1.328125_g25499_i0 | PRJNA591127 | 25668 | 165 | 1.328125 | 2.19140625 | Natronorubrum daqingense | 588898 | Archaea | Archaea | 263 | 5.86e-66 | NTclustered | gi|1134979927|gb|CP019327.1| | 588898 | g25499 | i0 | 95.706 | 184.6 | 163 | 7 | 99 | 0 | 3 | 165 | 1056251 | 1056413 | Natronorubrum daqingense strain JX313, complete sequence | blastn | 30459 | 263 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronorubrum | Natronorubrum daqingense | |
| 16441396 | 16441396 | PRJNA591127_P_NODE_12473_length_208_cov_3.233918_g12304_i0 | PRJNA591127 | 12473 | 208 | 3.233918 | 6.72654944 | Halococcus | 2249 | Archaea | Archaea | 335 | 1.6199999999999996e-87 | NTclustered | gi|2221492933|gb|CP095007.1| | 179637 | g12304 | i0 | 95.694 | 131.697115384615 | 209 | 8 | 100 | 1 | 1 | 208 | 129554 | 129346 | Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence | blastn | 27393 | 335 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 16441597 | 16441597 | PRJNA591127_P_NODE_3093_length_406_cov_2.536585_g2925_i0 | PRJNA591127 | 3093 | 406 | 2.536585 | 10.2985351 | Halococcus | 2249 | Archaea | Archaea | 664 | 0 | NTclustered | gi|288192|emb|X72588.1| | 2250 | g2925 | i0 | 96.078 | 149.379310344828 | 408 | 14 | 100 | 2 | 1 | 406 | 4073 | 4480 | H.morrhuae ribosomal RNA operon and flanking regions | blastn | 60648 | 669 | 0.992526158445441 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus morrhuae | |
| 18990247 | 18990247 | PRJNA591127_P_NODE_32155_length_150_cov_2.380531_g31986_i0 | PRJNA591127 | 32155 | 150 | 2.380531 | 3.5707965 | Halomicrobium | 203135 | Archaea | Archaea | 87.9 | 3.35e-13 | NTclustered | gi|2105355784|gb|CP084090.1| | 1586233 | g31986 | i0 | 83.871 | 2.20666666666667 | 93 | 14 | 62 | 1 | 58 | 150 | 1139888 | 1139797 | Halomicrobium urmianum strain IBRC-M: 10911 chromosome, complete genome | blastn | 331 | 87.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halomicrobium | Halomicrobium urmianum | |
| 20967177 | 20967177 | PRJNA591127_P_NODE_1517_length_551_cov_4.173152_g1367_i0 | PRJNA591127 | 1517 | 551 | 4.173152 | 22.99406752 | Halococcus qingdaonensis | 224402 | Archaea | Archaea | 846 | 0 | NTclustered | gi|2281256326|gb|CP101943.1| | 224402 | g1367 | i0 | 94.834 | 150.938294010889 | 542 | 28 | 98 | 0 | 10 | 551 | 2645317 | 2645858 | Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome | blastn | 83167 | 846 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus qingdaonensis | |
| 21540712 | 21540712 | PRJNA591127_P_NODE_2257_length_465_cov_3.235981_g2094_i0 | PRJNA591127 | 2257 | 465 | 3.235981 | 15.04731165 | Halococcus | 2249 | Archaea | Archaea | 765 | 0 | NTclustered | gi|43626|emb|X05481.1| | 2250 | g2094 | i0 | 96.352 | 161.172043010753 | 466 | 16 | 100 | 1 | 1 | 465 | 2199 | 2664 | Halococcus morrhuae 23S ribosomal RNA | blastn | 74945 | 771 | 0.992217898832685 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus morrhuae | |
| 22816080 | 22816080 | PRJNA591127_P_NODE_32298_length_150_cov_1.026549_g32129_i0 | PRJNA591127 | 32298 | 150 | 1.026549 | 1.5398235 | Methanobrevibacter | 2172 | Archaea | Archaea | 255 | 8.680000000000001e-64 | NTclustered | gi|2791693311|gb|CP144200.1| | 2173 | g32129 | i0 | 97.333 | 131.02 | 150 | 4 | 100 | 0 | 1 | 150 | 1285970 | 1285821 | Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome | blastn | 19653 | 255 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 24791360 | 24791360 | PRJNA591127_P_NODE_7180_length_274_cov_3.367089_g7012_i0 | PRJNA591127 | 7180 | 274 | 3.367089 | 9.22582386 | Halococcus dombrowskii | 179637 | Archaea | Archaea | 462 | 9.81e-126 | NTclustered | gi|2221492933|gb|CP095007.1| | 179637 | g7012 | i0 | 97.08 | 171.478102189781 | 274 | 8 | 100 | 0 | 1 | 274 | 130823 | 131096 | Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence | blastn | 46985 | 462 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halococcus | Halococcus dombrowskii | |
| 26763174 | 26763174 | PRJNA591127_P_NODE_17421_length_197_cov_2.493750_g17252_i0 | PRJNA591127 | 17421 | 197 | 2.49375 | 4.9126875 | Natronosalvus halobius | 2953746 | Archaea | Archaea | 75.1 | 7.96e-14 | NR | WP_253437457.1 | 2953746 | g17252 | i0 | 71 | 0.944162436548223 | 62 | 9 | 94.4 | 1 | 10 | 195 | 458 | 510 | WP_253437457.1 DEAD/DEAH box helicase family protein [Natronosalvus halobius] | diamond | 186 | 75.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronosalvus | Natronosalvus halobius | |
| 29840431 | 29840431 | PRJNA591127_P_NODE_30391_length_151_cov_2.903509_g30222_i0 | PRJNA591127 | 30391 | 151 | 2.903509 | 4.38429859 | Methanomassiliicoccus | 1080709 | Archaea | Archaea | 57.8 | 5.27e-8 | NR | WP_026068762.1 | 1080712 | g30222 | i0 | 100 | 1.49006622516556 | 25 | 0 | 49.7 | 0 | 150 | 76 | 328 | 352 | WP_026068762.1 coenzyme-B sulfoethylthiotransferase subunit beta [Methanomassiliicoccus luminyensis] | diamond | 225 | 57.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Methanomassiliicoccus | Methanomassiliicoccus luminyensis | ||
| 30142544 | 30142544 | PRJNA591127_P_NODE_25772_length_164_cov_2.984252_g25603_i0 | PRJNA591127 | 25772 | 164 | 2.984252 | 4.89417328 | Hadesarchaea archaeon | 2250276 | Archaea | Archaea | 48.9 | 1.03e-5 | NR | MCS7131446.1 | 2250276 | g25603 | i0 | 46.3 | 0.98780487804878 | 54 | 28 | 98.8 | 1 | 1 | 162 | 19 | 71 | MCS7131446.1 50S ribosomal protein L34e [Hadesarchaea archaeon] | diamond | 162 | 48.9 | 1 | Archaea | Methanobacteriati | Candidatus Hadarchaeota | Candidatus Hadarchaeia | Hadesarchaea archaeon | |||||
| 31786295 | 31786295 | PRJNA591127_P_NODE_20657_length_196_cov_3.069182_g20488_i0 | PRJNA591127 | 20657 | 196 | 3.069182 | 6.01559672 | Methanobacterium sp. | 2164 | Archaea | Archaea | 45.1 | 0.00266 | NR | MDD1775483.1 | 2164 | g20488 | i0 | 76 | 0.75 | 25 | 6 | 38.3 | 0 | 75 | 1 | 79 | 103 | MDD1775483.1 CPBP family intramembrane metalloprotease [Methanobacterium sp.] | diamond | 147 | 45.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 31831376 | 31831376 | PRJNA591127_P_NODE_14237_length_197_cov_4.643750_g14068_i0 | PRJNA591127 | 14237 | 197 | 4.64375 | 9.1481875 | Halalkalicoccus | 332246 | Archaea | Archaea | 58.9 | 3.7e-8 | NR | WP_066383698.1 | 1008153 | g14068 | i0 | 92 | 1.52284263959391 | 25 | 2 | 38.1 | 0 | 2 | 76 | 125 | 149 | WP_066383698.1 DUF354 domain-containing protein [Halalkalicoccus paucihalophilus] | diamond | 300 | 58.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halococcaceae | Halalkalicoccus | Halalkalicoccus paucihalophilus |
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);;