metadata: contig_metadata: 11 rows where bioproject = "PRJNA801875" and tax

11 rows where bioproject = "PRJNA801875" 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
14829491	14829491	PRJNA801875_P_NODE_1752_length_283_cov_1.967742_g1649_i0	PRJNA801875	1752	283	1.967742	5.56870986	Stanieria cyanosphaera	102116	Bacteria	Bacteria	250	8.63e-62	NTclustered	gi\|17976754\|emb\|AJ252121.1\|	111780	g1649	i0	83.395	50.4452296819788	271	43	95	2	3	272	492	761	Dermocarpa sp. strain PCC 7437 partial gap gene for NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating)	blastn	14276	250	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria cyanosphaera
18652530	18652530	PRJNA801875_P_NODE_1755_length_283_cov_1.125000_g1652_i0	PRJNA801875	1755	283	1.125	3.18375	Geminocystis sp. NIES-3709	1617448	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|770470343\|dbj\|AP014821.1\|	1617448	g1652	i0	96.774	0.109540636042403	31	1	11	0	175	205	3342900	3342870	Geminocystis sp. NIES-3709 DNA, complete genome	blastn	31	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Geminocystis	Geminocystis sp. NIES-3709
18652546	18652546	PRJNA801875_P_NODE_2995_length_193_cov_1.715190_g2892_i0	PRJNA801875	2995	193	1.71519	3.3103167	Cyanobacteria bacterium K4m	2830641	Bacteria	Bacteria	300	5.3800000000000004e-77	NTclustered	gi\|2029258269\|gb\|MZ020199.1\|	2830641	g2892	i0	95.263	189.290155440415	190	8	98	1	4	192	1280	1469	Cyanobacteria bacterium K4m 16S ribosomal RNA gene and 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	36533	300	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium K4m
22478133	22478133	PRJNA801875_P_NODE_4458_length_155_cov_1.200000_g4355_i0	PRJNA801875	4458	155	1.2	1.86	Leptolyngbyales cyanobacterium LEGE 16527	3132504	Bacteria	Bacteria	248	1.51e-61	NTclustered	gi\|2697880852\|gb\|PP476853.1\|	3132504	g4355	i0	95.57	102.98064516129	158	1	98	3	4	155	1241	1084	Leptolyngbyales cyanobacterium LEGE 16527 16S ribosomal RNA gene, partial sequence	blastn	15962	248	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales			Leptolyngbyales cyanobacterium LEGE 16527
26737194	26737194	PRJNA801875_P_NODE_3581_length_173_cov_1.949275_g3478_i0	PRJNA801875	3581	173	1.949275	3.37224575	Pleurocapsa sp. MO_226.B13	3036786	Bacteria	Bacteria	42.4	0.0204	NR	MDJ0594391.1	3036786	g3478	i0	43.9	0.988439306358382	57	31	97.1	1	2	169	1009	1065	MDJ0594391.1 malectin domain-containing carbohydrate-binding protein [Pleurocapsa sp. MO_226.B13]	diamond	171	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. MO_226.B13
27117145	27117145	PRJNA801875_P_NODE_2582_length_212_cov_2.141243_g2479_i0	PRJNA801875	2582	212	2.141243	4.53943516	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	108	7.14e-26	NR	HEY9756413.1	3088181	g2479	i0	72.5	0.976415094339623	69	19	97.6	0	6	212	191	259	HEY9756413.1 acetyl-CoA hydrolase/transferase C-terminal domain-containing protein [Oculatellaceae cyanobacterium]	diamond	207	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
28727938	28727938	PRJNA801875_P_NODE_2007_length_255_cov_2.645455_g1904_i0	PRJNA801875	2007	255	2.645455	6.74591025	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	126	2.21e-35	NR	MBX9692690.1	2847862	g1904	i0	91.8	0.717647058823529	61	5	71.8	0	1	183	57	117	MBX9692690.1 (2Fe-2S)-binding protein [Cyanobacteriota bacterium]	diamond	183	126	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29210580	29210580	PRJNA801875_P_NODE_2129_length_244_cov_1.851675_g2026_i0	PRJNA801875	2129	244	1.851675	4.518087	Cyanophyceae	3028117	Bacteria	Bacteria	65.9	2.34e-10	NR	WP_107670899.1	2082950	g2026	i0	63.5	4.73360655737705	52	10	63.9	1	6	161	309	351	WP_107670899.1 alkene reductase [Cyanothece sp. BG0011]	diamond	1155	66.2	0.995468277945619	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Cyanothecaceae	Cyanothece	Cyanothece sp. BG0011
29391111	29391111	PRJNA801875_P_NODE_3209_length_184_cov_2.389262_g3106_i0	PRJNA801875	3209	184	2.389262	4.39624208	Hormoscilla sp. GUM202	2480853	Bacteria	Bacteria	88.2	2.44e-19	NR	MBO1351640.1	2480853	g3106	i0	67.2	2.95108695652174	61	20	99.5	0	1	183	146	206	MBO1351640.1 SDR family oxidoreductase [Hormoscilla sp. GUM202]	diamond	543	88.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Gomontiellaceae	Hormoscilla	Hormoscilla sp. GUM202
30685923	30685923	PRJNA801875_P_NODE_3193_length_185_cov_1.326667_g3090_i0	PRJNA801875	3193	185	1.326667	2.45433395	Cyanobacteria bacterium P01_H01_bin.153	3023316	Bacteria	Bacteria	94.4	8.3e-23	NR	MEM1309679.1	3023316	g3090	i0	71.2	4.63783783783784	59	17	95.7	0	6	182	87	145	MEM1309679.1 nucleoside-diphosphate kinase [Cyanobacteria bacterium P01_H01_bin.153]	diamond	858	94.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_H01_bin.153
32307960	32307960	PRJNA801875_P_NODE_2459_length_220_cov_2.421622_g2356_i0	PRJNA801875	2459	220	2.421622	5.3275684	Bacillati	1783272	Bacteria	Bacteria	77.8	1.26e-14	NR	WP_298917448.1	340711	g2356	i0	55.6	6.69545454545455	72	32	98.2	0	5	220	817	888	WP_298917448.1 amino acid adenylation domain-containing protein [uncultured Nostoc sp.]	diamond	1473	77.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	uncultured Nostoc sp.

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