metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA358049" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA358049" and tax_clade = "Bacteria candidate phyla"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
3623831	3623831	PRJNA358049_S_NODE_6443_length_243_cov_13.056701_g6395_i0	PRJNA358049	6443	243	13.056701	31.72778343	Candidatus Saccharimonadota	95818	Bacteria	Bacteria	300	7.08e-77	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g6395	i0	92.754	195.267489711934	207	15	85	0	14	220	115461	115255	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	47450	300	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
6776063	6776063	PRJNA358049_S_NODE_11906_length_191_cov_1.323944_g11858_i0	PRJNA358049	11906	191	1.323944	2.52873304	candidate division WOR-3 bacterium	2052148	Bacteria	Bacteria	73.1	1.26e-8	NTclustered	gi\|2108275290\|gb\|CP070680.1\|	2052148	g11858	i0	85.714	11.2251308900524	70	9	36	1	102	170	1347588	1347519	MAG: candidate division WOR-3 bacterium isolate bin69 chromosome	blastn	2144	73.1	1	Bacteria	Bacteria candidate phyla	candidate division WOR-3					candidate division WOR-3 bacterium
10602274	10602274	PRJNA358049_S_NODE_14809_length_174_cov_1.984000_g14761_i0	PRJNA358049	14809	174	1.984	3.45216	Candidatus Minimicrobia naudis	2841263	Bacteria	Bacteria	224	2.93e-54	NTclustered	gi\|2052595119\|gb\|CP076460.1\|	2841263	g14761	i0	91.411	90.4540229885057	163	14	94	0	12	174	122984	123146	Candidatus Minimicrobia naudis isolate IHU1 chromosome, complete genome	blastn	15739	224	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia naudis
15701475	15701475	PRJNA358049_S_NODE_7633_length_226_cov_1.898305_g7585_i0	PRJNA358049	7633	226	1.898305	4.2901693	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	115	2.5300000000000003e-21	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g7585	i0	85.217	1.01769911504425	115	14	50	3	78	190	429477	429590	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	230	115	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
19524550	19524550	PRJNA358049_S_NODE_5256_length_266_cov_1.658986_g5208_i0	PRJNA358049	5256	266	1.658986	4.41290276	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	267	7.979999999999999e-67	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g5208	i0	84.962	220.195488721805	266	36	99	4	4	266	125422	125686	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	58572	267	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_1
19524591	19524591	PRJNA358049_S_NODE_6696_length_239_cov_2.673684_g6648_i0	PRJNA358049	6696	239	2.673684	6.39010476	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	239	1.54e-58	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g6648	i0	84.874	94.0334728033473	238	34	99	2	3	239	125669	125905	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	22474	239	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_1
20800279	20800279	PRJNA358049_S_NODE_6737_length_239_cov_1.105263_g6689_i0	PRJNA358049	6737	239	1.105263	2.64157857	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	436	5.0799999999999985e-118	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g6689	i0	99.582	211.008368200837	239	1	100	0	1	239	111002	111240	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	50431	436	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
23350763	23350763	PRJNA358049_S_NODE_6279_length_246_cov_3.096447_g6231_i0	PRJNA358049	6279	246	3.096447	7.61725962	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g6231	i0	100	72.9674796747967	246	0	100	0	1	246	111645	111400	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	17950	455	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae 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);;