contig_metadata
5 rows where bioproject = "PRJNA1098727" and tax_phylum = "Nitrospirota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 211098 | 211098 | PRJNA1098727_P_NODE_14441_length_165_cov_0.896552_g14200_i0 | PRJNA1098727 | 14441 | 165 | 0.896552 | 1.4793108 | Candidatus Nitrospira inopinata | 1715989 | Bacteria | Bacteria | 291 | 2.69e-74 | NTclustered | gi|952974062|emb|LN885086.1| | 1715989 | g14200 | i0 | 98.773 | 0.987878787878788 | 163 | 2 | 99 | 0 | 2 | 164 | 1555920 | 1555758 | Nitrospira sp. ENR4 genome assembly NiCh1, chromosome : 1 | blastn | 163 | 291 | 1 | Bacteria | Pseudomonadati | Nitrospirota | Nitrospiria | Nitrospirales | Nitrospiraceae | Nitrospira | Candidatus Nitrospira inopinata | ||
| 10414497 | 10414497 | PRJNA1098727_P_NODE_15269_length_163_cov_0.912281_g15028_i0 | PRJNA1098727 | 15269 | 163 | 0.912281 | 1.48701803 | Nitrospira sp. | 70125 | Bacteria | Bacteria | 231 | 1.63e-56 | NTclustered | gi|2290906964|gb|CP058931.1| | 70125 | g15028 | i0 | 92.547 | 1.97546012269939 | 161 | 12 | 99 | 0 | 2 | 162 | 2105690 | 2105850 | MAG: Nitrospira sp. isolate DJ chromosome | blastn | 322 | 231 | 1 | Bacteria | Pseudomonadati | Nitrospirota | Nitrospiria | Nitrospirales | Nitrospiraceae | Nitrospira | Nitrospira sp. | ||
| 19336872 | 19336872 | PRJNA1098727_P_NODE_12876_length_169_cov_0.866667_g12635_i0 | PRJNA1098727 | 12876 | 169 | 0.866667 | 1.46466723 | Nitrospira defluvii | 330214 | Bacteria | Bacteria | 176 | 8.03e-40 | NTclustered | gi|300603458|emb|FP929003.1| | 330214 | g12635 | i0 | 87.097 | 0.917159763313609 | 155 | 20 | 92 | 0 | 7 | 161 | 3996295 | 3996141 | Candidatus Nitrospira defluvii chromosome, complete genome | blastn | 155 | 176 | 1 | Bacteria | Pseudomonadati | Nitrospirota | Nitrospiria | Nitrospirales | Nitrospiraceae | Nitrospira | Nitrospira defluvii | ||
| 29057259 | 29057259 | PRJNA1098727_P_NODE_13708_length_167_cov_0.881356_g13467_i0 | PRJNA1098727 | 13708 | 167 | 0.881356 | 1.47186452 | Nitrospira sp. CR1.2 | 2656757 | Bacteria | Bacteria | 117 | 9.28e-29 | NR | MBA5875532.1 | 2656757 | g13467 | i0 | 98.2 | 4.94011976047904 | 55 | 1 | 98.8 | 0 | 167 | 3 | 268 | 322 | MBA5875532.1 hypothetical protein [Nitrospira sp. CR1.2] | diamond | 825 | 117 | 1 | Bacteria | Pseudomonadati | Nitrospirota | Nitrospiria | Nitrospirales | Nitrospiraceae | Nitrospira | Nitrospira sp. CR1.2 | ||
| 29499109 | 29499109 | PRJNA1098727_P_NODE_15770_length_162_cov_0.920354_g15529_i0 | PRJNA1098727 | 15770 | 162 | 0.920354 | 1.49097348 | Nitrospira sp. | 70125 | Bacteria | Bacteria | 65.9 | 8.64e-11 | NR | TKS63325.1 | 70125 | g15529 | i0 | 60.4 | 0.981481481481482 | 53 | 21 | 98.1 | 0 | 4 | 162 | 219 | 271 | TKS63325.1 MAG: hypothetical protein EWM73_01594 [Nitrospira sp.] | diamond | 159 | 65.9 | 1 | Bacteria | Pseudomonadati | Nitrospirota | Nitrospiria | Nitrospirales | Nitrospiraceae | Nitrospira | Nitrospira sp. |
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);;