metadata: contig_metadata: 16 rows where bioproject = "PRJNA758398", tax_clade = "PVC group" and tax

16 rows where bioproject = "PRJNA758398", tax_clade = "PVC group" 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
10944208	10944208	PRJNA758398_S_NODE_989_length_884_cov_2.549701_g902_i0	PRJNA758398	989	884	2.549701	22.53935684	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	127	5.099999999999999e-33	NR	HNA62975.1	2047756	g902	i0	95.5	0.223981900452489	66	3	22.4	0	860	663	4	69	HNA62975.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	198	127	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
20330814	20330814	PRJNA758398_S_NODE_21896_length_219_cov_1.635294_g21755_i0	PRJNA758398	21896	219	1.635294	3.58129386	Chlamydia	810	Bacteria	Bacteria	58.4	4.16e-4	NTclustered	gi\|2744459767\|gb\|CP158099.1\|	83555	g21755	i0	100	3.08675799086758	31	0	14	0	24	54	369698	369728	Chlamydia abortus strain NL2381-3B chromosome, complete genome	blastn	676	58.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia abortus
27590395	27590395	PRJNA758398_S_NODE_764_length_978_cov_2.660926_g690_i0	PRJNA758398	764	978	2.660926	26.02385628	Simkania sp.	34094	Bacteria	Bacteria	257	2.39e-81	NR	MCB1084310.1	34094	g690	i0	74.7	0.521472392638037	170	43	52.1	0	719	210	1	170	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	510	257	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
27685184	27685184	PRJNA758398_S_NODE_26024_length_205_cov_1.429487_g25883_i0	PRJNA758398	26024	205	1.429487	2.93044835	Simkania sp.	34094	Bacteria	Bacteria	78.6	3.38e-17	NR	MCB1084315.1	34094	g25883	i0	66.1	0.863414634146341	59	20	86.3	0	189	13	1	59	MCB1084315.1 hypothetical protein [Simkania sp.]	diamond	177	78.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
28221443	28221443	PRJNA758398_S_NODE_14086_length_263_cov_1.429907_g13945_i0	PRJNA758398	14086	263	1.429907	3.76065541	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	73.2	9.07e-13	NR	HSX03456.1	2047756	g13945	i0	51.3	0.91254752851711	80	34	90.1	3	24	260	44	119	HSX03456.1 glycosyltransferase family A protein [Rhabdochlamydiaceae bacterium]	diamond	240	73.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
28989426	28989426	PRJNA758398_S_NODE_728_length_1001_cov_19.693277_g658_i0	PRJNA758398	728	1001	19.693277	197.12970277	root	1	Root_unresolved	Root_unresolved	257	2.21e-81	NR	MCB1084310.1	34094	g658	i0	74.4	3.17382617382617	172	44	51.5	0	744	229	1	172	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	3177	257	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
29390068	29390068	PRJNA758398_S_NODE_8689_length_327_cov_1.500000_g8548_i0	PRJNA758398	8689	327	1.5	4.905	Simkania sp.	34094	Bacteria	Bacteria	160	9.7e-48	NR	MCB1084350.1	34094	g8548	i0	82	1.62385321100917	89	16	81.7	0	327	61	8	96	MCB1084350.1 MC/SLC25 family protein [Simkania sp.]	diamond	531	160	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
30189092	30189092	PRJNA758398_S_NODE_28812_length_197_cov_1.445946_g28671_i0	PRJNA758398	28812	197	1.445946	2.84851362	root	1	Root_unresolved	Root_unresolved	108	5.03e-28	NR	MCB1084350.1	34094	g28671	i0	72.3	3.95939086294416	65	18	99	0	2	196	68	132	MCB1084350.1 MC/SLC25 family protein [Simkania sp.]	diamond	780	108	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
30843055	30843055	PRJNA758398_S_NODE_34274_length_183_cov_1.455224_g34133_i0	PRJNA758398	34274	183	1.455224	2.66305992	Chlamydiales bacterium	2047757	Bacteria	Bacteria	53.9	1.87e-6	NR	MDF2550084.1	2047757	g34133	i0	44.8	0.950819672131147	58	25	95.1	1	175	2	609	659	MDF2550084.1 putative phosphoketolase [Chlamydiales bacterium]	diamond	174	53.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31348754	31348754	PRJNA758398_S_NODE_3536_length_503_cov_11.149780_g3395_i0	PRJNA758398	3536	503	11.14978	56.0833934	Chlamydiales bacterium	2047757	Bacteria	Bacteria	212	2.2899999999999994e-67	NR	MCP5470420.1	2047757	g3395	i0	81	0.846918489065606	142	26	84.7	1	503	78	6	146	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	426	212	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31538553	31538553	PRJNA758398_S_NODE_13936_length_264_cov_1.660465_g13795_i0	PRJNA758398	13936	264	1.660465	4.3836276	Simkania sp.	34094	Bacteria	Bacteria	70.9	4.84e-14	NR	MCB1084368.1	34094	g13795	i0	61.2	0.556818181818182	49	19	55.7	0	171	25	16	64	MCB1084368.1 hypothetical protein [Simkania sp.]	diamond	147	70.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
31570268	31570268	PRJNA758398_S_NODE_3676_length_493_cov_16.729730_g3535_i0	PRJNA758398	3676	493	16.72973	82.4775689	Chlamydiales bacterium	2047757	Bacteria	Bacteria	218	1.06e-69	NR	MCP5470420.1	2047757	g3535	i0	78.1	0.918864097363083	151	33	91.9	0	493	41	6	156	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	453	218	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31664754	31664754	PRJNA758398_S_NODE_11477_length_287_cov_2.100840_g11336_i0	PRJNA758398	11477	287	2.10084	6.0294108	Rhabdochlamydiaceae bacterium	2047756	Bacteria	Bacteria	114	7.28e-31	NR	HNA63020.1	2047756	g11336	i0	70.6	0.710801393728223	68	20	71.1	0	1	204	7	74	HNA63020.1 hypothetical protein [Rhabdochlamydiaceae bacterium]	diamond	204	114	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae		Rhabdochlamydiaceae bacterium
31791214	31791214	PRJNA758398_S_NODE_1977_length_650_cov_3.945092_g1852_i0	PRJNA758398	1977	650	3.945092	25.643098	Simkania sp.	34094	Bacteria	Bacteria	224	3.65e-70	NR	MCB1084310.1	34094	g1852	i0	77.5	0.655384615384615	142	32	65.5	0	581	156	31	172	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	426	224	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
31854632	31854632	PRJNA758398_S_NODE_3357_length_516_cov_3.601713_g3217_i0	PRJNA758398	3357	516	3.601713	18.58483908	Chlamydiales bacterium	2047757	Bacteria	Bacteria	211	5.59e-67	NR	MCP5470420.1	2047757	g3217	i0	78.6	0.843023255813954	145	29	84.3	1	1	435	3	145	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	435	211	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32107812	32107812	PRJNA758398_S_NODE_4598_length_442_cov_3.501272_g4457_i0	PRJNA758398	4598	442	3.501272	15.47562224	Chlamydiales bacterium	2047757	Bacteria	Bacteria	249	2.5599999999999995e-82	NR	MCP5470421.1	2047757	g4457	i0	81.6	0.997737556561086	147	27	99.8	0	441	1	6	152	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	441	249	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales 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);;