contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJEB66218" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10335959 | 10335959 | PRJEB66218_P_NODE_247589_length_190_cov_3.581395_g245157_i0 | PRJEB66218 | 247589 | 190 | 3.581395 | 6.8046505 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 109 | 6.38e-26 | NR | HED37809.1 | 2053306 | g245157 | i0 | 79 | 1.95789473684211 | 62 | 13 | 97.9 | 0 | 3 | 188 | 1310 | 1371 | HED37809.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 372 | 109 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 26717060 | 26717060 | PRJEB66218_P_NODE_202461_length_210_cov_0.872483_g200031_i0 | PRJEB66218 | 202461 | 210 | 0.872483 | 1.8322143 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 98.2 | 7.49e-22 | NR | MBD1209841.1 | 2053306 | g200031 | i0 | 83.1 | 0.842857142857143 | 59 | 10 | 84.3 | 0 | 210 | 34 | 1094 | 1152 | MBD1209841.1 hypothetical protein [Ignavibacteria bacterium] | diamond | 177 | 98.2 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 27823896 | 27823896 | PRJEB66218_P_NODE_14884_length_1071_cov_3.836634_g13101_i0 | PRJEB66218 | 14884 | 1071 | 3.836634 | 41.09035014 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 103 | 4.86e-20 | NR | MFA6597452.1 | 2651163 | g13101 | i0 | 31.5 | 1.40336134453782 | 235 | 125 | 64.7 | 7 | 224 | 916 | 613 | 815 | MFA6597452.1 LamG-like jellyroll fold domain-containing protein [Ignavibacteriaceae bacterium] | diamond | 1503 | 103 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 29174459 | 29174459 | PRJEB66218_P_NODE_124789_length_268_cov_2.212560_g122360_i0 | PRJEB66218 | 124789 | 268 | 2.21256 | 5.9296608 | Bacteria | 2 | Bacteria | Bacteria | 53.5 | 8.02e-6 | NR | OIP63676.1 | 1805221 | g122360 | i0 | 40.2 | 7.44402985074627 | 92 | 44 | 98.5 | 5 | 268 | 5 | 95 | 179 | OIP63676.1 MAG: hypothetical protein AUK34_01090 [Ignavibacteria bacterium CG2_30_36_16] | diamond | 1995 | 53.5 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium CG2_30_36_16 | ||||
| 29900671 | 29900671 | PRJEB66218_P_NODE_148971_length_242_cov_1.751381_g146542_i0 | PRJEB66218 | 148971 | 242 | 1.751381 | 4.23834202 | Bacteria | 2 | Bacteria | Bacteria | 65.1 | 4.85e-10 | NR | OIP63676.1 | 1805221 | g146542 | i0 | 43.9 | 3.96694214876033 | 82 | 41 | 97.9 | 3 | 239 | 3 | 252 | 331 | OIP63676.1 MAG: hypothetical protein AUK34_01090 [Ignavibacteria bacterium CG2_30_36_16] | diamond | 960 | 65.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium CG2_30_36_16 | ||||
| 30034098 | 30034098 | PRJEB66218_P_NODE_167831_length_229_cov_1.160714_g165401_i0 | PRJEB66218 | 167831 | 229 | 1.160714 | 2.65803506 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 140 | 2.29e-39 | NR | MBD1209766.1 | 2053306 | g165401 | i0 | 96 | 0.982532751091703 | 75 | 3 | 98.3 | 0 | 3 | 227 | 73 | 147 | MBD1209766.1 DUF1573 domain-containing protein [Ignavibacteria bacterium] | diamond | 225 | 140 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 30034193 | 30034193 | PRJEB66218_P_NODE_63351_length_410_cov_2.275072_g60929_i0 | PRJEB66218 | 63351 | 410 | 2.275072 | 9.3277952 | Ignavibacteriaceae bacterium | 2651163 | Bacteria | Bacteria | 47.8 | 0.00358 | NR | MCC6254276.1 | 2651163 | g60929 | i0 | 33.7 | 0.607317073170732 | 83 | 54 | 60.7 | 1 | 332 | 84 | 7 | 88 | MCC6254276.1 hypothetical protein [Ignavibacteriaceae bacterium] | diamond | 249 | 47.8 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteriales | Ignavibacteriaceae | Ignavibacteriaceae bacterium | ||
| 30065479 | 30065479 | PRJEB66218_P_NODE_169852_length_227_cov_2.253012_g167422_i0 | PRJEB66218 | 169852 | 227 | 2.253012 | 5.11433724 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 45.4 | 0.00335 | NR | NLT50021.1 | 2053306 | g167422 | i0 | 40.3 | 2.84140969162996 | 62 | 37 | 81.9 | 0 | 3 | 188 | 331 | 392 | NLT50021.1 T9SS type A sorting domain-containing protein [Ignavibacteria bacterium] | diamond | 645 | 45.4 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 30665816 | 30665816 | PRJEB66218_P_NODE_123413_length_270_cov_1.822967_g120984_i0 | PRJEB66218 | 123413 | 270 | 1.822967 | 4.9220109 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 60.1 | 4.07e-8 | NR | NLT50021.1 | 2053306 | g120984 | i0 | 42.1 | 5.07777777777778 | 76 | 43 | 83.3 | 1 | 43 | 267 | 96 | 171 | NLT50021.1 T9SS type A sorting domain-containing protein [Ignavibacteria bacterium] | diamond | 1371 | 60.1 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 31930476 | 31930476 | PRJEB66218_P_NODE_209237_length_208_cov_2.340136_g206807_i0 | PRJEB66218 | 209237 | 208 | 2.340136 | 4.86748288 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 43.9 | 0.00942 | NR | HEX2788535.1 | 2053306 | g206807 | i0 | 36.8 | 0.822115384615385 | 57 | 35 | 82.2 | 1 | 1 | 171 | 85 | 140 | HEX2788535.1 LamG-like jellyroll fold domain-containing protein [Ignavibacteria bacterium] | diamond | 171 | 43.9 | 1 | Bacteria | FCB group | Pseudomonadati | Ignavibacteriota | Ignavibacteria | Ignavibacteria bacterium | ||||
| 32531932 | 32531932 | PRJEB66218_P_NODE_170699_length_227_cov_1.204819_g168269_i0 | PRJEB66218 | 170699 | 227 | 1.204819 | 2.73493913 | Ignavibacteria bacterium | 2053306 | Bacteria | Bacteria | 136 | 3.71e-35 | NR | MBD1207425.1 | 2053306 | g168269 | i0 | 88 | 0.991189427312775 | 75 | 9 | 99.1 | 0 | 226 | 2 | 612 | 686 | MBD1207425.1 TonB-dependent receptor [Ignavibacteria bacterium] | diamond | 225 | 136 | 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);;