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

9 rows where analysis = "diamond", bioproject = "PRJNA690124" 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
14698419	14698419	PRJNA690124_P_NODE_43672_length_253_cov_0.866667_g43306_i0	PRJNA690124	43672	253	0.866667	2.19266751	Oscillatoriaceae cyanobacterium	2664179	Bacteria	Bacteria	89.4	3.06e-19	NR	HEY9724626.1	2664179	g43306	i0	61	1.99209486166008	82	29	97.2	1	6	251	130	208	HEY9724626.1 response regulator [Oscillatoriaceae cyanobacterium]	diamond	504	89.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae		Oscillatoriaceae cyanobacterium
26987333	26987333	PRJNA690124_P_NODE_45362_length_251_cov_0.876404_g44996_i0	PRJNA690124	45362	251	0.876404	2.19977404	Leptolyngbya sp. KIOST-1	1229172	Bacteria	Bacteria	168	1.59e-47	NR	WP_263970550.1	1229172	g44996	i0	98.8	0.9800796812749	82	1	98	0	250	5	278	359	WP_263970550.1 transglutaminase-like domain-containing protein [Leptolyngbya sp. KIOST-1]	diamond	246	168	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. KIOST-1
27208587	27208587	PRJNA690124_P_NODE_33222_length_288_cov_1.153488_g32856_i0	PRJNA690124	33222	288	1.153488	3.32204544	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	81.6	1.76e-16	NR	MBY0496793.1	2847862	g32856	i0	100	0.385416666666667	37	0	38.5	0	288	178	194	230	MBY0496793.1 TRAP transporter TatT component family protein [Cyanobacteriota bacterium]	diamond	111	81.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27587981	27587981	PRJNA690124_P_NODE_51224_length_246_cov_0.901734_g50858_i0	PRJNA690124	51224	246	0.901734	2.21826564	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	47.4	9.16e-4	NR	MBC7474511.1	2762020	g50858	i0	46.5	0.865853658536585	71	31	80.5	2	219	22	455	523	MBC7474511.1 IS200/IS605 family element transposase accessory protein TnpB [Candidatus Sericytochromatia bacterium]	diamond	213	47.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
27998524	27998524	PRJNA690124_P_NODE_34025_length_285_cov_0.990566_g33659_i0	PRJNA690124	34025	285	0.990566	2.8231131	unclassified Synechococcus	2626047	Bacteria	Bacteria	106	5.35e-28	NR	WP_255131134.1	2626047	g33659	i0	91.8	0.642105263157895	61	5	64.2	0	99	281	1	61	WP_255131134.1 MULTISPECIES: DUF2862 domain-containing protein [unclassified Synechococcus]	diamond	183	106	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus
28388647	28388647	PRJNA690124_P_NODE_526_length_1674_cov_3.620237_g439_i0	PRJNA690124	526	1674	3.620237	60.60276738	root	1	Root_unresolved	Root_unresolved	235	2.76e-69	NR	WP_104396736.1	1125	g439	i0	43.9	2.52329749103943	285	154	50.2	4	1609	770	2	285	WP_104396736.1 MULTISPECIES: follicular epithelium yolk protein subunit [Microcystis]	diamond	4224	237	0.991561181434599	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis
28630031	28630031	PRJNA690124_P_NODE_52807_length_245_cov_0.906977_g52441_i0	PRJNA690124	52807	245	0.906977	2.22209365	Synechococcus sp.	1131	Bacteria	Bacteria	125	2.44e-35	NR	MEB3270085.1	1131	g52441	i0	78.8	0.979591836734694	80	17	98	0	2	241	19	98	MEB3270085.1 DUF1257 domain-containing protein [Synechococcus sp.]	diamond	240	125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp.
29387748	29387748	PRJNA690124_P_NODE_34909_length_281_cov_1.500000_g34543_i0	PRJNA690124	34909	281	1.5	4.215	Crocosphaera sp.	2729996	Bacteria	Bacteria	43.9	0.0231	NR	MDJ0661407.1	2729996	g34543	i0	31.6	0.811387900355872	76	50	79	1	236	15	206	281	MDJ0661407.1 NACHT domain-containing protein [Crocosphaera sp.]	diamond	228	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Crocosphaera	Crocosphaera sp.
29829580	29829580	PRJNA690124_P_NODE_34211_length_284_cov_1.165877_g33845_i0	PRJNA690124	34211	284	1.165877	3.31109068	Synechococcus sp. UW14	1131	Bacteria	Bacteria	209	1.45e-61	NR	WP_341882169.1	368503	g33845	i0	97.9	0.992957746478873	94	2	99.3	0	2	283	80	173	WP_341882169.1 1,4-alpha-glucan branching protein GlgB [Synechococcus sp. UW140]	diamond	282	209	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. UW140

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