contig_metadata
5 rows where bioproject = "PRJNA944406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11128102 | 11128102 | PRJNA944406_P_NODE_3469_length_724_cov_2.629800_g2603_i0 | PRJNA944406 | 3469 | 724 | 2.6298 | 19.039752 | Candidatus Roseilinea sp. | 2838777 | Bacteria | Bacteria | 852 | 0 | NTclustered | gi|2314722916|dbj|AP024676.1| | 2838777 | g2603 | i0 | 88 | 101.196132596685 | 725 | 81 | 99 | 6 | 1 | 723 | 3495256 | 3495976 | MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome | blastn | 73266 | 852 | 1 | Bacteria | Candidatus Thermofonsia Clade 3 | Bacillati | Chloroflexota | Candidatus Thermofontia | Candidatus Roseilinea | Candidatus Roseilinea sp. | |||
| 11128707 | 11128707 | PRJNA944406_P_NODE_9029_length_414_cov_1.888563_g8070_i0 | PRJNA944406 | 9029 | 414 | 1.888563 | 7.81865082 | Candidatus Roseilinea sp. | 2838777 | Bacteria | Bacteria | 627 | 5.199999999999999e-175 | NTclustered | gi|2314722916|dbj|AP024676.1| | 2838777 | g8070 | i0 | 94.175 | 34.4903381642512 | 412 | 23 | 99 | 1 | 1 | 412 | 3495669 | 3496079 | MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome | blastn | 14279 | 627 | 1 | Bacteria | Candidatus Thermofonsia Clade 3 | Bacillati | Chloroflexota | Candidatus Thermofontia | Candidatus Roseilinea | Candidatus Roseilinea sp. | |||
| 17503223 | 17503223 | PRJNA944406_P_NODE_85194_length_246_cov_0.890173_g84235_i0 | PRJNA944406 | 85194 | 246 | 0.890173 | 2.18982558 | Candidatus Roseilinea sp. | 2838777 | Bacteria | Bacteria | 377 | 3.2300000000000003e-100 | NTclustered | gi|2314722916|dbj|AP024676.1| | 2838777 | g84235 | i0 | 94.309 | 18.9512195121951 | 246 | 14 | 100 | 0 | 1 | 246 | 3495861 | 3496106 | MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome | blastn | 4662 | 377 | 1 | Bacteria | Candidatus Thermofonsia Clade 3 | Bacillati | Chloroflexota | Candidatus Thermofontia | Candidatus Roseilinea | Candidatus Roseilinea sp. | |||
| 20051362 | 20051362 | PRJNA944406_P_NODE_60156_length_253_cov_2.561111_g59197_i0 | PRJNA944406 | 60156 | 253 | 2.561111 | 6.47961083 | Candidatus Roseilinea sp. | 2838777 | Bacteria | Bacteria | 318 | 2.05e-82 | NTclustered | gi|2314722916|dbj|AP024676.1| | 2838777 | g59197 | i0 | 90.756 | 112.660079051383 | 238 | 22 | 94 | 0 | 1 | 238 | 3494746 | 3494983 | MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome | blastn | 28503 | 318 | 1 | Bacteria | Candidatus Thermofonsia Clade 3 | Bacillati | Chloroflexota | Candidatus Thermofontia | Candidatus Roseilinea | Candidatus Roseilinea sp. | |||
| 22601744 | 22601744 | PRJNA944406_P_NODE_5338_length_561_cov_1.577869_g4394_i0 | PRJNA944406 | 5338 | 561 | 1.577869 | 8.85184509 | Candidatus Roseilinea sp. | 2838777 | Bacteria | Bacteria | 797 | 0 | NTclustered | gi|2314722916|dbj|AP024676.1| | 2838777 | g4394 | i0 | 92.321 | 109.964349376114 | 560 | 43 | 99 | 0 | 1 | 560 | 3495138 | 3495697 | MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome | blastn | 61690 | 797 | 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);;