metadata: contig_metadata: 5 rows where bioproject = "PRJEB83711", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

5 rows where bioproject = "PRJEB83711", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Candidatus Melainabacteria"

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_kingdom	tax_phylum	tax_order	tax_species
10347464	10347464	PRJEB83711_P_NODE_62109_length_251_cov_0.876404_g61843_i0	PRJEB83711	62109	251	0.876404	2.19977404	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	287	5.73e-73	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g61843	i0	87.352	84.0956175298805	253	28	100	4	1	251	1381909	1381659	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	21108	287	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium MEL.A1
14172942	14172942	PRJEB83711_P_NODE_60292_length_252_cov_0.871508_g60026_i0	PRJEB83711	60292	252	0.871508	2.19620016	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	129	1.65e-33	NR	MDD3237259.1	2137880	g60026	i0	75.9	0.94047619047619	79	19	94	0	245	9	48	126	MDD3237259.1 Mur ligase family protein [Candidatus Gastranaerophilales bacterium]	diamond	237	129	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales	Candidatus Gastranaerophilales bacterium
27571458	27571458	PRJEB83711_P_NODE_71504_length_246_cov_0.901734_g71238_i0	PRJEB83711	71504	246	0.901734	2.21826564	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	67.8	5.68e-11	NR	MCR5261300.1	2137880	g71238	i0	63	0.560975609756098	46	17	56.1	0	107	244	466	511	MCR5261300.1 glucosaminidase domain-containing protein [Candidatus Gastranaerophilales bacterium]	diamond	138	67.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales	Candidatus Gastranaerophilales bacterium
29307966	29307966	PRJEB83711_P_NODE_59989_length_252_cov_0.871508_g59723_i0	PRJEB83711	59989	252	0.871508	2.19620016	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	100	1.88e-22	NR	MCD7780448.1	2137880	g59723	i0	70.1	1.5952380952381	67	20	79.8	0	3	203	535	601	MCD7780448.1 ABC transporter ATP-binding protein/permease [Candidatus Gastranaerophilales bacterium]	diamond	402	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales	Candidatus Gastranaerophilales bacterium
31077129	31077129	PRJEB83711_P_NODE_45675_length_276_cov_1.039409_g45409_i0	PRJEB83711	45675	276	1.039409	2.86876884	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	163	3.3699999999999998e-46	NR	MDD3237458.1	2137880	g45409	i0	85.9	1	92	13	100	0	276	1	169	260	MDD3237458.1 trigger factor [Candidatus Gastranaerophilales bacterium]	diamond	276	163	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales	Candidatus Gastranaerophilales 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);;