contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1120060" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4087647 | 4087647 | PRJNA1120060_P_NODE_3225104_length_230_cov_3.312102_g3206997_i0 | PRJNA1120060 | 3225104 | 230 | 3.312102 | 7.6178346 | Candidatus Cloacimonadales bacterium | 3060593 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2621706016|emb|OY764078.1| | 3060593 | g3206997 | i0 | 100 | 0.130434782608696 | 30 | 0 | 13 | 0 | 197 | 226 | 617500 | 617529 | MAG: Candidatus Cloacimonadales bacterium isolate 02056a20-4ec6-4ab0-ab2d-03f0ed9894bb genome assembly, chromosome: 1 | blastn | 30 | 56.5 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadia | Candidatus Cloacimonadales | Candidatus Cloacimonadales bacterium | |||
| 5359242 | 5359242 | PRJNA1120060_P_NODE_2813485_length_246_cov_0.867052_g2795399_i0 | PRJNA1120060 | 2813485 | 246 | 0.867052 | 2.13294792 | Candidatus Cloacimonadales bacterium | 3060593 | Bacteria | Bacteria | 54.7 | 0.006 | NTclustered | gi|2621786041|emb|OY782499.1| | 3060593 | g2795399 | i0 | 100 | 0.117886178861789 | 29 | 0 | 12 | 0 | 181 | 209 | 1138543 | 1138515 | MAG: Candidatus Cloacimonadales bacterium isolate 75f626e2-485c-4b2b-9e06-a5cee39fa54d genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadia | Candidatus Cloacimonadales | Candidatus Cloacimonadales bacterium | |||
| 7888753 | 7888753 | PRJNA1120060_P_NODE_1291547_length_307_cov_3.277778_g1273600_i0 | PRJNA1120060 | 1291547 | 307 | 3.277778 | 10.06277846 | Candidatus Cloacimonadales bacterium | 3060593 | Bacteria | Bacteria | 52.8 | 0.029 | NTclustered | gi|2626245904|emb|OY829950.1| | 3060593 | g1273600 | i0 | 100 | 0.0912052117263844 | 28 | 0 | 9 | 0 | 58 | 85 | 839325 | 839352 | MAG: Candidatus Cloacimonadales bacterium isolate 55f7dba2-411d-4d06-9fab-9545568f0b98 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadia | Candidatus Cloacimonadales | Candidatus Cloacimonadales bacterium | |||
| 14285878 | 14285878 | PRJNA1120060_P_NODE_2892452_length_244_cov_0.906433_g2874363_i0 | PRJNA1120060 | 2892452 | 244 | 0.906433 | 2.21169652 | Candidatus Cloacimonadota bacterium | 2030808 | Bacteria | Bacteria | 52.8 | 0.022 | NTclustered | gi|2621703985|emb|OY762940.1| | 2030808 | g2874363 | i0 | 100 | 0.114754098360656 | 28 | 0 | 11 | 0 | 175 | 202 | 1196576 | 1196549 | MAG: Candidatus Cloacimonadota bacterium isolate fde15138-546a-48ac-9104-3b47d2f39405 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadota bacterium | |||||
| 21926897 | 21926897 | PRJNA1120060_P_NODE_2328318_length_260_cov_1.877005_g2310258_i0 | PRJNA1120060 | 2328318 | 260 | 1.877005 | 4.880213 | Candidatus Cloacimonadales bacterium | 3060593 | Bacteria | Bacteria | 58.4 | 5.09e-4 | NTclustered | gi|2621786041|emb|OY782499.1| | 3060593 | g2310258 | i0 | 97.059 | 0.130769230769231 | 34 | 1 | 13 | 0 | 129 | 162 | 2242490 | 2242523 | MAG: Candidatus Cloacimonadales bacterium isolate 75f626e2-485c-4b2b-9e06-a5cee39fa54d genome assembly, chromosome: 1 | blastn | 34 | 58.4 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Cloacimonadota | Candidatus Cloacimonadia | Candidatus Cloacimonadales | Candidatus Cloacimonadales bacterium | |||
| 24457538 | 24457538 | PRJNA1120060_P_NODE_1004280_length_312_cov_2.506276_g986351_i0 | PRJNA1120060 | 1004280 | 312 | 2.506276 | 7.81958112 | Candidatus Cloacimonadales bacterium | 3060593 | Bacteria | Bacteria | 56.5 | 0.002 | NTclustered | gi|2621786041|emb|OY782499.1| | 3060593 | g986351 | i0 | 100 | 0.0961538461538462 | 30 | 0 | 10 | 0 | 59 | 88 | 740078 | 740107 | MAG: Candidatus Cloacimonadales bacterium isolate 75f626e2-485c-4b2b-9e06-a5cee39fa54d genome assembly, chromosome: 1 | blastn | 30 | 56.5 | 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);;