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

9 rows where analysis = "diamond", bioproject = "PRJNA801875" 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
26737194	26737194	PRJNA801875_P_NODE_3581_length_173_cov_1.949275_g3478_i0	PRJNA801875	3581	173	1.949275	3.37224575	Pleurocapsa sp. MO_226.B13	3036786	Bacteria	Bacteria	42.4	0.0204	NR	MDJ0594391.1	3036786	g3478	i0	43.9	0.988439306358382	57	31	97.1	1	2	169	1009	1065	MDJ0594391.1 malectin domain-containing carbohydrate-binding protein [Pleurocapsa sp. MO_226.B13]	diamond	171	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. MO_226.B13
26864601	26864601	PRJNA801875_P_NODE_2741_length_204_cov_1.396450_g2638_i0	PRJNA801875	2741	204	1.39645	2.848758	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	82	1.2e-17	NR	MBX9724270.1	2364082	g2638	i0	97.5	0.588235294117647	40	1	58.8	0	203	84	131	170	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	120	82	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
27117145	27117145	PRJNA801875_P_NODE_2582_length_212_cov_2.141243_g2479_i0	PRJNA801875	2582	212	2.141243	4.53943516	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	108	7.14e-26	NR	HEY9756413.1	3088181	g2479	i0	72.5	0.976415094339623	69	19	97.6	0	6	212	191	259	HEY9756413.1 acetyl-CoA hydrolase/transferase C-terminal domain-containing protein [Oculatellaceae cyanobacterium]	diamond	207	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
28727938	28727938	PRJNA801875_P_NODE_2007_length_255_cov_2.645455_g1904_i0	PRJNA801875	2007	255	2.645455	6.74591025	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	126	2.21e-35	NR	MBX9692690.1	2847862	g1904	i0	91.8	0.717647058823529	61	5	71.8	0	1	183	57	117	MBX9692690.1 (2Fe-2S)-binding protein [Cyanobacteriota bacterium]	diamond	183	126	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29210580	29210580	PRJNA801875_P_NODE_2129_length_244_cov_1.851675_g2026_i0	PRJNA801875	2129	244	1.851675	4.518087	Cyanophyceae	3028117	Bacteria	Bacteria	65.9	2.34e-10	NR	WP_107670899.1	2082950	g2026	i0	63.5	4.73360655737705	52	10	63.9	1	6	161	309	351	WP_107670899.1 alkene reductase [Cyanothece sp. BG0011]	diamond	1155	66.2	0.995468277945619	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Cyanothecaceae	Cyanothece	Cyanothece sp. BG0011
29391111	29391111	PRJNA801875_P_NODE_3209_length_184_cov_2.389262_g3106_i0	PRJNA801875	3209	184	2.389262	4.39624208	Hormoscilla sp. GUM202	2480853	Bacteria	Bacteria	88.2	2.44e-19	NR	MBO1351640.1	2480853	g3106	i0	67.2	2.95108695652174	61	20	99.5	0	1	183	146	206	MBO1351640.1 SDR family oxidoreductase [Hormoscilla sp. GUM202]	diamond	543	88.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Gomontiellaceae	Hormoscilla	Hormoscilla sp. GUM202
30685923	30685923	PRJNA801875_P_NODE_3193_length_185_cov_1.326667_g3090_i0	PRJNA801875	3193	185	1.326667	2.45433395	Cyanobacteria bacterium P01_H01_bin.153	3023316	Bacteria	Bacteria	94.4	8.3e-23	NR	MEM1309679.1	3023316	g3090	i0	71.2	4.63783783783784	59	17	95.7	0	6	182	87	145	MEM1309679.1 nucleoside-diphosphate kinase [Cyanobacteria bacterium P01_H01_bin.153]	diamond	858	94.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_H01_bin.153
30812377	30812377	PRJNA801875_P_NODE_994_length_415_cov_6.413158_g891_i0	PRJNA801875	994	415	6.413158	26.6146057	Candidatus Gastranaerophilaceae bacterium	3022870	Bacteria	Bacteria	53.9	3.58e-6	NR	MEI3251335.1	3022870	g891	i0	53.3	10.5036144578313	60	28	43.4	0	224	45	53	112	MEI3251335.1 30S ribosomal protein S13 [Candidatus Gastranaerophilaceae bacterium]	diamond	4359	53.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales	Candidatus Gastranaerophilaceae		Candidatus Gastranaerophilaceae bacterium
32307960	32307960	PRJNA801875_P_NODE_2459_length_220_cov_2.421622_g2356_i0	PRJNA801875	2459	220	2.421622	5.3275684	Bacillati	1783272	Bacteria	Bacteria	77.8	1.26e-14	NR	WP_298917448.1	340711	g2356	i0	55.6	6.69545454545455	72	32	98.2	0	5	220	817	888	WP_298917448.1 amino acid adenylation domain-containing protein [uncultured Nostoc sp.]	diamond	1473	77.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	uncultured Nostoc sp.

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