metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJNA976345" and tax

4 rows where analysis = "blastn", bioproject = "PRJNA976345" 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_genus	tax_species
6051089	6051089	PRJNA976345_P_NODE_146985_length_167_cov_3.242424_g145377_i0	PRJNA976345	146985	167	3.242424	5.41484808	uncultured Poribacteria bacterium	265321	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2518551991\|emb\|OX638351.1\|	265321	g145377	i0	96.97	0.197604790419162	33	1	20	0	135	167	541036	541068	MAG: uncultured Poribacteria bacterium isolate d4690918-7cf6-4b6d-bcb0-07eb3c50a363 genome assembly, chromosome: 1	blastn	33	56.5	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria		uncultured Poribacteria bacterium
21669265	21669265	PRJNA976345_P_NODE_114737_length_181_cov_0.856164_g113129_i0	PRJNA976345	114737	181	0.856164	1.54965684	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	246	6.57e-61	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g113129	i0	94.375	49.0110497237569	160	9	88	0	22	181	77999	77840	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	8871	246	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharimonadota bacterium
22944936	22944936	PRJNA976345_P_NODE_24538_length_340_cov_1.029508_g22936_i0	PRJNA976345	24538	340	1.029508	3.5003272	Candidatus Minimicrobia	2905967	Bacteria	Bacteria	318	2.869999999999999e-82	NTclustered	gi\|2052595119\|gb\|CP076460.1\|	2841263	g22936	i0	83.776	7.95588235294118	339	52	99	3	2	338	28373	28036	Candidatus Minimicrobia naudis isolate IHU1 chromosome, complete genome	blastn	2705	318	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Minimicrobia	Candidatus Minimicrobia naudis
25173906	25173906	PRJNA976345_P_NODE_135080_length_173_cov_1.543478_g133472_i0	PRJNA976345	135080	173	1.543478	2.67021694	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2870347126\|gb\|CP175956.1\|	2045217	g133472	i0	100	0.161849710982659	28	0	16	0	63	90	362597	362570	MAG: Candidatus Moraniibacteriota bacterium isolate MKparc2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota		Candidatus Moraniibacteriota 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);;