metadata: contig_metadata: 13 rows where bioproject = "PRJNA1063685" and tax

13 rows where bioproject = "PRJNA1063685" 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
2729879	2729879	PRJNA1063685_S_NODE_16683_length_543_cov_4.061702_g16152_i0	PRJNA1063685	16683	543	4.061702	22.05504186	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	691	0	NTclustered	gi\|2874253890\|emb\|OY970065.1\|	2052178	g16152	i0	91.176	429.081031307551	510	44	94	1	18	526	626500	625991	MAG: Parachlamydiales bacterium isolate MFD09286.bin.c.6 genome assembly, chromosome: 1	blastn	232991	691	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
2729880	2729880	PRJNA1063685_S_NODE_16823_length_541_cov_22.692308_g16291_i0	PRJNA1063685	16823	541	22.692308	122.76538628	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	817	0	NTclustered	gi\|2874253890\|emb\|OY970065.1\|	2052178	g16291	i0	95.499	91.1275415896488	511	23	94	0	24	534	624145	624655	MAG: Parachlamydiales bacterium isolate MFD09286.bin.c.6 genome assembly, chromosome: 1	blastn	49300	817	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
6557550	6557550	PRJNA1063685_S_NODE_38626_length_375_cov_11.519868_g38083_i0	PRJNA1063685	38626	375	11.519868	43.199505	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	292	1.9299999999999993e-74	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g38083	i0	82.022	352.554666666667	356	52	94	10	2	352	1333977	1334325	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	132208	292	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
6557648	6557648	PRJNA1063685_S_NODE_50806_length_315_cov_6.826446_g50263_i0	PRJNA1063685	50806	315	6.826446	21.5033049	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	353	7.22e-93	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g50263	i0	88.927	169.136507936508	289	28	91	4	5	290	655116	655403	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	53278	353	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
14208553	14208553	PRJNA1063685_S_NODE_70832_length_248_cov_2.800000_g70289_i0	PRJNA1063685	70832	248	2.8	6.944	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	165	2.76e-36	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g70289	i0	88.489	15.9717741935484	139	12	55	4	89	225	1332798	1332934	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	3961	165	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
15482695	15482695	PRJNA1063685_S_NODE_80913_length_198_cov_4.416000_g80370_i0	PRJNA1063685	80913	198	4.416	8.74368	Chlamydia psittaci 84-8471/1	1112230	Bacteria	Bacteria	92.8	5.1099999999999996e-23	NR	EPP32950.1	1112230	g80370	i0	90	0.757575757575758	50	5	75.8	0	6	155	1	50	EPP32950.1 hypothetical protein CP8484711_2610, partial [Chlamydia psittaci 84-8471/1]	diamond	150	92.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
21856356	21856356	PRJNA1063685_S_NODE_27518_length_447_cov_4.636364_g26977_i0	PRJNA1063685	27518	447	4.636364	20.72454708	Bacteria	2	Bacteria	Bacteria	229	1.87e-70	NR	HEY4832636.1	2026802	g26977	i0	78.7	15.1275167785235	141	30	94.6	0	445	23	150	290	HEY4832636.1 MBOAT family O-acyltransferase [Waddliaceae bacterium]	diamond	6762	229	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae		Waddliaceae bacterium
23131910	23131910	PRJNA1063685_S_NODE_40759_length_364_cov_4.941581_g40216_i0	PRJNA1063685	40759	364	4.941581	17.98735484	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	486	7.989999999999999e-133	NTclustered	gi\|2874253890\|emb\|OY970065.1\|	2052178	g40216	i0	93.134	108.535714285714	335	18	92	2	22	356	627025	627354	MAG: Parachlamydiales bacterium isolate MFD09286.bin.c.6 genome assembly, chromosome: 1	blastn	39507	486	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
26687203	26687203	PRJNA1063685_S_NODE_3381_length_795_cov_9.817175_g2985_i0	PRJNA1063685	3381	795	9.817175	78.04654125	Chlamydiia bacterium	2052156	Bacteria	Bacteria	172	6.68e-48	NR	MCB1073391.1	2052156	g2985	i0	43.4	0.860377358490566	228	113	83	8	727	68	111	330	MCB1073391.1 hypothetical protein [Chlamydiia bacterium]	diamond	684	172	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				Chlamydiia bacterium
27415045	27415045	PRJNA1063685_S_NODE_31983_length_415_cov_1.961988_g31441_i0	PRJNA1063685	31983	415	1.961988	8.1422502	Candidatus Algichlamydia australiensis	3341976	Bacteria	Bacteria	45.8	0.0185	NR	MDX8431166.1	3341976	g31441	i0	30.6	0.874698795180723	121	75	83.9	3	406	59	430	546	MDX8431166.1 hypothetical protein [Candidatus Algichlamydia australiensis]	diamond	363	45.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Algichlamydia	Candidatus Algichlamydia australiensis
28298760	28298760	PRJNA1063685_S_NODE_5746_length_711_cov_11.056426_g5283_i0	PRJNA1063685	5746	711	11.056426	78.61118886	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	243	2.72e-73	NR	QVL54756.1	2698248	g5283	i0	57.3	0.89873417721519	213	87	88.2	3	711	85	375	587	QVL54756.1 MAG: hypothetical protein KFB95_05390 [Simkaniaceae bacterium]	diamond	639	243	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae		Simkaniaceae bacterium
30920414	30920414	PRJNA1063685_S_NODE_62474_length_272_cov_1.195980_g61931_i0	PRJNA1063685	62474	272	1.19598	3.2530656	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	114	1.5600000000000002e-27	NR	MBY0529559.1	2047756	g61931	i0	60	1.98529411764706	90	36	99.3	0	272	3	65	154	MBY0529559.1 7-dehydrocholesterol reductase [Rhabdochlamydiaceae bacterium]	diamond	540	114	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
32375104	32375104	PRJNA1063685_S_NODE_10799_length_617_cov_2.652574_g10284_i0	PRJNA1063685	10799	617	2.652574	16.36638158	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	53.9	1.42e-4	NR	MBA3720792.1	2052176	g10284	i0	30.6	0.777957860615883	160	92	74.4	6	579	121	416	563	MBA3720792.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	480	53.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae 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);;