metadata: contig_metadata: 13 rows where bioproject = "PRJNA400171" and tax

13 rows where bioproject = "PRJNA400171" 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
8067278	8067278	PRJNA400171_S_NODE_9267_length_151_cov_2.139344_g9177_i0	PRJNA400171	9267	151	2.139344	3.23040944	uncultured Cyanobacterium sp.	751952	Bacteria	Bacteria	274	2.42e-69	NTclustered	gi\|375112276\|gb\|JQ071830.1\|	751952	g9177	i0	99.342	103.026490066225	152	0	100	1	1	151	102	253	Uncultured Cyanobacterium sp. clone JJD39 16S ribosomal RNA gene, partial sequence	blastn	15557	274	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Cyanobacterium	uncultured Cyanobacterium sp.
10617791	10617791	PRJNA400171_S_NODE_7629_length_165_cov_1.889706_g7539_i0	PRJNA400171	7629	165	1.889706	3.1180149	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	278	2.09e-70	NTclustered	gi\|225696206\|gb\|FJ805873.1\|	259957	g7539	i0	96.97	100.090909090909	165	5	100	0	1	165	973	809	Uncultured Chroococcidiopsis sp. clone A2_15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	16515	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
27075394	27075394	PRJNA400171_S_NODE_3722_length_218_cov_2.439153_g3632_i0	PRJNA400171	3722	218	2.439153	5.31735354	Pannus brasiliensis	1579216	Bacteria	Bacteria	58.5	7.15e-8	NR	WP_332866389.1	1579216	g3632	i0	32.4	1.95412844036697	71	48	97.7	0	213	1	208	278	WP_332866389.1 ATP-dependent nuclease [Pannus brasiliensis]	diamond	426	58.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Pannus	Pannus brasiliensis
27345204	27345204	PRJNA400171_S_NODE_5443_length_189_cov_2.250000_g5353_i0	PRJNA400171	5443	189	2.25	4.2525	Nostocales	1161	Bacteria	Bacteria	95.1	3.18e-21	NR	WP_321206680.1	457083	g5353	i0	75.4	4.85714285714286	61	15	96.8	0	3	185	217	277	WP_321206680.1 CgeB family protein [Tolypothrix tenuis]	diamond	918	95.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix tenuis
28623024	28623024	PRJNA400171_S_NODE_5287_length_191_cov_2.561728_g5197_i0	PRJNA400171	5287	191	2.561728	4.89290048	Anabaena lutea	212350	Bacteria	Bacteria	84	5.55e-17	NR	WP_190711624.1	212350	g5197	i0	63.1	2.04188481675393	65	22	99	1	1	189	446	510	WP_190711624.1 ATP-dependent nuclease [Anabaena lutea]	diamond	390	84	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena lutea
28734376	28734376	PRJNA400171_S_NODE_1807_length_280_cov_3.374502_g1717_i0	PRJNA400171	1807	280	3.374502	9.4486056	Bacillati	1783272	Bacteria	Bacteria	112	1.15e-26	NR	WP_190711624.1	212350	g1717	i0	54.9	9.87857142857143	91	40	96.4	1	9	278	363	453	WP_190711624.1 ATP-dependent nuclease [Anabaena lutea]	diamond	2766	112	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena lutea
29695999	29695999	PRJNA400171_S_NODE_5250_length_191_cov_4.228395_g5160_i0	PRJNA400171	5250	191	4.228395	8.07623445	Nodosilinea sp. LEGE	2497642	Bacteria	Bacteria	53.1	3.77e-6	NR	WP_194026426.1	2777970	g5160	i0	48.6	1.16230366492147	37	19	58.1	0	114	4	2	38	WP_194026426.1 hypothetical protein [Nodosilinea sp. LEGE 07298]	diamond	222	53.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. LEGE 07298
29822469	29822469	PRJNA400171_S_NODE_2971_length_236_cov_3.898551_g2881_i0	PRJNA400171	2971	236	3.898551	9.20058036	Pannus brasiliensis	1579216	Bacteria	Bacteria	70.5	5.68e-12	NR	WP_332866389.1	1579216	g2881	i0	58.5	2.25	53	22	67.4	0	189	31	1	53	WP_332866389.1 ATP-dependent nuclease [Pannus brasiliensis]	diamond	531	70.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Pannus	Pannus brasiliensis
30075299	30075299	PRJNA400171_S_NODE_852_length_360_cov_3.613293_g762_i0	PRJNA400171	852	360	3.613293	13.0078548	Stenomitos sp.	3088177	Bacteria	Bacteria	47	0.00437	NR	HEY9831066.1	3088177	g762	i0	26.4	0.916666666666667	110	78	91.7	2	17	346	59	165	HEY9831066.1 AAA family ATPase [Stenomitos sp.]	diamond	330	47	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos sp.
30233391	30233391	PRJNA400171_S_NODE_3212_length_229_cov_3.700000_g3122_i0	PRJNA400171	3212	229	3.7	8.473	Cyanobacteria bacterium J06636_28	3023207	Bacteria	Bacteria	83.2	2.02e-18	NR	MEO1182938.1	3023207	g3122	i0	53.5	1.91266375545852	71	33	93	0	216	4	43	113	MEO1182938.1 hypothetical protein [Cyanobacteria bacterium J06636_28]	diamond	438	83.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06636_28
30818869	30818869	PRJNA400171_S_NODE_394_length_462_cov_4.085450_g305_i0	PRJNA400171	394	462	4.08545	18.874779	Cyanophyceae	3028117	Bacteria	Bacteria	152	2.2499999999999994e-42	NR	MBW4419891.1	1601976	g305	i0	50	1.8961038961039	146	73	94.8	0	461	24	55	200	MBW4419891.1 tRNA-guanine transglycosylase [Myxacorys californica WJT36-NPBG1]	diamond	876	152	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Myxacorys	Myxacorys californica
30865232	30865232	PRJNA400171_S_NODE_1134_length_325_cov_3.016892_g1044_i0	PRJNA400171	1134	325	3.016892	9.804899	Nodosilinea sp. LEGE	2497642	Bacteria	Bacteria	45.8	0.007	NR	WP_194026426.1	2777970	g1044	i0	63.3	0.276923076923077	30	11	27.7	0	6	95	295	324	WP_194026426.1 hypothetical protein [Nodosilinea sp. LEGE 07298]	diamond	90	45.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. LEGE 07298
30897096	30897096	PRJNA400171_S_NODE_954_length_344_cov_3.361905_g864_i0	PRJNA400171	954	344	3.361905	11.5649532	Aphanizomenon flos-aquae	1176	Bacteria	Bacteria	80.1	8.85e-15	NR	MBO1063114.1	2717881	g864	i0	42.1	0.828488372093023	95	55	82.8	0	334	50	245	339	MBO1063114.1 DUF4157 domain-containing protein [Aphanizomenon flos-aquae CP01]	diamond	285	80.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Aphanizomenon	Aphanizomenon flos-aquae

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