contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA841653" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2506391 | 2506391 | PRJNA841653_P_NODE_47782_length_249_cov_0.875000_g47108_i0 | PRJNA841653 | 47782 | 249 | 0.875 | 2.17875 | Gemmatirosa | 1706036 | Bacteria | Bacteria | 252 | 2.07e-62 | NTclustered | gi|2874253995|emb|OY970320.1| | 246130 | g47108 | i0 | 88.517 | 73.9277108433735 | 209 | 22 | 84 | 2 | 30 | 237 | 231424 | 231631 | MAG: uncultured Gemmatimonadaceae bacterium isolate MFD00031.bin.c.2 genome assembly, chromosome: 1 | blastn | 18408 | 252 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | uncultured Gemmatimonadaceae bacterium | ||
| 3782763 | 3782763 | PRJNA841653_P_NODE_49763_length_248_cov_0.828571_g49089_i0 | PRJNA841653 | 49763 | 248 | 0.828571 | 2.05485608 | Gemmatirosa | 1706036 | Bacteria | Bacteria | 219 | 2.0899999999999994e-52 | NTclustered | gi|2874253789|emb|OY969773.1| | 412054 | g49089 | i0 | 83.265 | 71.1209677419355 | 245 | 33 | 97 | 8 | 2 | 242 | 421109 | 420869 | MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1 | blastn | 17638 | 219 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 11034571 | 11034571 | PRJNA841653_P_NODE_53289_length_246_cov_0.890173_g52615_i0 | PRJNA841653 | 53289 | 246 | 0.890173 | 2.18982558 | uncultured Gemmatimonadales bacterium | 412054 | Bacteria | Bacteria | 91.6 | 4.71e-14 | NTclustered | gi|2874254107|emb|OY970192.1| | 412054 | g52615 | i0 | 90 | 74.3333333333333 | 70 | 7 | 28 | 0 | 176 | 245 | 1593291 | 1593222 | MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1 | blastn | 18286 | 91.6 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | uncultured Gemmatimonadales bacterium | |||
| 16133141 | 16133141 | PRJNA841653_P_NODE_31333_length_291_cov_1.408257_g30659_i0 | PRJNA841653 | 31333 | 291 | 1.408257 | 4.09802787 | Gemmatimonas phototrophica | 1379270 | Bacteria | Bacteria | 442 | 1.3699999999999994e-119 | NTclustered | gi|1015602748|gb|CP011454.1| | 1379270 | g30659 | i0 | 94.464 | 69.6701030927835 | 289 | 12 | 99 | 4 | 1 | 287 | 2075022 | 2074736 | Gemmatimonas phototrophica strain AP64, complete genome | blastn | 20274 | 442 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatimonas | Gemmatimonas phototrophica | |
| 21232556 | 21232556 | PRJNA841653_P_NODE_34017_length_281_cov_1.350962_g33343_i0 | PRJNA841653 | 34017 | 281 | 1.350962 | 3.79620322 | Gaopeijia maritima | 3119007 | Bacteria | Bacteria | 150 | 8.929999999999999e-32 | NTclustered | gi|2716997671|gb|CP144380.1| | 3119007 | g33343 | i0 | 90.517 | 4.5729537366548 | 116 | 7 | 41 | 2 | 17 | 130 | 725216 | 725329 | Gaopeijia maritima strain DH-78 chromosome, complete genome | blastn | 1285 | 150 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Longimicrobiia | Gaopeijiales | Gaopeijiaceae | Gaopeijia | Gaopeijia maritima | |
| 23783256 | 23783256 | PRJNA841653_P_NODE_60479_length_242_cov_0.911243_g59805_i0 | PRJNA841653 | 60479 | 242 | 0.911243 | 2.20520806 | Gemmatirosa kalamazoonensis | 861299 | Bacteria | Bacteria | 137 | 5.85e-28 | NTclustered | gi|575456455|gb|CP007128.1| | 861299 | g59805 | i0 | 91.919 | 1.67355371900826 | 99 | 7 | 40 | 1 | 4 | 101 | 2192805 | 2192707 | Gemmatirosa kalamazoonesis strain KBS708, complete genome | blastn | 405 | 137 | 1 | Bacteria | FCB group | Pseudomonadati | Gemmatimonadota | Gemmatimonadia | Gemmatimonadales | Gemmatimonadaceae | Gemmatirosa | Gemmatirosa kalamazoonensis |
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);;