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

6 rows where bioproject = "PRJNA608660" and tax_phylum = "Chlamydiota"

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
4975081	4975081	PRJNA608660_P_NODE_36144_length_204_cov_1.341935_g35788_i0	PRJNA608660	36144	204	1.341935	2.7375474	Candidatus Protochlamydia	282132	Bacteria	Bacteria	261	2.72e-65	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g35788	i0	89.855	129.044117647059	207	16	100	4	1	204	1251186	1251390	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	26325	261	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
26827082	26827082	PRJNA608660_P_NODE_24381_length_274_cov_3.342222_g24025_i0	PRJNA608660	24381	274	3.342222	9.15768828	Chlamydiota bacterium	2081524	Bacteria	Bacteria	58.9	9.53e-8	NR	MES2121163.1	2081524	g24025	i0	41.3	0.875912408759124	80	43	87.6	1	12	251	218	293	MES2121163.1 hypothetical protein [Chlamydiota bacterium]	diamond	240	58.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
29069770	29069770	PRJNA608660_P_NODE_29388_length_239_cov_2.178947_g29032_i0	PRJNA608660	29388	239	2.178947	5.20768333	Chlamydiota bacterium	2081524	Bacteria	Bacteria	159	4.89e-44	NR	MES2122697.1	2081524	g29032	i0	89.9	0.99163179916318	79	8	99.2	0	2	238	93	171	MES2122697.1 NAD+ synthase [Chlamydiota bacterium]	diamond	237	159	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
29827272	29827272	PRJNA608660_P_NODE_40831_length_185_cov_1.529412_g40474_i0	PRJNA608660	40831	185	1.529412	2.8294122	Chlamydiota bacterium	2081524	Bacteria	Bacteria	52.4	6.83e-6	NR	NGX62158.1	2081524	g40474	i0	63.2	0.616216216216216	38	14	61.6	0	180	67	113	150	NGX62158.1 hypothetical protein [Chlamydiota bacterium]	diamond	114	52.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
30490902	30490902	PRJNA608660_P_NODE_25713_length_264_cov_1.832558_g25357_i0	PRJNA608660	25713	264	1.832558	4.83795312	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	155	1.6499999999999998e-42	NR	MFA6916373.1	2052178	g25357	i0	92	1	88	7	100	0	1	264	260	347	MFA6916373.1 Npt1/Npt2 family nucleotide transporter [Parachlamydiales bacterium]	diamond	264	155	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
30522400	30522400	PRJNA608660_P_NODE_11493_length_439_cov_2.694872_g11146_i0	PRJNA608660	11493	439	2.694872	11.83048808	Chlamydiota bacterium	2081524	Bacteria	Bacteria	92.4	1.5e-18	NR	NGX62298.1	2081524	g11146	i0	36.2	0.867881548974943	127	81	86.8	0	390	10	976	1102	NGX62298.1 hypothetical protein [Chlamydiota bacterium]	diamond	381	92.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota 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);;