metadata: contig_metadata: 11 rows where bioproject = "PRJNA293022", tax_clade = "Bacteria candidate phyla" and tax

11 rows where bioproject = "PRJNA293022", tax_clade = "Bacteria candidate phyla" 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_species
1648038	1648038	PRJNA293022_P_NODE_382_length_1703_cov_7.244256_g236_i0	PRJNA293022	382	1703	7.244256	123.36967968	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	2019	0	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g236	i0	94.826	219.135642982971	1295	66	76	1	1	1295	139600	138307	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	373188	2019	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharibacteria bacterium oral taxon 955
5476777	5476777	PRJNA293022_P_NODE_4705_length_646_cov_4.698492_g4055_i0	PRJNA293022	4705	646	4.698492	30.35225832	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	828	0	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g4055	i0	98.712	397.656346749226	466	6	72	0	2	467	907486	907021	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	256886	828	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				TM7 phylum sp. oral taxon 349
6750901	6750901	PRJNA293022_P_NODE_27026_length_271_cov_1.297297_g26289_i0	PRJNA293022	27026	271	1.297297	3.51567487	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	398	2.7699999999999993e-106	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g26289	i0	94.574	176.284132841328	258	13	95	1	14	271	138659	138403	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	47773	398	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharibacteria bacterium oral taxon 955
8026616	8026616	PRJNA293022_P_NODE_42567_length_214_cov_1.248485_g41830_i0	PRJNA293022	42567	214	1.248485	2.6717579	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	263	8.000000000000002e-66	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g41830	i0	89.151	54.2523364485981	212	22	99	1	1	212	543807	544017	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	11610	263	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharibacteria genomosp. TM7-H1
9987911	9987911	PRJNA293022_P_NODE_7308_length_528_cov_5.054280_g6589_i0	PRJNA293022	7308	528	5.05428	26.6865984	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	905	0	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g6589	i0	97.719	139.920454545455	526	12	99	0	3	528	151807	152332	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	73878	911	0.993413830954994	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharibacteria bacterium oral taxon 488
9987919	9987919	PRJNA293022_P_NODE_74748_length_164_cov_2.808696_g74011_i0	PRJNA293022	74748	164	2.808696	4.60626144	Candidatus Saccharimonadaceae	2171986	Bacteria	Bacteria	259	7.52e-65	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g74011	i0	95.122	105.05487804878	164	8	100	0	1	164	904988	905151	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	17229	261	0.992337164750958	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				TM7 phylum sp. oral taxon 349
13127121	13127121	PRJNA293022_P_NODE_46711_length_204_cov_1.658065_g45974_i0	PRJNA293022	46711	204	1.658065	3.3824526	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	274	3.49e-69	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g45974	i0	91.176	29.7941176470588	204	15	100	3	1	204	543538	543738	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	6078	274	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharibacteria genomosp. TM7-H1
17637330	17637330	PRJNA293022_P_NODE_38394_length_225_cov_2.886364_g37657_i0	PRJNA293022	38394	225	2.886364	6.494319	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	368	1.75e-97	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g37657	i0	96.413	133.271111111111	223	8	99	0	1	223	79818	79596	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	29986	368	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
18224871	18224871	PRJNA293022_P_NODE_20915_length_311_cov_2.400763_g20178_i0	PRJNA293022	20915	311	2.400763	7.46637293	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	540	5.09e-149	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g20178	i0	98.684	63.4951768488746	304	4	99	0	6	309	111847	111544	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	19747	540	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae	Candidatus Nanogingivalaceae bacterium
19499205	19499205	PRJNA293022_P_NODE_43236_length_212_cov_2.024540_g42499_i0	PRJNA293022	43236	212	2.02454	4.2920248	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	340	3.55e-89	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g42499	i0	96.585	243.27358490566	205	7	97	0	7	211	884054	883850	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	51574	340	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharimonadota bacterium
22049638	22049638	PRJNA293022_P_NODE_21718_length_305_cov_2.503906_g20981_i0	PRJNA293022	21718	305	2.503906	7.6369133	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	409	1.46e-109	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g20981	i0	91.118	63.1606557377049	304	24	99	3	1	303	452001	451700	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	19264	409	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Saccharibacteria bacterium RAAC3_TM7_1

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);;