contig_metadata
7 rows where bioproject = "PRJNA404067", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28906843 | 28906843 | PRJNA404067_P_NODE_44728_length_169_cov_4.148148_g44341_i0 | PRJNA404067 | 44728 | 169 | 4.148148 | 7.01037012 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 79.3 | 2.2e-17 | NR | MBS1702077.1 | 2033014 | g44341 | i0 | 66.1 | 2.98224852071006 | 56 | 19 | 99.4 | 0 | 168 | 1 | 36 | 91 | MBS1702077.1 winged helix-turn-helix transcriptional regulator [Armatimonadota bacterium] | diamond | 504 | 79.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29002213 | 29002213 | PRJNA404067_P_NODE_26388_length_219_cov_1.620253_g26001_i0 | PRJNA404067 | 26388 | 219 | 1.620253 | 3.54835407 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 69.3 | 3.03e-13 | NR | MBS1724766.1 | 2033014 | g26001 | i0 | 68.1 | 1.26027397260274 | 47 | 15 | 64.4 | 0 | 142 | 2 | 1 | 47 | MBS1724766.1 MmcQ/YjbR family DNA-binding protein [Armatimonadota bacterium] | diamond | 276 | 69.3 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29159845 | 29159845 | PRJNA404067_P_NODE_34449_length_205_cov_1.340278_g34062_i0 | PRJNA404067 | 34449 | 205 | 1.340278 | 2.7475699 | Armatimonadota bacterium | 2033014 | Bacteria | Bacteria | 72 | 2.45e-13 | NR | MCC2667766.1 | 2033014 | g34062 | i0 | 70.2 | 0.68780487804878 | 47 | 14 | 68.8 | 0 | 204 | 64 | 171 | 217 | MCC2667766.1 iron (metal) dependent repressor, DtxR family [Armatimonadota bacterium] | diamond | 141 | 72 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 29159848 | 29159848 | PRJNA404067_P_NODE_37369_length_202_cov_1.326241_g36982_i0 | PRJNA404067 | 37369 | 202 | 1.326241 | 2.67900682 | Fimbriimonadaceae bacterium | 2682144 | Bacteria | Bacteria | 52.4 | 8.25e-6 | NR | MDX2064501.1 | 2682144 | g36982 | i0 | 53.3 | 4.96039603960396 | 60 | 21 | 89.1 | 2 | 21 | 200 | 6 | 58 | MDX2064501.1 glucoamylase family protein [Fimbriimonadaceae bacterium] | diamond | 1002 | 52.4 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonadaceae bacterium | |||
| 30155053 | 30155053 | PRJNA404067_P_NODE_24852_length_223_cov_1.820988_g24465_i0 | PRJNA404067 | 24852 | 223 | 1.820988 | 4.06080324 | Bacteria | 2 | Bacteria | Bacteria | 89 | 7.25e-19 | NR | KAA0232136.1 | 2033014 | g24465 | i0 | 57.5 | 4.82959641255605 | 73 | 31 | 98.2 | 0 | 222 | 4 | 196 | 268 | KAA0232136.1 MAG: penicillin-binding protein 2, partial [Armatimonadota bacterium] | diamond | 1077 | 89 | 1 | Bacteria | Bacillati | Armatimonadota | Armatimonadota bacterium | ||||||
| 31180937 | 31180937 | PRJNA404067_P_NODE_23975_length_225_cov_4.170732_g23588_i0 | PRJNA404067 | 23975 | 225 | 4.170732 | 9.384147 | Fimbriimonas ginsengisoli | 1005039 | Bacteria | Bacteria | 69.3 | 1.84e-12 | NR | MBI1756261.1 | 1005039 | g23588 | i0 | 45.8 | 0.786666666666667 | 59 | 32 | 78.7 | 0 | 46 | 222 | 30 | 88 | MBI1756261.1 sigma-70 family RNA polymerase sigma factor [Fimbriimonas ginsengisoli] | diamond | 177 | 69.3 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli | ||
| 31371243 | 31371243 | PRJNA404067_P_NODE_44916_length_168_cov_4.158879_g44529_i0 | PRJNA404067 | 44916 | 168 | 4.158879 | 6.98691672 | Fimbriimonas ginsengisoli | 1005039 | Bacteria | Bacteria | 51.6 | 1.94e-6 | NR | MBI1755905.1 | 1005039 | g44529 | i0 | 48.4 | 3.05357142857143 | 62 | 24 | 96.4 | 1 | 167 | 6 | 55 | 116 | MBI1755905.1 hypothetical protein [Fimbriimonas ginsengisoli] | diamond | 513 | 51.6 | 1 | Bacteria | Bacillati | Armatimonadota | Fimbriimonadia | Fimbriimonadales | Fimbriimonadaceae | Fimbriimonas | Fimbriimonas ginsengisoli |
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);;