metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA1120203" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA1120203" 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
4855475	4855475	PRJNA1120203_P_NODE_100544_length_243_cov_0.905882_g99528_i0	PRJNA1120203	100544	243	0.905882	2.20129326	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	368	1.91e-97	NTclustered	gi\|2218409810\|gb\|CP089289.1\|	2899133	g99528	i0	94.191	5.94238683127572	241	14	99	0	3	243	203773	203533	Candidatus Nanosynbacter sp. HMT-352 strain TM7-072 chromosome	blastn	1444	368	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
5378546	5378546	PRJNA1120203_P_NODE_83345_length_249_cov_1.005682_g82329_i0	PRJNA1120203	83345	249	1.005682	2.50414818	Candidatus Minimicrobia vallesae	2841264	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2052594292\|gb\|CP076459.1\|	2841264	g82329	i0	99.598	8	249	1	100	0	1	249	81988	82236	Candidatus Minimicrobia vallesae isolate IHU2 chromosome, complete genome	blastn	1992	455	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia vallesae
9956039	9956039	PRJNA1120203_P_NODE_63588_length_282_cov_1.588517_g62572_i0	PRJNA1120203	63588	282	1.588517	4.47961794	Bacteria	2	Bacteria	Bacteria	309	1.4e-79	NTclustered	gi\|2874253873\|emb\|OY969928.1\|	179883	g62572	i0	87.97	435.202127659574	266	26	93	6	7	269	597314	597052	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04212.bin.c.13 genome assembly, chromosome: 1	blastn	122727	309	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
9956219	9956219	PRJNA1120203_P_NODE_87048_length_248_cov_0.880000_g86032_i0	PRJNA1120203	87048	248	0.88	2.1824	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|2052594292\|gb\|CP076459.1\|	2841264	g86032	i0	99.597	5.98790322580645	248	1	100	0	1	248	652975	653222	Candidatus Minimicrobia vallesae isolate IHU2 chromosome, complete genome	blastn	1485	453	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia vallesae
10478421	10478421	PRJNA1120203_P_NODE_32789_length_407_cov_14.766467_g31774_i0	PRJNA1120203	32789	407	14.766467	60.09952069	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	540	6.839999999999999e-149	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g31774	i0	91.414	86.2162162162162	396	30	97	4	1	394	427520	427127	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	35090	540	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
10479040	10479040	PRJNA1120203_P_NODE_79709_length_251_cov_0.865169_g78693_i0	PRJNA1120203	79709	251	0.865169	2.17157419	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	137	6.100000000000001e-28	NTclustered	gi\|2874254095\|emb\|OY970178.1\|	2212470	g78693	i0	79.293	3.46613545816733	198	39	78	2	54	250	1442459	1442263	MAG: Candidatus Eisenbacteria bacterium isolate MFD05942.bin.c.1 genome assembly, chromosome: 1	blastn	870	137	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota					Candidatus Eiseniibacteriota bacterium
11753237	11753237	PRJNA1120203_P_NODE_32790_length_407_cov_10.955090_g31775_i0	PRJNA1120203	32790	407	10.95509	44.5872163	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	623	6.599999999999998e-174	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g31775	i0	95.19	85.2702702702703	395	17	97	2	1	394	427520	427127	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	34705	623	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
11753426	11753426	PRJNA1120203_P_NODE_47350_length_328_cov_2.937255_g46334_i0	PRJNA1120203	47350	328	2.937255	9.6341964	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	521	1.9599999999999998e-143	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g46334	i0	95.427	88.6981707317073	328	14	100	1	1	328	427194	427520	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	29093	521	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
15055847	15055847	PRJNA1120203_P_NODE_84452_length_249_cov_0.875000_g83436_i0	PRJNA1120203	84452	249	0.875	2.17875	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2218410560\|gb\|CP089288.1\|	2899133	g83436	i0	100	4	249	0	100	0	1	249	640437	640189	Candidatus Nanosynbacter sp. HMT-352 strain TM7-037 chromosome	blastn	996	460	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
16330505	16330505	PRJNA1120203_P_NODE_70253_length_268_cov_0.892308_g69237_i0	PRJNA1120203	70253	268	0.892308	2.39138544	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	429	9.7e-116	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g69237	i0	95.522	10.4626865671642	268	12	100	0	1	268	231462	231195	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	2804	429	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
18127391	18127391	PRJNA1120203_P_NODE_99415_length_243_cov_0.905882_g98399_i0	PRJNA1120203	99415	243	0.905882	2.20129326	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	326	1.17e-84	NTclustered	gi\|1958112918\|gb\|CP065009.1\|	2030811	g98399	i0	93.578	90.3786008230453	218	14	90	0	14	231	1124749	1124966	MAG: Candidatus Peregrinibacteria bacterium isolate Lyne_18-Q3-R50-59_MAXAC.411_cln chromosome, complete genome	blastn	21962	326	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota					Candidatus Peregrinibacteria bacterium
19401335	19401335	PRJNA1120203_P_NODE_84616_length_249_cov_0.875000_g83600_i0	PRJNA1120203	84616	249	0.875	2.17875	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	71.3	6.22e-8	NTclustered	gi\|2621703606\|emb\|OY761465.1\|	2838779	g83600	i0	97.561	264.538152610442	41	1	20	0	64	104	2066051	2066011	MAG: Candidatus Binatia bacterium isolate d3e24e22-6b5b-4867-8422-75782eed2520 genome assembly, chromosome: 1	blastn	65870	71.3	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia 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);;