metadata: contig_metadata: 6 rows where bioproject = "PRJDB12134" and tax

6 rows where bioproject = "PRJDB12134" 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
8927100	8927100	PRJDB12134_P_NODE_14128_length_243_cov_0.917647_g13993_i0	PRJDB12134	14128	243	0.917647	2.22988221	Allocoleopsis sp.	3088169	Bacteria	Bacteria	95.1	1.28e-20	NR	HEY9661216.1	3088169	g13993	i0	56.3	0.987654320987654	80	34	98.8	1	240	1	101	179	HEY9661216.1 matrixin family metalloprotease [Allocoleopsis sp.]	diamond	240	95.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis sp.
15302165	15302165	PRJDB12134_P_NODE_13633_length_246_cov_0.895954_g13498_i0	PRJDB12134	13633	246	0.895954	2.20404684	Woronichinia naegeliana	283820	Bacteria	Bacteria	254	5.68e-63	NTclustered	gi\|2307062866\|gb\|CP073041.1\|	2824559	g13498	i0	85.366	1	246	34	99	2	1	245	2902449	2902693	MAG: Woronichinia naegeliana WA131 chromosome, complete genome	blastn	246	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Coelosphaeriaceae	Woronichinia	Woronichinia naegeliana
20107209	20107209	PRJDB12134_P_NODE_9996_length_289_cov_1.337963_g9861_i0	PRJDB12134	9996	289	1.337963	3.86671307	Cyanophyceae	3028117	Bacteria	Bacteria	189	3.19e-53	NR	WP_073632608.1	1137095	g9861	i0	93.8	74.916955017301	96	6	99.7	0	289	2	314	409	WP_073632608.1 hydantoinase B/oxoprolinase family protein [Scytonema sp. HK-05]	diamond	21651	190	0.994736842105263	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. HK-05
26810864	26810864	PRJDB12134_P_NODE_5101_length_472_cov_1.967419_g4967_i0	PRJDB12134	5101	472	1.967419	9.28621768	Cyanobacteria bacterium J06553_1	3023125	Bacteria	Bacteria	114	4.3e-26	NR	MEL7520422.1	3023125	g4967	i0	42	1.94491525423729	157	88	98.5	3	467	3	244	399	MEL7520422.1 reverse transcriptase family protein [Cyanobacteria bacterium J06553_1]	diamond	918	114	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06553_1
27759275	27759275	PRJDB12134_P_NODE_12244_length_253_cov_2.200000_g12109_i0	PRJDB12134	12244	253	2.2	5.566	Chroococcus sp. FPU1	1974212	Bacteria	Bacteria	143	1.7699999999999998e-37	NR	WP_206816591.1	1974212	g12109	i0	89.2	0.984189723320158	83	8	98.4	1	3	251	663	744	WP_206816591.1 filamentous hemagglutinin N-terminal domain-containing protein [Chroococcus sp. FPU101]	diamond	249	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Chroococcus	Chroococcus sp. FPU101
28453761	28453761	PRJDB12134_P_NODE_12206_length_254_cov_1.535912_g12071_i0	PRJDB12134	12206	254	1.535912	3.90121648	Merismopedia glauca	292586	Bacteria	Bacteria	145	2.7599999999999998e-43	NR	WP_106287367.1	292586	g12071	i0	94.7	0.885826771653543	75	4	88.6	0	3	227	11	85	WP_106287367.1 Txe/YoeB family addiction module toxin [Merismopedia glauca]	diamond	225	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Merismopedia	Merismopedia glauca

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