contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Cloacimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2850683 | 2850683 | PRJNA1148190_P_NODE_753263_length_242_cov_1.810651_g742090_i0 | PRJNA1148190 | 753263 | 242 | 1.810651 | 4.38177542 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 78.7 | 3.6e-10 | NTclustered | gi|2621784603|emb|OY781061.1| | 2030808 | g742090 | i0 | 97.778 | 4.64462809917355 | 45 | 1 | 19 | 0 | 187 | 231 | 1149182 | 1149226 | MAG: Candidatus Cloacimonadota bacterium isolate d61283ab-f090-4083-af93-b05ca963783c genome assembly, chromosome: 1 | blastn | 1124 | 78.7 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota bacterium | |||||
| 11769325 | 11769325 | PRJNA1148190_P_NODE_11830_length_2857_cov_3.277299_g6195_i0 | PRJNA1148190 | 11830 | 2857 | 3.277299 | 93.63243243 | Candidatus Cloacimonadales bacterium | 3060593 | Bacteria | Bacteria | 608 | 1.3999999999999996e-168 | NTclustered | gi|2621786373|emb|OY782831.1| | 3060593 | g6195 | i0 | 80.909 | 0.818690934546727 | 770 | 147 | 27 | 0 | 2088 | 2857 | 2019377 | 2018608 | MAG: Candidatus Cloacimonadales bacterium isolate 04309a76-b7cc-48c3-85ee-0a4392eb1095 genome assembly, chromosome: 1 | blastn | 2339 | 608 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadia | Candidatus Cloacimonadales | Candidatus Cloacimonadales bacterium | |||
| 14325870 | 14325870 | PRJNA1148190_P_NODE_526952_length_261_cov_1.638298_g515779_i0 | PRJNA1148190 | 526952 | 261 | 1.638298 | 4.27595778 | Candidatus Cloacimonadales bacterium | 3060593 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2621706016|emb|OY764078.1| | 3060593 | g515779 | i0 | 92.308 | 0.149425287356322 | 39 | 3 | 15 | 0 | 101 | 139 | 2411893 | 2411855 | MAG: Candidatus Cloacimonadales bacterium isolate 02056a20-4ec6-4ab0-ab2d-03f0ed9894bb genome assembly, chromosome: 1 | blastn | 39 | 56.5 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadia | Candidatus Cloacimonadales | Candidatus Cloacimonadales bacterium | |||
| 15596411 | 15596411 | PRJNA1148190_P_NODE_291533_length_323_cov_1.848000_g280360_i0 | PRJNA1148190 | 291533 | 323 | 1.848 | 5.96904 | Candidatus Cloacimonadales bacterium | 3060593 | Bacteria | Bacteria | 52.8 | 0.03 | NTclustered | gi|2626245904|emb|OY829950.1| | 3060593 | g280360 | i0 | 96.774 | 0.0959752321981424 | 31 | 1 | 10 | 0 | 215 | 245 | 1451019 | 1451049 | MAG: Candidatus Cloacimonadales bacterium isolate 55f7dba2-411d-4d06-9fab-9545568f0b98 genome assembly, chromosome: 1 | blastn | 31 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadia | Candidatus Cloacimonadales | Candidatus Cloacimonadales 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);;