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

5 rows where analysis = "blastn", bioproject = "PRJNA385073" 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
5509328	5509328	PRJNA385073_P_NODE_21225_length_312_cov_1.288703_g21063_i0	PRJNA385073	21225	312	1.288703	4.02075336	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	289	2.04e-73	NTclustered	gi\|2575803556\|emb\|OY729432.1\|	2838779	g21063	i0	83.648	262.211538461538	318	40	100	8	1	312	2239525	2239214	MAG: Candidatus Binatia bacterium isolate b65fbbe8-1638-4b94-9072-1473f084fbf4 genome assembly, chromosome: 1	blastn	81810	289	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
5509797	5509797	PRJNA385073_P_NODE_41005_length_251_cov_2.578652_g40843_i0	PRJNA385073	41005	251	2.578652	6.47241652	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	394	3.28e-105	NTclustered	gi\|2556885218\|gb\|CP129471.1\|	2052139	g40843	i0	94.882	219.908366533865	254	10	100	1	1	251	70933	70680	MAG: Patescibacteria group bacterium isolate cMAG.25 chromosome, complete genome	blastn	55197	394	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
6783873	6783873	PRJNA385073_P_NODE_45126_length_249_cov_0.875000_g44964_i0	PRJNA385073	45126	249	0.875	2.17875	Candidatus Minusculum obligatum	1948790	Bacteria	Bacteria	268	2.06e-67	NTclustered	gi\|2862534883\|gb\|CP174360.1\|	1948790	g44964	i0	86.345	35.2248995983936	249	30	100	4	1	249	190593	190837	MAG: Patescibacteria group bacterium UBA2103 chromosome, complete genome	blastn	8771	268	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Minusculum	Candidatus Minusculum obligatum
11884763	11884763	PRJNA385073_P_NODE_39970_length_253_cov_9.472222_g39808_i0	PRJNA385073	39970	253	9.472222	23.96472166	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	292	1.24e-74	NTclustered	gi\|2814788387\|emb\|OY762897.2\|	2838779	g39808	i0	88.477	241.501976284585	243	27	96	1	3	245	597131	596890	MAG: Candidatus Binatia bacterium isolate 08c4157d-86a7-49cc-8b26-f3076a3ae996 genome assembly, chromosome: 1	blastn	61100	292	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
13829651	13829651	PRJNA385073_P_NODE_30311_length_278_cov_1.502439_g30149_i0	PRJNA385073	30311	278	1.502439	4.17678042	Bacteria	2	Bacteria	Bacteria	300	8.280000000000001e-77	NTclustered	gi\|2621703606\|emb\|OY761465.1\|	2838779	g30149	i0	88.142	123.503597122302	253	28	91	2	1	252	3395685	3395434	MAG: Candidatus Binatia bacterium isolate d3e24e22-6b5b-4867-8422-75782eed2520 genome assembly, chromosome: 1	blastn	34334	300	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia 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);;