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

12 rows where analysis = "diamond", bioproject = "PRJEB55250" 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
15424037	15424037	PRJEB55250_P_NODE_11613_length_251_cov_0.865169_g11489_i0	PRJEB55250	11613	251	0.865169	2.17157419	Cyanophyceae	3028117	Bacteria	Bacteria	105	2.5299999999999998e-24	NR	MBW4549202.1	450513	g11489	i0	66.2	2.8804780876494	77	26	92	0	250	20	432	508	MBW4549202.1 NACHT domain-containing protein [Symplocastrum torsivum CPER-KK1]	diamond	723	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Symplocastrum	Symplocastrum torsivum
24347555	24347555	PRJEB55250_P_NODE_13660_length_247_cov_0.885057_g13536_i0	PRJEB55250	13660	247	0.885057	2.18609079	Coleofasciculus sp. FACHB-712	2692789	Bacteria	Bacteria	140	2.939999999999999e-38	NR	WP_190430061.1	2692789	g13536	i0	87.8	9.95951417004049	82	10	99.6	0	246	1	212	293	WP_190430061.1 Re/Si-specific NAD(P)(+) transhydrogenase subunit alpha [Coleofasciculus sp. FACHB-712]	diamond	2460	140	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. FACHB-712
26709929	26709929	PRJEB55250_P_NODE_10021_length_261_cov_1.638298_g9897_i0	PRJEB55250	10021	261	1.638298	4.27595778	Bacteria	2	Bacteria	Bacteria	87.4	2.73e-19	NR	MBS1994242.1	2807732	g9897	i0	70.9	2.01149425287356	55	16	63.2	0	96	260	11	65	MBS1994242.1 hypothetical protein [Cyanobacteria bacterium SZAS LIN-3]	diamond	525	87.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-3
26716631	26716631	PRJEB55250_P_NODE_16261_length_241_cov_2.380952_g16137_i0	PRJEB55250	16261	241	2.380952	5.73809432	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	154	1.05e-45	NR	MBI2812446.1	2052166	g16137	i0	100	1.99170124481328	80	0	99.6	0	2	241	18	97	MBI2812446.1 TolC family protein [Candidatus Melainabacteria bacterium]	diamond	480	154	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
27279778	27279778	PRJEB55250_P_NODE_12063_length_250_cov_0.870056_g11939_i0	PRJEB55250	12063	250	0.870056	2.17514	Cyanophyceae	3028117	Bacteria	Bacteria	121	1.6199999999999998e-31	NR	WP_190831219.1	2806730	g11939	i0	68.7	1.992	83	26	99.6	0	249	1	183	265	WP_190831219.1 AraC family transcriptional regulator [Iningainema tapete]	diamond	498	122	0.991803278688525	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Iningainema	Iningainema tapete
29118040	29118040	PRJEB55250_P_NODE_11749_length_251_cov_0.865169_g11625_i0	PRJEB55250	11749	251	0.865169	2.17157419	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	97.4	1.43e-22	NR	MFA6208717.1	2364082	g11625	i0	90.4	0.99203187250996006	83	8	99.2	0	251	3	96	178	MFA6208717.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	249	97.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29300553	29300553	PRJEB55250_P_NODE_8009_length_276_cov_1.517241_g7885_i0	PRJEB55250	8009	276	1.517241	4.18758516	root	1	Root_unresolved	Root_unresolved	49.3	2.4e-4	NR	WP_277866815.1	1522304	g7885	i0	49.2	1.92391304347826	61	25	65.2	2	10	189	211	266	WP_277866815.1 prohibitin family protein [Candidatus Synechococcus calcipolaris]	diamond	531	49.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Candidatus Synechococcus calcipolaris
29907359	29907359	PRJEB55250_P_NODE_9231_length_267_cov_1.546392_g9107_i0	PRJEB55250	9231	267	1.546392	4.12886664	Cyanobacteria bacterium J06638_20	3023208	Bacteria	Bacteria	53.5	7.86e-6	NR	MEO1208378.1	3023208	g9107	i0	40.2	0.921348314606742	82	48	91	1	266	24	411	492	MEO1208378.1 capsid cement protein [Cyanobacteria bacterium J06638_20]	diamond	246	53.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06638_20
31139090	31139090	PRJEB55250_P_NODE_12435_length_249_cov_1.340909_g12311_i0	PRJEB55250	12435	249	1.340909	3.33886341	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	42.7	0.00886	NR	HMY56310.1	2711154	g12311	i0	48.8	1.03614457831325	43	21	51.8	1	88	216	44	85	HMY56310.1 hypothetical protein [Candidatus Obscuribacter sp.]	diamond	258	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
31455730	31455730	PRJEB55250_P_NODE_14296_length_245_cov_1.790698_g14172_i0	PRJEB55250	14296	245	1.790698	4.3872101	Leptolyngbya sp. FACHB-321	2692807	Bacteria	Bacteria	164	7.809999999999999e-47	NR	WP_190513291.1	2692807	g14172	i0	86.4	0.991836734693878	81	11	99.2	0	1	243	325	405	WP_190513291.1 C1 family peptidase [Leptolyngbya sp. FACHB-321]	diamond	243	164	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. FACHB-321
31512366	31512366	PRJEB55250_P_NODE_16496_length_241_cov_0.916667_g16372_i0	PRJEB55250	16496	241	0.916667	2.20916747	Bacillati	1783272	Bacteria	Bacteria	45.8	0.00283	NR	WP_038080763.1	1161	g16372	i0	63.2	0.871369294605809	38	12	47.3	1	116	3	1	36	WP_038080763.1 MULTISPECIES: VWA domain-containing protein [Nostocales]	diamond	210	46.2	0.991341991341991	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales
32499872	32499872	PRJEB55250_P_NODE_9599_length_264_cov_1.612565_g9475_i0	PRJEB55250	9599	264	1.612565	4.2571716	Calothrix sp. NIES-21	1187	Bacteria	Bacteria	42.7	0.0489	NR	WP_096600565.1	1954172	g9475	i0	47.9	0.545454545454545	48	22	54.5	1	180	37	107	151	WP_096600565.1 PAS domain-containing sensor histidine kinase [Calothrix sp. NIES-2100]	diamond	144	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-2100

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