metadata: contig_metadata: 5 rows where bioproject = "PRJNA1146029", tax_clade = "PVC group" and tax

5 rows where bioproject = "PRJNA1146029", 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_species
7943111	7943111	PRJNA1146029_P_NODE_14027_length_264_cov_1.612565_g13746_i0	PRJNA1146029	14027	264	1.612565	4.2571716	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	383	7.53e-102	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g13746	i0	92.803	122.128787878788	264	19	100	0	1	264	654819	654556	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	32242	383	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	uncultured Parachlamydiaceae bacterium
9218071	9218071	PRJNA1146029_P_NODE_16428_length_250_cov_1.740113_g16147_i0	PRJNA1146029	16428	250	1.740113	4.3502825	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	326	1.21e-84	NTclustered	gi\|880804247\|gb\|KT262991.1\|	174324	g16147	i0	90.119	69.268	253	22	100	2	1	250	267	15	Uncultured Chlamydiales bacterium clone SW5A 16S ribosomal RNA gene, partial sequence	blastn	17317	326	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales		uncultured Chlamydiales bacterium
24515862	24515862	PRJNA1146029_P_NODE_11020_length_284_cov_1.459716_g10739_i0	PRJNA1146029	11020	284	1.459716	4.14559344	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	429	1.04e-115	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g10739	i0	94.035	116.679577464789	285	13	100	4	1	284	2060234	2060515	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	33137	429	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	uncultured Parachlamydiaceae bacterium
27912104	27912104	PRJNA1146029_P_NODE_19845_length_245_cov_0.895349_g19564_i0	PRJNA1146029	19845	245	0.895349	2.19360505	Chlamydiia	204429	Bacteria	Bacteria	105	2.95e-26	NR	HEY4255098.1	2047757	g19564	i0	61.5	3.82040816326531	78	30	95.5	0	236	3	102	179	HEY4255098.1 1-acyl-sn-glycerol-3-phosphate acyltransferase [Chlamydiales bacterium]	diamond	936	105	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales		Chlamydiales bacterium
30196798	30196798	PRJNA1146029_P_NODE_21592_length_242_cov_0.911243_g21311_i0	PRJNA1146029	21592	242	0.911243	2.20520806	Simkaniaceae bacterium	2698248	Bacteria	Bacteria	43.1	0.0266	NR	MBP9841691.1	2698248	g21311	i0	43.8	0.59504132231405	48	27	59.5	0	14	157	64	111	MBP9841691.1 hypothetical protein [Simkaniaceae bacterium]	diamond	144	43.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkaniaceae 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);;