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

8 rows where analysis = "diamond", bioproject = "PRJNA789095" 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
27622566	27622566	PRJNA789095_P_NODE_41844_length_310_cov_3.286920_g40510_i0	PRJNA789095	41844	310	3.28692	10.189452	Cyanobacteria bacterium J06649_11	3023232	Bacteria	Bacteria	43.5	0.0176	NR	MEO0687191.1	3023232	g40510	i0	30.6	0.696774193548387	72	44	69.7	1	303	88	2	67	MEO0687191.1 YbjN domain-containing protein [Cyanobacteria bacterium J06649_11]	diamond	216	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06649_11
27780417	27780417	PRJNA789095_P_NODE_79584_length_226_cov_2.875817_g78250_i0	PRJNA789095	79584	226	2.875817	6.49934642	Cyanobacteria bacterium J06553_1	3023125	Bacteria	Bacteria	63.5	6.58e-10	NR	MEL7523216.1	3023125	g78250	i0	58.8	0.676991150442478	51	21	67.7	0	69	221	122	172	MEL7523216.1 endonuclease/exonuclease/phosphatase family protein [Cyanobacteria bacterium J06553_1]	diamond	153	63.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06553_1
29832578	29832578	PRJNA789095_P_NODE_71171_length_245_cov_6.133721_g69837_i0	PRJNA789095	71171	245	6.133721	15.02761645	Cyanobacteria bacterium J06553_1	3023125	Bacteria	Bacteria	75.1	1.53e-13	NR	MEL7520422.1	3023125	g69837	i0	68.9	0.551020408163265	45	14	55.1	0	244	110	367	411	MEL7520422.1 reverse transcriptase family protein [Cyanobacteria bacterium J06553_1]	diamond	135	75.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06553_1
30116794	30116794	PRJNA789095_P_NODE_41232_length_310_cov_4.388186_g39898_i0	PRJNA789095	41232	310	4.388186	13.6033766	Cyanobacteria bacterium J06553_1	3023125	Bacteria	Bacteria	58.2	3.2e-7	NR	MEL7520422.1	3023125	g39898	i0	63	0.445161290322581	46	15	42.6	1	178	309	651	696	MEL7520422.1 reverse transcriptase family protein [Cyanobacteria bacterium J06553_1]	diamond	138	58.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06553_1
30211518	30211518	PRJNA789095_P_NODE_13392_length_783_cov_1.363380_g12157_i0	PRJNA789095	13392	783	1.36338	10.6752654	Cyanobacteria bacterium J06553_1	3023125	Bacteria	Bacteria	290	1.44e-89	NR	MEL7520422.1	3023125	g12157	i0	58.9	1.00766283524904	263	104	99.6	3	781	2	252	513	MEL7520422.1 reverse transcriptase family protein [Cyanobacteria bacterium J06553_1]	diamond	789	290	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06553_1
30780406	30780406	PRJNA789095_P_NODE_67934_length_249_cov_0.875000_g66600_i0	PRJNA789095	67934	249	0.875	2.17875	Hydrococcus sp. SU_1_0	2720475	Bacteria	Bacteria	76.6	2.28e-14	NR	NJL51449.1	2720475	g66600	i0	51.8	1	83	39	98.8	1	3	248	73	155	NJL51449.1 hypothetical protein [Hydrococcus sp. SU_1_0]	diamond	249	76.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hydrococcaceae	Hydrococcus	Hydrococcus sp. SU_1_0
31285905	31285905	PRJNA789095_P_NODE_11555_length_893_cov_7.596341_g10396_i0	PRJNA789095	11555	893	7.596341	67.83532513	Hydrococcus sp. SU_1_0	2720475	Bacteria	Bacteria	64.7	7.71e-8	NR	NJL51449.1	2720475	g10396	i0	48.3	0.201567749160134	60	31	20.2	0	610	789	222	281	NJL51449.1 hypothetical protein [Hydrococcus sp. SU_1_0]	diamond	180	64.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hydrococcaceae	Hydrococcus	Hydrococcus sp. SU_1_0
32393306	32393306	PRJNA789095_P_NODE_60559_length_262_cov_1.867725_g59225_i0	PRJNA789095	60559	262	1.867725	4.8934395	Aphanothece sp. CMT-3BRIN-NPC111	2839655	Bacteria	Bacteria	114	2.57e-29	NR	MBW4575085.1	2839655	g59225	i0	90.3	0.709923664122137	62	6	71	0	188	3	14	75	MBW4575085.1 sulfate ABC transporter permease subunit CysT [Aphanothece sp. CMT-3BRIN-NPC111]	diamond	186	114	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Aphanothece	Aphanothece sp. CMT-3BRIN-NPC111

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