metadata: contig_metadata: 9 rows where bioproject = "PRJEB10140", tax_clade = "PVC group" and tax

9 rows where bioproject = "PRJEB10140", 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
11779	11779	PRJEB10140_P_NODE_16261_length_1717_cov_6.985012_g9111_i1	PRJEB10140	16261	1717	6.985012	119.93265604	Simkania negevensis	83561	Bacteria	Bacteria	54.7	0.049	NTclustered	gi\|336481279\|emb\|FR872582.1\|	331113	g9111	i1	100	0.0168899242865463	29	0	2	0	1473	1501	975538	975510	Simkania negevensis Z main chromosome, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis
3839475	3839475	PRJEB10140_P_NODE_65644_length_559_cov_4.078431_g48664_i0	PRJEB10140	65644	559	4.078431	22.79842929	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g48664	i0	100	0.0554561717352415	31	0	6	0	71	101	1194943	1194913	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	31	58.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
7664035	7664035	PRJEB10140_P_NODE_16007_length_1733_cov_7.245843_g9111_i0	PRJEB10140	16007	1733	7.245843	125.57045919	Simkania negevensis	83561	Bacteria	Bacteria	54.7	0.05	NTclustered	gi\|336481279\|emb\|FR872582.1\|	331113	g9111	i0	100	0.016733987305251	29	0	2	0	217	245	975510	975538	Simkania negevensis Z main chromosome, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis
21384481	21384481	PRJEB10140_P_NODE_288617_length_162_cov_0.920354_g271308_i0	PRJEB10140	288617	162	0.920354	1.49097348	Chlamydia	810	Bacteria	Bacteria	137	3.6199999999999997e-28	NTclustered	gi\|1032413971\|gb\|CP015840.1\|	1143323	g271308	i0	82.895	71.5925925925926	152	26	94	0	1	152	328520	328369	Chlamydia gallinacea 08-1274/3, complete genome	blastn	11598	137	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia gallinacea
26931662	26931662	PRJEB10140_P_NODE_122562_length_299_cov_1.032000_g105255_i0	PRJEB10140	122562	299	1.032	3.08568	Bacteria	2	Bacteria	Bacteria	59.3	1.14e-7	NR	WP_059359016.1	83552	g105255	i0	35.7	5.06688963210702	70	45	70.2	0	260	51	2154	2223	WP_059359016.1 amino acid adenylation domain-containing protein [Parachlamydia acanthamoebae]	diamond	1515	59.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
27601514	27601514	PRJEB10140_P_NODE_192624_length_201_cov_1.453947_g175315_i0	PRJEB10140	192624	201	1.453947	2.92243347	Simkania sp.	34094	Bacteria	Bacteria	85.1	3.36e-18	NR	MCB1084310.1	34094	g175315	i0	63.1	0.970149253731343	65	24	97	0	3	197	110	174	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	195	85.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
28169673	28169673	PRJEB10140_P_NODE_266146_length_166_cov_0.871795_g248837_i0	PRJEB10140	266146	166	0.871795	1.4471797	Candidatus Rhabdochlamydia	292833	Bacteria	Bacteria	55.1	9.22e-8	NR	WP_215217323.1	292833	g248837	i0	79.4	0.614457831325301	34	6	61.4	1	2	103	94	126	WP_215217323.1 MULTISPECIES: preprotein translocase subunit YajC [Candidatus Rhabdochlamydia]	diamond	102	55.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia
28548707	28548707	PRJEB10140_P_NODE_134387_length_273_cov_3.107143_g117080_i0	PRJEB10140	134387	273	3.107143	8.48250039	Candidatus Algichlamydia australiensis	3341976	Bacteria	Bacteria	44.7	0.0109	NR	MDX8431166.1	3341976	g117080	i0	35.9	0.703296703296703	64	38	68.1	2	256	71	484	546	MDX8431166.1 hypothetical protein [Candidatus Algichlamydia australiensis]	diamond	192	44.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Algichlamydia	Candidatus Algichlamydia australiensis
29779940	29779940	PRJEB10140_P_NODE_249571_length_168_cov_1.310924_g232262_i0	PRJEB10140	249571	168	1.310924	2.20235232	Parachlamydiaceae bacterium	2052176	Bacteria	Bacteria	66.2	6.77e-11	NR	MFI0436039.1	2052176	g232262	i0	64.8	0.964285714285714	54	17	96.4	1	164	3	256	307	MFI0436039.1 BT4734/BF3469 family protein [Parachlamydiaceae bacterium]	diamond	162	66.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		Parachlamydiaceae 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);;