metadata: contig_metadata: 18 rows where analysis = "diamond", bioproject = "PRJNA900028" and tax

18 rows where analysis = "diamond", bioproject = "PRJNA900028" 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
3425799	3425799	PRJNA900028_P_NODE_177123_length_162_cov_1.044248_g176374_i0	PRJNA900028	177123	162	1.044248	1.69168176	Chlamydia psittaci 1	83554	Bacteria	Bacteria	73.2	1.55e-15	NR	EPP36914.1	1238236	g176374	i0	94.4	0.666666666666667	36	2	66.7	0	24	131	1	36	EPP36914.1 hypothetical protein CP10743SC13_1736 [Chlamydia psittaci 10_743_SC13]	diamond	108	73.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
25101042	25101042	PRJNA900028_P_NODE_178800_length_162_cov_0.902655_g178051_i0	PRJNA900028	178800	162	0.902655	1.4623011	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	106	1.83e-25	NR	MBA3602602.1	2052176	g178051	i0	94.4	2	54	3	100	0	162	1	337	390	MBA3602602.1 pyruvate dehydrogenase complex dihydrolipoamide acetyltransferase [Parachlamydiaceae bacterium]	diamond	324	106	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
26707267	26707267	PRJNA900028_P_NODE_104561_length_173_cov_4.508065_g103812_i0	PRJNA900028	104561	173	4.508065	7.79895245	Chlamydia psittaci	83554	Bacteria	Bacteria	58.2	1.46e-9	NR	EPP28701.1	1112246	g103812	i0	87.1	0.53757225433526	31	4	53.8	0	99	7	1	31	EPP28701.1 hypothetical protein CP082626L3_1512, partial [Chlamydia psittaci 08-2626_L3]	diamond	93	58.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
26707288	26707288	PRJNA900028_P_NODE_157601_length_164_cov_0.886957_g156852_i0	PRJNA900028	157601	164	0.886957	1.45460948	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	63.5	5.1e-10	NR	HEV8050857.1	2052176	g156852	i0	73	0.676829268292683	37	10	67.7	0	53	163	53	89	HEV8050857.1 AMP-binding protein [Parachlamydiaceae bacterium]	diamond	111	63.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
27403596	27403596	PRJNA900028_P_NODE_70543_length_189_cov_1.435714_g69794_i0	PRJNA900028	70543	189	1.435714	2.71349946	Chlamydiota bacterium	2081524	Bacteria	Bacteria	68.9	1.01e-11	NR	NGX58127.1	2081524	g69794	i0	51.6	0.984126984126984	62	30	98.4	0	2	187	252	313	NGX58127.1 hypothetical protein [Chlamydiota bacterium]	diamond	186	68.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota					Chlamydiota bacterium
27600716	27600716	PRJNA900028_P_NODE_117504_length_167_cov_1.728814_g116755_i0	PRJNA900028	117504	167	1.728814	2.88711938	Candidatus Protochlamydia	282132	Bacteria	Bacteria	55.5	4.32e-7	NR	WP_059059980.1	389348	g116755	i0	49.1	2.87425149700599	53	27	95.2	0	164	6	330	382	WP_059059980.1 hypothetical protein [Candidatus Protochlamydia naegleriophila]	diamond	480	55.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
27940343	27940343	PRJNA900028_P_NODE_78585_length_185_cov_2.897059_g77836_i0	PRJNA900028	78585	185	2.897059	5.35955915	Chlamydia psittaci 1	83554	Bacteria	Bacteria	51.2	5.74e-7	NR	EPP36737.1	1238236	g77836	i0	75.9	0.47027027027027	29	7	47	0	18	104	12	40	EPP36737.1 hypothetical protein CP10743SC13_1200 [Chlamydia psittaci 10_743_SC13]	diamond	87	51.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
28287347	28287347	PRJNA900028_P_NODE_89666_length_181_cov_0.772727_g88917_i0	PRJNA900028	89666	181	0.772727	1.39863587	Chlamydia psittaci 1	83554	Bacteria	Bacteria	73.9	3.8e-14	NR	EPP36802.1	1238236	g88917	i0	97.4	0.629834254143646	38	1	63	0	114	1	79	116	EPP36802.1 hypothetical protein CP10743SC13_1855 [Chlamydia psittaci 10_743_SC13]	diamond	114	73.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
28413903	28413903	PRJNA900028_P_NODE_14586_length_303_cov_1.401575_g13838_i0	PRJNA900028	14586	303	1.401575	4.24677225	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	84.7	2.47e-17	NR	MFI0435509.1	2052176	g13838	i0	83.3	1.57425742574257	48	8	47.5	0	167	24	2	49	MFI0435509.1 MBL fold metallo-hydrolase [Parachlamydiaceae bacterium]	diamond	477	84.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
28603367	28603367	PRJNA900028_P_NODE_5507_length_457_cov_0.982843_g4768_i0	PRJNA900028	5507	457	0.982843	4.49159251	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	65.1	1.59e-10	NR	HEY5234571.1	2047756	g4768	i0	69.2	0.341356673960613	52	12	32.8	3	152	3	1	50	HEY5234571.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	156	65.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
29423970	29423970	PRJNA900028_P_NODE_190849_length_161_cov_0.910714_g190100_i0	PRJNA900028	190849	161	0.910714	1.46624954	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	91.7	1.45e-22	NR	MFN4173774.1	2052176	g190100	i0	95.5	0.819875776397516	44	2	82	0	1	132	49	92	MFN4173774.1 hypothetical protein [Parachlamydiaceae bacterium]	diamond	132	91.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
29518867	29518867	PRJNA900028_P_NODE_89490_length_181_cov_1.037879_g88741_i0	PRJNA900028	89490	181	1.037879	1.87856099	Chlamydia ibidis	1405396	Bacteria	Bacteria	72.4	4.75e-15	NR	EPP35264.1	1405396	g88741	i0	61	0.977900552486188	59	23	97.8	0	180	4	8	66	EPP35264.1 hypothetical protein CP10139811_1531, partial [Chlamydia ibidis]	diamond	177	72.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia ibidis
29960983	29960983	PRJNA900028_P_NODE_48151_length_210_cov_1.180124_g47402_i0	PRJNA900028	48151	210	1.180124	2.4782604	Chlamydia ibidis	1405396	Bacteria	Bacteria	81.6	1.29e-18	NR	EPP34980.1	1405396	g47402	i0	90.9	0.628571428571429	44	4	62.9	0	208	77	1	44	EPP34980.1 hypothetical protein CP10139811_1107, partial [Chlamydia ibidis]	diamond	132	81.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia ibidis
30245563	30245563	PRJNA900028_P_NODE_3412_length_585_cov_2.878731_g620_i2	PRJNA900028	3412	585	2.878731	16.84057635	Chlamydia ibidis	1405396	Bacteria	Bacteria	76.3	1.27e-14	NR	EPP34943.1	1405396	g620	i2	82.2	0.230769230769231	45	7	22.6	1	26	157	13	57	EPP34943.1 hypothetical protein CP10139811_1560, partial [Chlamydia ibidis]	diamond	135	76.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia ibidis
31074559	31074559	PRJNA900028_P_NODE_62295_length_195_cov_1.041096_g61546_i0	PRJNA900028	62295	195	1.041096	2.0301372	Chlamydia	810	Bacteria	Bacteria	70.1	3.58e-13	NR	EPP30166.1	1112230	g61546	i0	98.4	1.96923076923077	64	1	98.5	0	3	194	39	102	EPP30166.1 hypothetical protein CP8484711_2613, partial [Chlamydia psittaci 84-8471/1]	diamond	384	70.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
32363881	32363881	PRJNA900028_P_NODE_143479_length_165_cov_0.879310_g142730_i0	PRJNA900028	143479	165	0.87931	1.4508615	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	115	4.42e-29	NR	HEY5234572.1	2047756	g142730	i0	98.1	0.963636363636364	53	1	96.4	0	5	163	1	53	HEY5234572.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	159	115	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
32458774	32458774	PRJNA900028_P_NODE_58419_length_199_cov_0.933333_g57670_i0	PRJNA900028	58419	199	0.933333	1.85733267	Chlamydia psittaci	83554	Bacteria	Bacteria	45.4	2.2e-4	NR	EPJ33212.1	1112244	g57670	i0	92.9	0.422110552763819	28	2	42.2	0	86	3	3	30	EPJ33212.1 hypothetical protein CP061683_2349, partial [Chlamydia psittaci 06-1683]	diamond	84	45.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
32522183	32522183	PRJNA900028_P_NODE_2199_length_754_cov_2.534752_g620_i1	PRJNA900028	2199	754	2.534752	19.11203008	Chlamydia ibidis	1405396	Bacteria	Bacteria	75.9	5.84e-14	NR	EPP34943.1	1405396	g620	i1	82.2	0.179045092838196	45	7	17.5	1	602	471	13	57	EPP34943.1 hypothetical protein CP10139811_1560, partial [Chlamydia ibidis]	diamond	135	75.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia ibidis

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