metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA446034" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA446034" and tax_clade = "Bacteria candidate phyla"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
5542116	5542116	PRJNA446034_S_NODE_75265_length_166_cov_5.224806_g75228_i0	PRJNA446034	75265	166	5.224806	8.67317796	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	268	1.27e-67	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g75228	i0	96.319	0.981927710843373	163	6	98	0	1	163	186583	186745	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	163	268	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
15740948	15740948	PRJNA446034_S_NODE_68793_length_170_cov_2.834586_g68756_i0	PRJNA446034	68793	170	2.834586	4.8187962	Candidatus Nanosynbacter featherlites	2572088	Bacteria	Bacteria	219	1.3199999999999996e-52	NTclustered	gi\|1663054866\|gb\|CP040004.1\|	2572088	g68756	i0	89.941	1.98235294117647	169	17	99	0	2	170	222312	222480	Candidatus Nanosynbacter featherlites strain BB001 chromosome, complete genome	blastn	337	219	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter featherlites
18289854	18289854	PRJNA446034_S_NODE_38215_length_195_cov_4.215190_g38178_i0	PRJNA446034	38215	195	4.21519	8.2196205	Candidatus Minimicrobia vallesae	2841264	Bacteria	Bacteria	292	9.12e-75	NTclustered	gi\|2052594292\|gb\|CP076459.1\|	2841264	g38178	i0	93.846	6	195	11	100	1	1	195	379821	380014	Candidatus Minimicrobia vallesae isolate IHU2 chromosome, complete genome	blastn	1170	292	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia vallesae
20218241	20218241	PRJNA446034_S_NODE_81516_length_163_cov_3.238095_g81479_i0	PRJNA446034	81516	163	3.238095	5.27809485	Candidatus Saccharimonadota	95818	Bacteria	Bacteria	246	5.8099999999999995e-61	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g81479	i0	93.865	3.82822085889571	163	10	100	0	1	163	325044	324882	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	624	246	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
22114911	22114911	PRJNA446034_S_NODE_7438_length_280_cov_5.469136_g7401_i0	PRJNA446034	7438	280	5.469136	15.3135808	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	207	5.2e-49	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g7401	i0	80.427	1.00357142857143	281	47	98	6	6	279	95338	95059	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	281	207	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas 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);;