metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA703759" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA703759" 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
1184884	1184884	PRJNA703759_P_NODE_23261_length_292_cov_1.232877_g22785_i0	PRJNA703759	23261	292	1.232877	3.60000084	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	512	1.03e-140	NTclustered	gi\|734569044\|gb\|CP007496.1\|	2093824	g22785	i0	98.288	3.1472602739726	292	5	100	0	1	292	538121	538412	Candidatus Nanosynbacter lyticus strain TM7x chromosome, complete genome	blastn	919	512	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter lyticus
3235768	3235768	PRJNA703759_P_NODE_46463_length_245_cov_0.906977_g45987_i0	PRJNA703759	46463	245	0.906977	2.22209365	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	119	2.15e-22	NTclustered	gi\|2874254017\|emb\|OY970342.1\|	2212470	g45987	i0	95.89	0.56734693877551	73	3	30	0	173	245	2587837	2587765	MAG: Candidatus Eisenbacteria bacterium isolate MFD02242.bin.c.1 genome assembly, chromosome: 1	blastn	139	119	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota					Candidatus Eiseniibacteriota bacterium
12163303	12163303	PRJNA703759_P_NODE_170_length_20396_cov_6.439994_g70_i0	PRJNA703759	170	20396	6.439994	1313.50117624	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	1363	0	NTclustered	gi\|1958074337\|gb\|CP064994.1\|	2045217	g70	i0	78.706	0.208080015689351	2118	397	10	46	6922	9013	239580	241669	MAG: Candidatus Moraniibacteriota bacterium isolate Hirt_18-Q3-R61-65_MAXAC.378_cln chromosome, complete genome	blastn	4244	1363	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota					Candidatus Moraniibacteriota bacterium
17262030	17262030	PRJNA703759_P_NODE_174_length_19879_cov_6.122892_g71_i0	PRJNA703759	174	19879	6.122892	1217.16970068	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	1851	0	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g71	i0	86.366	0.832738065295035	1709	218	9	14	159	1861	393643	395342	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	16554	1851	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
19811580	19811580	PRJNA703759_P_NODE_42836_length_247_cov_0.896552_g42360_i0	PRJNA703759	42836	247	0.896552	2.21448344	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	239	1.6e-58	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g42360	i0	84.274	28.7044534412955	248	35	99	3	3	247	162069	161823	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	7090	239	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
21086961	21086961	PRJNA703759_P_NODE_37617_length_251_cov_0.876404_g37141_i0	PRJNA703759	37617	251	0.876404	2.19977404	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	145	3.65e-30	NTclustered	gi\|2874253997\|emb\|OY970322.1\|	179883	g37141	i0	98.765	24.1195219123506	81	1	32	0	83	163	1087175	1087095	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05512.bin.c.2 genome assembly, chromosome: 1	blastn	6054	145	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
23637625	23637625	PRJNA703759_P_NODE_46539_length_245_cov_0.906977_g46063_i0	PRJNA703759	46539	245	0.906977	2.22209365	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	425	1.1299999999999999e-114	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g46063	i0	97.959	2.00408163265306	245	5	100	0	1	245	19103	18859	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	491	425	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
23637843	23637843	PRJNA703759_P_NODE_7319_length_515_cov_6.800905_g6843_i0	PRJNA703759	7319	515	6.800905	35.02466075	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	137	1.35e-27	NTclustered	gi\|1958030595\|gb\|CP064975.1\|	2045217	g6843	i0	98.701	3.19417475728155	77	1	15	0	148	224	167636	167560	MAG: Candidatus Moraniibacteriota bacterium isolate EsbW_18-Q3-R4-48_MAXAC.278_cln chromosome, complete genome	blastn	1645	137	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota					Candidatus Moraniibacteriota bacterium
24910323	24910323	PRJNA703759_P_NODE_14700_length_352_cov_1.655914_g14224_i0	PRJNA703759	14700	352	1.655914	5.82881728	candidate division Kazan bacterium GW2011_GWA1_50_15	1620412	Bacteria	Bacteria	111	5.41e-20	NTclustered	gi\|837354425\|gb\|CP011216.1\|	1620412	g14224	i0	93.333	21.4090909090909	75	5	21	0	2	76	424052	424126	Candidate division Kazan bacterium GW2011_GWA1_50_15 chromosome, complete genome	blastn	7536	111	1	Bacteria	Bacteria candidate phyla						candidate division Kazan bacterium GW2011_GWA1_50_15

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