metadata: contig_metadata: 10 rows where bioproject = "PRJNA597223", tax_clade = "PVC group" and tax

10 rows where bioproject = "PRJNA597223", 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
569641	569641	PRJNA597223_P_NODE_9881_length_551_cov_138.372093_g8241_i0	PRJNA597223	9881	551	138.372093	762.43023243	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	662	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g8241	i0	89.326	139.693284936479	534	47	96	8	2	528	654873	655403	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	76971	662	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
10773334	10773334	PRJNA597223_P_NODE_3449_length_927_cov_15.553812_g2478_i0	PRJNA597223	3449	927	15.553812	144.18383724	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	259	5.1400000000000006e-64	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g2478	i0	82.051	41.2308522114347	312	48	33	8	620	927	2059246	2059553	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	38221	259	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
10773748	10773748	PRJNA597223_P_NODE_72009_length_168_cov_1.000000_g70163_i0	PRJNA597223	72009	168	1	1.68	Chlamydia sp. 12-3998_AO002	1608579	Bacteria	Bacteria	150	4.86e-32	NTclustered	gi\|795784157\|emb\|LN810465.1\|	1608579	g70163	i0	82.941	244.690476190476	170	25	100	4	1	168	258	91	Chlamydia sp. 12-3998_AO002 partial 23S rRNA gene, isolate 12-3998_AO002	blastn	41108	150	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia sp. 12-3998_AO002
15168804	15168804	PRJNA597223_P_NODE_27672_length_291_cov_5.070312_g25826_i0	PRJNA597223	27672	291	5.070312	14.75460792	Chlamydiia	204429	Bacteria	Bacteria	257	5.32e-64	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g25826	i0	85.375	84.9381443298969	253	31	86	6	41	291	2366263	2366015	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	24717	259	0.992277992277992	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
18992250	18992250	PRJNA597223_P_NODE_86235_length_151_cov_3.413793_g84389_i0	PRJNA597223	86235	151	3.413793	5.15482743	Parachlamydiales	1963360	Bacteria	Bacteria	95.3	2.02e-15	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g84389	i0	92.424	10.6026490066225	66	5	44	0	6	71	1215	1280	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	1601	95.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
21542535	21542535	PRJNA597223_P_NODE_26977_length_296_cov_6.704981_g25131_i0	PRJNA597223	26977	296	6.704981	19.84674376	Parachlamydia	83551	Bacteria	Bacteria	444	3.88e-120	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g25131	i0	93.878	159.148648648649	294	18	99	0	3	296	2946	2653	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	47108	444	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
22817822	22817822	PRJNA597223_P_NODE_15298_length_428_cov_8.399491_g13502_i0	PRJNA597223	15298	428	8.399491	35.94982148	Chlamydiia	204429	Bacteria	Bacteria	516	1.22e-141	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g13502	i0	89.398	141.588785046729	415	37	96	7	2	412	2060622	2061033	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	60600	516	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
23521378	23521378	PRJNA597223_P_NODE_35359_length_245_cov_2.585714_g33513_i0	PRJNA597223	35359	245	2.585714	6.3349993	Candidatus Protochlamydia amoebophila	362787	Bacteria	Bacteria	311	3.3000000000000003e-80	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g33513	i0	89.712	37.1387755102041	243	25	99	0	2	244	2154021	2153779	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	9099	311	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
29763755	29763755	PRJNA597223_P_NODE_19651_length_366_cov_2.870091_g17820_i0	PRJNA597223	19651	366	2.870091	10.50453306	Chlamydiales bacterium	2047757	Bacteria	Bacteria	75.5	5.14e-13	NR	HEV7737122.1	2047757	g17820	i0	66.1	2.29508196721311	56	19	45.9	0	199	366	137	192	HEV7737122.1 reverse transcriptase family protein [Chlamydiales bacterium]	diamond	840	75.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31944612	31944612	PRJNA597223_P_NODE_52017_length_193_cov_2.012658_g50171_i0	PRJNA597223	52017	193	2.012658	3.88442994	Chlamydiales bacterium	2047757	Bacteria	Bacteria	42	0.0149	NR	MDR3624086.1	2047757	g50171	i0	84.6	0.823834196891192	26	4	40.4	0	185	108	41	66	MDR3624086.1 histone [Chlamydiales bacterium]	diamond	159	42	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales 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);;