contig_metadata
9 rows where bioproject = "PRJNA1046144" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2722883 | 2722883 | PRJNA1046144_P_NODE_4523_length_736_cov_3.223388_g4257_i0 | PRJNA1046144 | 4523 | 736 | 3.223388 | 23.72413568 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 351 | 4.429999999999999e-110 | NR | MEE8596102.1 | 2026742 | g4257 | i0 | 80.6 | 0.966032608695652 | 237 | 46 | 96.6 | 0 | 2 | 712 | 174 | 410 | MEE8596102.1 amino acid adenylation domain-containing protein [Gemmatimonadota bacterium] | diamond | 711 | 351 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 2723492 | 2723492 | PRJNA1046144_P_NODE_9583_length_511_cov_1.228507_g9290_i0 | PRJNA1046144 | 9583 | 511 | 1.228507 | 6.27767077 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 348 | 3.189999999999999e-110 | NR | MEE8596102.1 | 2026742 | g9290 | i0 | 100 | 0.998043052837573 | 170 | 0 | 99.8 | 0 | 510 | 1 | 420 | 589 | MEE8596102.1 amino acid adenylation domain-containing protein [Gemmatimonadota bacterium] | diamond | 510 | 348 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 8662051 | 8662051 | PRJNA1046144_P_NODE_11287_length_473_cov_3.101485_g10992_i0 | PRJNA1046144 | 11287 | 473 | 3.101485 | 14.67002405 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 251 | 2.8000000000000003e-74 | NR | MEE8596102.1 | 2026742 | g10992 | i0 | 100 | 0.818181818181818 | 129 | 0 | 81.8 | 0 | 388 | 2 | 1 | 129 | MEE8596102.1 amino acid adenylation domain-containing protein [Gemmatimonadota bacterium] | diamond | 387 | 251 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 9100516 | 9100516 | PRJNA1046144_P_NODE_7308_length_584_cov_2.858252_g7017_i0 | PRJNA1046144 | 7308 | 584 | 2.858252 | 16.69219168 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 379 | 2.4699999999999996e-121 | NR | MEE8596102.1 | 2026742 | g7017 | i0 | 99 | 0.996575342465753 | 194 | 2 | 99.7 | 0 | 583 | 2 | 867 | 1060 | MEE8596102.1 amino acid adenylation domain-containing protein [Gemmatimonadota bacterium] | diamond | 582 | 379 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 14201228 | 14201228 | PRJNA1046144_P_NODE_51772_length_244_cov_1.268571_g51477_i0 | PRJNA1046144 | 51772 | 244 | 1.268571 | 3.09531324 | Longimicrobium sp. | 2029185 | Bacteria | Bacteria | 105 | 4.38e-24 | NR | HEV3049408.1 | 2029185 | g51477 | i0 | 60.5 | 0.995901639344262 | 81 | 32 | 99.6 | 0 | 243 | 1 | 708 | 788 | HEV3049408.1 amino acid adenylation domain-containing protein [Longimicrobium sp.] | diamond | 243 | 105 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. | |
| 16748761 | 16748761 | PRJNA1046144_P_NODE_14314_length_424_cov_2.216901_g14019_i0 | PRJNA1046144 | 14314 | 424 | 2.216901 | 9.39966024 | Gemmatimonadota bacterium | 2026742 | Bacteria | Bacteria | 155 | 7.9e-41 | NR | MEW5930501.1 | 2026742 | g14019 | i0 | 63.9 | 1.95990566037736 | 133 | 47 | 94.1 | 1 | 2 | 400 | 1538 | 1669 | MEW5930501.1 amino acid adenylation domain-containing protein [Gemmatimonadota bacterium] | diamond | 831 | 155 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadota bacterium | |||||
| 28709195 | 28709195 | PRJNA1046144_P_NODE_41687_length_267_cov_1.454545_g41392_i0 | PRJNA1046144 | 41687 | 267 | 1.454545 | 3.88363515 | Longimicrobiaceae bacterium | 3047548 | Bacteria | Bacteria | 89.4 | 1.08e-19 | NR | HEX7241433.1 | 3047548 | g41392 | i0 | 52.4 | 0.921348314606742 | 82 | 39 | 92.1 | 0 | 8 | 253 | 88 | 169 | HEX7241433.1 class I SAM-dependent methyltransferase [Longimicrobiaceae bacterium] | diamond | 246 | 89.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobiaceae bacterium | ||
| 28961864 | 28961864 | PRJNA1046144_P_NODE_43448_length_263_cov_1.113402_g43153_i0 | PRJNA1046144 | 43448 | 263 | 1.113402 | 2.92824726 | Longimicrobiaceae bacterium | 3047548 | Bacteria | Bacteria | 79.3 | 6.43e-15 | NR | HEX7243455.1 | 3047548 | g43153 | i0 | 55.6 | 10.1863117870722 | 90 | 36 | 98.1 | 1 | 1 | 258 | 488 | 577 | HEX7243455.1 amino acid adenylation domain-containing protein [Longimicrobiaceae bacterium] | diamond | 2679 | 79.3 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobiaceae bacterium | ||
| 29206388 | 29206388 | PRJNA1046144_P_NODE_50349_length_247_cov_1.393258_g50054_i0 | PRJNA1046144 | 50349 | 247 | 1.393258 | 3.44134726 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 87.4 | 7.29e-18 | NR | HEX8242041.1 | 2029185 | g50054 | i0 | 54.3 | 5.8663967611336 | 81 | 37 | 98.4 | 0 | 3 | 245 | 823 | 903 | HEX8242041.1 amino acid adenylation domain-containing protein [Longimicrobium sp.] | diamond | 1449 | 87.4 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Longimicrobiales | Longimicrobiaceae | Longimicrobium | Longimicrobium sp. |
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);;