contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA459724" and tax_phylum = "Chlamydiota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5546721 | 5546721 | PRJNA459724_P_NODE_1385_length_493_cov_2.254310_g1055_i0 | PRJNA459724 | 1385 | 493 | 2.25431 | 11.1137483 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 256 | 2.09e-80 | NR | MFI0436073.1 | 2052176 | g1055 | i0 | 84.1 | 0.955375253549696 | 157 | 25 | 95.5 | 0 | 491 | 21 | 328 | 484 | MFI0436073.1 replicative DNA helicase [Parachlamydiaceae bacterium] | diamond | 471 | 256 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 26696192 | 26696192 | PRJNA459724_P_NODE_301_length_1018_cov_4.123357_g179_i0 | PRJNA459724 | 301 | 1018 | 4.123357 | 41.97577426 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 400 | 1.35e-137 | NR | MFI0436135.1 | 2052176 | g179 | i0 | 97.5 | 0.595284872298625 | 202 | 2 | 59.5 | 1 | 1018 | 413 | 47 | 245 | MFI0436135.1 terminase large subunit [Parachlamydiaceae bacterium] | diamond | 606 | 400 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 27234203 | 27234203 | PRJNA459724_P_NODE_303_length_1016_cov_4.159068_g180_i0 | PRJNA459724 | 303 | 1016 | 4.159068 | 42.25613088 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 399 | 5.299999999999998e-137 | NR | MFI0436135.1 | 2052176 | g180 | i0 | 97.5 | 0.593503937007874 | 201 | 2 | 59.4 | 1 | 2 | 604 | 48 | 245 | MFI0436135.1 terminase large subunit [Parachlamydiaceae bacterium] | diamond | 603 | 399 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 27518561 | 27518561 | PRJNA459724_P_NODE_223_length_1184_cov_3.614719_g121_i0 | PRJNA459724 | 223 | 1184 | 3.614719 | 42.79827296 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 399 | 2.09e-136 | NR | MFI0436135.1 | 2052176 | g121 | i0 | 97.5 | 0.511824324324324 | 202 | 2 | 51.2 | 1 | 1184 | 579 | 47 | 245 | MFI0436135.1 terminase large subunit [Parachlamydiaceae bacterium] | diamond | 606 | 399 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 27960528 | 27960528 | PRJNA459724_P_NODE_3105_length_268_cov_2.882845_g2714_i0 | PRJNA459724 | 3105 | 268 | 2.882845 | 7.7260246 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 140 | 4.15e-37 | NR | MFI0436073.1 | 2052176 | g2714 | i0 | 78.7 | 0.996268656716418 | 89 | 19 | 99.6 | 0 | 1 | 267 | 112 | 200 | MFI0436073.1 replicative DNA helicase [Parachlamydiaceae bacterium] | diamond | 267 | 140 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 28529066 | 28529066 | PRJNA459724_P_NODE_207_length_1211_cov_2.633672_g110_i0 | PRJNA459724 | 207 | 1211 | 2.633672 | 31.89376792 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 527 | 1.1799999999999996e-180 | NR | MFI0436039.1 | 2052176 | g110 | i0 | 64.4 | 0.995871180842279 | 402 | 140 | 99.3 | 2 | 2 | 1204 | 8 | 407 | MFI0436039.1 BT4734/BF3469 family protein [Parachlamydiaceae bacterium] | diamond | 1206 | 527 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 28592137 | 28592137 | PRJNA459724_S_NODE_2087_length_167_cov_1.189394_g2084_i0 | PRJNA459724 | 2087 | 167 | 1.189394 | 1.98628798 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 104 | 1.73e-25 | NR | MFV0339066.1 | 2052176 | g2084 | i0 | 92.7 | 0.988023952095808 | 55 | 4 | 98.8 | 0 | 1 | 165 | 26 | 80 | MFV0339066.1 TIGR01777 family oxidoreductase [Parachlamydiaceae bacterium] | diamond | 165 | 104 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 31181676 | 31181676 | PRJNA459724_P_NODE_1555_length_458_cov_2.806527_g1208_i0 | PRJNA459724 | 1555 | 458 | 2.806527 | 12.85389366 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 114 | 5.44e-28 | NR | MFI0435901.1 | 2052176 | g1208 | i0 | 82.8 | 0.419213973799127 | 64 | 11 | 41.9 | 0 | 457 | 266 | 207 | 270 | MFI0435901.1 hypothetical protein [Parachlamydiaceae bacterium] | diamond | 192 | 114 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 31972731 | 31972731 | PRJNA459724_P_NODE_1798_length_413_cov_2.632812_g1426_i0 | PRJNA459724 | 1798 | 413 | 2.632812 | 10.87351356 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 118 | 8.69e-28 | NR | MFI0436039.1 | 2052176 | g1426 | i0 | 60 | 0.653753026634383 | 90 | 34 | 65.4 | 1 | 411 | 142 | 424 | 511 | MFI0436039.1 BT4734/BF3469 family protein [Parachlamydiaceae bacterium] | diamond | 270 | 118 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 31972733 | 31972733 | PRJNA459724_P_NODE_3418_length_246_cov_3.087558_g3026_i0 | PRJNA459724 | 3418 | 246 | 3.087558 | 7.59539268 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 169 | 1.12e-50 | NR | MFI0436136.1 | 2052176 | g3026 | i0 | 100 | 1.97560975609756 | 81 | 0 | 98.8 | 0 | 245 | 3 | 155 | 235 | MFI0436136.1 phage portal protein [Parachlamydiaceae bacterium] | diamond | 486 | 169 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 32415851 | 32415851 | PRJNA459724_P_NODE_1159_length_546_cov_2.682785_g859_i0 | PRJNA459724 | 1159 | 546 | 2.682785 | 14.6480061 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 115 | 1.1e-27 | NR | MFI0436074.1 | 2052176 | g859 | i0 | 53.5 | 0.697802197802198 | 127 | 52 | 67 | 4 | 421 | 56 | 149 | 273 | MFI0436074.1 DUF6291 domain-containing protein [Parachlamydiaceae bacterium] | diamond | 381 | 115 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae 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);;