metadata: contig_metadata: 8 rows where bioproject = "PRJNA526367", tax_clade = "PVC group" and tax

8 rows where bioproject = "PRJNA526367", 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_genus	tax_species
18347292	18347292	PRJNA526367_P_NODE_19695_length_324_cov_2.458182_g19486_i0	PRJNA526367	19695	324	2.458182	7.96450968	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	163	1.35e-35	NTclustered	gi\|1869331976\|gb\|CP058704.1\|	2052176	g19486	i0	96.907	49.7469135802469	97	3	30	0	228	324	835937	835841	Parachlamydiaceae bacterium isolate SSA5 chromosome	blastn	16118	163	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae bacterium
28119634	28119634	PRJNA526367_P_NODE_48845_length_169_cov_1.225000_g48635_i0	PRJNA526367	48845	169	1.225	2.07025	Chlamydia psittaci 84-8471/1	1112230	Bacteria	Bacteria	68.2	1.02e-13	NR	EPP38980.1	1112230	g48635	i0	78	0.727810650887574	41	9	72.8	0	47	169	1	41	EPP38980.1 hypothetical protein CP8484711_2377, partial [Chlamydia psittaci 84-8471/1]	diamond	123	68.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
28625043	28625043	PRJNA526367_P_NODE_25827_length_324_cov_1.956364_g25618_i0	PRJNA526367	25827	324	1.956364	6.33861936	Chlamydia trachomatis	813	Bacteria	Bacteria	106	9.85e-26	NR	CQB88612.1	813	g25618	i0	59.4	0.981481481481482	106	22	98.1	1	324	7	128	212	CQB88612.1 Uncharacterised protein [Chlamydia trachomatis]	diamond	318	106	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
28877362	28877362	PRJNA526367_P_NODE_37108_length_188_cov_3.287770_g36898_i0	PRJNA526367	37108	188	3.28777	6.1810076	Chlamydia trachomatis	813	Bacteria	Bacteria	136	2.6399999999999998e-40	NR	CQB88610.1	813	g36898	i0	95.1	0.973404255319149	61	3	97.3	0	5	187	14	74	CQB88610.1 Uncharacterised protein [Chlamydia trachomatis]	diamond	183	136	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
29145580	29145580	PRJNA526367_P_NODE_32969_length_235_cov_1.161290_g32759_i0	PRJNA526367	32969	235	1.16129	2.7290315	Chlamydia	810	Bacteria	Bacteria	55.5	5.61e-8	NR	EPP29881.1	1112230	g32759	i0	83.9	1.12340425531915	31	5	39.6	0	229	137	2	32	EPP29881.1 hypothetical protein CP8484711_2856, partial [Chlamydia psittaci 84-8471/1]	diamond	264	55.8	0.99462365591397806	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
30835652	30835652	PRJNA526367_P_NODE_16274_length_324_cov_2.770909_g16065_i0	PRJNA526367	16274	324	2.770909	8.97774516	Chlamydia trachomatis	813	Bacteria	Bacteria	68.6	3.35e-11	NR	CQB88612.1	813	g16065	i0	100	0.601851851851852	33	0	30.6	0	99	1	95	127	CQB88612.1 Uncharacterised protein [Chlamydia trachomatis]	diamond	195	68.6	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis
31057187	31057187	PRJNA526367_P_NODE_40035_length_183_cov_2.186567_g39825_i0	PRJNA526367	40035	183	2.186567	4.00141761	Chlamydiales bacterium	2047757	Bacteria	Bacteria	87.4	5.23e-19	NR	MBN9377299.1	2047757	g39825	i0	71.9	1.86885245901639	57	16	93.4	0	6	176	43	99	MBN9377299.1 glutamate racemase [Chlamydiales bacterium]	diamond	342	87.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
32385336	32385336	PRJNA526367_P_NODE_48159_length_170_cov_1.454545_g47949_i0	PRJNA526367	48159	170	1.454545	2.4727265	Chlamydia psittaci 84-8471/1	1112230	Bacteria	Bacteria	53.9	4.35e-8	NR	EPP35180.1	1112230	g47949	i0	80	0.529411764705882	30	6	52.9	0	3	92	11	40	EPP35180.1 hypothetical protein CP8484711_2899, partial [Chlamydia psittaci 84-8471/1]	diamond	90	53.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci

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);;