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

5 rows where bioproject = "PRJEB39643", 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_class	tax_order	tax_species
8984924	8984924	PRJEB39643_P_NODE_21188_length_395_cov_3.801242_g20995_i0	PRJEB39643	21188	395	3.801242	15.0149059	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	241	2.2300000000000003e-79	NR	MBX9724270.1	2364082	g20995	i0	89.3	0.994936708860759	131	14	99.5	0	2	394	20	150	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	393	241	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
26906836	26906836	PRJEB39643_P_NODE_146382_length_242_cov_1.822485_g146189_i0	PRJEB39643	146382	242	1.822485	4.4104137	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	146	1.5e-38	NR	MBX9572289.1	2364082	g146189	i0	91.3	0.991735537190083	80	7	99.2	0	1	240	691	770	MBX9572289.1 CusA/CzcA family heavy metal efflux RND transporter [Candidatus Obscuribacterales bacterium]	diamond	240	146	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
27406263	27406263	PRJEB39643_P_NODE_121163_length_251_cov_4.460674_g120970_i0	PRJEB39643	121163	251	4.460674	11.19629174	root	1	Root_unresolved	Root_unresolved	111	2.56e-29	NR	MDX1919641.1	2729995	g120970	i0	57.7	1.9003984063745	78	33	93.2	0	14	247	6	83	MDX1919641.1 CoA-binding protein [Candidatus Caenarcanales bacterium]	diamond	477	111	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Candidatus Caenarcanales	Candidatus Caenarcanales bacterium
28423254	28423254	PRJEB39643_P_NODE_99186_length_261_cov_3.324468_g98993_i0	PRJEB39643	99186	261	3.324468	8.67686148	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	44.3	0.012	NR	HEY9814218.1	2364082	g98993	i0	36.4	1.01149425287356	88	53	98.9	2	258	1	109	195	HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	264	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
30412897	30412897	PRJEB39643_P_NODE_89433_length_266_cov_1.595855_g89240_i0	PRJEB39643	89433	266	1.595855	4.2449743	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	50.4	7.69e-5	NR	HEY9814218.1	2364082	g89240	i0	39.3	0.947368421052632	84	39	88	5	1	234	181	258	HEY9814218.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	252	50.4	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);;