contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA785164" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3317484 | 3317484 | PRJNA785164_P_NODE_39883_length_285_cov_2.226415_g39418_i0 | PRJNA785164 | 39883 | 285 | 2.226415 | 6.34528275 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 152 | 1.46e-42 | NR | MBP6912888.1 | 2053589 | g39418 | i0 | 96.3 | 0.842105263157895 | 80 | 3 | 84.2 | 0 | 241 | 2 | 1 | 80 | MBP6912888.1 recombinase RecA [Candidatus Paceibacterota bacterium] | diamond | 240 | 152 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 8419428 | 8419428 | PRJNA785164_P_NODE_44647_length_269_cov_2.265306_g44182_i0 | PRJNA785164 | 44647 | 269 | 2.265306 | 6.09367314 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 152 | 4.529999999999999e-42 | NR | HEX4799160.1 | 2053589 | g44182 | i0 | 88.2 | 4.73977695167286 | 85 | 10 | 94.8 | 0 | 267 | 13 | 232 | 316 | HEX4799160.1 serine hydroxymethyltransferase [Candidatus Paceibacterota bacterium] | diamond | 1275 | 152 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 26736709 | 26736709 | PRJNA785164_P_NODE_35321_length_305_cov_1.146552_g34856_i0 | PRJNA785164 | 35321 | 305 | 1.146552 | 3.4969836 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 104 | 1.1799999999999999e-23 | NR | MFA6097568.1 | 2053589 | g34856 | i0 | 56.4 | 0.99344262295082 | 101 | 39 | 95.4 | 2 | 305 | 15 | 221 | 320 | MFA6097568.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 303 | 104 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 27243288 | 27243288 | PRJNA785164_P_NODE_36123_length_301_cov_1.350877_g35658_i0 | PRJNA785164 | 36123 | 301 | 1.350877 | 4.06613977 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 79 | 9.58e-17 | NR | MFA6386855.1 | 2053589 | g35658 | i0 | 57.4 | 0.60797342192691 | 61 | 22 | 56.8 | 2 | 130 | 300 | 3 | 63 | MFA6386855.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 183 | 79 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28001415 | 28001415 | PRJNA785164_P_NODE_27885_length_348_cov_1.414545_g27420_i0 | PRJNA785164 | 27885 | 348 | 1.414545 | 4.9226166 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 56.6 | 6.33e-8 | NR | MBP6857741.1 | 2053589 | g27420 | i0 | 53.7 | 0.46551724137931 | 54 | 25 | 46.6 | 0 | 185 | 346 | 1 | 54 | MBP6857741.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 162 | 56.6 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 28095957 | 28095957 | PRJNA785164_P_NODE_62245_length_241_cov_0.916667_g61780_i0 | PRJNA785164 | 62245 | 241 | 0.916667 | 2.20916747 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 127 | 3.47e-32 | NR | MDI9407820.1 | 2053589 | g61780 | i0 | 89.5 | 1.89211618257261 | 76 | 8 | 94.6 | 0 | 230 | 3 | 399 | 474 | MDI9407820.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 456 | 127 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 29895809 | 29895809 | PRJNA785164_P_NODE_52911_length_249_cov_1.704545_g52446_i0 | PRJNA785164 | 52911 | 249 | 1.704545 | 4.24431705 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 42.7 | 0.0213 | NR | HEY6020168.1 | 2053589 | g52446 | i0 | 42.1 | 0.91566265060241 | 76 | 38 | 88 | 3 | 5 | 223 | 69 | 141 | HEY6020168.1 hypothetical protein [Candidatus Paceibacterota bacterium] | diamond | 228 | 42.7 | 1 | Bacteria | Bacteria candidate phyla | Minisyncoccota | Minisyncoccota bacterium | ||||||
| 30464804 | 30464804 | PRJNA785164_P_NODE_40313_length_284_cov_1.227488_g39848_i0 | PRJNA785164 | 40313 | 284 | 1.227488 | 3.48606592 | Minisyncoccota bacterium | 2053589 | Bacteria | Bacteria | 87 | 2.9e-19 | NR | MDP7158977.1 | 2053589 | g39848 | i0 | 48.9 | 5.98943661971831 | 94 | 37 | 91.9 | 2 | 22 | 282 | 4 | 93 | MDP7158977.1 ATP-binding protein [Candidatus Paceibacterota bacterium] | diamond | 1701 | 87 | 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);;