metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA627467" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA627467" 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	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
5702688	5702688	PRJNA627467_P_NODE_1005_length_364_cov_5.028571_g938_i0	PRJNA627467	1005	364	5.028571	18.30399844	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	287	8.7e-73	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g938	i0	99.367	44.7884615384615	158	1	75	207	364	111499	111656	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	16303	287	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
8252352	8252352	PRJNA627467_P_NODE_19927_length_158_cov_9.733945_g19858_i0	PRJNA627467	19927	158	9.733945	15.3796331	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	278	1.98e-70	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g19858	i0	100	303.335443037975	150	0	97	4	153	110115	110264	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	47927	278	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
11354248	11354248	PRJNA627467_P_NODE_3229_length_316_cov_2.142322_g3161_i0	PRJNA627467	3229	316	2.142322	6.76973752	Bacteria	2	Bacteria	Bacteria	207	5.97e-49	NTclustered	gi\|1958075319\|gb\|CP064995.1\|	2026720	g3161	i0	98.305	59.4588607594937	118	2	66	199	316	693007	692890	Candidatus Saccharibacteria bacterium isolate Hjor_18-Q3-R7-51_MAXAC.102_uni chromosome, complete genome	blastn	18789	207	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
12078575	12078575	PRJNA627467_P_NODE_19730_length_159_cov_5.172727_g19661_i0	PRJNA627467	19730	159	5.172727	8.22463593	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	132	1.64e-26	NTclustered	gi\|2218409032\|gb\|CP089290.1\|	2899133	g19661	i0	81.935	3.89937106918239	155	28	97	2	156	329265	329111	Candidatus Nanosynbacter sp. HMT-352 strain TM7-001 chromosome	blastn	620	132	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
13353468	13353468	PRJNA627467_P_NODE_5551_length_316_cov_1.531835_g5483_i0	PRJNA627467	5551	316	1.531835	4.8405986	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	76.8	1.76e-9	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g5483	i0	91.071	0.177215189873418	56	5	18	1	56	881928	881983	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	56	76.8	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium Aalborg_AAW-1
14628202	14628202	PRJNA627467_P_NODE_8272_length_210_cov_2.633540_g8203_i0	PRJNA627467	8272	210	2.63354	5.530434	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	383	5.75e-102	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g8203	i0	100	318.204761904762	207	0	99	4	210	139062	138856	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	66823	383	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
15902214	15902214	PRJNA627467_P_NODE_6173_length_312_cov_2.653992_g6105_i0	PRJNA627467	6173	312	2.653992	8.28045504	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	145	4.68e-30	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g6105	i0	92.929	33.9070512820513	99	7	63	213	311	890219	890317	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	10579	145	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium HOT-871
19002217	19002217	PRJNA627467_P_NODE_15055_length_170_cov_6.347107_g14986_i0	PRJNA627467	15055	170	6.347107	10.7900819	Candidatus Saccharimonadota	95818	Bacteria	Bacteria	219	1.3199999999999996e-52	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g14986	i0	90.798	341.017647058824	163	15	98	5	167	115299	115461	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	57973	219	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
21001566	21001566	PRJNA627467_P_NODE_20957_length_154_cov_3.142857_g20888_i0	PRJNA627467	20957	154	3.142857	4.83999978	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	132	1.58e-26	NTclustered	gi\|2621702180\|emb\|OY760177.1\|	2044595	g20888	i0	90.099	11.1233766233766	101	10	66	7	107	333608	333508	MAG: Candidatus Gracilibacteria bacterium isolate ba77f91b-d06a-446b-8ae6-f296fa1be4ef genome assembly, chromosome: 1	blastn	1713	132	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Altimarinota bacterium
23551800	23551800	PRJNA627467_P_NODE_4399_length_316_cov_1.756554_g4331_i0	PRJNA627467	4399	316	1.756554	5.55071064	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	73.1	2.27e-8	NTclustered	gi\|2518556404\|emb\|OX638375.1\|	2838779	g4331	i0	92.157	0.30379746835443	51	4	16	41	91	4019614	4019564	MAG: Candidatus Binatia bacterium isolate 97b5e0c7-6798-4f16-949c-9b63468df6e4 genome assembly, chromosome: 1	blastn	96	73.1	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
24825428	24825428	PRJNA627467_P_NODE_6320_length_300_cov_3.808765_g6252_i0	PRJNA627467	6320	300	3.808765	11.426295	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	204	7.28e-48	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g6252	i0	96.721	151.313333333333	122	4	73	1	122	110999	110878	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	45394	204	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);;