contig_metadata
15 rows where bioproject = "PRJNA382357" and tax_clade = "acIV cluster"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24630518 | 24630518 | PRJNA382357_P_NODE_63420_length_295_cov_15.995726_g62681_i0 | PRJNA382357 | 63420 | 295 | 15.995726 | 47.1873917 | Acidimicrobiia bacterium BACL6 MAG-12122 | 2080302 | Bacteria | Bacteria | 120 | 5.73e-32 | NR | KRO63326.1 | 1655584 | g62681 | i0 | 100 | 0.6 | 59 | 0 | 60 | 0 | 118 | 294 | 2 | 60 | KRO63326.1 MAG: 30S ribosomal protein S4, partial [Acidimicrobiia bacterium BACL6 MAG-121220-bin61] | diamond | 177 | 120 | 1 | Bacteria | acIV cluster | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium BACL6 MAG-121220-bin61 | ||||
| 26933825 | 26933825 | PRJNA382357_P_NODE_124862_length_219_cov_1.189873_g124123_i0 | PRJNA382357 | 124862 | 219 | 1.189873 | 2.60582187 | Bacteria | 2 | Bacteria | Bacteria | 109 | 3.25e-26 | NR | KRO48729.1 | 1655583 | g124123 | i0 | 98.2 | 3.01369863013699 | 55 | 1 | 75.3 | 0 | 1 | 165 | 157 | 211 | KRO48729.1 MAG: hypothetical protein ABR75_05330 [Acidimicrobiia bacterium BACL6 MAG-120924-bin43] | diamond | 660 | 109 | 1 | Bacteria | acIV cluster | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium BACL6 MAG-120924-bin43 | ||||
| 27281790 | 27281790 | PRJNA382357_P_NODE_121883_length_221_cov_4.843750_g121144_i0 | PRJNA382357 | 121883 | 221 | 4.84375 | 10.7046875 | Acidimicrobium | 53634 | Bacteria | Bacteria | 105 | 3.4999999999999997e-25 | NR | KRO49116.1 | 1655583 | g121144 | i0 | 98.1 | 2.82352941176471 | 52 | 1 | 70.6 | 0 | 198 | 43 | 207 | 258 | KRO49116.1 MAG: hypothetical protein ABR75_05795 [Acidimicrobiia bacterium BACL6 MAG-120924-bin43] | diamond | 624 | 106 | 0.990566037735849 | Bacteria | acIV cluster | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium BACL6 MAG-120924-bin43 | ||||
| 27502983 | 27502983 | PRJNA382357_P_NODE_161523_length_192_cov_18.145038_g160784_i0 | PRJNA382357 | 161523 | 192 | 18.145038 | 34.83847296 | Bacteria | 2 | Bacteria | Bacteria | 77 | 5.96e-15 | NR | KRO46607.1 | 1655583 | g160784 | i0 | 92.7 | 2.5625 | 41 | 3 | 64.1 | 0 | 190 | 68 | 124 | 164 | KRO46607.1 MAG: anthranilate phosphoribosyltransferase, partial [Acidimicrobiia bacterium BACL6 MAG-120924-bin43] | diamond | 492 | 77.4 | 0.994832041343669 | Bacteria | acIV cluster | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium BACL6 MAG-120924-bin43 | ||||
| 27976391 | 27976391 | PRJNA382357_P_NODE_142985_length_207_cov_1.808219_g142246_i0 | PRJNA382357 | 142985 | 207 | 1.808219 | 3.74301333 | Bacteria | 2 | Bacteria | Bacteria | 55.1 | 4.29e-7 | NR | KRO65760.1 | 1655584 | g142246 | i0 | 96.4 | 0.811594202898551 | 28 | 1 | 40.6 | 0 | 124 | 207 | 140 | 167 | KRO65760.1 MAG: hypothetical protein ABR76_04355, partial [Acidimicrobiia bacterium BACL6 MAG-121220-bin61] | diamond | 168 | 55.1 | 1 | Bacteria | acIV cluster | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium BACL6 MAG-121220-bin61 | ||||
| 28828816 | 28828816 | PRJNA382357_P_NODE_98628_length_243_cov_25.456044_g97889_i0 | PRJNA382357 | 98628 | 243 | 25.456044 | 61.85818692 | Acidimicrobium | 53634 | Bacteria | Bacteria | 125 | 1.5899999999999998e-31 | NR | KRO48843.1 | 1655583 | g97889 | i0 | 96.7 | 3.01234567901235 | 61 | 2 | 75.3 | 0 | 55 | 237 | 448 | 508 | KRO48843.1 MAG: hypothetical protein ABR75_06240, partial [Acidimicrobiia bacterium BACL6 MAG-120924-bin43] | diamond | 732 | 125 | 1 | Bacteria | acIV cluster | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium BACL6 MAG-120924-bin43 | ||||
| 28891915 | 28891915 | PRJNA382357_P_NODE_161588_length_192_cov_9.229008_g160849_i0 | PRJNA382357 | 161588 | 192 | 9.229008 | 17.71969536 | Acidimicrobium | 53634 | Bacteria | Bacteria | 62.8 | 9.4e-10 | NR | KRO49274.1 | 1655583 | g160849 | i0 | 100 | 0.9375 | 30 | 0 | 46.9 | 0 | 1 | 90 | 199 | 228 | KRO49274.1 MAG: RNA polymerase subunit sigma-70 [Acidimicrobiia bacterium BACL6 MAG-120924-bin43] | diamond | 180 | 62.8 | 1 | Bacteria | acIV cluster | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium BACL6 MAG-120924-bin43 | ||||
| 29523595 | 29523595 | PRJNA382357_P_NODE_164170_length_187_cov_11.301587_g163431_i0 | PRJNA382357 | 164170 | 187 | 11.301587 | 21.13396769 | Acidimicrobium | 53634 | Bacteria | Bacteria | 67.8 | 2.16e-11 | NR | KRO46972.1 | 1655583 | g163431 | i0 | 79.1 | 3.44919786096257 | 43 | 9 | 69 | 0 | 3 | 131 | 27 | 69 | KRO46972.1 MAG: hypothetical protein ABR75_01780, partial [Acidimicrobiia bacterium BACL6 MAG-120924-bin43] | diamond | 645 | 68.2 | 0.994134897360704 | Bacteria | acIV cluster | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium BACL6 MAG-120924-bin43 | ||||
| 29617940 | 29617940 | PRJNA382357_P_NODE_161590_length_192_cov_9.114504_g160851_i0 | PRJNA382357 | 161590 | 192 | 9.114504 | 17.49984768 | Acidimicrobium | 53634 | Bacteria | Bacteria | 57.8 | 9.53e-8 | NR | KRO47578.1 | 1655583 | g160851 | i0 | 87.5 | 1.5 | 32 | 4 | 50 | 0 | 10 | 105 | 240 | 271 | KRO47578.1 MAG: hypothetical protein ABR75_01260 [Acidimicrobiia bacterium BACL6 MAG-120924-bin43] | diamond | 288 | 57.8 | 1 | Bacteria | acIV cluster | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium BACL6 MAG-120924-bin43 | ||||
| 29948768 | 29948768 | PRJNA382357_P_NODE_37791_length_372_cov_1.234727_g37052_i0 | PRJNA382357 | 37791 | 372 | 1.234727 | 4.59318444 | Acidimicrobiia bacterium BACL6 MAG-12 | 2080302 | Bacteria | Bacteria | 189 | 4.53e-58 | NR | KRO48260.1 | 1655583 | g37052 | i0 | 89.9 | 0.798387096774194 | 99 | 10 | 79.8 | 0 | 70 | 366 | 1 | 99 | KRO48260.1 MAG: hypothetical protein ABR75_01035 [Acidimicrobiia bacterium BACL6 MAG-120924-bin43] | diamond | 297 | 189 | 1 | Bacteria | acIV cluster | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium BACL6 MAG-120924-bin43 | ||||
| 29965746 | 29965746 | PRJNA382357_P_NODE_157291_length_200_cov_3.705036_g156552_i0 | PRJNA382357 | 157291 | 200 | 3.705036 | 7.410072 | Bacteria | 2 | Bacteria | Bacteria | 85.5 | 8.53e-18 | NR | KRO49055.1 | 1655583 | g156552 | i0 | 92.9 | 2.52 | 42 | 3 | 63 | 0 | 52 | 177 | 27 | 68 | KRO49055.1 MAG: hypothetical protein ABR75_08770 [Acidimicrobiia bacterium BACL6 MAG-120924-bin43] | diamond | 504 | 85.5 | 1 | Bacteria | acIV cluster | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium BACL6 MAG-120924-bin43 | ||||
| 30169658 | 30169658 | PRJNA382357_P_NODE_125652_length_218_cov_1.573248_g124913_i0 | PRJNA382357 | 125652 | 218 | 1.573248 | 3.42968064 | Acidimicrobiia bacterium BACL6 MAG-12 | 2080302 | Bacteria | Bacteria | 92 | 4.730000000000001e-21 | NR | KRO47428.1 | 1655583 | g124913 | i0 | 100 | 1.89908256880734 | 46 | 0 | 63.3 | 0 | 180 | 43 | 167 | 212 | KRO47428.1 MAG: 50S ribosomal protein L3 [Acidimicrobiia bacterium BACL6 MAG-120924-bin43] | diamond | 414 | 92 | 1 | Bacteria | acIV cluster | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium BACL6 MAG-120924-bin43 | ||||
| 30282013 | 30282013 | PRJNA382357_P_NODE_122832_length_220_cov_21.018868_g122093_i0 | PRJNA382357 | 122832 | 220 | 21.018868 | 46.2415096 | Bacteria | 2 | Bacteria | Bacteria | 82.8 | 1.08e-16 | NR | KRO48551.1 | 1655583 | g122093 | i0 | 94.9 | 2.65909090909091 | 39 | 2 | 53.2 | 0 | 1 | 117 | 33 | 71 | KRO48551.1 MAG: cyclic pyranopterin phosphate synthase MoaA [Acidimicrobiia bacterium BACL6 MAG-120924-bin43] | diamond | 585 | 82.8 | 1 | Bacteria | acIV cluster | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium BACL6 MAG-120924-bin43 | ||||
| 30643677 | 30643677 | PRJNA382357_P_NODE_61473_length_299_cov_3.882353_g60734_i0 | PRJNA382357 | 61473 | 299 | 3.882353 | 11.60823547 | Acidimicrobiia bacterium BACL6 MAG-12 | 2080302 | Bacteria | Bacteria | 158 | 1.54e-45 | NR | KRO46174.1 | 1655583 | g60734 | i0 | 98.7 | 3.96321070234114 | 79 | 1 | 79.3 | 0 | 62 | 298 | 69 | 147 | KRO46174.1 MAG: succinyl-CoA synthetase subunit beta, partial [Acidimicrobiia bacterium BACL6 MAG-120924-bin43] | diamond | 1185 | 158 | 1 | Bacteria | acIV cluster | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium BACL6 MAG-120924-bin43 | ||||
| 32400125 | 32400125 | PRJNA382357_P_NODE_147059_length_205_cov_27.993056_g146320_i0 | PRJNA382357 | 147059 | 205 | 27.993056 | 57.3857648 | Bacteria | 2 | Bacteria | Bacteria | 92.4 | 7.27e-20 | NR | KRO65711.1 | 1655584 | g146320 | i0 | 100 | 3.07317073170732 | 42 | 0 | 61.5 | 0 | 204 | 79 | 647 | 688 | KRO65711.1 MAG: 2-phospho-L-lactate guanylyltransferase, partial [Acidimicrobiia bacterium BACL6 MAG-121220-bin61] | diamond | 630 | 92.4 | 1 | Bacteria | acIV cluster | Bacillati | Actinomycetota | Acidimicrobiia | Acidimicrobiia bacterium BACL6 MAG-121220-bin61 |
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);;