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

12 rows where analysis = "diamond", bioproject = "PRJNA436017" 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
22107567	22107567	PRJNA436017_P_NODE_5378_length_391_cov_1.567797_g5082_i0	PRJNA436017	5378	391	1.567797	6.13008627	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	94.7	3.9200000000000006e-21	NR	MBX9690859.1	2847862	g5082	i0	40	0.997442455242967	130	70	99.7	2	2	391	86	207	MBX9690859.1 AMP-binding protein [Cyanobacteriota bacterium]	diamond	390	94.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27739566	27739566	PRJNA436017_P_NODE_13364_length_229_cov_2.578125_g13066_i0	PRJNA436017	13364	229	2.578125	5.90390625	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	97.4	1.6399999999999998e-23	NR	MBX9724270.1	2364082	g13066	i0	98	0.641921397379913	49	1	64.2	0	228	82	122	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	147	97.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27771023	27771023	PRJNA436017_P_NODE_9324_length_285_cov_0.935484_g9026_i0	PRJNA436017	9324	285	0.935484	2.6661294	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	113	5.13e-28	NR	MBX9694561.1	2847862	g9026	i0	70.2	0.884210526315789	84	21	84.2	1	240	1	15	98	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	252	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28275879	28275879	PRJNA436017_P_NODE_22906_length_170_cov_2.849624_g22608_i0	PRJNA436017	22906	170	2.849624	4.8443608	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	42	0.00961	NR	PZM84364.1	2052166	g22608	i0	62.2	0.652941176470588	37	14	65.3	0	128	18	77	113	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	111	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
28370632	28370632	PRJNA436017_P_NODE_16346_length_204_cov_1.341317_g16048_i0	PRJNA436017	16346	204	1.341317	2.73628668	Richelia intracellularis	1164990	Bacteria	Bacteria	58.5	5.1e-9	NR	CDN15762.1	1164990	g16048	i0	66.7	1.20588235294118	42	14	61.8	0	198	73	4	45	CDN15762.1 hypothetical protein RintRC_0033 [Richelia intracellularis]	diamond	246	58.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia intracellularis
29128728	29128728	PRJNA436017_P_NODE_22649_length_171_cov_6.320896_g22351_i0	PRJNA436017	22649	171	6.320896	10.80873216	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	61.2	3.03e-10	NR	PZM84364.1	2052166	g22351	i0	59.6	0.912280701754386	52	21	91.2	0	2	157	64	115	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	156	61.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
29934472	29934472	PRJNA436017_P_NODE_25651_length_161_cov_1.258065_g25353_i0	PRJNA436017	25651	161	1.258065	2.02548465	Cyanophyceae	3028117	Bacteria	Bacteria	80.1	7.96e-16	NR	WP_036536179.1	1501145	g25353	i0	69.8	5.92546583850932	53	16	98.8	0	161	3	351	403	WP_036536179.1 glutamate synthase subunit beta [Neosynechococcus sphagnicola]	diamond	954	80.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Neosynechococcales	Neosynechococcaceae	Neosynechococcus	Neosynechococcus sphagnicola
30012781	30012781	PRJNA436017_P_NODE_19631_length_184_cov_2.591837_g19333_i0	PRJNA436017	19631	184	2.591837	4.76898008	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	45.1	2.19e-4	NR	HEY9844071.1	2364082	g19333	i0	88	0.407608695652174	25	3	40.8	0	79	5	1	25	HEY9844071.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	75	45.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30044170	30044170	PRJNA436017_P_NODE_29731_length_150_cov_1.035398_g29433_i0	PRJNA436017	29731	150	1.035398	1.553097	Cyanobacteria bacterium P01_H01_bin.152	3023315	Bacteria	Bacteria	72	4.82e-13	NR	MEM1278527.1	3023315	g29433	i0	60.4	2.84	48	19	96	0	149	6	556	603	MEM1278527.1 glycoside hydrolase family 19 protein [Cyanobacteria bacterium P01_H01_bin.152]	diamond	426	72	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_H01_bin.152
30297523	30297523	PRJNA436017_P_NODE_21952_length_174_cov_2.255474_g21654_i0	PRJNA436017	21952	174	2.255474	3.92452476	Nostocales cyanobacterium ELA608	3064516	Bacteria	Bacteria	45.1	0.00148	NR	MEI6371987.1	3064516	g21654	i0	40.4	0.982758620689655	57	34	98.3	0	172	2	15	71	MEI6371987.1 NADH-quinone oxidoreductase subunit C [Nostocales cyanobacterium ELA608]	diamond	171	45.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium ELA608
31292912	31292912	PRJNA436017_P_NODE_27695_length_155_cov_1.322034_g27397_i0	PRJNA436017	27695	155	1.322034	2.0491527	Cyanophyceae	3028117	Bacteria	Bacteria	43.9	0.00443	NR	OAB62278.1	322866	g27397	i0	47.5	2.36129032258065	40	21	77.4	0	20	139	634	673	OAB62278.1 hypothetical protein AY599_10795 [Leptolyngbya valderiana BDU 20041]	diamond	366	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya valderiana
32098942	32098942	PRJNA436017_P_NODE_24418_length_165_cov_1.375000_g24120_i0	PRJNA436017	24418	165	1.375	2.26875	Nostoc sp. CHAB 5715	2780400	Bacteria	Bacteria	48.1	1.47e-4	NR	WP_229458700.1	2780400	g24120	i0	87.5	0.436363636363636	24	3	43.6	0	74	3	1	24	WP_229458700.1 hypothetical protein [Nostoc sp. CHAB 5715]	diamond	72	48.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CHAB 5715

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