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

11 rows where analysis = "diamond", bioproject = "PRJNA1174234" 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
26616499	26616499	PRJNA1174234_P_NODE_22101_length_293_cov_2.754545_g21905_i0	PRJNA1174234	22101	293	2.754545	8.07081685	Bacillati	1783272	Bacteria	Bacteria	102	1.36e-23	NR	WP_015134806.1	111781	g21905	i0	66.2	8.38566552901024	74	25	75.8	0	71	292	2	75	WP_015134806.1 cysteine synthase A [[Leptolyngbya] sp. PCC 7376]	diamond	2457	103	0.990291262135922	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	[Leptolyngbya] sp. PCC 7376
26648024	26648024	PRJNA1174234_P_NODE_28921_length_251_cov_1.640449_g28725_i0	PRJNA1174234	28921	251	1.640449	4.11752699	Nostocales	1161	Bacteria	Bacteria	133	7.09e-35	NR	MBW4635042.1	1494767	g28725	i0	78.3	4.9601593625498	83	18	99.2	0	250	2	21	103	MBW4635042.1 MFS transporter [Iphinoe sp. HA4291-MV1]	diamond	1245	133	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Stigonemataceae	Iphinoe	Iphinoe sp. HA4291-MV1
26977224	26977224	PRJNA1174234_P_NODE_30982_length_248_cov_0.880000_g30786_i0	PRJNA1174234	30982	248	0.88	2.1824	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	142	2.52e-37	NR	WP_009631933.1	927677	g30786	i0	89	0.991935483870968	82	9	99.2	0	248	3	36	117	WP_009631933.1 beta strand repeat-containing protein [Synechocystis sp. PCC 7509]	diamond	246	142	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
28619787	28619787	PRJNA1174234_P_NODE_15167_length_354_cov_1.370107_g14971_i0	PRJNA1174234	15167	354	1.370107	4.85017878	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	60.5	4.57e-8	NR	MSR89129.1	2053573	g14971	i0	35.9	0.779661016949153	92	55	77.1	2	4	276	71	159	MSR89129.1 DUF1295 domain-containing protein [Candidatus Margulisiibacteriota bacterium]	diamond	276	60.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
28840532	28840532	PRJNA1174234_P_NODE_19228_length_315_cov_0.954545_g19032_i0	PRJNA1174234	19228	315	0.954545	3.00681675	unclassified Leptolyngbya	2650499	Bacteria	Bacteria	64.3	8.68e-10	NR	WP_190774651.1	2650499	g19032	i0	37.7	1.2	69	43	65.7	0	87	293	136	204	WP_190774651.1 MULTISPECIES: glutathione S-transferase family protein [unclassified Leptolyngbya]	diamond	378	64.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya
29156614	29156614	PRJNA1174234_P_NODE_24509_length_278_cov_1.214634_g24313_i0	PRJNA1174234	24509	278	1.214634	3.37668252	Calothrix sp. CCY 0018	3103864	Bacteria	Bacteria	62	9.12e-9	NR	WP_414625200.1	3103864	g24313	i0	33.8	1.80215827338129	77	51	83.1	0	239	9	369	445	WP_414625200.1 protein kinase domain-containing protein [Calothrix sp. CCY 0018]	diamond	501	62	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. CCY 0018
29914397	29914397	PRJNA1174234_P_NODE_31711_length_247_cov_0.885057_g31515_i0	PRJNA1174234	31711	247	0.885057	2.18609079	Nostoc sp.	1180	Bacteria	Bacteria	164	6.6e-45	NR	WP_324981494.1	1180	g31515	i0	96.3	0.983805668016194	81	3	98.4	0	3	245	609	689	WP_324981494.1 AAA family ATPase, partial [Nostoc sp.]	diamond	243	164	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
31968664	31968664	PRJNA1174234_P_NODE_25318_length_273_cov_1.155000_g25122_i0	PRJNA1174234	25318	273	1.155	3.15315	Scytonema sp. HK-	1204	Bacteria	Bacteria	51.2	5.03e-5	NR	WP_143173024.1	1137095	g25122	i0	65.6	0.351648351648352	32	11	35.2	0	272	177	157	188	WP_143173024.1 WD40 repeat domain-containing protein, partial [Scytonema sp. HK-05]	diamond	96	51.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. HK-05
32367838	32367838	PRJNA1174234_P_NODE_11059_length_416_cov_0.892128_g10863_i0	PRJNA1174234	11059	416	0.892128	3.71125248	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	126	7.719999999999998e-32	NR	MBR8839220.1	221294	g10863	i0	46.4	6.07211538461539	138	71	99.5	2	415	2	195	329	MBR8839220.1 alkene reductase [Stigonema ocellatum SAG 48.90 = DSM 106950]	diamond	2526	126	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Stigonemataceae	Stigonema	Stigonema ocellatum
32411848	32411848	PRJNA1174234_P_NODE_32759_length_245_cov_1.343023_g32563_i0	PRJNA1174234	32759	245	1.343023	3.29040635	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	62.4	2e-9	NR	MFN4149726.1	2762020	g32563	i0	46.6	0.710204081632653	58	28	71	1	3	176	175	229	MFN4149726.1 2-hydroxychromene-2-carboxylate isomerase [Candidatus Sericytochromatia bacterium]	diamond	174	62.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
32758857	32758857	PRJNA1174234_P_NODE_4820_length_612_cov_1.730983_g4627_i0	PRJNA1174234	4820	612	1.730983	10.59361596	Dolichospermum sp.	2720786	Bacteria	Bacteria	146	9.94e-40	NR	MFN7661193.1	2720786	g4627	i0	86.4	0.397058823529412	81	11	39.7	0	610	368	41	121	MFN7661193.1 hypothetical protein [Dolichospermum sp.]	diamond	243	146	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum 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);;