contig_metadata
10 rows where bioproject = "PRJNA946307", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 925724 | 925724 | PRJNA946307_P_NODE_114241_length_178_cov_1.201550_g113367_i0 | PRJNA946307 | 114241 | 178 | 1.20155 | 2.138759 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 104 | 2.34e-24 | NR | HOP49471.1 | 2049428 | g113367 | i0 | 92.7 | 0.926966292134832 | 55 | 4 | 92.7 | 0 | 168 | 4 | 897 | 951 | HOP49471.1 response regulator [Ignavibacteriales bacterium] | diamond | 165 | 104 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 12405013 | 12405013 | PRJNA946307_P_NODE_121790_length_174_cov_2.352000_g120916_i0 | PRJNA946307 | 121790 | 174 | 2.352 | 4.09248 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 124 | 3.0599999999999998e-24 | NTclustered | gi|1958088527|gb|CP065001.1| | 2049428 | g120916 | i0 | 81.41 | 28.5459770114943 | 156 | 25 | 90 | 4 | 1 | 156 | 609442 | 609291 | Ignavibacteriales bacterium isolate Kalu_18-Q3-R12-55_MAXAC.127v2 chromosome, complete genome | blastn | 4967 | 124 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 12405306 | 12405306 | PRJNA946307_P_NODE_138070_length_168_cov_0.873950_g137196_i0 | PRJNA946307 | 138070 | 168 | 0.87395 | 1.468236 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 104 | 2.1e-26 | NR | HRT99185.1 | 2049428 | g137196 | i0 | 96 | 2.67857142857143 | 50 | 2 | 89.3 | 0 | 153 | 4 | 78 | 127 | HRT99185.1 pyruvate, phosphate dikinase [Ignavibacteriales bacterium] | diamond | 450 | 104 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 20052569 | 20052569 | PRJNA946307_P_NODE_126276_length_172_cov_2.382114_g125402_i0 | PRJNA946307 | 126276 | 172 | 2.382114 | 4.09723608 | Ignavibacterium sp. | 2651167 | Bacteria | Bacteria | 54.7 | 0.004 | NTclustered | gi|2314740639|dbj|AP026678.1| | 2651167 | g125402 | i0 | 100 | 0.168604651162791 | 29 | 0 | 17 | 0 | 53 | 81 | 1402622 | 1402650 | MAG: Ignavibacterium sp. KatS3mg037 DNA, complete genome | blastn | 29 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacterium | Ignavibacterium sp. | |
| 23878468 | 23878468 | PRJNA946307_P_NODE_120039_length_175_cov_1.769841_g119165_i0 | PRJNA946307 | 120039 | 175 | 1.769841 | 3.09722175 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 178 | 2.3299999999999993e-40 | NTclustered | gi|2621704225|emb|OY761615.1| | 2651163 | g119165 | i0 | 89.362 | 4.43428571428571 | 141 | 15 | 81 | 0 | 1 | 141 | 3101165 | 3101025 | MAG: Ignavibacteriaceae bacterium isolate 0c874fb2-9291-49ee-bde1-826c4484edf3 genome assembly, chromosome: 1 | blastn | 776 | 178 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 26613666 | 26613666 | PRJNA946307_P_NODE_130801_length_170_cov_2.462810_g129927_i0 | PRJNA946307 | 130801 | 170 | 2.46281 | 4.186777 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 94.4 | 9.15e-21 | NR | HOP48990.1 | 2049428 | g129927 | i0 | 89.4 | 0.829411764705882 | 47 | 5 | 82.9 | 0 | 161 | 21 | 170 | 216 | HOP48990.1 alpha-amylase family glycosyl hydrolase [Ignavibacteriales bacterium] | diamond | 141 | 94.4 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 26676882 | 26676882 | PRJNA946307_P_NODE_135681_length_168_cov_4.411765_g134807_i0 | PRJNA946307 | 135681 | 168 | 4.411765 | 7.4117652 | Ignavibacteriota bacterium | 2026749 | Bacteria | Bacteria | 67.8 | 1.57e-11 | NR | MCB0727705.1 | 2026749 | g134807 | i0 | 56 | 1.76785714285714 | 50 | 22 | 89.3 | 0 | 14 | 163 | 220 | 269 | MCB0727705.1 PliI family lysozyme inhibitor of I-type lysozyme [Ignavibacteriota bacterium] | diamond | 297 | 67.8 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteriota bacterium | |||||
| 26708614 | 26708614 | PRJNA946307_P_NODE_81081_length_193_cov_3.090278_g80207_i0 | PRJNA946307 | 81081 | 193 | 3.090278 | 5.96423654 | Ignavibacteriales bacterium | 2049428 | Bacteria | Bacteria | 79 | 1.48e-15 | NR | MCK7517096.1 | 2049428 | g80207 | i0 | 56.7 | 1.04145077720207 | 67 | 19 | 88.6 | 1 | 4 | 174 | 146 | 212 | MCK7517096.1 alcohol dehydrogenase catalytic domain-containing protein [Ignavibacteriales bacterium] | diamond | 201 | 79 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriales bacterium | |||
| 28200512 | 28200512 | PRJNA946307_P_NODE_44046_length_211_cov_2.783951_g43172_i0 | PRJNA946307 | 44046 | 211 | 2.783951 | 5.87413661 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 65.5 | 2.43e-10 | NR | MFA5012717.1 | 2053306 | g43172 | i0 | 90.6 | 3.1563981042654 | 32 | 3 | 45.5 | 0 | 5 | 100 | 1807 | 1838 | MFA5012717.1 alpha-2-macroglobulin family protein [Ignavibacteria bacterium] | diamond | 666 | 65.5 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 32743949 | 32743949 | PRJNA946307_P_NODE_86160_length_190_cov_2.460993_g85286_i0 | PRJNA946307 | 86160 | 190 | 2.460993 | 4.6758867 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 58.9 | 3.63e-8 | NR | MCU7495390.1 | 2053306 | g85286 | i0 | 53.4 | 1.81578947368421 | 58 | 27 | 91.6 | 0 | 7 | 180 | 340 | 397 | MCU7495390.1 PAS domain S-box protein [Ignavibacteria bacterium] | diamond | 345 | 58.9 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria 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);;