metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1233465" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1233465" 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
25673428	25673428	PRJNA1233465b_S_NODE_191242_length_213_cov_1.865854_g189557_i0	PRJNA1233465	191242	213	1.865854	3.97426902	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	63.9	8.66e-6	NTclustered	gi\|2874253688\|emb\|OY969414.1\|	174324	g189557	i0	89.796	1.69953051643192	49	5	23	0	133	181	1887191	1887143	MAG: uncultured Chlamydiales bacterium isolate MFD04463.bin.c.14 genome assembly, chromosome: 1	blastn	362	63.9	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
25692028	25692028	PRJNA1233465f_S_NODE_210250_length_174_cov_1.616000_g207970_i0	PRJNA1233465	210250	174	1.616	2.81184	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	224	2.93e-54	NTclustered	gi\|2874253712\|emb\|OY969554.1\|	174324	g207970	i0	90.964	2.68390804597701	166	15	95	0	4	169	172359	172194	MAG: uncultured Chlamydiales bacterium isolate MFD04540.bin.c.3 genome assembly, chromosome: 1	blastn	467	224	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
25696437	25696437	PRJNA1233465f_S_NODE_70378_length_277_cov_2.197368_g68098_i0	PRJNA1233465	70378	277	2.197368	6.08670936	Criblamydia sequanensis CRIB-18	1437425	Bacteria	Bacteria	300	8.24e-77	NTclustered	gi\|678241437\|emb\|LK031773.1\|	1437425	g68098	i0	98.246	1.23465703971119	171	3	62	0	107	277	21870	22040	Criblamydia sequanensis plasmid 1, strain CRIB-18, complete sequence	blastn	342	300	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Candidatus Criblamydia	Candidatus Criblamydia sequanensis
25814494	25814494	PRJNA1233465d_S_NODE_139371_length_163_cov_0.868421_g138260_i0	PRJNA1233465	139371	163	0.868421	1.41552623	Criblamydia sequanensis CRIB-18	1437425	Bacteria	Bacteria	268	1.24e-67	NTclustered	gi\|678241437\|emb\|LK031773.1\|	1437425	g138260	i0	96.319	2	163	6	100	0	1	163	22166	22004	Criblamydia sequanensis plasmid 1, strain CRIB-18, complete sequence	blastn	326	268	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Candidatus Criblamydia	Candidatus Criblamydia sequanensis
25818689	25818689	PRJNA1233465e_S_NODE_121675_length_178_cov_1.186047_g120365_i0	PRJNA1233465	121675	178	1.186047	2.11116366	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	163	6.67e-36	NTclustered	gi\|2874253676\|emb\|OY969110.1\|	305355	g120365	i0	95.192	9.66292134831461	104	4	58	1	1	103	753405	753508	MAG: uncultured Chlamydiae bacterium isolate MFD00082.bin.c.5 genome assembly, chromosome: 1	blastn	1720	163	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
25832868	25832868	PRJNA1233465f_S_NODE_78163_length_265_cov_2.032407_g75883_i0	PRJNA1233465	78163	265	2.032407	5.38587855	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	169	2.31e-37	NTclustered	gi\|2874253676\|emb\|OY969110.1\|	305355	g75883	i0	95.327	6.58490566037736	107	4	40	1	160	265	753508	753402	MAG: uncultured Chlamydiae bacterium isolate MFD00082.bin.c.5 genome assembly, chromosome: 1	blastn	1745	169	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
25955328	25955328	PRJNA1233465e_S_NODE_138052_length_169_cov_1.291667_g136742_i0	PRJNA1233465	138052	169	1.291667	2.18291723	Criblamydia sequanensis CRIB-18	1437425	Bacteria	Bacteria	213	6.12e-51	NTclustered	gi\|678241437\|emb\|LK031773.1\|	1437425	g136742	i0	97.581	1.45562130177515	124	3	73	0	1	124	21993	21870	Criblamydia sequanensis plasmid 1, strain CRIB-18, complete sequence	blastn	246	213	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Candidatus Criblamydia	Candidatus Criblamydia sequanensis
26225594	26225594	PRJNA1233465d_S_NODE_83518_length_196_cov_2.428571_g82407_i0	PRJNA1233465	83518	196	2.428571	4.75999916	Criblamydia sequanensis CRIB-18	1437425	Bacteria	Bacteria	267	5.5599999999999996e-67	NTclustered	gi\|678241437\|emb\|LK031773.1\|	1437425	g82407	i0	98.039	1.56122448979592	153	3	78	0	1	153	22022	21870	Criblamydia sequanensis plasmid 1, strain CRIB-18, complete sequence	blastn	306	267	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Criblamydiaceae	Candidatus Criblamydia	Candidatus Criblamydia sequanensis
26356821	26356821	PRJNA1233465b_S_NODE_74535_length_306_cov_1.715953_g72850_i0	PRJNA1233465	74535	306	1.715953	5.25081618	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	255	2.03e-63	NTclustered	gi\|2874253712\|emb\|OY969554.1\|	174324	g72850	i0	83.824	3.40196078431373	272	41	88	3	37	306	100482	100752	MAG: uncultured Chlamydiales bacterium isolate MFD04540.bin.c.3 genome assembly, chromosome: 1	blastn	1041	255	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured 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);;