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

15 rows where analysis = "diamond", bioproject = "PRJNA505329" 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
19609179	19609179	PRJNA505329_P_NODE_13176_length_233_cov_2.918478_g12705_i0	PRJNA505329	13176	233	2.918478	6.80005374	Pleurocapsa sp. SU_196_0	2720476	Bacteria	Bacteria	89	1.46e-19	NR	NJK46683.1	2720476	g12705	i0	56.1	1.2618025751073	98	22	99.1	2	232	2	17	114	NJK46683.1 cell division protein ZapE [Pleurocapsa sp. SU_196_0]	diamond	294	89	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. SU_196_0
26617718	26617718	PRJNA505329_P_NODE_29021_length_188_cov_4.791367_g28550_i0	PRJNA505329	29021	188	4.791367	9.00776996	Microcoleus	44471	Bacteria	Bacteria	55.1	8.07e-7	NR	WP_373536476.1	44472	g28550	i0	46.6	15.9893617021277	58	27	87.8	2	20	184	2051	2107	WP_373536476.1 amino acid adenylation domain-containing protein [Microcoleus sp.]	diamond	3006	55.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp.
27487943	27487943	PRJNA505329_P_NODE_38663_length_174_cov_1.640000_g38192_i0	PRJNA505329	38663	174	1.64	2.8536	Synechococcales cyanobacterium CRU_2_2	2720405	Bacteria	Bacteria	79	3.34e-16	NR	NJR67822.1	2720405	g38192	i0	86.8	1.29310344827586	38	5	65.5	0	173	60	181	218	NJR67822.1 class I SAM-dependent methyltransferase [Synechococcales cyanobacterium CRU_2_2]	diamond	225	79	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales			Synechococcales cyanobacterium CRU_2_2
28466814	28466814	PRJNA505329_P_NODE_33326_length_182_cov_2.308271_g32855_i0	PRJNA505329	33326	182	2.308271	4.20105322	Leptodesmis sichuanensis	2906798	Bacteria	Bacteria	107	1.91e-25	NR	WP_233748098.1	2906798	g32855	i0	91.5	0.972527472527473	59	5	97.3	0	4	180	28	86	WP_233748098.1 AAA family ATPase [Leptodesmis sichuanensis]	diamond	177	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptodesmis	Leptodesmis sichuanensis
29193029	29193029	PRJNA505329_P_NODE_12189_length_233_cov_3.233696_g11718_i0	PRJNA505329	12189	233	3.233696	7.53451168	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	68.9	2.42e-12	NR	WP_009630127.1	927677	g11718	i0	90.6	0.824034334763948	32	3	41.2	0	135	230	78	109	WP_009630127.1 hypothetical protein [Synechocystis sp. PCC 7509]	diamond	192	68.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
29571657	29571657	PRJNA505329_P_NODE_36790_length_177_cov_1.601562_g36319_i0	PRJNA505329	36790	177	1.601562	2.83476474	Leptolyngbyaceae cyanobacterium C42_A2020_001	2811131	Bacteria	Bacteria	55.1	6.99e-7	NR	MBF2029820.1	2811131	g36319	i0	76.5	1.72881355932203	34	8	57.6	0	1	102	604	637	MBF2029820.1 PTS transporter subunit EIIC [Leptolyngbyaceae cyanobacterium C42_A2020_001]	diamond	306	55.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium C42_A2020_001
29681592	29681592	PRJNA505329_P_NODE_23030_length_199_cov_3.386667_g22559_i0	PRJNA505329	23030	199	3.386667	6.73946733	Bacillati	1783272	Bacteria	Bacteria	58.5	5.72e-8	NR	WP_187758643.1	54297	g22559	i0	43.8	1.79396984924623	64	36	96.5	0	5	196	1978	2041	WP_187758643.1 tetratricopeptide repeat protein [Limnospira fusiformis]	diamond	357	58.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira fusiformis
29792609	29792609	PRJNA505329_P_NODE_24471_length_195_cov_4.671233_g24000_i0	PRJNA505329	24471	195	4.671233	9.10890435	Candidatus Melainabacteria bacterium HGW-Melainabacteria-1	2013813	Bacteria	Bacteria	58.5	5.41e-8	NR	PKL75867.1	2013813	g24000	i0	52.5	0.907692307692308	59	27	90.8	1	195	19	383	440	PKL75867.1 MAG: hypothetical protein CVV27_13150, partial [Candidatus Melainabacteria bacterium HGW-Melainabacteria-1]	diamond	177	58.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium HGW-Melainabacteria-1
29824171	29824171	PRJNA505329_P_NODE_20171_length_201_cov_3.934211_g19700_i0	PRJNA505329	20171	201	3.934211	7.90776411	Leptodesmis sichuanensis	2906798	Bacteria	Bacteria	59.7	2.19e-8	NR	WP_233744923.1	2906798	g19700	i0	84.8	0.492537313432836	33	5	49.3	0	101	199	55	87	WP_233744923.1 FAD-dependent oxidoreductase [Leptodesmis sichuanensis]	diamond	99	59.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptodesmis	Leptodesmis sichuanensis
29887662	29887662	PRJNA505329_P_NODE_43491_length_168_cov_0.873950_g43020_i0	PRJNA505329	43491	168	0.87395	1.468236	Leptodesmis sichuanensis	2906798	Bacteria	Bacteria	97.1	2.3499999999999994e-23	NR	WP_233745239.1	2906798	g43020	i0	81.8	0.982142857142857	55	10	98.2	0	167	3	143	197	WP_233745239.1 molybdenum cofactor guanylyltransferase [Leptodesmis sichuanensis]	diamond	165	97.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptodesmis	Leptodesmis sichuanensis
30425074	30425074	PRJNA505329_P_NODE_15213_length_233_cov_2.652174_g14742_i0	PRJNA505329	15213	233	2.652174	6.17956542	Leptolyngbyaceae cyanobacterium bins.349	2971803	Bacteria	Bacteria	62.8	2.85e-9	NR	MDX2230559.1	2971803	g14742	i0	87.9	0.424892703862661	33	4	42.5	0	101	3	647	679	MDX2230559.1 CHAT domain-containing protein [Leptolyngbyaceae cyanobacterium bins.349]	diamond	99	62.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium bins.349
30534836	30534836	PRJNA505329_P_NODE_29493_length_188_cov_1.482014_g29022_i0	PRJNA505329	29493	188	1.482014	2.78618632	Cyanophyceae	3028117	Bacteria	Bacteria	118	2.17e-29	NR	WP_002755764.1	1125	g29022	i0	98.4	178.085106382979	62	1	98.9	0	186	1	361	422	WP_002755764.1 MULTISPECIES: chaperonin GroEL [Microcystis]	diamond	33480	119	0.991596638655462	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis
30645599	30645599	PRJNA505329_P_NODE_51773_length_155_cov_4.075472_g51302_i0	PRJNA505329	51773	155	4.075472	6.3169816	Nodosilinea nodulosa	416001	Bacteria	Bacteria	40.4	0.0242	NR	WP_017298926.1	416001	g51302	i0	47.1	0.658064516129032	34	18	65.8	0	138	37	23	56	WP_017298926.1 hypothetical protein [Nodosilinea nodulosa]	diamond	102	40.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea nodulosa
30993423	30993423	PRJNA505329_P_NODE_31154_length_185_cov_3.014706_g30683_i0	PRJNA505329	31154	185	3.014706	5.5772061	Nostoc punctiforme	272131	Bacteria	Bacteria	116	1.6499999999999999e-28	NR	WP_190949437.1	272131	g30683	i0	87.5	1.03783783783784	64	5	98.9	1	183	1	253	316	WP_190949437.1 beta strand repeat-containing protein [Nostoc punctiforme]	diamond	192	116	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
32163693	32163693	PRJNA505329_P_NODE_50378_length_161_cov_2.750000_g49907_i0	PRJNA505329	50378	161	2.75	4.4275	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	96.7	4.78e-22	NR	WP_009633426.1	927677	g49907	i0	92.3	0.968944099378882	52	4	96.9	0	6	161	291	342	WP_009633426.1 glycosyltransferase family 4 protein [Synechocystis sp. PCC 7509]	diamond	156	96.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509

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