metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA575566" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA575566" and tax_clade = "PVC group"

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
28609016	28609016	PRJNA575566_P_NODE_7887_length_374_cov_1.191693_g7690_i0	PRJNA575566	7887	374	1.191693	4.45693182	Bacteria	2	Bacteria	Bacteria	105	1.69e-23	NR	MEI8213485.1	2026780	g7690	i0	49.6	2.00534759358289	121	57	96.3	2	374	15	132	249	MEI8213485.1 peroxidase family protein [Planctomycetota bacterium]	diamond	750	106	0.990566037735849	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29069202	29069202	PRJNA575566_P_NODE_24548_length_209_cov_0.864865_g24351_i0	PRJNA575566	24548	209	0.864865	1.80756785	Simkania sp.	34094	Bacteria	Bacteria	48.1	2.98e-4	NR	MBS3903878.1	34094	g24351	i0	43.5	0.990430622009569	69	38	99	1	1	207	257	324	MBS3903878.1 PDZ domain-containing protein [Simkania sp.]	diamond	207	48.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
29745415	29745415	PRJNA575566_P_NODE_28430_length_203_cov_0.901408_g28233_i0	PRJNA575566	28430	203	0.901408	1.82985824	Bacteria	2	Bacteria	Bacteria	43.5	0.0121	NR	WP_096894051.1	1284222	g28233	i0	52.8	6.65024630541872	36	17	53.2	0	96	203	1356	1391	WP_096894051.1 tetratricopeptide repeat protein [Candidatus Scalindua japonica]	diamond	1350	43.9	0.990888382687927	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Scalinduaceae	Candidatus Scalindua	Candidatus Scalindua japonica
30174255	30174255	PRJNA575566_P_NODE_1892_length_746_cov_2.769343_g1713_i0	PRJNA575566	1892	746	2.769343	20.65929878	Paludisphaera sp.	2017432	Bacteria	Bacteria	53.5	1.95e-4	NR	WP_337176277.1	2017432	g1713	i0	29.9	1.60053619302949	197	117	74	9	684	133	26	214	WP_337176277.1 hypothetical protein [Paludisphaera sp.]	diamond	1194	53.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera sp.
31185100	31185100	PRJNA575566_P_NODE_22075_length_221_cov_1.600000_g21878_i0	PRJNA575566	22075	221	1.6	3.536	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	67.4	3.41e-12	NR	MCB1068935.1	2212473	g21878	i0	55.7	0.950226244343891	70	28	91	1	10	210	55	124	MCB1068935.1 30S ribosomal protein S13 [Kiritimatiellia bacterium]	diamond	210	67.4	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
31280164	31280164	PRJNA575566_P_NODE_19975_length_235_cov_0.850575_g19778_i0	PRJNA575566	19975	235	0.850575	1.99885125	Luteolibacter sp.	1962973	Bacteria	Bacteria	42.4	0.0459	NR	MEO7098011.1	1962973	g19778	i0	40.8	0.625531914893617	49	25	58.7	2	17	154	313	360	MEO7098011.1 MBOAT family O-acyltransferase [Luteolibacter sp.]	diamond	147	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
32860608	32860608	PRJNA575566_P_NODE_27240_length_205_cov_0.888889_g27043_i0	PRJNA575566	27240	205	0.888889	1.82222245	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.4	0.0322	NR	HCF96245.1	2026799	g27043	i0	63	0.395121951219512	27	10	39.5	0	174	94	674	700	HCF96245.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	81	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;