metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA704949" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA704949" and tax_phylum = "Armatimonadota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1964377	1964377	PRJNA704949_P_NODE_1298262_length_221_cov_1.209302_g1282925_i0	PRJNA704949	1298262	221	1.209302	2.67255742	Capsulimonas corticalis	2219043	Bacteria	Bacteria	113	8.860000000000001e-21	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g1282925	i0	87.129	10.8914027149321	101	11	45	2	70	169	2316582	2316483	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	2407	113	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
8838787	8838787	PRJNA704949_P_NODE_1224887_length_229_cov_1.600000_g1209550_i0	PRJNA704949	1224887	229	1.6	3.664	Bacteria	2	Bacteria	Bacteria	176	1.16e-39	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g1209550	i0	84.358	76.9126637554585	179	28	78	0	20	198	5332298	5332476	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	17613	176	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
10893309	10893309	PRJNA704949_P_NODE_1406849_length_209_cov_2.512500_g1391511_i0	PRJNA704949	1406849	209	2.5125	5.251125	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	137	4.92e-28	NTclustered	gi\|2076449834\|gb\|CP075365.1\|	2682144	g1391511	i0	81.818	4.14832535885167	165	28	78	2	27	190	734195	734358	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome	blastn	867	137	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
17265813	17265813	PRJNA704949_P_NODE_1228854_length_229_cov_1.022222_g1213517_i0	PRJNA704949	1228854	229	1.022222	2.34088838	Armatimonadota bacterium	2033014	Bacteria	Bacteria	154	5.44e-33	NTclustered	gi\|2314718026\|dbj\|AP024674.1\|	2033014	g1213517	i0	81.967	3.50218340611354	183	31	79	2	6	187	383895	383714	MAG: Armatimonadetes bacterium KatS3mg024 DNA, complete genome	blastn	802	154	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
19820591	19820591	PRJNA704949_P_NODE_1968356_length_168_cov_0.873950_g1953017_i0	PRJNA704949	1968356	168	0.87395	1.468236	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g1953017	i0	96.875	0.19047619047619	32	0	18	1	138	168	598884	598853	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	32	52.8	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
21103978	21103978	PRJNA704949_P_NODE_878537_length_282_cov_1.115880_g863203_i0	PRJNA704949	878537	282	1.11588	3.1467816	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	121	7.03e-23	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g863203	i0	88.776	2.88652482269504	98	11	36	0	100	197	2302052	2301955	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	814	121	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
23646083	23646083	PRJNA704949_P_NODE_187959_length_601_cov_3.018116_g173962_i0	PRJNA704949	187959	601	3.018116	18.13887716	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	370	1.45e-97	NTclustered	gi\|2874253689\|emb\|OY969415.1\|	157466	g173962	i0	79.235	182.480865224626	549	101	90	11	33	575	4335575	4335034	MAG: uncultured Armatimonadetes bacterium isolate MFD00905.bin.2.19 genome assembly, chromosome: 1	blastn	109671	370	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
25411974	25411974	PRJNA704949_P_NODE_1048660_length_253_cov_1.034314_g1033324_i0	PRJNA704949	1048660	253	1.034314	2.61681442	PVC group	1783257	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g1033324	i0	100	2.58102766798419	29	0	11	0	141	169	1923810	1923782	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	653	54.7	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes 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);;