metadata: contig_metadata: 11 rows where bioproject = "PRJNA482207", tax_clade = "PVC group" and tax

11 rows where bioproject = "PRJNA482207", 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_species
27360945	27360945	PRJNA482207_P_NODE_20483_length_250_cov_0.870056_g20373_i0	PRJNA482207	20483	250	0.870056	2.17514	Chlamydiota bacterium	2081524	Bacteria	Bacteria	58.9	7.92e-8	NR	MEM1283154.1	2081524	g20373	i0	50.9	0.684	57	28	68.4	0	72	242	292	348	MEM1283154.1 reverse transcriptase domain-containing protein [Chlamydiota bacterium]	diamond	171	58.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiota bacterium
28497576	28497576	PRJNA482207_P_NODE_10747_length_322_cov_0.767068_g10637_i0	PRJNA482207	10747	322	0.767068	2.46995896	Chlamydiota bacterium	2081524	Bacteria	Bacteria	62	1.67e-8	NR	MEM1283154.1	2081524	g10637	i0	37.4	1.86335403726708	99	61	92.2	1	26	322	662	759	MEM1283154.1 reverse transcriptase domain-containing protein [Chlamydiota bacterium]	diamond	600	62	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiota bacterium
28497584	28497584	PRJNA482207_P_NODE_26327_length_245_cov_0.895349_g26217_i0	PRJNA482207	26327	245	0.895349	2.19360505	Chlamydiota bacterium	2081524	Bacteria	Bacteria	102	2.82e-23	NR	MEM1283154.1	2081524	g26217	i0	60.3	1.91020408163265	78	31	95.5	0	239	6	797	874	MEM1283154.1 reverse transcriptase domain-containing protein [Chlamydiota bacterium]	diamond	468	102	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiota bacterium
28592253	28592253	PRJNA482207_P_NODE_20967_length_250_cov_0.870056_g20857_i0	PRJNA482207	20967	250	0.870056	2.17514	Chlamydiota bacterium	2081524	Bacteria	Bacteria	49.3	2.04e-4	NR	MEM1283154.1	2081524	g20857	i0	36.6	0.984	82	51	98.4	1	1	246	597	677	MEM1283154.1 reverse transcriptase domain-containing protein [Chlamydiota bacterium]	diamond	246	49.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiota bacterium
29003077	29003077	PRJNA482207_P_NODE_2988_length_540_cov_0.952891_g2878_i0	PRJNA482207	2988	540	0.952891	5.1456114	Chlamydiota bacterium	2081524	Bacteria	Bacteria	122	1.51e-28	NR	MEM1283154.1	2081524	g2878	i0	48.1	0.727777777777778	131	66	72.8	2	530	138	290	418	MEM1283154.1 reverse transcriptase domain-containing protein [Chlamydiota bacterium]	diamond	393	122	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiota bacterium
29097446	29097446	PRJNA482207_P_NODE_12108_length_308_cov_1.280851_g11998_i0	PRJNA482207	12108	308	1.280851	3.94502108	Chlamydiota bacterium	2081524	Bacteria	Bacteria	110	1.31e-25	NR	MEM1283154.1	2081524	g11998	i0	48.5	1.00324675324675	103	52	99.4	1	306	1	121	223	MEM1283154.1 reverse transcriptase domain-containing protein [Chlamydiota bacterium]	diamond	309	110	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiota bacterium
29129153	29129153	PRJNA482207_P_NODE_5909_length_402_cov_0.820669_g5799_i0	PRJNA482207	5909	402	0.820669	3.29908938	Chlamydiota bacterium	2081524	Bacteria	Bacteria	127	3.89e-31	NR	MEM1283154.1	2081524	g5799	i0	48.5	1	134	68	100	1	402	1	270	402	MEM1283154.1 reverse transcriptase domain-containing protein [Chlamydiota bacterium]	diamond	402	127	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiota bacterium
29633704	29633704	PRJNA482207_P_NODE_27490_length_244_cov_0.900585_g27380_i0	PRJNA482207	27490	244	0.900585	2.1974274	Chlamydiota bacterium	2081524	Bacteria	Bacteria	79.7	3.47e-15	NR	NGX31178.1	2081524	g27380	i0	52.5	0.983606557377049	80	38	98.4	0	242	3	527	606	NGX31178.1 DNA ligase [Chlamydiota bacterium]	diamond	240	79.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiota bacterium
29633709	29633709	PRJNA482207_P_NODE_8230_length_353_cov_0.814286_g8120_i0	PRJNA482207	8230	353	0.814286	2.87442958	Chlamydiota bacterium	2081524	Bacteria	Bacteria	128	1.4799999999999998e-31	NR	MEM1283154.1	2081524	g8120	i0	55.6	0.994334277620397	117	52	99.4	0	2	352	220	336	MEM1283154.1 reverse transcriptase domain-containing protein [Chlamydiota bacterium]	diamond	351	128	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiota bacterium
30076165	30076165	PRJNA482207_P_NODE_26892_length_244_cov_0.900585_g26782_i0	PRJNA482207	26892	244	0.900585	2.1974274	Chlamydiota bacterium	2081524	Bacteria	Bacteria	80.5	1.97e-15	NR	MEM1283154.1	2081524	g26782	i0	51.9	0.94672131147541	77	37	94.7	0	243	13	290	366	MEM1283154.1 reverse transcriptase domain-containing protein [Chlamydiota bacterium]	diamond	231	80.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiota bacterium
30739755	30739755	PRJNA482207_P_NODE_3634_length_497_cov_0.962264_g3524_i0	PRJNA482207	3634	497	0.962264	4.78245208	Chlamydiota bacterium	2081524	Bacteria	Bacteria	135	2.49e-33	NR	MEM1283154.1	2081524	g3524	i0	55.8	0.724346076458752	120	53	72.4	0	369	10	828	947	MEM1283154.1 reverse transcriptase domain-containing protein [Chlamydiota bacterium]	diamond	360	135	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiota 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);;