contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA800053" and tax_phylum = "Minisyncoccota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27307074 | 27307074 | PRJNA800053_P_NODE_16643_length_255_cov_1.324176_g16479_i0 | PRJNA800053 | 16643 | 255 | 1.324176 | 3.3766488 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 80.5 | 1.2e-17 | NR | HEY4506363.1 | 2053589 | g16479 | i0 | 62.7 | 0.788235294117647 | 67 | 24 | 77.6 | 1 | 223 | 26 | 1 | 67 | HEY4506363.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 201 | 80.5 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27717886 | 27717886 | PRJNA800053_P_NODE_15464_length_262_cov_1.619048_g15300_i0 | PRJNA800053 | 15464 | 262 | 1.619048 | 4.24190576 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 111 | 6.1099999999999994e-30 | NR | MBP6974691.1 | 2053589 | g15300 | i0 | 100 | 0.595419847328244 | 52 | 0 | 59.5 | 0 | 258 | 103 | 36 | 87 | MBP6974691.1 type II toxin-antitoxin system mRNA interferase toxin, RelE/StbE family [Candidatus Paceibacterota bacterium] | diamond | 156 | 111 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27780751 | 27780751 | PRJNA800053_P_NODE_22184_length_243_cov_1.800000_g22020_i0 | PRJNA800053 | 22184 | 243 | 1.8 | 4.374 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 50.1 | 1e-4 | NR | MFA7192390.1 | 2053589 | g22020 | i0 | 38.2 | 0.839506172839506 | 68 | 41 | 84 | 1 | 16 | 219 | 514 | 580 | MFA7192390.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 204 | 50.1 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30211866 | 30211866 | PRJNA800053_P_NODE_8192_length_333_cov_1.500000_g8028_i0 | PRJNA800053 | 8192 | 333 | 1.5 | 4.995 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 58.2 | 2.17e-7 | NR | MFA6251563.1 | 2053589 | g8028 | i0 | 71.1 | 0.342342342342342 | 38 | 11 | 34.2 | 0 | 218 | 331 | 1 | 38 | MFA6251563.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 114 | 58.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31159533 | 31159533 | PRJNA800053_P_NODE_13115_length_279_cov_1.169903_g12951_i0 | PRJNA800053 | 13115 | 279 | 1.169903 | 3.26402937 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 114 | 1.13e-29 | NR | MFA6408436.1 | 2053589 | g12951 | i0 | 58 | 1.89247311827957 | 88 | 37 | 94.6 | 0 | 9 | 272 | 62 | 149 | MFA6408436.1 L-threonylcarbamoyladenylate synthase [Candidatus Paceibacterota bacterium] | diamond | 528 | 114 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31317968 | 31317968 | PRJNA800053_P_NODE_14135_length_271_cov_2.181818_g13971_i0 | PRJNA800053 | 14135 | 271 | 2.181818 | 5.91272678 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 72.8 | 1.17e-12 | NR | MFA7192389.1 | 2053589 | g13971 | i0 | 40.3 | 0.85239852398524 | 77 | 46 | 85.2 | 0 | 33 | 263 | 272 | 348 | MFA7192389.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 231 | 72.8 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31729126 | 31729126 | PRJNA800053_P_NODE_17957_length_250_cov_0.870056_g17793_i0 | PRJNA800053 | 17957 | 250 | 0.870056 | 2.17514 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 86.7 | 2.13e-18 | NR | MBP9717376.1 | 2053589 | g17793 | i0 | 73 | 0.756 | 63 | 14 | 75.6 | 1 | 192 | 4 | 4 | 63 | MBP9717376.1 F0F1 ATP synthase subunit A [Candidatus Paceibacterota bacterium] | diamond | 189 | 86.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 31982166 | 31982166 | PRJNA800053_P_NODE_19298_length_248_cov_0.880000_g19134_i0 | PRJNA800053 | 19298 | 248 | 0.88 | 2.1824 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 124 | 1.3399999999999998e-32 | NR | MBP6924230.1 | 2053589 | g19134 | i0 | 76.8 | 1.98387096774194 | 82 | 17 | 99.2 | 1 | 248 | 3 | 25 | 104 | MBP6924230.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 492 | 124 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32172339 | 32172339 | PRJNA800053_P_NODE_22378_length_243_cov_0.905882_g22214_i0 | PRJNA800053 | 22378 | 243 | 0.905882 | 2.20129326 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 79.3 | 4.83e-15 | NR | HYE22855.1 | 2053589 | g22214 | i0 | 50 | 2.88888888888889 | 78 | 39 | 96.3 | 0 | 2 | 235 | 1067 | 1144 | HYE22855.1 class I tRNA ligase family protein [Candidatus Paceibacterota bacterium] | diamond | 702 | 79.3 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32488732 | 32488732 | PRJNA800053_P_NODE_23219_length_242_cov_0.911243_g23055_i0 | PRJNA800053 | 23219 | 242 | 0.911243 | 2.20520806 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 63.2 | 1.94e-9 | NR | HEY6020745.1 | 2053589 | g23055 | i0 | 39.7 | 0.966942148760331 | 78 | 46 | 96.7 | 1 | 240 | 7 | 50 | 126 | HEY6020745.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 234 | 63.2 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 32614880 | 32614880 | PRJNA800053_P_NODE_20080_length_247_cov_0.885057_g19916_i0 | PRJNA800053 | 20080 | 247 | 0.885057 | 2.18609079 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 122 | 3.22e-31 | NR | MDD5318294.1 | 2053589 | g19916 | i0 | 77.2 | 0.959514170040486 | 79 | 18 | 96 | 0 | 245 | 9 | 195 | 273 | MDD5318294.1 tRNA-dihydrouridine synthase [Candidatus Paceibacterota bacterium] | diamond | 237 | 122 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium |
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);;