contig_metadata
18 rows where bioproject = "PRJNA744060" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24949623 | 24949623 | PRJNA744060_P_NODE_22260_length_343_cov_3.174074_g21931_i0 | PRJNA744060 | 22260 | 343 | 3.174074 | 10.88707382 | uncultured Methanoregulaceae archaeon | 1392423 | Archaea | Archaea | 198 | 3.94e-46 | NTclustered | gi|2874254037|emb|OY970361.1| | 1392423 | g21931 | i0 | 85.714 | 46.3119533527697 | 189 | 25 | 55 | 2 | 49 | 236 | 2544725 | 2544912 | MAG: uncultured Methanoregulaceae archaeon isolate MFD01476.bin.2.40 genome assembly, chromosome: 1 | blastn | 15885 | 198 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | uncultured Methanoregulaceae archaeon | ||
| 24949793 | 24949793 | PRJNA744060_P_NODE_31360_length_293_cov_1.418182_g31031_i0 | PRJNA744060 | 31360 | 293 | 1.418182 | 4.15527326 | Haloferax mediterranei | 2252 | Archaea | Archaea | 54.7 | 0.008 | NTclustered | gi|640913992|gb|CP001868.2| | 523841 | g31031 | i0 | 94.444 | 0.368600682593857 | 36 | 1 | 12 | 1 | 47 | 82 | 1848311 | 1848345 | Haloferax mediterranei ATCC 33500, complete genome | blastn | 108 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloferax | Haloferax mediterranei | |
| 24950063 | 24950063 | PRJNA744060_P_NODE_48340_length_246_cov_1.323699_g48011_i0 | PRJNA744060 | 48340 | 246 | 1.323699 | 3.25629954 | Haloarcula regularis | 3033392 | Archaea | Archaea | 58.4 | 4.78e-4 | NTclustered | gi|2463595545|gb|CP119794.1| | 3033392 | g48011 | i0 | 100 | 0.601626016260163 | 31 | 0 | 13 | 0 | 216 | 246 | 814474 | 814444 | Haloarcula regularis strain SYNS111 chromosome, complete genome | blastn | 148 | 58.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Haloarcula | Haloarcula regularis | |
| 26641129 | 26641129 | PRJNA744060_P_NODE_28641_length_305_cov_1.771552_g28312_i0 | PRJNA744060 | 28641 | 305 | 1.771552 | 5.4032336 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 64.3 | 1.98e-9 | NR | UCE36149.1 | 1906666 | g28312 | i0 | 46 | 1.22950819672131 | 63 | 33 | 62 | 1 | 191 | 3 | 238 | 299 | UCE36149.1 MAG: hypothetical protein JSW00_11420 [Thermoplasmata archaeon] | diamond | 375 | 64.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 26841420 | 26841420 | PRJNA744060_P_NODE_50541_length_243_cov_0.917647_g50212_i0 | PRJNA744060 | 50541 | 243 | 0.917647 | 2.22988221 | Methanobacteriati | 3366610 | Archaea | Archaea | 120 | 4.55e-31 | NR | MBH33411.1 | 2026739 | g50212 | i0 | 73.8 | 5.92592592592593 | 80 | 16 | 98.8 | 1 | 242 | 3 | 183 | 257 | MBH33411.1 3,4-dihydroxy-2-butanone-4-phosphate synthase [Methanobacteriota archaeon] | diamond | 1440 | 120 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 27021112 | 27021112 | PRJNA744060_P_NODE_51022_length_242_cov_1.775148_g50693_i0 | PRJNA744060 | 51022 | 242 | 1.775148 | 4.29585816 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 47.4 | 8.71e-4 | NR | MEL0267202.1 | 2163009 | g50693 | i0 | 26.9 | 1.89669421487603 | 78 | 54 | 93 | 1 | 17 | 241 | 372 | 449 | MEL0267202.1 hypothetical protein [Candidatus Poseidoniales archaeon] | diamond | 459 | 47.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 27283984 | 27283984 | PRJNA744060_P_NODE_51343_length_242_cov_0.923077_g51014_i0 | PRJNA744060 | 51343 | 242 | 0.923077 | 2.23384634 | Halobacteriales | 2235 | Archaea | Archaea | 80.9 | 1.37e-15 | NR | WP_263017800.1 | 1679076 | g51014 | i0 | 44.6 | 2.78925619834711 | 74 | 41 | 91.7 | 0 | 4 | 225 | 144 | 217 | WP_263017800.1 beta-mannosidase [Natronobiforma cellulositropha] | diamond | 675 | 80.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natronobiforma | Natronobiforma cellulositropha | |
| 27811046 | 27811046 | PRJNA744060_P_NODE_46184_length_249_cov_2.159091_g45855_i0 | PRJNA744060 | 46184 | 249 | 2.159091 | 5.37613659 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 122 | 1.38e-30 | NR | RYE85578.1 | 2250255 | g45855 | i0 | 68.3 | 0.987951807228916 | 82 | 26 | 98.8 | 0 | 2 | 247 | 177 | 258 | RYE85578.1 MAG: hypothetical protein EOO65_00010 [Methanosarcinales archaeon] | diamond | 246 | 122 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 28294339 | 28294339 | PRJNA744060_P_NODE_12426_length_455_cov_2.018325_g12098_i0 | PRJNA744060 | 12426 | 455 | 2.018325 | 9.18337875 | Methanosarcina | 2207 | Archaea | Archaea | 76.3 | 2.39e-13 | NR | WP_300098040.1 | 2213 | g12098 | i0 | 41.3 | 4.06153846153846 | 104 | 57 | 67.9 | 3 | 367 | 59 | 173 | 273 | WP_300098040.1 protease inhibitor I42 family protein [Methanosarcina sp.] | diamond | 1848 | 77 | 0.990909090909091 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina sp. | |
| 28316067 | 28316067 | PRJNA744060_P_NODE_34126_length_282_cov_1.636364_g33797_i0 | PRJNA744060 | 34126 | 282 | 1.636364 | 4.61454648 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 84.3 | 1.41e-16 | NR | RMG31918.1 | 2026739 | g33797 | i0 | 48.8 | 0.914893617021277 | 86 | 41 | 91.5 | 1 | 277 | 20 | 936 | 1018 | RMG31918.1 MAG: hypothetical protein D6732_14205 [Methanobacteriota archaeon] | diamond | 258 | 84.3 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 28979222 | 28979222 | PRJNA744060_P_NODE_43248_length_254_cov_1.767956_g42919_i0 | PRJNA744060 | 43248 | 254 | 1.767956 | 4.49060824 | Methanoregula sp. | 2052170 | Archaea | Archaea | 42.4 | 0.0465 | NR | MCX6686830.1 | 2052170 | g42919 | i0 | 30 | 0.826771653543307 | 70 | 49 | 82.7 | 0 | 13 | 222 | 79 | 148 | MCX6686830.1 DNA double-strand break repair nuclease NurA [Methanoregula sp.] | diamond | 210 | 42.4 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanoregulaceae | Methanoregula | Methanoregula sp. | |
| 29831508 | 29831508 | PRJNA744060_P_NODE_15131_length_413_cov_1.361765_g14802_i0 | PRJNA744060 | 15131 | 413 | 1.361765 | 5.62408945 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 172 | 1.0399999999999999e-46 | NR | MAD56215.1 | 2026739 | g14802 | i0 | 59.9 | 1.85956416464891 | 137 | 51 | 99.5 | 1 | 3 | 413 | 469 | 601 | MAD56215.1 hypothetical protein [Methanobacteriota archaeon] | diamond | 768 | 172 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 30084163 | 30084163 | PRJNA744060_P_NODE_26892_length_314_cov_1.763485_g26563_i0 | PRJNA744060 | 26892 | 314 | 1.763485 | 5.5373429 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 51.2 | 6.85e-5 | NR | MEM4728455.1 | 1906666 | g26563 | i0 | 40.3 | 1.29936305732484 | 62 | 36 | 59.2 | 1 | 312 | 127 | 174 | 234 | MEM4728455.1 PAC2 family protein [Thermoplasmata archaeon] | diamond | 408 | 51.2 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 30178972 | 30178972 | PRJNA744060_P_NODE_2812_length_917_cov_10.161137_g2562_i0 | PRJNA744060 | 2812 | 917 | 10.161137 | 93.17762629 | Methanobacteriota archaeon | 2026739 | Archaea | Archaea | 221 | 1.8e-64 | NR | PXF22894.1 | 2026739 | g2562 | i0 | 57 | 1.29225736095965 | 193 | 80 | 63.1 | 3 | 160 | 738 | 38 | 227 | PXF22894.1 MAG: hypothetical protein CXX71_03015 [Methanobacteriota archaeon] | diamond | 1185 | 221 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Methanobacteriota archaeon | ||||||
| 31832527 | 31832527 | PRJNA744060_P_NODE_47717_length_247_cov_0.896552_g47388_i0 | PRJNA744060 | 47717 | 247 | 0.896552 | 2.21448344 | Archaea | 2157 | Archaea | Archaea | 61.6 | 6.92e-9 | NR | MDI9642494.1 | 2250258 | g47388 | i0 | 40.5 | 1.93117408906883 | 79 | 43 | 96 | 1 | 2 | 238 | 125 | 199 | MDI9642494.1 alpha/beta hydrolase [Archaeoglobales archaeon] | diamond | 477 | 61.6 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Archaeoglobi | Archaeoglobales | Archaeoglobales archaeon | ||||
| 32170971 | 32170971 | PRJNA744060_P_NODE_34718_length_280_cov_1.449275_g34389_i0 | PRJNA744060 | 34718 | 280 | 1.449275 | 4.05797 | Methanosarcinales archaeon | 2250255 | Archaea | Archaea | 129 | 1.1399999999999999e-32 | NR | RYE85578.1 | 2250255 | g34389 | i0 | 65.5 | 0.9 | 84 | 27 | 87.9 | 1 | 30 | 275 | 19 | 102 | RYE85578.1 MAG: hypothetical protein EOO65_00010 [Methanosarcinales archaeon] | diamond | 252 | 129 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinales archaeon | |||
| 32812309 | 32812309 | PRJNA744060_P_NODE_20600_length_356_cov_2.056537_g20271_i0 | PRJNA744060 | 20600 | 356 | 2.056537 | 7.32127172 | root | 1 | Root_unresolved | Root_unresolved | 67.8 | 2.43e-10 | NR | OPX78749.1 | 1811685 | g20271 | i0 | 41.2 | 6.37078651685393 | 102 | 54 | 85.1 | 4 | 8 | 310 | 1769 | 1865 | OPX78749.1 MAG: HYR domain protein [Methanosaeta sp. PtaB.Bin039] | diamond | 2268 | 68.2 | 0.994134897360704 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanosaeta sp. PtaB.Bin039 | |
| 32896681 | 32896681 | PRJNA744060_P_NODE_20260_length_359_cov_1.790210_g19931_i0 | PRJNA744060 | 20260 | 359 | 1.79021 | 6.4268539 | Methanovulcanius yangii | 1789227 | Archaea | Archaea | 46.2 | 0.00879 | NR | MBT8507577.1 | 1789227 | g19931 | i0 | 30.4 | 1.92200557103064 | 115 | 62 | 96.1 | 3 | 348 | 4 | 1357 | 1453 | MBT8507577.1 hypothetical protein [Methanovulcanius yangii] | diamond | 690 | 46.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanomicrobiales | Methanomicrobiaceae | Methanovulcanius | Methanovulcanius yangii |
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);;