metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA861969" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA861969" and tax_phylum = "Cyanobacteriota"

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
28097345	28097345	PRJNA861969_P_NODE_5545_length_546_cov_2.114165_g5315_i0	PRJNA861969	5545	546	2.114165	11.5433409	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	46.2	0.0324	NR	MEW5820732.1	2847862	g5315	i0	35.1	0.423076923076923	77	50	42.3	0	440	210	144	220	MEW5820732.1 SGNH/GDSL hydrolase family protein [Cyanobacteriota bacterium]	diamond	231	46.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28831635	28831635	PRJNA861969_P_NODE_35588_length_247_cov_0.885057_g35357_i0	PRJNA861969	35588	247	0.885057	2.18609079	Spirulina	1154	Bacteria	Bacteria	94.4	2.69e-20	NR	NEO87136.1	2607816	g35357	i0	57.3	3.95951417004049	82	34	99.6	1	2	247	472	552	NEO87136.1 GHKL domain-containing protein [Spirulina sp. SIO3F2]	diamond	978	94.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Spirulinales	Spirulinaceae	Spirulina	Spirulina sp. SIO3F2
29644118	29644118	PRJNA861969_P_NODE_25510_length_273_cov_1.540000_g25279_i0	PRJNA861969	25510	273	1.54	4.2042	Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40	3070899	Bacteria	Bacteria	182	5.11e-51	NR	MDQ5937995.1	3070899	g25279	i0	98.9	1	91	1	100	0	273	1	371	461	MDQ5937995.1 hypothetical protein [Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40]	diamond	273	182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40
30023694	30023694	PRJNA861969_P_NODE_26831_length_267_cov_1.484536_g26600_i0	PRJNA861969	26831	267	1.484536	3.96371112	Iningainema tapete	2806730	Bacteria	Bacteria	51.6	4.04e-5	NR	WP_190835607.1	2806730	g26600	i0	88.5	0.292134831460674	26	3	29.2	0	73	150	2085	2110	WP_190835607.1 type I polyketide synthase [Iningainema tapete]	diamond	78	51.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Iningainema	Iningainema tapete
30189556	30189556	PRJNA861969_P_NODE_31792_length_250_cov_0.870056_g31561_i0	PRJNA861969	31792	250	0.870056	2.17514	Cyanophyceae	3028117	Bacteria	Bacteria	71.2	3.54e-12	NR	WP_190595277.1	1162	g31561	i0	58.8	2.304	68	28	81.6	0	1	204	364	431	WP_190595277.1 MULTISPECIES: glycosyltransferase [Nostocaceae]	diamond	576	71.6	0.994413407821229	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae
32521515	32521515	PRJNA861969_P_NODE_28799_length_258_cov_1.664865_g28568_i0	PRJNA861969	28799	258	1.664865	4.2953517	Nostoc ellipsosporum	45916	Bacteria	Bacteria	102	6.5e-23	NR	MDF2385032.1	2804519	g28568	i0	100	1	86	0	100	0	1	258	755	840	MDF2385032.1 RHS repeat protein [Nostoc ellipsosporum NOK]	diamond	258	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc ellipsosporum

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