metadata: contig_metadata: 11 rows where bioproject = "PRJNA694557" and tax

11 rows where bioproject = "PRJNA694557" 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
5776972	5776972	PRJNA694557_P_NODE_4385_length_721_cov_3.245370_g4174_i0	PRJNA694557	4385	721	3.24537	23.3991177	Candidatus Criblamydia sequanensis	340071	Bacteria	Bacteria	771	0	NTclustered	gi\|678241437\|emb\|LK031773.1\|	1437425	g4174	i0	86.988	0.998613037447989	684	89	95	0	16	699	28854	29537	Criblamydia sequanensis plasmid 1, strain CRIB-18, complete sequence	blastn	720	771	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Candidatus Criblamydia	Candidatus Criblamydia sequanensis
15208316	15208316	PRJNA694557_P_NODE_6232_length_582_cov_2.302554_g6013_i0	PRJNA694557	6232	582	2.302554	13.40086428	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	152	1.79e-41	NR	MBX7067559.1	2052178	g6013	i0	81.9	0.427835051546392	83	15	42.8	0	2	250	235	317	MBX7067559.1 prolyl aminopeptidase [Parachlamydiales bacterium]	diamond	249	152	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
18525251	18525251	PRJNA694557_P_NODE_18615_length_292_cov_3.301370_g18395_i0	PRJNA694557	18615	292	3.30137	9.6400004	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	527	3.69e-145	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g18395	i0	99.315	1	292	1	100	1	1	292	2104757	2105047	Parachlamydia acanthamoebae UV-7, complete genome	blastn	292	527	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
27588201	27588201	PRJNA694557_P_NODE_23844_length_249_cov_0.875000_g23624_i0	PRJNA694557	23844	249	0.875	2.17875	Chlamydiales bacterium	2047757	Bacteria	Bacteria	114	7.14e-28	NR	HSX10843.1	2047757	g23624	i0	68.8	1.93975903614458	80	25	96.4	0	247	8	131	210	HSX10843.1 hemolysin family protein [Chlamydiales bacterium]	diamond	483	114	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28440731	28440731	PRJNA694557_P_NODE_12806_length_369_cov_2.831081_g12586_i0	PRJNA694557	12806	369	2.831081	10.44668889	Chlamydiales bacterium	2047757	Bacteria	Bacteria	47	0.00526	NR	HSW73342.1	2047757	g12586	i0	24.2	1.04065040650407	128	87	96.7	3	357	1	899	1025	HSW73342.1 hypothetical protein [Chlamydiales bacterium]	diamond	384	47	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
28630246	28630246	PRJNA694557_P_NODE_3187_length_863_cov_3.098734_g2991_i0	PRJNA694557	3187	863	3.098734	26.74207442	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	202	1.68e-61	NR	MBA3958744.1	2052176	g2991	i0	85	0.371958285052144	107	16	37.2	0	861	541	63	169	MBA3958744.1 transposase [Parachlamydiaceae bacterium]	diamond	321	202	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
29766569	29766569	PRJNA694557_P_NODE_24211_length_247_cov_3.206897_g23991_i0	PRJNA694557	24211	247	3.206897	7.92103559	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	130	1.93e-36	NR	MBX7065666.1	2052178	g23991	i0	83.8	0.825910931174089	68	11	82.6	0	23	226	90	157	MBX7065666.1 hypothetical protein [Parachlamydiales bacterium]	diamond	204	130	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
32275480	32275480	PRJNA694557_P_NODE_22858_length_255_cov_1.692308_g22638_i0	PRJNA694557	22858	255	1.692308	4.3153854	Bacteria	2	Bacteria	Bacteria	153	6.01e-44	NR	QLH34770.1	2052176	g22638	i0	82.7	2.85882352941176	81	14	95.3	0	244	2	138	218	QLH34770.1 MAG: IS5 family transposase [Parachlamydiaceae bacterium]	diamond	729	153	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
32674558	32674558	PRJNA694557_P_NODE_13100_length_364_cov_3.388316_g12880_i0	PRJNA694557	13100	364	3.388316	12.33347024	Chlamydiota bacterium	2081524	Bacteria	Bacteria	48.9	0.00105	NR	MES2345038.1	2081524	g12880	i0	29.6	1.78021978021978	108	70	87.4	3	322	5	741	844	MES2345038.1 hypothetical protein [Chlamydiota bacterium]	diamond	648	48.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
32832177	32832177	PRJNA694557_P_NODE_21520_length_266_cov_1.595855_g21300_i0	PRJNA694557	21520	266	1.595855	4.2449743	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	142	3.66e-37	NR	MEI8366527.1	2052176	g21300	i0	78.8	2.90977443609023	85	18	95.9	0	262	8	533	617	MEI8366527.1 site-2 protease family protein [Parachlamydiaceae bacterium]	diamond	774	142	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
32895015	32895015	PRJNA694557_P_NODE_15400_length_330_cov_1.221790_g15180_i0	PRJNA694557	15400	330	1.22179	4.031907	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	113	9.65e-28	NR	MBX7066418.1	2052178	g15180	i0	76.8	1.25454545454545	69	16	62.7	0	330	124	238	306	MBX7066418.1 DMT family transporter [Parachlamydiales bacterium]	diamond	414	113	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales 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);;