metadata: contig_metadata: 3 rows where analysis = "diamond", bioproject = "PRJEB48218" and tax_clade = "Cyanobacteriota/Melainabacteria group"

3 rows where analysis = "diamond", bioproject = "PRJEB48218" and tax_clade = "Cyanobacteriota/Melainabacteria group"

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
27658840	27658840	PRJEB48218_S_NODE_24984_length_174_cov_2.179310_g24022_i0	PRJEB48218	24984	174	2.17931	3.7919994	Bacillati	1783272	Bacteria	Bacteria	82.4	1.36e-17	NR	MFN8554655.1	2364082	g24022	i0	68.5	1.86206896551724	54	17	93.1	0	162	1	74	127	MFN8554655.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	324	82.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
28044221	28044221	PRJEB48218_S_NODE_16565_length_230_cov_2.860697_g15603_i0	PRJEB48218	16565	230	2.860697	6.5796031	Leptolyngbya sp. UWPOB_LEPTO1	2815653	Bacteria	Bacteria	143	8.92e-41	NR	WP_353736685.1	2815653	g15603	i0	86.5	0.965217391304348	74	10	96.5	0	2	223	115	188	WP_353736685.1 IS1 family transposase [Leptolyngbya sp. UWPOB_LEPTO1]	diamond	222	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. UWPOB_LEPTO1
31891668	31891668	PRJEB48218_S_NODE_11057_length_271_cov_3.123967_g10095_i0	PRJEB48218	11057	271	3.123967	8.46595057	Cyanophyceae	3028117	Bacteria	Bacteria	70.1	2.23e-12	NR	WP_273766868.1	2593658	g10095	i0	47.9	3.27675276752768	71	35	78.6	1	49	261	2	70	WP_273766868.1 MULTISPECIES: DUF1003 domain-containing protein [unclassified Nostoc]	diamond	888	70.5	0.994326241134752	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc

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);;