metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1120771" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1120771" 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
5379720	5379720	PRJNA1120771_S_NODE_17805_length_273_cov_2.095652_g17405_i0	PRJNA1120771	17805	273	2.095652	5.72112996	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	427	3.5599999999999992e-115	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g17405	i0	94.872	158.285714285714	273	14	100	0	1	273	1249737	1250009	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	43212	427	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
7406434	7406434	PRJNA1120771_S_NODE_2926_length_530_cov_4.154004_g2549_i0	PRJNA1120771	2926	530	4.154004	22.0162212	Candidatus Protochlamydia	282132	Bacteria	Bacteria	750	0	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g2549	i0	93.01	176.754716981132	515	35	97	1	1	514	1249814	1250328	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	93680	750	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
13030352	13030352	PRJNA1120771_S_NODE_3251_length_507_cov_7.635776_g2864_i0	PRJNA1120771	3251	507	7.635776	38.71338432	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	699	0	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g2864	i0	91.552	180.447731755424	509	39	100	4	1	507	2190851	2190345	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	91487	699	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
18128278	18128278	PRJNA1120771_S_NODE_16655_length_280_cov_2.341772_g16255_i0	PRJNA1120771	16655	280	2.341772	6.5569616	Rosistilla oblonga	2527990	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1712737282\|gb\|CP036318.1\|	2527990	g16255	i0	96.875	0.328571428571429	32	1	11	0	82	113	5614571	5614540	Rosistilla oblonga strain Mal33 chromosome	blastn	92	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla oblonga
24502648	24502648	PRJNA1120771_S_NODE_4440_length_449_cov_8.305419_g4042_i0	PRJNA1120771	4440	449	8.305419	37.29133131	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	551	3.5199999999999983e-152	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g4042	i0	88.864	57.8129175946548	449	48	99	2	1	448	1867429	1867876	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	25958	551	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae 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);;