metadata: contig_metadata: 8 rows where bioproject = "PRJNA1120203" and tax

8 rows where bioproject = "PRJNA1120203" and tax_phylum = "Candidatus Saccharimonadota"

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
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
28554549	28554549	PRJNA1120203_P_NODE_104347_length_241_cov_0.916667_g103331_i0	PRJNA1120203	104347	241	0.916667	2.20916747	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	148	2.78e-41	NR	HUD11459.1	2890869	g103331	i0	90	0.995850622406639	80	8	99.6	0	1	240	74	153	HUD11459.1 hypothetical protein [Candidatus Saccharimonadia bacterium]	diamond	240	148	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia				Candidatus Saccharimonadia bacterium
31618671	31618671	PRJNA1120203_P_NODE_90256_length_247_cov_0.885057_g89240_i0	PRJNA1120203	90256	247	0.885057	2.18609079	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	54.7	1.45e-6	NR	MDB5176210.1	2026720	g89240	i0	80	0.680161943319838	30	6	36.4	0	1	90	195	224	MDB5176210.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	168	54.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota 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);;