metadata: contig_metadata: 10 rows where bioproject = "PRJNA773247", tax_clade = "PVC group" and tax

10 rows where bioproject = "PRJNA773247", tax_clade = "PVC group" and tax_phylum = "Lentisphaerota"

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
26809758	26809758	PRJNA773247_P_NODE_36701_length_224_cov_4.357616_g36617_i0	PRJNA773247	36701	224	4.357616	9.76105984	Pseudomonadati	3379134	Bacteria	Bacteria	57	2.66e-7	NR	NQT93604.1	1932692	g36617	i0	65.9	1.82142857142857	44	15	58.9	0	217	86	331	374	NQT93604.1 tyrosine-type recombinase/integrase [Lentisphaerota bacterium]	diamond	408	57	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
27558675	27558675	PRJNA773247_P_NODE_25924_length_274_cov_2.885572_g25840_i0	PRJNA773247	25924	274	2.885572	7.90646728	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	102	7.22e-24	NR	HQL08161.1	2053569	g25840	i0	68.7	1.45620437956204	67	21	73.4	0	203	3	3	69	HQL08161.1 hypothetical protein [Lentisphaeria bacterium]	diamond	399	102	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
27622158	27622158	PRJNA773247_P_NODE_32284_length_246_cov_8.791908_g32200_i0	PRJNA773247	32284	246	8.791908	21.62809368	uncultured Victivallis sp.	354118	Bacteria	Bacteria	53.5	6.74e-7	NR	WP_294508145.1	354118	g32200	i0	55.3	0.573170731707317	47	21	57.3	0	74	214	52	98	WP_294508145.1 helix-turn-helix transcriptional regulator [uncultured Victivallis sp.]	diamond	141	53.5	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae	Victivallis	uncultured Victivallis sp.
27717144	27717144	PRJNA773247_P_NODE_26764_length_269_cov_3.295918_g26680_i0	PRJNA773247	26764	269	3.295918	8.86601942	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	94	4.15e-20	NR	NLE67547.1	1932692	g26680	i0	51.2	1.9182156133829	86	42	95.9	0	267	10	216	301	NLE67547.1 hypothetical protein [Lentisphaerota bacterium]	diamond	516	94	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
27905908	27905908	PRJNA773247_P_NODE_28485_length_260_cov_1.486631_g28401_i0	PRJNA773247	28485	260	1.486631	3.8652406	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	77	3.93e-14	NR	MBM4164844.1	1932692	g28401	i0	45.7	2.82692307692308	81	44	93.5	0	259	17	545	625	MBM4164844.1 polysaccharide lyase 8 family protein [Lentisphaerota bacterium]	diamond	735	77	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
28348204	28348204	PRJNA773247_P_NODE_5846_length_717_cov_8.543478_g5766_i0	PRJNA773247	5846	717	8.543478	61.25673726	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	116	2.04e-29	NR	HQL09913.1	2053569	g5766	i0	59.1	0.368200836820084	88	35	36.8	1	716	453	8	94	HQL09913.1 hypothetical protein [Lentisphaeria bacterium]	diamond	264	116	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
29137812	29137812	PRJNA773247_P_NODE_12169_length_438_cov_4.476712_g12086_i0	PRJNA773247	12169	438	4.476712	19.60799856	Victivallales bacterium	2212475	Bacteria	Bacteria	47.4	0.0028	NR	MBQ9367076.1	2212475	g12086	i0	29.7	0.876712328767123	128	77	84.2	3	45	413	17	136	MBQ9367076.1 hypothetical protein [Victivallales bacterium]	diamond	384	47.4	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales			Victivallales bacterium
29304869	29304869	PRJNA773247_P_NODE_13629_length_408_cov_2.379104_g13545_i0	PRJNA773247	13629	408	2.379104	9.70674432	Bacteria	2	Bacteria	Bacteria	70.5	2.17e-11	NR	MBQ9501666.1	2053569	g13545	i0	42.2	3.30882352941176	90	42	63.2	4	408	151	197	280	MBQ9501666.1 hypothetical protein [Lentisphaeria bacterium]	diamond	1350	71.2	0.990168539325843	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
29832199	29832199	PRJNA773247_P_NODE_8691_length_545_cov_10.523305_g8608_i0	PRJNA773247	8691	545	10.523305	57.35201225	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	59.3	5.42e-7	NR	MCK5805354.1	2053569	g8608	i0	40.7	0.963302752293578	86	43	42.9	2	537	304	133	218	MCK5805354.1 hypothetical protein [Lentisphaeria bacterium]	diamond	525	59.3	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
32654766	32654766	PRJNA773247_P_NODE_18000_length_342_cov_7.003717_g17916_i0	PRJNA773247	18000	342	7.003717	23.95271214	Pseudomonadati	3379134	Bacteria	Bacteria	52.8	2.65e-5	NR	NLC82908.1	1932692	g17916	i0	56	5.84210526315789	50	19	41.2	1	142	2	3	52	NLC82908.1 3'-5' exonuclease [Lentisphaerota bacterium]	diamond	1998	53.1	0.994350282485876	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota 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);;