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

12 rows where analysis = "diamond", bioproject = "PRJNA358490" 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
4901144	4901144	PRJNA358490_P_NODE_13224_length_215_cov_2.238636_g12880_i0	PRJNA358490	13224	215	2.238636	4.8130674	Aetokthonos hydrillicola	1550245	Bacteria	Bacteria	115	6.38e-32	NR	WP_208344208.1	1550245	g12880	i0	93.3	0.837209302325581	60	4	83.7	0	31	210	1	60	WP_208344208.1 type II toxin-antitoxin system HicA family toxin [Aetokthonos hydrillicola]	diamond	180	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Hapalosiphonaceae	Aetokthonos	Aetokthonos hydrillicola
13152816	13152816	PRJNA358490_P_NODE_5531_length_577_cov_3.072491_g5230_i0	PRJNA358490	5531	577	3.072491	17.72827307	Cyanophyceae	3028117	Bacteria	Bacteria	100	1.73e-22	NR	WP_048017771.1	1662190	g5230	i0	72.2	5.97920277296361	72	17	37.4	1	22	237	89	157	WP_048017771.1 transketolase C-terminal domain-containing protein, partial [Synechococcus sp. GFB01]	diamond	3450	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. GFB01
18250703	18250703	PRJNA358490_P_NODE_4035_length_704_cov_1.765414_g3807_i0	PRJNA358490	4035	704	1.765414	12.42851456	Dolichospermum sp.	2720786	Bacteria	Bacteria	82	6.61e-14	NR	MFN9405480.1	2720786	g3807	i0	64.1	1.08238636363636	64	23	27.3	0	1	192	317	380	MFN9405480.1 VWD domain-containing protein [Dolichospermum sp.]	diamond	762	82	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum sp.
24625298	24625298	PRJNA358490_P_NODE_40_length_3107_cov_4.366362_g36_i0	PRJNA358490	40	3107	4.366362	135.66286734	Stigonema ocellatum	221293	Bacteria	Bacteria	1035	0	NR	MBR8841076.1	221294	g36	i0	85	0.579336981010621	600	90	57.9	0	1820	21	250	849	MBR8841076.1 Tn3 family transposase [Stigonema ocellatum SAG 48.90 = DSM 106950]	diamond	1800	1035	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Stigonemataceae	Stigonema	Stigonema ocellatum
26821855	26821855	PRJNA358490_P_NODE_6941_length_488_cov_2.463252_g6609_i0	PRJNA358490	6941	488	2.463252	12.02066976	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	262	5.96e-80	NR	MBY0497111.1	2847862	g6609	i0	82.1	0.995901639344262	162	25	99.6	1	1	486	183	340	MBY0497111.1 penicillin acylase family protein [Cyanobacteriota bacterium]	diamond	486	262	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27201090	27201090	PRJNA358490_P_NODE_5682_length_566_cov_4.679317_g5376_i0	PRJNA358490	5682	566	4.679317	26.48493422	Cyanobacteria bacterium Co-bin13	2768923	Bacteria	Bacteria	110	6.53e-26	NR	MBD0335310.1	2768923	g5376	i0	50.8	0.625441696113074	118	55	61	1	414	70	160	277	MBD0335310.1 class I SAM-dependent methyltransferase [Cyanobacteria bacterium Co-bin13]	diamond	354	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium Co-bin13
27359507	27359507	PRJNA358490_P_NODE_283_length_1875_cov_4.273965_g255_i0	PRJNA358490	283	1875	4.273965	80.13684375	Cyanobacteria bacterium SZAS-4	2807733	Bacteria	Bacteria	1032	0	NR	MBS1953979.1	2807733	g255	i0	88.5	0.9856	616	71	98.6	0	21	1868	287	902	MBS1953979.1 hypothetical protein [Cyanobacteria bacterium SZAS-4]	diamond	1848	1032	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS-4
29727133	29727133	PRJNA358490_P_NODE_3550_length_758_cov_2.082058_g3327_i0	PRJNA358490	3550	758	2.082058	15.78199964	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	185	1.01e-49	NR	MBY0497111.1	2847862	g3327	i0	77.5	0.474934036939314	120	27	47.5	0	178	537	1	120	MBY0497111.1 penicillin acylase family protein [Cyanobacteriota bacterium]	diamond	360	185	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
30422806	30422806	PRJNA358490_P_NODE_4273_length_681_cov_2.096573_g4028_i0	PRJNA358490	4273	681	2.096573	14.27766213	Coleofasciculaceae cyanobacterium	3081323	Bacteria	Bacteria	64.3	7.01e-9	NR	HEY9770896.1	3081323	g4028	i0	33.3	1.31277533039648	147	91	63.9	3	103	537	1	142	HEY9770896.1 2TM domain-containing protein [Coleofasciculaceae cyanobacterium]	diamond	894	64.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae		Coleofasciculaceae cyanobacterium
30850220	30850220	PRJNA358490_P_NODE_14514_length_190_cov_1.562914_g14170_i0	PRJNA358490	14514	190	1.562914	2.9695366	Nostocales	1161	Bacteria	Bacteria	110	1.39e-26	NR	MEB3179044.1	2723028	g14170	i0	87.1	2.93684210526316	62	8	97.9	0	188	3	300	361	MEB3179044.1 TldD/PmbA family protein [Nostocaceae cyanobacterium]	diamond	558	111	0.990990990990991	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae		Nostocaceae cyanobacterium
31324254	31324254	PRJNA358490_P_NODE_1475_length_1120_cov_2.169288_g1358_i0	PRJNA358490	1475	1120	2.169288	24.2960256	Coleofasciculaceae	1892251	Bacteria	Bacteria	163	3.57e-40	NR	NER48745.1	2607766	g1358	i0	79.8	3.20892857142857	114	23	30.5	0	24	365	837	950	NER48745.1 GAF domain-containing protein [Symploca sp. SIO1A3]	diamond	3594	164	0.99390243902439	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Symploca	Symploca sp. SIO1A3
31939690	31939690	PRJNA358490_P_NODE_13197_length_216_cov_1.604520_g12853_i0	PRJNA358490	13197	216	1.60452	3.4657632	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	103	7.69e-25	NR	HEY9782343.1	3088178	g12853	i0	62	0.986111111111111	71	27	98.6	0	3	215	79	149	HEY9782343.1 hypothetical protein [Leptolyngbyaceae cyanobacterium]	diamond	213	103	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae 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);;