metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA911178" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA911178" 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_family	tax_genus	tax_species
11453843	11453843	PRJNA911178_P_NODE_237869_length_252_cov_1.441341_g235395_i0	PRJNA911178	237869	252	1.441341	3.63217932	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	167	1.83e-51	NR	MBX9722701.1	2364082	g235395	i0	94	0.988095238095238	83	5	98.8	0	3	251	51	133	MBX9722701.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	249	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
26707611	26707611	PRJNA911178_P_NODE_260841_length_247_cov_0.885057_g258367_i0	PRJNA911178	260841	247	0.885057	2.18609079	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	84.3	2.88e-17	NR	MBX9720574.1	2364082	g258367	i0	54.9	0.862348178137652	71	32	86.2	0	239	27	32	102	MBX9720574.1 tetratricopeptide repeat protein [Candidatus Obscuribacterales bacterium]	diamond	213	84.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27435590	27435590	PRJNA911178_P_NODE_282003_length_243_cov_0.905882_g279529_i0	PRJNA911178	282003	243	0.905882	2.20129326	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	43.1	0.014	NR	HND69355.1	2711154	g279529	i0	39.7	1.55555555555556	63	33	71.6	1	220	47	90	152	HND69355.1 response regulator transcription factor [Candidatus Obscuribacter sp.]	diamond	378	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
27782768	27782768	PRJNA911178_P_NODE_193744_length_275_cov_1.495050_g191271_i0	PRJNA911178	193744	275	1.49505	4.1113875	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	63.5	1.82e-10	NR	MBX9771232.1	2364082	g191271	i0	87.5	0.687272727272727	32	4	34.9	0	98	3	1	32	MBX9771232.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	189	63.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28729920	28729920	PRJNA911178_P_NODE_309407_length_196_cov_4.292683_g306932_i0	PRJNA911178	309407	196	4.292683	8.41365868	Candidatus Obscuribacter phosphatis	1906157	Bacteria	Bacteria	107	3.39e-27	NR	MBN8662923.1	1906157	g306932	i0	100	0.811224489795918	53	0	81.1	0	1	159	144	196	MBN8662923.1 sigma-70 family RNA polymerase sigma factor [Candidatus Obscuribacter phosphatis]	diamond	159	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter phosphatis
30877550	30877550	PRJNA911178_P_NODE_278414_length_244_cov_0.900585_g275940_i0	PRJNA911178	278414	244	0.900585	2.1974274	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	133	6.97e-37	NR	MBX9567321.1	2364082	g275940	i0	74.7	1.95491803278689	79	20	97.1	0	242	6	56	134	MBX9567321.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	477	133	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30909299	30909299	PRJNA911178_P_NODE_269794_length_245_cov_1.558140_g267320_i0	PRJNA911178	269794	245	1.55814	3.817443	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	156	3.18e-42	NR	MBX9568717.1	2364082	g267320	i0	97.5	0.96734693877551	79	2	96.7	0	243	7	593	671	MBX9568717.1 tetratricopeptide repeat protein [Candidatus Obscuribacterales bacterium]	diamond	237	156	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
31794255	31794255	PRJNA911178_P_NODE_276037_length_244_cov_0.900585_g273563_i0	PRJNA911178	276037	244	0.900585	2.1974274	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	43.9	0.00495	NR	MBX9690686.1	2364082	g273563	i0	40.7	0.725409836065574	59	31	72.5	1	195	19	55	109	MBX9690686.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	177	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales			Candidatus Obscuribacterales 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);;