contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA908278" and tax_clade = "Methanomada 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 890439 | 890439 | PRJNA908278_P_NODE_61_length_2445_cov_4.557336_g51_i0 | PRJNA908278 | 61 | 2445 | 4.557336 | 111.4268652 | uncultured Methanobrevibacter sp. | 253161 | Archaea | Archaea | 1105 | 0 | NR | WP_295614768.1 | 253161 | g51 | i0 | 66.5 | 1.97914110429448 | 805 | 269 | 98.7 | 1 | 2414 | 3 | 1 | 805 | WP_295614768.1 GTP-binding protein [uncultured Methanobrevibacter sp.] | diamond | 4839 | 1105 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 26739061 | 26739061 | PRJNA908278_P_NODE_29681_length_247_cov_3.097701_g29578_i0 | PRJNA908278 | 29681 | 247 | 3.097701 | 7.65132147 | Methanobrevibacter arboriphilus | 39441 | Archaea | Archaea | 62.4 | 4.83e-9 | NR | WP_158082511.1 | 39441 | g29578 | i0 | 41.5 | 4.16599190283401 | 65 | 35 | 78.9 | 1 | 32 | 226 | 38 | 99 | WP_158082511.1 Ig-like domain repeat protein [Methanobrevibacter arboriphilus] | diamond | 1029 | 62.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter arboriphilus | |
| 26866430 | 26866430 | PRJNA908278_P_NODE_4621_length_538_cov_1.324731_g4518_i0 | PRJNA908278 | 4621 | 538 | 1.324731 | 7.12705278 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 50.4 | 0.00113 | NR | MEE3491292.1 | 66852 | g4518 | i0 | 28.7 | 0.602230483271376 | 108 | 75 | 59.7 | 2 | 522 | 202 | 24 | 130 | MEE3491292.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 324 | 50.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 27656418 | 27656418 | PRJNA908278_P_NODE_23084_length_270_cov_1.355330_g22981_i0 | PRJNA908278 | 23084 | 270 | 1.35533 | 3.659391 | Methanosphaera sp. | 2666342 | Archaea | Archaea | 82.8 | 4.36e-16 | NR | HIH36214.1 | 2666342 | g22981 | i0 | 52.6 | 0.866666666666667 | 78 | 35 | 84.4 | 1 | 234 | 7 | 89 | 166 | HIH36214.1 hypothetical protein [Methanosphaera sp.] | diamond | 234 | 82.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. | |
| 28129987 | 28129987 | PRJNA908278_P_NODE_24365_length_262_cov_1.703704_g24262_i0 | PRJNA908278 | 24365 | 262 | 1.703704 | 4.46370448 | Methanobrevibacter sp. UBA188 | 1915473 | Archaea | Archaea | 107 | 1.17e-24 | NR | WP_292883709.1 | 1915473 | g24262 | i0 | 65.1 | 0.984732824427481 | 86 | 30 | 98.5 | 0 | 4 | 261 | 681 | 766 | WP_292883709.1 ThiF family adenylyltransferase, partial [Methanobrevibacter sp. UBA188] | diamond | 258 | 107 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. UBA188 | |
| 29392981 | 29392981 | PRJNA908278_P_NODE_5769_length_487_cov_5.594203_g5666_i0 | PRJNA908278 | 5769 | 487 | 5.594203 | 27.24376861 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 131 | 1.7299999999999998e-35 | NR | MEE3444538.1 | 66852 | g5666 | i0 | 41.3 | 0.985626283367556 | 160 | 93 | 97.9 | 1 | 483 | 7 | 3 | 162 | MEE3444538.1 40S ribosomal protein S19 [Methanobrevibacter sp.] | diamond | 480 | 131 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 29550508 | 29550508 | PRJNA908278_P_NODE_14490_length_330_cov_1.042802_g14387_i0 | PRJNA908278 | 14490 | 330 | 1.042802 | 3.4412466 | Methanobrevibacter sp. UBA188 | 1915473 | Archaea | Archaea | 102 | 1.66e-22 | NR | WP_292883709.1 | 1915473 | g14387 | i0 | 40 | 1 | 110 | 66 | 100 | 0 | 330 | 1 | 455 | 564 | WP_292883709.1 ThiF family adenylyltransferase, partial [Methanobrevibacter sp. UBA188] | diamond | 330 | 102 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. UBA188 | |
| 30316756 | 30316756 | PRJNA908278_P_NODE_372_length_1414_cov_3.341536_g340_i0 | PRJNA908278 | 372 | 1414 | 3.341536 | 47.24931904 | Methanobrevibacter | 2172 | Archaea | Archaea | 51.6 | 0.00824 | NR | WP_012955053.1 | 83816 | g340 | i0 | 41.5 | 0.271570014144272 | 65 | 35 | 13.8 | 2 | 62 | 256 | 57 | 118 | WP_012955053.1 Ig-like domain repeat protein [Methanobrevibacter ruminantium] | diamond | 384 | 51.6 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter ruminantium | |
| 30561271 | 30561271 | PRJNA908278_P_NODE_14973_length_325_cov_1.833333_g14870_i0 | PRJNA908278 | 14973 | 325 | 1.833333 | 5.95833225 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 41.6 | 0.0302 | NR | MBO6105231.1 | 66852 | g14870 | i0 | 39.1 | 0.424615384615385 | 46 | 28 | 42.5 | 0 | 152 | 15 | 11 | 56 | MBO6105231.1 tetratricopeptide repeat protein [Methanobrevibacter sp.] | diamond | 138 | 41.6 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31288193 | 31288193 | PRJNA908278_P_NODE_155_length_1780_cov_9.258348_g143_i0 | PRJNA908278 | 155 | 1780 | 9.258348 | 164.7985944 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 123 | 1.01e-25 | NR | MEE3443986.1 | 66852 | g143 | i0 | 25.9 | 0.78876404494382 | 468 | 300 | 73.8 | 14 | 1763 | 450 | 3 | 453 | MEE3443986.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 1404 | 123 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31359183 | 31359183 | PRJNA908278_P_NODE_2936_length_657_cov_2.010274_g2833_i0 | PRJNA908278 | 2936 | 657 | 2.010274 | 13.20750018 | Methanobrevibacter | 2172 | Archaea | Archaea | 55.1 | 8.99e-5 | NR | WP_405265535.1 | 66852 | g2833 | i0 | 28.9 | 1.67579908675799 | 142 | 79 | 56.6 | 4 | 439 | 68 | 1272 | 1409 | WP_405265535.1 Ig-like domain repeat protein [Methanobrevibacter sp.] | diamond | 1101 | 55.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31952473 | 31952473 | PRJNA908278_P_NODE_16257_length_314_cov_1.622407_g16154_i0 | PRJNA908278 | 16257 | 314 | 1.622407 | 5.09435798 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 58.2 | 3.38e-7 | NR | WP_407432022.1 | 66852 | g16154 | i0 | 48.4 | 2.38853503184713 | 62 | 31 | 58.3 | 1 | 247 | 65 | 689 | 750 | WP_407432022.1 hypothetical protein [Methanobrevibacter sp.] | diamond | 750 | 58.2 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 31959989 | 31959989 | PRJNA908278_P_NODE_1737_length_833_cov_1.257895_g1653_i0 | PRJNA908278 | 1737 | 833 | 1.257895 | 10.47826535 | Methanobrevibacter | 2172 | Archaea | Archaea | 48.1 | 0.0396 | NR | WP_405265535.1 | 66852 | g1653 | i0 | 39.2 | 0.569027611044418 | 79 | 46 | 27.7 | 1 | 601 | 831 | 1328 | 1406 | WP_405265535.1 Ig-like domain repeat protein [Methanobrevibacter sp.] | diamond | 474 | 48.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 32616776 | 32616776 | PRJNA908278_P_NODE_1100_length_994_cov_5.246471_g1034_i0 | PRJNA908278 | 1100 | 994 | 5.246471 | 52.14992174 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 233 | 1.3e-70 | NR | WP_292806969.1 | 66852 | g1034 | i0 | 39.5 | 1.00804828973843 | 334 | 185 | 96.3 | 4 | 3 | 959 | 11 | 342 | WP_292806969.1 WD40 repeat domain-containing protein [Methanobrevibacter sp.] | diamond | 1002 | 233 | 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);;