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

5 rows where bioproject = "PRJNA615351" and tax_phylum = "Chlorobiota"

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
28596511	28596511	PRJNA615351_P_NODE_47607_length_763_cov_3.388736_g35896_i0	PRJNA615351	47607	763	3.388736	25.85605568	Chloroherpetonaceae bacterium	2969135	Bacteria	Bacteria	78.6	2.01e-12	NR	MDX2129122.1	2969135	g35896	i0	45.3	1.3132372214941	86	46	33.4	1	763	509	1392	1477	MDX2129122.1 ATP-binding protein [Chloroherpetonaceae bacterium]	diamond	1002	78.6	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chloroherpetonaceae		Chloroherpetonaceae bacterium
29164814	29164814	PRJNA615351_P_NODE_127709_length_231_cov_1.831633_g113609_i0	PRJNA615351	127709	231	1.831633	4.23107223	Chlorobiota bacterium	2268192	Bacteria	Bacteria	65.1	4.16e-10	NR	KAA0210744.1	2268192	g113609	i0	59.3	0.766233766233766	59	23	76.6	1	50	226	54	111	KAA0210744.1 MAG: CoA-binding protein [Chlorobiota bacterium]	diamond	177	65.1	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota					Chlorobiota bacterium
30270378	30270378	PRJNA615351_P_NODE_85092_length_393_cov_2.388268_g71031_i0	PRJNA615351	85092	393	2.388268	9.38589324	Candidatus Thermochlorobacter sp.	2928185	Bacteria	Bacteria	64.7	3.4e-9	NR	MFN3426671.1	2928185	g71031	i0	32.2	0.923664122137405	121	80	91.6	2	15	374	71	190	MFN3426671.1 WD40 repeat domain-containing protein [Candidatus Thermochlorobacter sp.]	diamond	363	64.7	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Candidatus Thermochlorobacteriaceae	Candidatus Thermochlorobacter	Candidatus Thermochlorobacter sp.
32609751	32609751	PRJNA615351_P_NODE_91560_length_357_cov_2.406832_g77476_i0	PRJNA615351	91560	357	2.406832	8.59239024	Chlorobium limicola	1092	Bacteria	Bacteria	43.9	0.0425	NR	NTV07450.1	1092	g77476	i0	32.4	0.571428571428571	68	45	57.1	1	114	317	184	250	NTV07450.1 aminomethyl-transferring glycine dehydrogenase subunit GcvPB [Chlorobium limicola]	diamond	204	43.9	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chlorobiaceae	Chlorobium	Chlorobium limicola
32892852	32892852	PRJNA615351_P_NODE_161200_length_175_cov_1.664286_g147100_i0	PRJNA615351	161200	175	1.664286	2.9125005	Chloroherpetonaceae bacterium	2969135	Bacteria	Bacteria	56.2	2.5e-7	NR	MCS7211189.1	2969135	g147100	i0	54	0.857142857142857	50	20	80.6	1	6	146	172	221	MCS7211189.1 hypothetical protein [Chloroherpetonaceae bacterium]	diamond	150	56.2	1	Bacteria	FCB group	Pseudomonadati	Chlorobiota	Chlorobiia	Chlorobiales	Chloroherpetonaceae		Chloroherpetonaceae bacterium

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