contig_metadata
8 rows where bioproject = "PRJNA492406", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5556230 | 5556230 | PRJNA492406_P_NODE_31825_length_241_cov_1.434524_g31526_i0 | PRJNA492406 | 31825 | 241 | 1.434524 | 3.45720284 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 57.4 | 2.4e-7 | NR | HET7464282.1 | 2029185 | g31526 | i0 | 53.6 | 0.697095435684647 | 56 | 26 | 69.7 | 0 | 240 | 73 | 323 | 378 | HET7464282.1 glycosyltransferase family 4 protein [Longimicrobium sp.] | diamond | 168 | 57.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 11931036 | 11931036 | PRJNA492406_P_NODE_19970_length_284_cov_0.819905_g19671_i0 | PRJNA492406 | 19970 | 284 | 0.819905 | 2.3285302 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 254 | 6.7e-63 | NTclustered | gi|2874253728|emb|OY969570.1| | 412054 | g19671 | i0 | 89.899 | 78.1232394366197 | 198 | 18 | 69 | 2 | 83 | 279 | 2314431 | 2314627 | MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1 | blastn | 22187 | 254 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 26791680 | 26791680 | PRJNA492406_P_NODE_22121_length_273_cov_1.310000_g21822_i0 | PRJNA492406 | 22121 | 273 | 1.31 | 3.5763 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 43.1 | 0.0375 | NR | MEO5904546.1 | 2026741 | g21822 | i0 | 47.5 | 0.43956043956044 | 40 | 21 | 44 | 0 | 2 | 121 | 297 | 336 | MEO5904546.1 hypothetical protein [Gemmatimonadaceae bacterium] | diamond | 120 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 30739919 | 30739919 | PRJNA492406_P_NODE_26874_length_250_cov_2.491525_g26575_i0 | PRJNA492406 | 26874 | 250 | 2.491525 | 6.2288125 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 63.2 | 2.7e-9 | NR | MDE2781386.1 | 2026742 | g26575 | i0 | 45.7 | 1.98 | 81 | 43 | 97.2 | 1 | 5 | 247 | 1609 | 1688 | MDE2781386.1 SwmB domain-containing protein [Gemmatimonadota bacterium] | diamond | 495 | 63.2 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 30803067 | 30803067 | PRJNA492406_P_NODE_32954_length_208_cov_4.614815_g32655_i0 | PRJNA492406 | 32954 | 208 | 4.614815 | 9.5988152 | Gemmatimonadales bacterium | 2448054 | Bacteria | Bacteria | 42 | 0.0432 | NR | HET9066663.1 | 2448054 | g32655 | i0 | 40.4 | 0.822115384615385 | 57 | 30 | 82.2 | 1 | 9 | 179 | 416 | 468 | HET9066663.1 ABC transporter permease [Gemmatimonadales bacterium] | diamond | 171 | 42 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadales bacterium | |||
| 31293047 | 31293047 | PRJNA492406_P_NODE_5455_length_513_cov_1.590909_g5157_i0 | PRJNA492406 | 5455 | 513 | 1.590909 | 8.16136317 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 112 | 4.76e-25 | NR | HKV50413.1 | 2026741 | g5157 | i0 | 32.8 | 8.7953216374269 | 189 | 101 | 98.2 | 5 | 511 | 8 | 525 | 708 | HKV50413.1 S41 family peptidase [Gemmatimonadaceae bacterium] | diamond | 4512 | 112 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae bacterium | ||
| 32052289 | 32052289 | PRJNA492406_P_NODE_21178_length_278_cov_1.151220_g20879_i0 | PRJNA492406 | 21178 | 278 | 1.15122 | 3.2003916 | root | 1 | Root_unresolved | Root_unresolved | 82.4 | 1.06e-16 | NR | MEA3247279.1 | 2026742 | g20879 | i0 | 52.7 | 1.96402877697842 | 91 | 37 | 96 | 3 | 9 | 275 | 144 | 230 | MEA3247279.1 SDR family oxidoreductase [Gemmatimonadota bacterium] | diamond | 546 | 82.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 32794301 | 32794301 | PRJNA492406_P_NODE_22740_length_270_cov_1.213198_g22441_i0 | PRJNA492406 | 22740 | 270 | 1.213198 | 3.2756346 | Gemmatimonadaceae bacterium | 2026741 | Bacteria | Bacteria | 63.9 | 1.8e-9 | NR | NUQ10938.1 | 2026741 | g22441 | i0 | 42.5 | 1.75555555555556 | 87 | 47 | 96.7 | 2 | 262 | 2 | 77 | 160 | NUQ10938.1 protein kinase [Gemmatimonadaceae bacterium] | diamond | 474 | 63.9 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonadaceae 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);;