contig_metadata
12 rows where analysis = "diamond", bioproject = "PRJNA674050" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26777386 | 26777386 | PRJNA674050_P_NODE_35661_length_244_cov_0.912281_g35458_i0 | PRJNA674050 | 35661 | 244 | 0.912281 | 2.22596564 | Halobacteriales | 2235 | Archaea | Archaea | 123 | 6.249999999999998e-32 | NR | MFB6235020.1 | 1979403 | g35458 | i0 | 75 | 3.9344262295082 | 80 | 20 | 98.4 | 0 | 240 | 1 | 106 | 185 | MFB6235020.1 PhnD/SsuA/transferrin family substrate-binding protein [Halopenitus sp.] | diamond | 960 | 124 | 0.991935483870968 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halopenitus | Halopenitus sp. | |
| 27113205 | 27113205 | PRJNA674050_P_NODE_33522_length_245_cov_0.906977_g33319_i0 | PRJNA674050 | 33522 | 245 | 0.906977 | 2.22209365 | Natranaeroarchaeum sulfidigenes | 2784880 | Archaea | Archaea | 110 | 4.18e-28 | NR | WP_238478096.1 | 2784880 | g33319 | i0 | 90.4 | 1.91020408163265 | 52 | 5 | 63.7 | 0 | 88 | 243 | 1 | 52 | WP_238478096.1 CRISPR-associated protein Cas4 [Natranaeroarchaeum sulfidigenes] | diamond | 468 | 110 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronoarchaeaceae | Natranaeroarchaeum | Natranaeroarchaeum sulfidigenes | |
| 27524131 | 27524131 | PRJNA674050_P_NODE_35403_length_244_cov_0.912281_g35200_i0 | PRJNA674050 | 35403 | 244 | 0.912281 | 2.22596564 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 117 | 8.91e-29 | NR | WP_181692137.1 | 2750669 | g35200 | i0 | 95.1 | 0.75 | 61 | 3 | 75 | 0 | 1 | 183 | 321 | 381 | WP_181692137.1 class III poly(R)-hydroxyalkanoic acid synthase subunit PhaC [Natronomonas sp. LN261] | diamond | 183 | 117 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 27618971 | 27618971 | PRJNA674050_P_NODE_22904_length_252_cov_0.871508_g22701_i0 | PRJNA674050 | 22904 | 252 | 0.871508 | 2.19620016 | Halodesulfurarchaeum sp. | 1980530 | Archaea | Archaea | 133 | 2.7e-34 | NR | WP_332320409.1 | 1980530 | g22701 | i0 | 91.7 | 6 | 72 | 6 | 85.7 | 0 | 218 | 3 | 1 | 72 | WP_332320409.1 FAD-binding protein [Halodesulfurarchaeum sp.] | diamond | 1512 | 133 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum sp. | |
| 28218514 | 28218514 | PRJNA674050_P_NODE_25266_length_250_cov_1.491525_g25063_i0 | PRJNA674050 | 25266 | 250 | 1.491525 | 3.7288125 | Halorientalis persicus | 1367881 | Archaea | Archaea | 42.7 | 0.0341 | NR | WP_092656756.1 | 1367881 | g25063 | i0 | 79.2 | 0.288 | 24 | 5 | 28.8 | 0 | 124 | 195 | 117 | 140 | WP_092656756.1 hypothetical protein [Halorientalis persicus] | diamond | 72 | 42.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloarculaceae | Halorientalis | Halorientalis persicus | |
| 28408247 | 28408247 | PRJNA674050_P_NODE_28466_length_248_cov_0.891429_g28263_i0 | PRJNA674050 | 28466 | 248 | 0.891429 | 2.21074392 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 126 | 3.1499999999999997e-35 | NR | WP_181691527.1 | 2750669 | g28263 | i0 | 88.7 | 0.858870967741935 | 71 | 8 | 85.9 | 0 | 214 | 2 | 1 | 71 | WP_181691527.1 hypothetical protein [Natronomonas sp. LN261] | diamond | 213 | 126 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 28534703 | 28534703 | PRJNA674050_P_NODE_28447_length_248_cov_0.891429_g28244_i0 | PRJNA674050 | 28447 | 248 | 0.891429 | 2.21074392 | Halodesulfurarchaeum sp. | 1980530 | Archaea | Archaea | 73.9 | 3.66e-13 | NR | MFB6086870.1 | 1980530 | g28244 | i0 | 64.2 | 0.641129032258065 | 53 | 19 | 64.1 | 0 | 159 | 1 | 1 | 53 | MFB6086870.1 NUDIX domain-containing protein [Halodesulfurarchaeum sp.] | diamond | 159 | 73.9 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Halodesulfurarchaeum | Halodesulfurarchaeum sp. | |
| 29197711 | 29197711 | PRJNA674050_P_NODE_40249_length_242_cov_0.857988_g40046_i0 | PRJNA674050 | 40249 | 242 | 0.857988 | 2.07633096 | Salarchaeum japonicum | 555573 | Archaea | Archaea | 53.1 | 7.25e-6 | NR | WP_227260632.1 | 555573 | g40046 | i0 | 88.9 | 0.334710743801653 | 27 | 3 | 33.5 | 0 | 1 | 81 | 295 | 321 | WP_227260632.1 sugar phosphate nucleotidyltransferase [Salarchaeum japonicum] | diamond | 81 | 53.1 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Halobacteriaceae | Salarchaeum | Salarchaeum japonicum | |
| 30883544 | 30883544 | PRJNA674050_P_NODE_36374_length_244_cov_0.900585_g36171_i0 | PRJNA674050 | 36374 | 244 | 0.900585 | 2.1974274 | Candidatus Nanosalina | 1051666 | Archaea | Archaea | 105 | 4.339999999999999e-24 | NR | MFB6292335.1 | 2594798 | g36171 | i0 | 63 | 2.00409836065574 | 81 | 30 | 99.6 | 0 | 2 | 244 | 265 | 345 | MFB6292335.1 STT3 domain-containing protein [Candidatus Nanohaloarchaea archaeon] | diamond | 489 | 105 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Candidatus Nanohaloarchaea | Candidatus Nanohaloarchaea archaeon | ||||
| 30998117 | 30998117 | PRJNA674050_P_NODE_24814_length_251_cov_0.870787_g24611_i0 | PRJNA674050 | 24814 | 251 | 0.870787 | 2.18567537 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 150 | 8.1e-43 | NR | WP_181693163.1 | 2750669 | g24611 | i0 | 92.8 | 0.99203187250996006 | 83 | 6 | 99.2 | 0 | 250 | 2 | 67 | 149 | WP_181693163.1 CheF family chemotaxis protein [Natronomonas sp. LN261] | diamond | 249 | 150 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 31630388 | 31630388 | PRJNA674050_P_NODE_31256_length_247_cov_0.873563_g31053_i0 | PRJNA674050 | 31256 | 247 | 0.873563 | 2.15770061 | Natronomonas sp. LN261 | 2750669 | Archaea | Archaea | 137 | 4.6199999999999995e-37 | NR | WP_181691507.1 | 2750669 | g31053 | i0 | 90.1 | 0.983805668016194 | 81 | 8 | 98.4 | 0 | 3 | 245 | 40 | 120 | WP_181691507.1 ATP-binding protein [Natronomonas sp. LN261] | diamond | 243 | 137 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas sp. LN261 | |
| 31661846 | 31661846 | PRJNA674050_P_NODE_36657_length_244_cov_0.865497_g36454_i0 | PRJNA674050 | 36657 | 244 | 0.865497 | 2.11181268 | Halonotius roseus | 2511997 | Archaea | Archaea | 105 | 5.44e-25 | NR | WP_142442090.1 | 2511997 | g36454 | i0 | 94.9 | 0.725409836065574 | 59 | 3 | 72.5 | 0 | 243 | 67 | 189 | 247 | WP_142442090.1 50S ribosomal protein L10 [Halonotius roseus] | diamond | 177 | 105 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Halonotius | Halonotius roseus |
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);;