contig_metadata
20 rows where bioproject = "PRJNA488043", tax_clade = "PVC group" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3000571 | 3000571 | PRJNA488043_P_NODE_13703_length_248_cov_4.168950_g11461_i0 | PRJNA488043 | 13703 | 248 | 4.16895 | 10.338996 | uncultured Parachlamydiaceae bacterium | 464461 | Bacteria | Bacteria | 207 | 4.52e-49 | NTclustered | gi|2874253811|emb|OY969795.1| | 464461 | g11461 | i0 | 82.143 | 195.665322580645 | 252 | 35 | 99 | 10 | 1 | 246 | 657284 | 657037 | MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1 | blastn | 48525 | 207 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | uncultured Parachlamydiaceae bacterium | ||
| 4926076 | 4926076 | PRJNA488043_P_NODE_3064_length_843_cov_5.181818_g869_i1 | PRJNA488043 | 3064 | 843 | 5.181818 | 43.68272574 | Candidatus Protochlamydia | 282132 | Bacteria | Bacteria | 774 | 0 | NTclustered | gi|1691252667|emb|BX908798.2| | 264201 | g869 | i1 | 83.506 | 154.143534994069 | 867 | 105 | 99 | 25 | 2 | 843 | 2153764 | 2154617 | Candidatus Protochlamydia amoebophila UWE25 complete genome | blastn | 129943 | 774 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia amoebophila | |
| 10653593 | 10653593 | PRJNA488043_P_NODE_21849_length_155_cov_2.960317_g19607_i0 | PRJNA488043 | 21849 | 155 | 2.960317 | 4.58849135 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 237 | 3.2800000000000004e-58 | NTclustered | gi|971146634|emb|LN879502.1| | 389348 | g19607 | i0 | 94.268 | 184.122580645161 | 157 | 5 | 100 | 2 | 1 | 155 | 1251568 | 1251414 | Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK | blastn | 28539 | 237 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 12576942 | 12576942 | PRJNA488043_P_NODE_3090_length_838_cov_2.349815_g1618_i0 | PRJNA488043 | 3090 | 838 | 2.349815 | 19.6914497 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 170 | 1.6599999999999998e-45 | NR | MFI0436073.1 | 2052176 | g1618 | i0 | 88.1 | 0.361575178997613 | 101 | 12 | 36.2 | 0 | 833 | 531 | 215 | 315 | MFI0436073.1 replicative DNA helicase [Parachlamydiaceae bacterium] | diamond | 303 | 170 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 15752626 | 15752626 | PRJNA488043_P_NODE_3973_length_704_cov_3.973333_g2263_i0 | PRJNA488043 | 3973 | 704 | 3.973333 | 27.97226432 | Candidatus Protochlamydia naegleriophila | 389348 | Bacteria | Bacteria | 976 | 0 | NTclustered | gi|971146634|emb|LN879502.1| | 389348 | g2263 | i0 | 91.667 | 181.075284090909 | 708 | 53 | 100 | 6 | 1 | 704 | 1250918 | 1250213 | Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK | blastn | 127477 | 976 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia naegleriophila | |
| 16400574 | 16400574 | PRJNA488043_P_NODE_6893_length_472_cov_6.372460_g4788_i0 | PRJNA488043 | 6893 | 472 | 6.37246 | 30.0780112 | Candidatus Protochlamydia | 282132 | Bacteria | Bacteria | 549 | 1.3399999999999996e-151 | NTclustered | gi|1691252667|emb|BX908798.2| | 264201 | g4788 | i0 | 88.387 | 83.6398305084746 | 465 | 43 | 97 | 9 | 1 | 460 | 1251096 | 1251554 | Candidatus Protochlamydia amoebophila UWE25 complete genome | blastn | 39478 | 549 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Candidatus Protochlamydia | Candidatus Protochlamydia amoebophila | |
| 17675630 | 17675630 | PRJNA488043_P_NODE_3174_length_822_cov_2.387137_g1671_i0 | PRJNA488043 | 3174 | 822 | 2.387137 | 19.62226614 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 286 | 2.74e-90 | NR | MFI0436073.1 | 2052176 | g1671 | i0 | 61.6 | 0.989051094890511 | 271 | 97 | 96.7 | 2 | 6 | 800 | 215 | 484 | MFI0436073.1 replicative DNA helicase [Parachlamydiaceae bacterium] | diamond | 813 | 286 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 18949337 | 18949337 | PRJNA488043_P_NODE_1195_length_1551_cov_2.419842_g454_i0 | PRJNA488043 | 1195 | 1551 | 2.419842 | 37.53174942 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 283 | 6.510000000000001e-86 | NR | MFI0436073.1 | 2052176 | g454 | i0 | 61.3 | 0.524177949709865 | 271 | 98 | 51.3 | 2 | 1546 | 752 | 215 | 484 | MFI0436073.1 replicative DNA helicase [Parachlamydiaceae bacterium] | diamond | 813 | 283 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 27518730 | 27518730 | PRJNA488043_P_NODE_603_length_3079_cov_3.211803_g202_i0 | PRJNA488043 | 603 | 3079 | 3.211803 | 98.89141437 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 149 | 6.399999999999999e-36 | NR | MFI0435901.1 | 2052176 | g202 | i0 | 80.7 | 0.0857421240662553 | 88 | 17 | 8.6 | 0 | 647 | 384 | 183 | 270 | MFI0435901.1 hypothetical protein [Parachlamydiaceae bacterium] | diamond | 264 | 149 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 27803022 | 27803022 | PRJNA488043_P_NODE_1984_length_1107_cov_3.030612_g897_i0 | PRJNA488043 | 1984 | 1107 | 3.030612 | 33.54887484 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 251 | 2.25e-75 | NR | MFI0436073.1 | 2052176 | g897 | i0 | 76.4 | 0.447154471544715 | 165 | 39 | 44.7 | 0 | 613 | 1107 | 47 | 211 | MFI0436073.1 replicative DNA helicase [Parachlamydiaceae bacterium] | diamond | 495 | 251 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 27897462 | 27897462 | PRJNA488043_P_NODE_9965_length_341_cov_1.951923_g7725_i0 | PRJNA488043 | 9965 | 341 | 1.951923 | 6.65605743 | Parachlamydiales bacterium | 2052178 | Bacteria | Bacteria | 80.9 | 2.91e-15 | NR | MFA6916993.1 | 2052178 | g7725 | i0 | 61.6 | 1.9266862170088 | 73 | 27 | 64.2 | 1 | 332 | 114 | 287 | 358 | MFA6916993.1 hypothetical protein [Parachlamydiales bacterium] | diamond | 657 | 80.9 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiales bacterium | |||
| 28023997 | 28023997 | PRJNA488043_P_NODE_6265_length_510_cov_3.162162_g4227_i0 | PRJNA488043 | 6265 | 510 | 3.162162 | 16.1270262 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 155 | 1.38e-40 | NR | MFI0436039.1 | 2052176 | g4227 | i0 | 67 | 0.605882352941176 | 103 | 34 | 60.6 | 0 | 201 | 509 | 468 | 570 | MFI0436039.1 BT4734/BF3469 family protein [Parachlamydiaceae bacterium] | diamond | 309 | 155 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 28560775 | 28560775 | PRJNA488043_P_NODE_11787_length_288_cov_1.679537_g9546_i0 | PRJNA488043 | 11787 | 288 | 1.679537 | 4.83706656 | Chlamydiae bacterium CG1 | 2081524 | Bacteria | Bacteria | 103 | 2.0199999999999994e-23 | NR | PIS01510.1 | 1973935 | g9546 | i0 | 56.4 | 1.05208333333333 | 101 | 37 | 97.9 | 3 | 282 | 1 | 530 | 630 | PIS01510.1 MAG: hypothetical protein COT84_02005 [Chlamydiae bacterium CG10_big_fil_rev_8_21_14_0_10_35_9] | diamond | 303 | 103 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiae bacterium CG10_big_fil_rev_8_21_14_0_10_35_9 | |||||
| 28718590 | 28718590 | PRJNA488043_P_NODE_4467_length_647_cov_8.441748_g2654_i0 | PRJNA488043 | 4467 | 647 | 8.441748 | 54.61810956 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 353 | 4.109999999999998e-121 | NR | MFI0436135.1 | 2052176 | g2654 | i0 | 100 | 0.792890262751159 | 171 | 0 | 79.3 | 0 | 2 | 514 | 75 | 245 | MFI0436135.1 terminase large subunit [Parachlamydiaceae bacterium] | diamond | 513 | 353 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 28939671 | 28939671 | PRJNA488043_P_NODE_608_length_3047_cov_3.252154_g202_i1 | PRJNA488043 | 608 | 3047 | 3.252154 | 99.09313238 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 149 | 6.32e-36 | NR | MFI0435901.1 | 2052176 | g202 | i1 | 80.7 | 0.0866425992779783 | 88 | 17 | 8.7 | 0 | 2449 | 2712 | 183 | 270 | MFI0435901.1 hypothetical protein [Parachlamydiaceae bacterium] | diamond | 264 | 149 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 29539335 | 29539335 | PRJNA488043_P_NODE_610_length_3031_cov_3.242838_g202_i2 | PRJNA488043 | 610 | 3031 | 3.242838 | 98.29041978 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 153 | 2.1399999999999996e-37 | NR | MFI0435901.1 | 2052176 | g202 | i2 | 83 | 0.0870999670075882 | 88 | 15 | 8.7 | 0 | 2433 | 2696 | 183 | 270 | MFI0435901.1 hypothetical protein [Parachlamydiaceae bacterium] | diamond | 264 | 153 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 30044622 | 30044622 | PRJNA488043_P_NODE_4911_length_605_cov_3.350694_g897_i1 | PRJNA488043 | 4911 | 605 | 3.350694 | 20.2716987 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 115 | 2.07e-27 | NR | MFI0436074.1 | 2052176 | g897 | i1 | 53.5 | 0.629752066115702 | 127 | 52 | 60.5 | 4 | 126 | 491 | 149 | 273 | MFI0436074.1 DUF6291 domain-containing protein [Parachlamydiaceae bacterium] | diamond | 381 | 115 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 30392749 | 30392749 | PRJNA488043_P_NODE_6793_length_478_cov_3.195991_g4699_i0 | PRJNA488043 | 6793 | 478 | 3.195991 | 15.27683698 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 155 | 9.53e-41 | NR | MFI0436039.1 | 2052176 | g4699 | i0 | 67 | 0.646443514644351 | 103 | 34 | 64.6 | 0 | 310 | 2 | 468 | 570 | MFI0436039.1 BT4734/BF3469 family protein [Parachlamydiaceae bacterium] | diamond | 309 | 155 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydiaceae bacterium | ||
| 30487169 | 30487169 | PRJNA488043_P_NODE_21313_length_160_cov_1.656489_g19071_i0 | PRJNA488043 | 21313 | 160 | 1.656489 | 2.6503824 | Parachlamydia sp. | 2052048 | Bacteria | Bacteria | 95.5 | 3.47e-23 | NR | MCE2983410.1 | 2052048 | g19071 | i0 | 84.3 | 0.95625 | 51 | 8 | 95.6 | 0 | 157 | 5 | 102 | 152 | MCE2983410.1 hypothetical protein [Parachlamydia sp.] | diamond | 153 | 95.5 | 1 | Bacteria | PVC group | Pseudomonadati | Chlamydiota | Chlamydiia | Parachlamydiales | Parachlamydiaceae | Parachlamydia | Parachlamydia sp. | |
| 32888765 | 32888765 | PRJNA488043_P_NODE_1040_length_1742_cov_4.063631_g368_i0 | PRJNA488043 | 1040 | 1742 | 4.063631 | 70.78845202 | Parachlamydiaceae bacterium | 2052176 | Bacteria | Bacteria | 519 | 1.15e-174 | NR | MFI0436039.1 | 2052176 | g368 | i0 | 64.7 | 0.687141216991963 | 399 | 138 | 68.5 | 2 | 1196 | 3 | 1 | 397 | MFI0436039.1 BT4734/BF3469 family protein [Parachlamydiaceae bacterium] | diamond | 1197 | 519 | 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);;