metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA557436" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA557436" 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
27236822	27236822	PRJNA557436_S_NODE_1843_length_274_cov_3.104603_g1795_i0	PRJNA557436	1843	274	3.104603	8.50661222	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	58.5	1.38e-7	NR	HEY9745493.1	3088181	g1795	i0	45.9	0.667883211678832	61	32	65.7	1	221	42	2	62	HEY9745493.1 RNA ligase [Oculatellaceae cyanobacterium]	diamond	183	58.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
27236833	27236833	PRJNA557436_S_NODE_5803_length_175_cov_1.178571_g5755_i0	PRJNA557436	5803	175	1.178571	2.06249925	Limnospira platensis	118562	Bacteria	Bacteria	75.1	2.5e-15	NR	MDV7395081.1	3080829	g5755	i0	58.6	0.994285714285714	58	23	97.7	1	1	171	19	76	MDV7395081.1 hypothetical protein [Arthrospira platensis SPKY1]	diamond	174	75.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
27363591	27363591	PRJNA557436_S_NODE_3003_length_223_cov_1.627660_g2955_i0	PRJNA557436	3003	223	1.62766	3.6296818	Limnospira platensis	118562	Bacteria	Bacteria	51.6	3.41e-6	NR	MDV7396614.1	3080829	g2955	i0	45.5	1.80269058295964	66	33	88.8	1	21	218	39	101	MDV7396614.1 hypothetical protein [Arthrospira platensis SPKY1]	diamond	402	51.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
27679402	27679402	PRJNA557436_S_NODE_7804_length_159_cov_1.274194_g7756_i0	PRJNA557436	7804	159	1.274194	2.02596846	Microcoleus sp. herbarium19	3055440	Bacteria	Bacteria	67.4	5.58e-12	NR	WP_333272797.1	3055440	g7756	i0	64.7	1.92452830188679	51	17	96.2	1	2	154	31	80	WP_333272797.1 hypothetical protein [Microcoleus sp. herbarium19]	diamond	306	67.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. herbarium19
27773964	27773964	PRJNA557436_S_NODE_1824_length_275_cov_2.816667_g1776_i0	PRJNA557436	1824	275	2.816667	7.74583425	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	58.2	1.57e-7	NR	MFN5119220.1	2847862	g1776	i0	67.9	0.610909090909091	56	17	61.1	1	4	171	171	225	MFN5119220.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	168	58.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27899892	27899892	PRJNA557436_S_NODE_2485_length_241_cov_1.694175_g2437_i0	PRJNA557436	2485	241	1.694175	4.08296175	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	47	1.09e-4	NR	MFM1842232.1	2847862	g2437	i0	73.1	0.323651452282158	26	7	32.4	0	163	240	13	38	MFM1842232.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	78	47	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28721095	28721095	PRJNA557436_S_NODE_4047_length_199_cov_1.432927_g3999_i0	PRJNA557436	4047	199	1.432927	2.85152473	Aphanizomenon flos-aquae WA1	1176	Bacteria	Bacteria	102	9.329999999999999e-24	NR	OBQ43526.1	1710896	g3999	i0	72.7	1.98994974874372	66	18	99.5	0	199	2	208	273	OBQ43526.1 MAG: hypothetical protein AN484_11950 [Aphanizomenon flos-aquae WA102]	diamond	396	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Aphanizomenon	Aphanizomenon flos-aquae
29068494	29068494	PRJNA557436_S_NODE_8588_length_154_cov_2.016807_g8540_i0	PRJNA557436	8588	154	2.016807	3.10588278	Cyanobacteria bacterium K_DeepCast_35m_m2_023	2775549	Bacteria	Bacteria	64.7	6.96e-11	NR	MBM5800586.1	2775549	g8540	i0	69	0.818181818181818	42	13	81.8	0	130	5	61	102	MBM5800586.1 hypothetical protein [Cyanobacteria bacterium K_DeepCast_35m_m2_023]	diamond	126	64.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium K_DeepCast_35m_m2_023
30332100	30332100	PRJNA557436_S_NODE_592_length_458_cov_1.886525_g544_i0	PRJNA557436	592	458	1.886525	8.6402845	Microcystis sp. M	1127	Bacteria	Bacteria	89.4	3.93e-20	NR	WP_287873660.1	2771111	g544	i0	54	0.569868995633188	87	37	57	2	107	367	2	85	WP_287873660.1 hypothetical protein [Microcystis sp. M034S1]	diamond	261	89.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. M034S1
30963625	30963625	PRJNA557436_S_NODE_1634_length_290_cov_2.925490_g1586_i0	PRJNA557436	1634	290	2.92549	8.483921	Pseudanabaena sp.	1153	Bacteria	Bacteria	124	2.2799999999999998e-32	NR	MFN9051406.1	1153	g1586	i0	68.1	0.941379310344828	91	29	94.1	0	288	16	31	121	MFN9051406.1 hypothetical protein [Pseudanabaena sp.]	diamond	273	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp.
31532756	31532756	PRJNA557436_S_NODE_1196_length_334_cov_1.779264_g1148_i0	PRJNA557436	1196	334	1.779264	5.94274176	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	62.8	4.81e-9	NR	ARV61587.1	1940762	g1148	i0	46.8	2.12874251497006	77	36	69.2	1	329	99	167	238	ARV61587.1 hypothetical protein BZZ01_25810 [Nostocales cyanobacterium HT-58-2]	diamond	711	62.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
32323832	32323832	PRJNA557436_S_NODE_2279_length_251_cov_1.736111_g2231_i0	PRJNA557436	2279	251	1.736111	4.35763861	Leptolyngbya sp. PCC 7375	102129	Bacteria	Bacteria	40.8	0.0275	NR	EKU97980.1	102129	g2231	i0	30.2	0.752988047808765	63	44	75.3	0	195	7	1	63	EKU97980.1 hypothetical protein Lepto7375DRAFT_7239 [Leptolyngbya sp. PCC 7375]	diamond	189	40.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. PCC 7375
32639251	32639251	PRJNA557436_S_NODE_580_length_463_cov_2.546729_g532_i0	PRJNA557436	580	463	2.546729	11.79135527	Lyngbya sp. HA4199-MV5	2835090	Bacteria	Bacteria	65.9	2.55e-9	NR	MBW4694177.1	2835090	g532	i0	78.4	0.239740820734341	37	8	24	0	349	459	2	38	MBW4694177.1 macro domain-containing protein [Lyngbya sp. HA4199-MV5]	diamond	111	65.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Lyngbya	Lyngbya sp. HA4199-MV5

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