metadata: contig_metadata: 5 rows where bioproject = "PRJNA576995" and tax

5 rows where bioproject = "PRJNA576995" 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
3111443	3111443	PRJNA576995_P_NODE_19423_length_342_cov_0.895911_g18831_i0	PRJNA576995	19423	342	0.895911	3.06401562	Synechococcus sp. CB0101	232348	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|1626690261\|gb\|CP039373.1\|	232348	g18831	i0	100	0.0818713450292398	28	0	8	0	222	249	1687046	1687073	Synechococcus sp. CB0101 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CB0101
26699539	26699539	PRJNA576995_P_NODE_29221_length_282_cov_1.473684_g28629_i0	PRJNA576995	29221	282	1.473684	4.15578888	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	94.4	2.01e-20	NR	HEY9759356.1	3088181	g28629	i0	54.8	0.98936170212766	93	39	98.9	1	280	2	106	195	HEY9759356.1 hypothetical protein [Oculatellaceae cyanobacterium]	diamond	279	94.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
26763069	26763069	PRJNA576995_P_NODE_38461_length_247_cov_0.885057_g37869_i0	PRJNA576995	38461	247	0.885057	2.18609079	Cyanobacteria bacterium HKST-UBA02	2775582	Bacteria	Bacteria	167	3.2899999999999996e-47	NR	MCA9803276.1	2775582	g37869	i0	96.3	1.9919028340081	82	3	99.6	0	246	1	270	351	MCA9803276.1 class I SAM-dependent methyltransferase [Cyanobacteria bacterium HKST-UBA02]	diamond	492	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium HKST-UBA02
27900659	27900659	PRJNA576995_P_NODE_39245_length_246_cov_0.890173_g38653_i0	PRJNA576995	39245	246	0.890173	2.18982558	Chroococcales cyanobacterium	3088180	Bacteria	Bacteria	134	2.33e-36	NR	HEY9715283.1	3088180	g38653	i0	81.7	1	82	15	100	0	1	246	207	288	HEY9715283.1 RNA polymerase sigma factor RpoD/SigA [Chroococcales cyanobacterium]	diamond	246	134	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales			Chroococcales cyanobacterium
29082719	29082719	PRJNA576995_P_NODE_29828_length_279_cov_1.330097_g29236_i0	PRJNA576995	29828	279	1.330097	3.71097063	root	1	Root_unresolved	Root_unresolved	91.3	4.78e-19	NR	WP_166281631.1	207921	g29236	i0	56.5	40.4301075268817	92	39	98.9	1	2	277	83	173	WP_166281631.1 R3H domain-containing nucleic acid-binding protein [Lyngbya confervoides]	diamond	11280	91.7	0.995637949836423	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Lyngbya	Lyngbya confervoides

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