contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA683902" and tax_clade = "Candidatus Thermofonsia Clade 3"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3216235 | 3216235 | PRJNA683902_S_NODE_34463_length_163_cov_3.738095_g34019_i0 | PRJNA683902 | 34463 | 163 | 3.738095 | 6.09309485 | Candidatus Roseilinea sp. | 2838777 | Bacteria | Bacteria | 195 | 2.13e-45 | NTclustered | gi|2314722916|dbj|AP024676.1| | 2838777 | g34019 | i0 | 88.095 | 141.668711656442 | 168 | 14 | 100 | 5 | 1 | 163 | 3496112 | 3496278 | MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome | blastn | 23092 | 195 | 1 | Bacteria | Candidatus Thermofonsia Clade 3 | Bacillati | Chloroflexota | Candidatus Thermofontia | Candidatus Roseilinea | Candidatus Roseilinea sp. | |||
| 7043986 | 7043986 | PRJNA683902_S_NODE_29706_length_179_cov_3.711268_g29262_i0 | PRJNA683902 | 29706 | 179 | 3.711268 | 6.64316972 | Candidatus Roseilinea sp. | 2838777 | Bacteria | Bacteria | 126 | 8.81e-25 | NTclustered | gi|2314722916|dbj|AP024676.1| | 2838777 | g29262 | i0 | 80.117 | 116.502793296089 | 171 | 32 | 94 | 2 | 1 | 169 | 3494758 | 3494588 | MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome | blastn | 20854 | 126 | 1 | Bacteria | Candidatus Thermofonsia Clade 3 | Bacillati | Chloroflexota | Candidatus Thermofontia | Candidatus Roseilinea | Candidatus Roseilinea sp. | |||
| 15967977 | 15967977 | PRJNA683902_S_NODE_23093_length_214_cov_3.536723_g22649_i0 | PRJNA683902 | 23093 | 214 | 3.536723 | 7.56858722 | Candidatus Roseilinea sp. | 2838777 | Bacteria | Bacteria | 178 | 2.98e-40 | NTclustered | gi|2314722916|dbj|AP024676.1| | 2838777 | g22649 | i0 | 81.991 | 109.023364485981 | 211 | 37 | 99 | 1 | 1 | 211 | 3497744 | 3497953 | MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome | blastn | 23331 | 178 | 1 | Bacteria | Candidatus Thermofonsia Clade 3 | Bacillati | Chloroflexota | Candidatus Thermofontia | Candidatus Roseilinea | Candidatus Roseilinea sp. | |||
| 19792127 | 19792127 | PRJNA683902_S_NODE_12576_length_361_cov_3.080247_g12132_i0 | PRJNA683902 | 12576 | 361 | 3.080247 | 11.11969167 | Candidatus Roseilinea sp. | 2838777 | Bacteria | Bacteria | 315 | 3.95e-81 | NTclustered | gi|2314722916|dbj|AP024676.1| | 2838777 | g12132 | i0 | 83.631 | 142.218836565097 | 336 | 53 | 93 | 1 | 25 | 358 | 3494998 | 3495333 | MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome | blastn | 51341 | 315 | 1 | Bacteria | Candidatus Thermofonsia Clade 3 | Bacillati | Chloroflexota | Candidatus Thermofontia | Candidatus Roseilinea | Candidatus Roseilinea 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);;