metadata: contig_metadata: 14 rows where bioproject = "PRJEB76780" and tax_clade = "Cyanobacteriota/Melainabacteria group"

14 rows where bioproject = "PRJEB76780" 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
3964922	3964922	PRJEB76780_P_NODE_4804_length_371_cov_0.909396_g4704_i0	PRJEB76780	4804	371	0.909396	3.37385916	Oscillatoria sp. PCC 1	1159	Bacteria	Bacteria	153	8.58e-44	NR	WP_017716299.1	1173028	g4704	i0	63.9	0.986522911051213	122	40	95.4	1	11	364	78	199	WP_017716299.1 SDR family oxidoreductase [Oscillatoria sp. PCC 10802]	diamond	366	153	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria sp. PCC 10802
12892256	12892256	PRJEB76780_P_NODE_4731_length_373_cov_1.696667_g4631_i0	PRJEB76780	4731	373	1.696667	6.32856791	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	180	1.7899999999999998e-55	NR	HEY9744954.1	3088181	g4631	i0	67.8	56.7747989276139	121	39	97.3	0	365	3	2	122	HEY9744954.1 nucleoside-diphosphate kinase [Oculatellaceae cyanobacterium]	diamond	21177	181	0.994475138121547	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
15441230	15441230	PRJEB76780_P_NODE_4413_length_387_cov_1.697452_g4313_i0	PRJEB76780	4413	387	1.697452	6.56913924	Synechococcus sp. CBW1108	1353147	Bacteria	Bacteria	60.2	2.21e-4	NTclustered	gi\|1940487417\|gb\|CP060395.1\|	1353147	g4313	i0	100	0.457364341085271	32	0	8	0	94	125	2318558	2318589	Synechococcus sp. CBW1108 chromosome, complete genome	blastn	177	60.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1108
26685928	26685928	PRJEB76780_P_NODE_2661_length_503_cov_1.767442_g2561_i0	PRJEB76780	2661	503	1.767442	8.89023326	Chroococcales cyanobacterium	3088180	Bacteria	Bacteria	138	2.06e-35	NR	HEY9726313.1	3088180	g2561	i0	56	0.745526838966203	125	53	74	2	382	11	328	451	HEY9726313.1 hypothetical protein [Chroococcales cyanobacterium]	diamond	375	138	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales			Chroococcales cyanobacterium
27002386	27002386	PRJEB76780_P_NODE_5322_length_351_cov_1.402878_g5222_i0	PRJEB76780	5322	351	1.402878	4.92410178	Pleurocapsa sp. MO_192.B19	3036785	Bacteria	Bacteria	108	7.05e-25	NR	MDJ0573029.1	3036785	g5222	i0	41.7	2.97435897435897	120	65	99.1	2	349	2	210	328	MDJ0573029.1 L-tyrosine/L-tryptophan isonitrile synthase family protein [Pleurocapsa sp. MO_192.B19]	diamond	1044	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. MO_192.B19
27666277	27666277	PRJEB76780_P_NODE_904_length_874_cov_2.088639_g820_i0	PRJEB76780	904	874	2.088639	18.25470486	Cyanobacteria bacterium P01_A01_bin.37	3023248	Bacteria	Bacteria	94	2.57e-17	NR	MEM7772855.1	3023248	g820	i0	57.3	0.51487414187643	150	49	51.5	2	92	541	721	855	MEM7772855.1 DUF4347 domain-containing protein [Cyanobacteria bacterium P01_A01_bin.37]	diamond	450	94	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_A01_bin.37
27918593	27918593	PRJEB76780_P_NODE_185_length_1626_cov_1.661301_g151_i0	PRJEB76780	185	1626	1.661301	27.01275426	Nostoc sp. FACHB-973	2692844	Bacteria	Bacteria	127	2.03e-26	NR	MBD2520363.1	2692844	g151	i0	31.8	2.75276752767528	242	151	43.7	9	796	1506	1874	2106	MBD2520363.1 choice-of-anchor D domain-containing protein [Nostoc sp. FACHB-973]	diamond	4476	127	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. FACHB-973
28992527	28992527	PRJEB76780_P_NODE_13108_length_243_cov_0.917647_g13008_i0	PRJEB76780	13108	243	0.917647	2.22988221	Coleofasciculus sp. FACHB-712	2692789	Bacteria	Bacteria	45.4	0.00423	NR	WP_190430679.1	2692789	g13008	i0	31.9	0.888888888888889	72	49	88.9	0	21	236	25	96	WP_190430679.1 tetratricopeptide repeat protein [Coleofasciculus sp. FACHB-712]	diamond	216	45.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. FACHB-712
30500911	30500911	PRJEB76780_P_NODE_4293_length_393_cov_1.218750_g4193_i0	PRJEB76780	4293	393	1.21875	4.7896875	Nostocales	1161	Bacteria	Bacteria	68.9	1.43e-10	NR	WP_190905229.1	1296320	g4193	i0	46.8	11.1984732824427	94	45	71	2	392	114	1146	1235	WP_190905229.1 beta strand repeat-containing protein [Anabaena catenula]	diamond	4401	68.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena catenula
30697639	30697639	PRJEB76780_P_NODE_5714_length_339_cov_0.868421_g5614_i0	PRJEB76780	5714	339	0.868421	2.94394719	Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11	1801609	Bacteria	Bacteria	58.5	2.59e-7	NR	OGI09100.1	1801609	g5614	i0	52.5	0.725663716814159	40	19	35.4	0	212	331	127	166	OGI09100.1 MAG: hypothetical protein A3F80_00030 [Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11]	diamond	246	58.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium RIFCSPLOWO2_12_FULL_35_11
31013663	31013663	PRJEB76780_P_NODE_375_length_1250_cov_1.892948_g328_i0	PRJEB76780	375	1250	1.892948	23.66185	Pleurocapsa sp. PCC 7327	118163	Bacteria	Bacteria	99.4	3.99e-18	NR	WP_041391870.1	118163	g328	i0	39.2	1.8864	209	107	47.5	6	1146	553	491	690	WP_041391870.1 Ig-like domain-containing protein [Pleurocapsa sp. PCC 7327]	diamond	2358	99.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. PCC 7327
31227476	31227476	PRJEB76780_P_NODE_4935_length_365_cov_1.602740_g4835_i0	PRJEB76780	4935	365	1.60274	5.850001	Bacteria	2	Bacteria	Bacteria	82	2.58e-15	NR	WP_106457246.1	1521625	g4835	i0	47.5	3.43561643835616	99	50	80.5	2	362	69	515	612	WP_106457246.1 Calx-beta domain-containing protein [Aphanothece hegewaldii]	diamond	1254	82.8	0.990338164251208	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Aphanothece	Aphanothece hegewaldii
31393225	31393225	PRJEB76780_P_NODE_6836_length_308_cov_1.868085_g6736_i0	PRJEB76780	6836	308	1.868085	5.7537018	Stanieria sp. NIES-3757	1807358	Bacteria	Bacteria	48.5	7.24e-4	NR	BAU64617.1	1807358	g6736	i0	78.6	0.272727272727273	28	6	27.3	0	306	223	369	396	BAU64617.1 fibro-slime family protein [Stanieria sp. NIES-3757]	diamond	84	48.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria sp. NIES-3757
31614434	31614434	PRJEB76780_P_NODE_2476_length_522_cov_1.211581_g2376_i0	PRJEB76780	2476	522	1.211581	6.32445282	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	107	1.5899999999999995e-23	NR	HEY9692014.1	3088181	g2376	i0	50.5	2.56896551724138	109	50	60.3	2	466	152	282	390	HEY9692014.1 PAS domain-containing protein [Oculatellaceae cyanobacterium]	diamond	1341	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium

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