metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA1111146" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA1111146" and tax_phylum = "Acidobacteriota"

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
1021859	1021859	PRJNA1111146_P_NODE_35241_length_315_cov_1.641221_g34104_i0	PRJNA1111146	35241	315	1.641221	5.16984615	Chloracidobacterium	458032	Bacteria	Bacteria	176	1.68e-39	NTclustered	gi\|2033641525\|gb\|CP072636.1\|	2821537	g34104	i0	85	47.4603174603175	180	19	56	7	33	208	2068594	2068769	Chloracidobacterium sp. 2 chromosome 1, complete sequence	blastn	14950	176	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium aggregatum
2296963	2296963	PRJNA1111146_P_NODE_174842_length_212_cov_1.427673_g173704_i0	PRJNA1111146	174842	212	1.427673	3.02666676	Chloracidobacterium	458032	Bacteria	Bacteria	193	1.05e-44	NTclustered	gi\|2033640757\|gb\|CP072635.1\|	2821536	g173704	i0	83.254	73.5518867924528	209	35	99	0	3	211	993852	994060	Chloracidobacterium sp. D chromosome 2, complete sequence	blastn	15593	193	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium sp. D
2767425	2767425	PRJNA1111146_P_NODE_404463_length_179_cov_0.896825_g403325_i0	PRJNA1111146	404463	179	0.896825	1.60531675	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	261	2.3100000000000002e-65	NTclustered	gi\|217038907\|gb\|EU810998.1\|	171953	g403325	i0	96.226	127.223463687151	159	6	89	0	1	159	159	1	Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence	blastn	22773	261	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6124991	6124991	PRJNA1111146_P_NODE_382285_length_180_cov_0.897638_g381147_i0	PRJNA1111146	382285	180	0.897638	1.6157484	PVC group	1783257	Bacteria	Bacteria	63.9	7.05e-6	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g381147	i0	100	9.11666666666667	34	0	19	0	18	51	152874	152841	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	1641	63.9	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
7399589	7399589	PRJNA1111146_P_NODE_286386_length_189_cov_1.676471_g285248_i0	PRJNA1111146	286386	189	1.676471	3.16853019	Holophagaceae	574976	Bacteria	Bacteria	206	1.1799999999999999e-48	NTclustered	gi\|2490895851\|dbj\|AP027081.1\|	2927980	g285248	i0	86.243	19.2380952380952	189	26	100	0	1	189	43234	43046	Mesoterricola sediminis W786 DNA, complete genome	blastn	3636	206	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Mesoterricola	Mesoterricola sediminis
10419924	10419924	PRJNA1111146_P_NODE_336709_length_183_cov_0.876923_g335571_i0	PRJNA1111146	336709	183	0.876923	1.60476909	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	161	2.48e-35	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g335571	i0	83.24	1.93989071038251	179	26	97	2	7	183	2720241	2720417	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	355	161	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10420471	10420471	PRJNA1111146_P_NODE_440269_length_177_cov_0.879032_g439131_i0	PRJNA1111146	440269	177	0.879032	1.55588664	Bryobacterales bacterium	2026791	Bacteria	Bacteria	145	2.4e-30	NTclustered	gi\|2913438621\|emb\|OZ224030.1\|	2026791	g439131	i0	82.53	87.638418079096	166	27	93	2	1	165	1017478	1017314	MAG: Bryobacterales bacterium isolate 7c2e36ee-14bd-451a-b5bf-70b98c7e11c2 genome assembly, chromosome: 1	blastn	15512	145	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
14245455	14245455	PRJNA1111146_P_NODE_352772_length_182_cov_0.883721_g351634_i0	PRJNA1111146	352772	182	0.883721	1.60837222	Luteitalea pratensis	1855912	Bacteria	Bacteria	141	3.21e-29	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g351634	i0	81.395	0.945054945054945	172	32	95	0	11	182	4835233	4835404	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	172	141	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
18067690	18067690	PRJNA1111146_P_NODE_236895_length_199_cov_1.205479_g235757_i0	PRJNA1111146	236895	199	1.205479	2.39890321	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g235757	i0	100	0.14070351758794	28	0	14	0	162	189	4612813	4612840	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
18068224	18068224	PRJNA1111146_P_NODE_363495_length_181_cov_1.351562_g362357_i0	PRJNA1111146	363495	181	1.351562	2.44632722	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	296	6.43e-76	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g362357	i0	96.133	99.7016574585635	181	7	100	0	1	181	635402	635222	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	18046	296	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
20616903	20616903	PRJNA1111146_P_NODE_168577_length_214_cov_1.416149_g167439_i0	PRJNA1111146	168577	214	1.416149	3.03055886	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	243	1.0400000000000001e-59	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g167439	i0	87.097	100.504672897196	217	24	100	3	1	214	3299881	3299666	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	21508	243	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
20617192	20617192	PRJNA1111146_P_NODE_24437_length_349_cov_2.266892_g23300_i0	PRJNA1111146	24437	349	2.266892	7.91145308	Chloracidobacterium validum	2821543	Bacteria	Bacteria	195	5.1699999999999995e-45	NTclustered	gi\|2033661925\|gb\|CP072649.1\|	2821543	g23300	i0	91.489	9.32378223495702	141	12	40	0	46	186	514106	514246	Chloracidobacterium validum strain BV2-C chromosome 2, complete sequence	blastn	3254	195	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Chloracidobacterium	Chloracidobacterium validum
21893333	21893333	PRJNA1111146_P_NODE_358678_length_182_cov_0.868217_g357540_i0	PRJNA1111146	358678	182	0.868217	1.58015494	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	119	1.5000000000000002e-22	NTclustered	gi\|2874253700\|emb\|OY969426.1\|	2651171	g357540	i0	87.037	6.53846153846154	108	11	58	3	57	162	2097459	2097353	MAG: Thermoanaerobaculia bacterium isolate MFD02979.bin.c.1 genome assembly, chromosome: 1	blastn	1190	119	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
24442180	24442180	PRJNA1111146_P_NODE_285500_length_189_cov_2.294118_g284362_i0	PRJNA1111146	285500	189	2.294118	4.33588302	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	217	5.429999999999999e-52	NTclustered	gi\|2874253931\|emb\|OY970256.1\|	2283092	g284362	i0	87.368	1.00529100529101	190	22	100	2	1	189	5494251	5494439	MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1	blastn	190	217	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae 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);;