metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA814235" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA814235" 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
2093013	2093013	PRJNA814235_P_NODE_27842_length_362_cov_5.387692_g26462_i0	PRJNA814235	27842	362	5.387692	19.50344504	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	560	4.61e-155	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g26462	i0	94.972	186.795580110497	358	17	99	1	6	362	963863	964220	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	67620	560	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
4643797	4643797	PRJNA814235_P_NODE_113024_length_203_cov_1.993976_g111629_i0	PRJNA814235	113024	203	1.993976	4.04777128	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	100	6.23e-17	NTclustered	gi\|2874254031\|emb\|OY970356.1\|	179883	g111629	i0	90.667	0.369458128078818	75	7	37	0	128	202	367273	367347	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05684.bin.c.4 genome assembly, chromosome: 1	blastn	75	100	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
4645760	4645760	PRJNA814235_P_NODE_24684_length_384_cov_45.242075_g23314_i0	PRJNA814235	24684	384	45.242075	173.729568	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	632	1.0299999999999998e-176	NTclustered	gi\|1958122490\|gb\|CP065015.1\|	2026720	g23314	i0	96.354	140.473958333333	384	14	100	0	1	384	511198	511581	Candidatus Saccharibacteria bacterium isolate Skiv_18-Q3-R9-52_BAT3C.188_fly chromosome, complete genome	blastn	53942	632	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
7195683	7195683	PRJNA814235_P_NODE_31906_length_338_cov_9.235880_g30520_i0	PRJNA814235	31906	338	9.23588	31.2172744	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	442	1.6199999999999995e-119	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g30520	i0	90.294	69.0798816568047	340	30	100	3	1	338	666709	667047	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	23349	442	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
7197088	7197088	PRJNA814235_P_NODE_99006_length_203_cov_2.493976_g97611_i0	PRJNA814235	99006	203	2.493976	5.06277128	Candidatus Chromulinivorax destructor	2066483	Bacteria	Bacteria	115	2.22e-21	NTclustered	gi\|1443103054\|gb\|CP025544.1\|	2066483	g97611	i0	94.595	0.364532019704433	74	4	36	0	1	74	923279	923352	Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome	blastn	74	115	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Chromulinivoraceae	Candidatus Chromulinivorax	Candidatus Chromulinivorax destructor
8468419	8468419	PRJNA814235_P_NODE_124647_length_201_cov_2.493902_g123252_i0	PRJNA814235	124647	201	2.493902	5.01274302	Candidatus Babeliales bacterium	2803731	Bacteria	Bacteria	137	4.69e-28	NTclustered	gi\|2874253748\|emb\|OY969622.1\|	2803731	g123252	i0	100	50.1542288557214	74	0	74	0	128	201	372569	372642	MAG: Candidatus Babeliales bacterium isolate MFD04434.bin.c.2 genome assembly, chromosome: 1	blastn	10081	137	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales			Candidatus Babeliales bacterium
12295845	12295845	PRJNA814235_P_NODE_174070_length_156_cov_2.453782_g172675_i0	PRJNA814235	174070	156	2.453782	3.82789992	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	250	4.25e-62	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g172675	i0	95.513	64.0448717948718	156	7	100	0	1	156	139585	139430	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	9991	250	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
14846604	14846604	PRJNA814235_P_NODE_77532_length_216_cov_1.938547_g76137_i0	PRJNA814235	77532	216	1.938547	4.18726152	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	150	6.57e-32	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g76137	i0	80.365	2.14814814814815	219	26	100	10	1	216	430547	430343	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	464	150	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
17396085	17396085	PRJNA814235_P_NODE_42334_length_293_cov_5.195312_g40943_i0	PRJNA814235	42334	293	5.195312	15.22226416	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	525	1.3299999999999994e-144	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g40943	i0	98.976	276.600682593857	293	3	100	0	1	293	963904	963612	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	81044	525	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
19943306	19943306	PRJNA814235_P_NODE_174976_length_156_cov_0.983193_g173581_i0	PRJNA814235	174976	156	0.983193	1.53378108	uncultured Parcubacteria group bacterium	221218	Bacteria	Bacteria	274	2.52e-69	NTclustered	gi\|380838161\|gb\|JN868132.1\|	221218	g173581	i0	98.701	96.7820512820513	154	2	99	0	1	154	619	466	Uncultured candidate division OD1 bacterium clone LZX176 16S ribosomal RNA gene, partial sequence	blastn	15098	274	1	Bacteria	Bacteria candidate phyla						uncultured Parcubacteria group bacterium
22495723	22495723	PRJNA814235_P_NODE_98978_length_203_cov_2.500000_g97583_i0	PRJNA814235	98978	203	2.5	5.075	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|2621706011\|emb\|OY764073.1\|	2026781	g97583	i0	100	0.137931034482759	28	0	14	0	27	54	2546925	2546898	MAG: Candidatus Poribacteria bacterium isolate c0dbee2e-4153-42cb-9392-5991059e4d04 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria					Candidatus Poribacteria bacterium
22905287	22905287	PRJNA814235_P_NODE_92358_length_203_cov_3.024096_g90963_i0	PRJNA814235	92358	203	3.024096	6.13891488	Bacillati	1783272	Bacteria	Bacteria	99	2.24e-16	NTclustered	gi\|374852841\|dbj\|AP011729.1\|	236499	g90963	i0	90.667	27.4581280788177	75	5	36	2	3	76	12990	12917	Uncultured Acetothermia bacterium DNA, fosmid clone: JFF031_E01	blastn	5574	99	1	Bacteria	Bacteria candidate phyla	Candidatus Bipolaricaulota					uncultured Acetothermia bacterium
25044786	25044786	PRJNA814235_P_NODE_74540_length_220_cov_3.256831_g73145_i0	PRJNA814235	74540	220	3.256831	7.1650282	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	161	3.1e-35	NTclustered	gi\|2874253687\|emb\|OY969413.1\|	2030810	g73145	i0	97.849	2.08636363636364	93	2	42	0	128	220	888637	888545	MAG: Candidatus Kaiserbacteria bacterium isolate MFD01223.bin.1.23 genome assembly, chromosome: 1	blastn	459	161	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota					Candidatus Kaiserbacteria 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);;