metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA917598" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA917598" and tax_phylum = "Cyanobacteriota"

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
27720124	27720124	PRJNA917598_P_NODE_82164_length_250_cov_0.870056_g81220_i0	PRJNA917598	82164	250	0.870056	2.17514	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	114	3.61e-27	NR	HEY9760341.1	3088181	g81220	i0	69.7	0.912	76	22	90	1	226	2	1	76	HEY9760341.1 response regulator [Oculatellaceae cyanobacterium]	diamond	228	114	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
28066905	28066905	PRJNA917598_P_NODE_52665_length_315_cov_1.272727_g51721_i0	PRJNA917598	52665	315	1.272727	4.00909005	Arthrospira platensis Ap-s	118562	Bacteria	Bacteria	202	3.98e-63	NR	ABC46995.1	357682	g51721	i0	98.1	0.990476190476191	104	2	99	0	3	314	70	173	ABC46995.1 chemotaxis signal transduction protein, partial [Arthrospira platensis Ap-s]	diamond	312	202	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
29235230	29235230	PRJNA917598_P_NODE_14789_length_613_cov_1.527778_g13855_i0	PRJNA917598	14789	613	1.527778	9.36527914	Anabaena sp. WA113	1710889	Bacteria	Bacteria	104	3.11e-25	NR	OBQ15776.1	1710889	g13855	i0	57.1	0.411092985318108	84	36	41.1	0	353	102	10	93	OBQ15776.1 MAG: hypothetical protein AN488_20530 [Anabaena sp. WA113]	diamond	252	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena sp. WA113
29961414	29961414	PRJNA917598_P_NODE_42691_length_351_cov_2.582734_g41747_i0	PRJNA917598	42691	351	2.582734	9.06539634	Trichormus sp. M33_DOE_039	2747804	Bacteria	Bacteria	118	2.1000000000000002e-30	NR	HIK06411.1	2747804	g41747	i0	63.3	3.97435897435897	90	31	75.2	1	3	266	144	233	HIK06411.1 CHRD domain-containing protein [Trichormus sp. M33_DOE_039]	diamond	1395	118	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Trichormus	Trichormus sp. M33_DOE_039
30214047	30214047	PRJNA917598_P_NODE_26312_length_450_cov_1.413793_g25368_i0	PRJNA917598	26312	450	1.413793	6.3620685	Limnothrix redekei	132606	Bacteria	Bacteria	186	1.7199999999999998e-54	NR	WP_393011443.1	132606	g25368	i0	83.7	2.76	104	17	69.3	0	449	138	280	383	WP_393011443.1 N-acetyl sugar amidotransferase [Limnothrix redekei]	diamond	1242	186	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Limnothrix	Limnothrix redekei
31098698	31098698	PRJNA917598_P_NODE_14675_length_615_cov_3.121771_g13741_i0	PRJNA917598	14675	615	3.121771	19.19889165	Synechococcus elongatus UTEX 2973	1350461	Bacteria	Bacteria	70.9	1.63e-12	NR	AJD58901.1	1350461	g13741	i0	52.4	0.307317073170732	63	30	30.7	0	343	155	1	63	AJD58901.1 hypothetical protein M744_10830 [Synechococcus elongatus UTEX 2973]	diamond	189	70.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus elongatus
31383594	31383594	PRJNA917598_P_NODE_92736_length_243_cov_0.905882_g91792_i0	PRJNA917598	92736	243	0.905882	2.20129326	Microcoleus sp. SM1_3_4	2720457	Bacteria	Bacteria	54.7	4.63e-7	NR	NJL66832.1	2720457	g91792	i0	43.5	2.2962962962963	62	31	76.5	1	1	186	18	75	NJL66832.1 hypothetical protein [Microcoleus sp. SM1_3_4]	diamond	558	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. SM1_3_4
31667994	31667994	PRJNA917598_P_NODE_24677_length_465_cov_2.198980_g23734_i0	PRJNA917598	24677	465	2.19898	10.225257	Planktothrix mougeotii	54306	Bacteria	Bacteria	96.3	2.5300000000000003e-21	NR	WP_193869616.1	54306	g23734	i0	47.4	2.4258064516129	95	50	61.3	0	172	456	1	95	WP_193869616.1 macro domain-containing protein [Planktothrix mougeotii]	diamond	1128	96.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix mougeotii
31770257	31770257	PRJNA917598_P_NODE_88317_length_246_cov_0.890173_g87373_i0	PRJNA917598	88317	246	0.890173	2.18982558	Cyanophyceae	3028117	Bacteria	Bacteria	100	1.53e-22	NR	WP_017719947.1	1173028	g87373	i0	90.4	1.26829268292683	52	5	63.4	0	246	91	398	449	WP_017719947.1 TldD/PmbA family protein [Oscillatoria sp. PCC 10802]	diamond	312	101	0.99009900990099	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria sp. PCC 10802
32711385	32711385	PRJNA917598_P_NODE_37680_length_374_cov_1.279070_g36736_i0	PRJNA917598	37680	374	1.27907	4.7837218	Rivularia sp. MS3	3012223	Bacteria	Bacteria	46.6	0.00683	NR	MBV6621788.1	3012223	g36736	i0	39.6	1.0668449197861	48	29	38.5	0	267	124	456	503	MBV6621788.1 cellulase family glycosylhydrolase [Rivularia sp. MS3]	diamond	399	46.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Rivulariaceae	Rivularia	Rivularia sp. MS3
32907601	32907601	PRJNA917598_P_NODE_76220_length_258_cov_1.670270_g75276_i0	PRJNA917598	76220	258	1.67027	4.3092966	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	145	5.9099999999999996e-40	NR	WP_115016674.1	368503	g75276	i0	78.6	8.81395348837209	84	18	97.7	0	5	256	7	90	WP_115016674.1 GDP-mannose 4,6-dehydratase [Synechococcus sp. UW140]	diamond	2274	146	0.993150684931507	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);;