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

5 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax_phylum = "Candidatus Omnitrophota"

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_genus	tax_species
602440	602440	PRJNA630162_P_NODE_59661_length_228_cov_3.212291_g58138_i0	PRJNA630162	59661	228	3.212291	7.32402348	Candidatus Velamenicoccus archaeovorus	1930593	Bacteria	Bacteria	204	5.2999999999999994e-48	NTclustered	gi\|1560991511\|gb\|CP019384.1\|	1930593	g58138	i0	84.541	160.526315789474	207	30	90	2	10	215	1198038	1198243	Candidatus Velamenicoccus archaeovorus strain LiM chromosome, complete genome	blastn	36600	204	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Velamenicoccus	Candidatus Velamenicoccus archaeovorus
1878724	1878724	PRJNA630162_P_NODE_68762_length_213_cov_5.054878_g67239_i0	PRJNA630162	68762	213	5.054878	10.76689014	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	206	1.36e-48	NTclustered	gi\|2621701202\|emb\|OY759724.1\|	2035772	g67239	i0	88.439	49.7042253521127	173	16	80	4	32	202	2373883	2373713	MAG: Candidatus Omnitrophota bacterium isolate 1a5844f9-839a-4d7b-a7f9-2444bab12bdd genome assembly, chromosome: 1	blastn	10587	206	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota		Candidatus Omnitrophota bacterium
15905061	15905061	PRJNA630162_P_NODE_30713_length_326_cov_2.036101_g29191_i0	PRJNA630162	30713	326	2.036101	6.63768926	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	333	9.77e-87	NTclustered	gi\|2621701202\|emb\|OY759724.1\|	2035772	g29191	i0	85.804	116.751533742331	317	41	97	4	11	326	2373284	2373597	MAG: Candidatus Omnitrophota bacterium isolate 1a5844f9-839a-4d7b-a7f9-2444bab12bdd genome assembly, chromosome: 1	blastn	38061	333	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota		Candidatus Omnitrophota bacterium
18454112	18454112	PRJNA630162_P_NODE_24895_length_367_cov_3.009434_g23375_i0	PRJNA630162	24895	367	3.009434	11.04462278	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	276	1.9e-69	NTclustered	gi\|2621701202\|emb\|OY759724.1\|	2035772	g23375	i0	81.02	322.828337874659	353	62	96	5	10	360	2372184	2371835	MAG: Candidatus Omnitrophota bacterium isolate 1a5844f9-839a-4d7b-a7f9-2444bab12bdd genome assembly, chromosome: 1	blastn	118478	276	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota		Candidatus Omnitrophota bacterium
19729132	19729132	PRJNA630162_P_NODE_66776_length_216_cov_3.574850_g65253_i0	PRJNA630162	66776	216	3.57485	7.721676	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	163	8.44e-36	NTclustered	gi\|2621701202\|emb\|OY759724.1\|	2035772	g65253	i0	80.841	100.782407407407	214	36	98	5	1	211	2372760	2372549	MAG: Candidatus Omnitrophota bacterium isolate 1a5844f9-839a-4d7b-a7f9-2444bab12bdd genome assembly, chromosome: 1	blastn	21769	163	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota		Candidatus Omnitrophota 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);;