contig_metadata
14 rows where bioproject = "PRJEB81327" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4824761 | 4824761 | PRJEB81327_P_NODE_12164_length_388_cov_1.958730_g11556_i0 | PRJEB81327 | 12164 | 388 | 1.95873 | 7.5998724 | root | 1 | Root_unresolved | Root_unresolved | 717 | 0 | NTclustered | gi|436492|gb|U00707.1|PSU00707 | 33866 | g11556 | i0 | 100 | 10.3659793814433 | 388 | 0 | 100 | 0 | 1 | 388 | 1170 | 1557 | Pyrococcus sp. Deep Vent DNA polymerase precursor gene, complete cds | blastn | 4022 | 717 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Thermococci | Thermococcales | Thermococcaceae | Pyrococcus | Pyrococcus sp. | ||
| 7792328 | 7792328 | PRJEB81327_P_NODE_54467_length_247_cov_0.885057_g53859_i0 | PRJEB81327 | 54467 | 247 | 0.885057 | 2.18609079 | Haloprofundus halobius | 2876194 | Archaea | Archaea | 318 | 1.9899999999999998e-82 | NTclustered | gi|2099489105|gb|CP083668.1| | 2876194 | g53859 | i0 | 89.879 | 3.21457489878543 | 247 | 25 | 100 | 0 | 1 | 247 | 101633 | 101879 | Haloprofundus halobius strain SEDH52 plasmid unnamed2, complete sequence | blastn | 794 | 318 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloprofundus | Haloprofundus halobius | |
| 16716677 | 16716677 | PRJEB81327_P_NODE_46814_length_251_cov_0.865169_g46206_i0 | PRJEB81327 | 46814 | 251 | 0.865169 | 2.17157419 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 150 | 1.97e-41 | NR | MCH7660637.1 | 2026739 | g46206 | i0 | 98.8 | 1.00398406374502 | 84 | 0 | 99.2 | 1 | 2 | 250 | 38 | 121 | MCH7660637.1 S8 family serine peptidase [Methanobacteriota archaeon] | diamond | 252 | 150 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 21816969 | 21816969 | PRJEB81327_P_NODE_65918_length_239_cov_4.626506_g65310_i0 | PRJEB81327 | 65918 | 239 | 4.626506 | 11.05734934 | Haloprofundus sp. MHR1 | 2572921 | Archaea | Archaea | 52.8 | 0.021 | NTclustered | gi|1633225932|gb|CP039833.1| | 2572921 | g65310 | i0 | 100 | 0.117154811715481 | 28 | 0 | 12 | 0 | 196 | 223 | 2006523 | 2006550 | Haloprofundus sp. MHR1 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloprofundus | Haloprofundus sp. MHR1 | |
| 23092074 | 23092074 | PRJEB81327_P_NODE_62299_length_242_cov_1.822485_g61691_i0 | PRJEB81327 | 62299 | 242 | 1.822485 | 4.4104137 | Methanocorpusculum sp. | 2058474 | Archaea | Archaea | 156 | 8.47e-44 | NR | HJK52518.1 | 2058474 | g61691 | i0 | 100 | 2.97520661157025 | 80 | 0 | 99.2 | 0 | 241 | 2 | 228 | 307 | HJK52518.1 2-isopropylmalate synthase [Methanocorpusculum sp.] | diamond | 720 | 156 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanocorpusculaceae | Methanocorpusculum | Methanocorpusculum sp. | |
| 27287120 | 27287120 | PRJEB81327_P_NODE_44183_length_254_cov_1.668508_g43575_i0 | PRJEB81327 | 44183 | 254 | 1.668508 | 4.23801032 | Methanosphaera sp. rholeuAM27 | 2666342 | Archaea | Archaea | 141 | 4.019999999999999e-40 | NR | RAP52248.1 | 1945577 | g43575 | i0 | 81.9 | 1.98425196850394 | 83 | 15 | 98 | 0 | 251 | 3 | 88 | 170 | RAP52248.1 MAG: hypothetical protein BZ138_03455 [Methanosphaera sp. rholeuAM270] | diamond | 504 | 141 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. rholeuAM270 | |
| 27603147 | 27603147 | PRJEB81327_P_NODE_22324_length_295_cov_1.536036_g21716_i0 | PRJEB81327 | 22324 | 295 | 1.536036 | 4.5313062 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 109 | 1.9899999999999999e-25 | NR | WP_295614768.1 | 253161 | g21716 | i0 | 76.6 | 0.650847457627119 | 64 | 15 | 65.1 | 0 | 293 | 102 | 757 | 820 | WP_295614768.1 GTP-binding protein [uncultured Methanobrevibacter sp.] | diamond | 192 | 109 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 27981925 | 27981925 | PRJEB81327_P_NODE_7525_length_512_cov_3.968109_g6921_i0 | PRJEB81327 | 7525 | 512 | 3.968109 | 20.31671808 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 57 | 1.55e-6 | NR | WP_297983794.1 | 253161 | g6921 | i0 | 32 | 1.470703125 | 122 | 73 | 69.7 | 3 | 24 | 380 | 67 | 181 | WP_297983794.1 translationally-controlled tumor protein [uncultured Methanobrevibacter sp.] | diamond | 753 | 57 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 29433959 | 29433959 | PRJEB81327_P_NODE_55630_length_246_cov_0.890173_g55022_i0 | PRJEB81327 | 55630 | 246 | 0.890173 | 2.18982558 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 75.9 | 8.58e-14 | NR | WP_405277409.1 | 66852 | g55022 | i0 | 51.6 | 0.75609756097561 | 62 | 27 | 72 | 1 | 243 | 67 | 751 | 812 | WP_405277409.1 AAA family ATPase [Methanobrevibacter sp.] | diamond | 186 | 75.9 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31013709 | 31013709 | PRJEB81327_P_NODE_47335_length_251_cov_0.865169_g46727_i0 | PRJEB81327 | 47335 | 251 | 0.865169 | 2.17157419 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 68.6 | 2.63e-11 | NR | WP_292806969.1 | 66852 | g46727 | i0 | 46.8 | 0.920318725099602 | 77 | 40 | 90.8 | 1 | 239 | 12 | 262 | 338 | WP_292806969.1 WD40 repeat domain-containing protein [Methanobrevibacter sp.] | diamond | 231 | 68.6 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31164099 | 31164099 | PRJEB81327_P_NODE_32955_length_273_cov_1.535000_g32347_i0 | PRJEB81327 | 32955 | 273 | 1.535 | 4.19055 | root | 1 | Root_unresolved | Root_unresolved | 115 | 8.97e-28 | NR | WP_406531486.1 | 66852 | g32347 | i0 | 64.7 | 2.8021978021978 | 85 | 30 | 93.4 | 0 | 260 | 6 | 533 | 617 | WP_406531486.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 765 | 116 | 0.991379310344828 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31575672 | 31575672 | PRJEB81327_P_NODE_67996_length_229_cov_2.628205_g67388_i0 | PRJEB81327 | 67996 | 229 | 2.628205 | 6.01858945 | Methanobacteriati | 3366610 | Archaea | Archaea | 77 | 2.61e-14 | NR | MAY05506.1 | 2026739 | g67388 | i0 | 44.9 | 9.17030567685589 | 78 | 39 | 98.3 | 2 | 225 | 1 | 199 | 275 | MAY05506.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 2100 | 77 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31740854 | 31740854 | PRJEB81327_P_NODE_27177_length_283_cov_2.166667_g26569_i0 | PRJEB81327 | 27177 | 283 | 2.166667 | 6.13166761 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 122 | 1.1799999999999999e-31 | NR | HEQ78865.1 | 2026739 | g26569 | i0 | 58.5 | 1.99293286219081 | 94 | 38 | 99.6 | 1 | 2 | 283 | 44 | 136 | HEQ78865.1 NAD-dependent epimerase/dehydratase family protein [Methanobacteriota archaeon] | diamond | 564 | 122 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 32563893 | 32563893 | PRJEB81327_P_NODE_57559_length_245_cov_0.895349_g56951_i0 | PRJEB81327 | 57559 | 245 | 0.895349 | 2.19360505 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 45.1 | 0.00582 | NR | MBP5699769.1 | 66852 | g56951 | i0 | 38 | 2.87755102040816 | 79 | 35 | 96.7 | 2 | 237 | 1 | 281 | 345 | MBP5699769.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 705 | 45.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. |
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);;