metadata: contig_metadata: 6 rows where bioproject = "PRJNA448207" and tax_clade = "Cyanobacteriota/Melainabacteria group"

6 rows where bioproject = "PRJNA448207" 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
23391063	23391063	PRJNA448207_P_NODE_32239_length_242_cov_0.911243_g32076_i0	PRJNA448207	32239	242	0.911243	2.20520806	Nostocales cyanobacterium HT-58-2	1940762	Bacteria	Bacteria	198	2.6499999999999997e-46	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g32076	i0	81.405	1	242	45	100	0	1	242	5789452	5789211	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	242	198	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
24665215	24665215	PRJNA448207_S_NODE_660_length_495_cov_8.177725_g649_i0	PRJNA448207	660	495	8.177725	40.47973875	Kalymmatonema hyalinum	119533	Bacteria	Bacteria	869	0	NTclustered	gi\|1280084616\|gb\|MF574178.1\|	119533	g649	i0	98.384	294.379797979798	495	7	100	1	1	495	2597	3090	Scytonema hyalinum rrn type 2 operon, precursor RNA, transcribed leader region, and 16S ribosomal RNA genes, 16S-23S internal transcribed spacer, tRNA-Ile, tRNA-Ala, and 23S ribosomal RNA genes, 23S-5S internal transcribed spacer, and 5S ribosomal RNA gene, complete sequence	blastn	145718	869	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Kalymmatonema	Kalymmatonema hyalinum
27186966	27186966	PRJNA448207_S_NODE_3222_length_257_cov_1.451087_g3211_i0	PRJNA448207	3222	257	1.451087	3.72929359	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	45.8	0.00347	NR	PZO14380.1	47253	g3211	i0	69	1.33073929961089	29	9	33.9	0	16	102	345	373	PZO14380.1 MAG: 4-hydroxyphenylpyruvate dioxygenase [Leptolyngbya foveolarum]	diamond	342	45.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya foveolarum
29065676	29065676	PRJNA448207_S_NODE_1648_length_340_cov_2.722846_g1637_i0	PRJNA448207	1648	340	2.722846	9.2576764	Anabaena azotica	197653	Bacteria	Bacteria	47	0.00338	NR	WP_413172610.1	197653	g1637	i0	37.9	0.838235294117647	95	57	82.1	1	32	310	71	165	WP_413172610.1 glycosyltransferase family 1 protein [Anabaena azotica]	diamond	285	47	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena azotica
29254736	29254736	PRJNA448207_P_NODE_26569_length_250_cov_0.870056_g26406_i0	PRJNA448207	26569	250	0.870056	2.17514	Cyanobacteria bacterium J06632_3	3023193	Bacteria	Bacteria	42.7	0.0392	NR	MEO1622368.1	3023193	g26406	i0	47.5	0.48	40	17	43.2	2	16	123	117	156	MEO1622368.1 apolipoprotein N-acyltransferase [Cyanobacteria bacterium J06632_3]	diamond	120	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06632_3
32699619	32699619	PRJNA448207_P_NODE_5260_length_525_cov_1.356195_g5101_i0	PRJNA448207	5260	525	1.356195	7.12002375	Coleofasciculus sp.	3100458	Bacteria	Bacteria	43.1	0.0473	NR	MFP5273888.1	3100458	g5101	i0	33	0.52	91	54	52	1	411	139	5	88	MFP5273888.1 hypothetical protein [Coleofasciculus sp.]	diamond	273	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus 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);;