contig_metadata
8 rows where bioproject = "PRJNA577580", tax_clade = "FCB group" and tax_phylum = "Ignavibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14592915 | 14592915 | PRJNA577580_P_NODE_4792_length_409_cov_1.812500_g4714_i0 | PRJNA577580 | 4792 | 409 | 1.8125 | 7.413125 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 283 | 1.28e-71 | NTclustered | gi|1850842921|gb|CP053447.1| | 2026749 | g4714 | i0 | 79.75 | 72.3814180929095 | 400 | 74 | 97 | 7 | 12 | 407 | 430054 | 429658 | Ignavibacteriae bacterium isolate IGN3 chromosome | blastn | 29604 | 283 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 27743320 | 27743320 | PRJNA577580_P_NODE_1484_length_744_cov_3.453055_g1411_i0 | PRJNA577580 | 1484 | 744 | 3.453055 | 25.6907292 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 76.6 | 7.34e-12 | NR | KAB2846403.1 | 2614255 | g1411 | i0 | 34.7 | 0.709677419354839 | 176 | 100 | 69.4 | 7 | 62 | 577 | 453 | 617 | KAB2846403.1 MAG: choice-of-anchor A family protein, partial [Melioribacteraceae bacterium] | diamond | 528 | 76.6 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 27945996 | 27945996 | PRJNA577580_P_NODE_10825_length_279_cov_2.582524_g10747_i0 | PRJNA577580 | 10825 | 279 | 2.582524 | 7.20524196 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 160 | 8.049999999999999e-47 | NR | MBZ0204643.1 | 2053306 | g10747 | i0 | 94.1 | 2.74193548387097 | 85 | 5 | 91.4 | 0 | 23 | 277 | 47 | 131 | MBZ0204643.1 LysM peptidoglycan-binding domain-containing protein [Ignavibacteria bacterium] | diamond | 765 | 161 | 0.993788819875776 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 29132435 | 29132435 | PRJNA577580_P_NODE_1009_length_879_cov_3.617866_g945_i0 | PRJNA577580 | 1009 | 879 | 3.617866 | 31.80104214 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 170 | 1.7599999999999999e-43 | NR | PLX33511.1 | 2053306 | g945 | i0 | 39.1 | 2.02730375426621 | 297 | 168 | 98.3 | 8 | 876 | 13 | 1306 | 1598 | PLX33511.1 MAG: hypothetical protein C0600_00325 [Ignavibacteria bacterium] | diamond | 1782 | 170 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 29731992 | 29731992 | PRJNA577580_P_NODE_14850_length_248_cov_0.891429_g14772_i0 | PRJNA577580 | 14850 | 248 | 0.891429 | 2.21074392 | Melioribacteraceae bacterium | 2614255 | Bacteria | Bacteria | 64.3 | 5.78e-10 | NR | MCF6268436.1 | 2614255 | g14772 | i0 | 44.7 | 3.67741935483871 | 76 | 38 | 90.7 | 2 | 239 | 15 | 176 | 248 | MCF6268436.1 MerR family transcriptional regulator [Melioribacteraceae bacterium] | diamond | 912 | 64.3 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Melioribacteraceae | Melioribacteraceae bacterium | ||
| 30521966 | 30521966 | PRJNA577580_P_NODE_14793_length_248_cov_0.891429_g14715_i0 | PRJNA577580 | 14793 | 248 | 0.891429 | 2.21074392 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 102 | 2.51e-23 | NR | MBD1210498.1 | 2053306 | g14715 | i0 | 88.1 | 1.01612903225806 | 84 | 4 | 99.2 | 2 | 246 | 1 | 126 | 205 | MBD1210498.1 leucine-rich repeat domain-containing protein [Ignavibacteria bacterium] | diamond | 252 | 102 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 31343687 | 31343687 | PRJNA577580_P_NODE_7756_length_324_cov_1.422311_g7678_i0 | PRJNA577580 | 7756 | 324 | 1.422311 | 4.60828764 | Ignavibacterium sp. | 2651167 | Bacteria | Bacteria | 54.3 | 6.43e-6 | NR | WP_348344159.1 | 2651167 | g7678 | i0 | 39.1 | 0.638888888888889 | 69 | 40 | 62 | 2 | 115 | 315 | 19 | 87 | WP_348344159.1 hypothetical protein [Ignavibacterium sp.] | diamond | 207 | 54.3 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacterium | Ignavibacterium sp. | |
| 31357223 | 31357223 | PRJNA577580_P_NODE_4916_length_404_cov_2.287009_g4838_i0 | PRJNA577580 | 4916 | 404 | 2.287009 | 9.23951636 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 99.4 | 2.91e-21 | NR | OGU71852.1 | 1798438 | g4838 | i0 | 42.9 | 5.45049504950495 | 105 | 60 | 78 | 0 | 24 | 338 | 421 | 525 | OGU71852.1 MAG: phosphoglycerate dehydrogenase [Ignavibacteria bacterium RIFCSPLOWO2_12_FULL_56_21] | diamond | 2202 | 99.4 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium RIFCSPLOWO2_12_FULL_56_21 |
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);;