contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA944406" and tax_phylum = "Candidatus Nomuraibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 924891 | 924891 | PRJNA944406_P_NODE_7481_length_459_cov_3.606218_g6525_i0 | PRJNA944406 | 7481 | 459 | 3.606218 | 16.55254062 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 725 | 0 | NTclustered | gi|2258875662|gb|CP060232.1| | 2052152 | g6525 | i0 | 95.207 | 97.7167755991285 | 459 | 20 | 99 | 2 | 2 | 459 | 966560 | 966103 | MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome | blastn | 44852 | 725 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 9852122 | 9852122 | PRJNA944406_P_NODE_104988_length_242_cov_0.911243_g104029_i0 | PRJNA944406 | 104988 | 242 | 0.911243 | 2.20520806 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 305 | 1.52e-78 | NTclustered | gi|2258865392|gb|CP060227.1| | 2052152 | g104029 | i0 | 89.873 | 182.078512396694 | 237 | 24 | 98 | 0 | 6 | 242 | 431997 | 431761 | MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome | blastn | 44063 | 305 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 12403424 | 12403424 | PRJNA944406_P_NODE_18490_length_305_cov_2.758621_g17531_i0 | PRJNA944406 | 18490 | 305 | 2.758621 | 8.41379405 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 444 | 4.01e-120 | NTclustered | gi|2258875662|gb|CP060232.1| | 2052152 | g17531 | i0 | 93.137 | 60.9803278688525 | 306 | 16 | 100 | 5 | 1 | 305 | 963046 | 963347 | MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome | blastn | 18599 | 444 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 17503032 | 17503032 | PRJNA944406_P_NODE_65914_length_251_cov_0.865169_g64955_i0 | PRJNA944406 | 65914 | 251 | 0.865169 | 2.17157419 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 268 | 2.07e-67 | NTclustered | gi|1958028780|gb|CP064973.1| | 2052152 | g64955 | i0 | 86.166 | 111.302788844622 | 253 | 30 | 99 | 4 | 2 | 251 | 126550 | 126800 | MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome | blastn | 27937 | 268 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium | ||||||
| 25150395 | 25150395 | PRJNA944406_P_NODE_111040_length_237_cov_2.542683_g110081_i0 | PRJNA944406 | 111040 | 237 | 2.542683 | 6.02615871 | Candidatus Nomurabacteria bacterium | 2052152 | Bacteria | Bacteria | 370 | 5.17e-98 | NTclustered | gi|2258866441|gb|CP060228.1| | 2052152 | g110081 | i0 | 96.035 | 12.2236286919831 | 227 | 9 | 96 | 0 | 11 | 237 | 249336 | 249110 | MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-23 chromosome | blastn | 2897 | 370 | 1 | Bacteria | Bacteria candidate phyla | Candidatus Nomuraibacteriota | Candidatus Nomurabacteria bacterium |
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);;