metadata: contig_metadata: 9 rows where bioproject = "PRJNA929522", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

9 rows where bioproject = "PRJNA929522", tax_clade = "Cyanobacteriota/Melainabacteria group" 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
8558253	8558253	PRJNA929522_S_NODE_2487_length_423_cov_1.320000_g2417_i0	PRJNA929522	2487	423	1.32	5.5836	Calothrix sp. PCC 6303	1170562	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|428233323\|gb\|CP003610.1\|	1170562	g2417	i0	100	0.215130023640662	30	0	7	0	14	43	6273110	6273139	Calothrix sp. PCC 6303, complete genome	blastn	91	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
22931226	22931226	PRJNA929522_S_NODE_5498_length_299_cov_1.022124_g5428_i0	PRJNA929522	5498	299	1.022124	3.05615076	Planktothrix	54304	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2261189783\|emb\|LR882967.1\|	132604	g5428	i0	100	0.193979933110368	29	0	10	0	230	258	2935600	2935628	Planktothrix pseudagardhii strain No.713 genome assembly, chromosome: I	blastn	58	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix pseudagardhii
23857727	23857727	PRJNA929522_S_NODE_8639_length_250_cov_0.870056_g8569_i0	PRJNA929522	8639	250	0.870056	2.17514	Nostoc sp. UHCC 0870	2914041	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2190707562\|gb\|CP091913.1\|	2914041	g8569	i0	100	0.112	28	0	11	0	140	167	94571	94544	Nostoc sp. UHCC 0870 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0870
25131461	25131461	PRJNA929522_S_NODE_1140_length_604_cov_1.977401_g1074_i0	PRJNA929522	1140	604	1.977401	11.94350204	Synechococcales cyanobacterium M58_A2018_015	2774348	Bacteria	Bacteria	150	3.2e-40	NR	MBF2000777.1	2774348	g1074	i0	59.2	0.620860927152318	125	50	61.6	1	373	2	215	339	MBF2000777.1 glycoside hydrolase family protein [Synechococcales cyanobacterium M58_A2018_015]	diamond	375	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales			Synechococcales cyanobacterium M58_A2018_015
26803232	26803232	PRJNA929522_S_NODE_321_length_1037_cov_1.859959_g284_i0	PRJNA929522	321	1037	1.859959	19.28777483	Microcoleus asticus	2815231	Bacteria	Bacteria	138	5.34e-32	NR	WP_172186771.1	2815231	g284	i0	33.8	1.97010607521697	331	186	91.1	9	1024	80	823	1136	WP_172186771.1 Ig-like domain-containing protein [Microcoleus asticus]	diamond	2043	138	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus asticus
27277862	27277862	PRJNA929522_S_NODE_263_length_1116_cov_16.487057_g228_i0	PRJNA929522	263	1116	16.487057	183.99555612	Nostoc sp. EfeVER	1180	Bacteria	Bacteria	52	4.17e-4	NR	WP_322687120.1	3075406	g228	i0	45.2	0.166666666666667	62	32	16.1	2	1058	879	52	113	WP_322687120.1 hypothetical protein [Nostoc sp. EfeVER01]	diamond	186	52	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. EfeVER01
29140954	29140954	PRJNA929522_S_NODE_4569_length_321_cov_1.447581_g4499_i0	PRJNA929522	4569	321	1.447581	4.6467350100000004	Umezakia ovalisporum	75695	Bacteria	Bacteria	46.6	0.00383	NR	WP_280649709.1	75695	g4499	i0	33.3	0.813084112149533	87	52	75.7	2	40	282	170	256	WP_280649709.1 hypothetical protein [Umezakia ovalisporum]	diamond	261	46.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Umezakia	Umezakia ovalisporum
30341374	30341374	PRJNA929522_S_NODE_9112_length_247_cov_0.885057_g9042_i0	PRJNA929522	9112	247	0.885057	2.18609079	Synechococcales cyanobacterium	2478492	Bacteria	Bacteria	79.3	2.29e-16	NR	MEB3355417.1	2478492	g9042	i0	76	0.607287449392713	50	12	60.7	0	2	151	115	164	MEB3355417.1 GNAT family protein [Synechococcales cyanobacterium]	diamond	150	79.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales			Synechococcales cyanobacterium
32522891	32522891	PRJNA929522_S_NODE_5439_length_300_cov_1.837004_g5369_i0	PRJNA929522	5439	300	1.837004	5.511012	Cyanobacteria bacterium J06553_1	3023125	Bacteria	Bacteria	76.3	1.22e-13	NR	MEL7520467.1	3023125	g5369	i0	38.7	1.86	93	54	93	1	299	21	316	405	MEL7520467.1 reverse transcriptase family protein [Cyanobacteria bacterium J06553_1]	diamond	558	76.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06553_1

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