metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA928559" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA928559" 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_class	tax_order	tax_family	tax_genus	tax_species
21304223	21304223	PRJNA928559_P_NODE_123197_length_320_cov_3.433198_g121628_i0	PRJNA928559	123197	320	3.433198	10.9862336	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	132	7.679999999999999e-37	NR	MBL8086285.1	2711154	g121628	i0	98.4	0.58125	62	1	58.1	0	133	318	1	62	MBL8086285.1 nicotinate-nucleotide adenylyltransferase [Candidatus Obscuribacter sp.]	diamond	186	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
27467352	27467352	PRJNA928559_P_NODE_212203_length_243_cov_0.917647_g210634_i0	PRJNA928559	212203	243	0.917647	2.22988221	Candidatus Caenarcanales bacterium	2729995	Bacteria	Bacteria	108	5.06e-27	NR	MDX1920634.1	2729995	g210634	i0	74.2	0.814814814814815	66	17	81.5	0	242	45	87	152	MDX1920634.1 hypothetical protein [Candidatus Caenarcanales bacterium]	diamond	198	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Candidatus Caenarcanales			Candidatus Caenarcanales bacterium
30656657	30656657	PRJNA928559_P_NODE_158633_length_279_cov_1.344660_g157064_i0	PRJNA928559	158633	279	1.34466	3.7516014	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	77.4	2.81e-15	NR	MBL8086383.1	2711154	g157064	i0	74.5	0.505376344086022	47	12	50.5	0	276	136	98	144	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	141	77.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
32079503	32079503	PRJNA928559_P_NODE_199658_length_248_cov_0.891429_g198089_i0	PRJNA928559	199658	248	0.891429	2.21074392	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	123	1.2699999999999998e-31	NR	HEY9843761.1	2364082	g198089	i0	72.6	1.01612903225806	84	19	96.8	1	7	246	56	139	HEY9843761.1 hemolysin family protein [Candidatus Obscuribacterales bacterium]	diamond	252	123	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);;