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

13 rows where analysis = "blastn", bioproject = "PRJNA493244" 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
456320	456320	PRJNA493244_P_NODE_1676521_length_206_cov_5.862069_g1653396_i0	PRJNA493244	1676521	206	5.862069	12.07586214	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	237	4.63e-58	NTclustered	gi\|2874253931\|emb\|OY970256.1\|	2283092	g1653396	i0	89.84	91.9029126213592	187	16	90	3	21	206	359002	359186	MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1	blastn	18932	237	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
3007319	3007319	PRJNA493244_P_NODE_1736043_length_194_cov_5.548872_g1712918_i0	PRJNA493244	1736043	194	5.548872	10.76481168	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	287	4.22e-73	NTclustered	gi\|2626289183\|emb\|OY843586.1\|	2052142	g1712918	i0	97.059	81.5360824742268	170	5	88	0	22	191	5216635	5216804	MAG: Acidobacteriaceae bacterium isolate 6f8c9a11-1c30-45b4-a4a5-28695f68a2e2 genome assembly, chromosome: 1	blastn	15818	287	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium
3008389	3008389	PRJNA493244_P_NODE_781263_length_517_cov_43.627193_g758647_i0	PRJNA493244	781263	517	43.627193	225.55258781	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	556	8.799999999999998e-154	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g758647	i0	87.097	372.974854932302	496	58	95	5	3	495	3298655	3298163	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	192828	556	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
4282555	4282555	PRJNA493244_P_NODE_1389744_length_271_cov_1.780952_g1366619_i0	PRJNA493244	1389744	271	1.780952	4.82637992	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	206	1.7999999999999998e-48	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g1366619	i0	82.186	3.73431734317343	247	36	89	7	10	251	2881266	2881023	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	1012	206	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
5561128	5561128	PRJNA493244_P_NODE_777905_length_519_cov_36.098253_g755301_i0	PRJNA493244	777905	519	36.098253	187.34993307	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	544	6.879999999999998e-150	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g755301	i0	86.653	198.036608863198	502	54	95	10	23	517	317250	317745	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	102781	544	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
8108124	8108124	PRJNA493244_P_NODE_1136907_length_351_cov_3.275862_g1113785_i0	PRJNA493244	1136907	351	3.275862	11.49827562	Terriglobus roseus	392734	Bacteria	Bacteria	333	1.06e-86	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g1113785	i0	84.848	0.94017094017094	330	50	94	0	21	350	489222	488893	Terriglobus roseus DSM 18391, complete genome	blastn	330	333	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
8108650	8108650	PRJNA493244_P_NODE_1373947_length_275_cov_4.696262_g1350822_i0	PRJNA493244	1373947	275	4.696262	12.9147205	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	137	6.78e-28	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g1350822	i0	79.71	66.5745454545455	207	29	73	11	24	223	1822597	1822397	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	18308	137	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
8753055	8753055	PRJNA493244_P_NODE_791627_length_511_cov_105.373333_g768974_i0	PRJNA493244	791627	511	105.373333	538.45773163	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	516	1.48e-141	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g768974	i0	85.918	277.344422700587	490	61	95	8	26	511	3298157	3298642	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	141723	516	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
9384402	9384402	PRJNA493244_P_NODE_1728388_length_199_cov_7.826087_g1705263_i0	PRJNA493244	1728388	199	7.826087	15.57391313	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	191	3.51e-44	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g1705263	i0	94.355	136.562814070352	124	7	62	0	54	177	1822542	1822665	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	27176	191	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
13210120	13210120	PRJNA493244_P_NODE_1708491_length_203_cov_0.901408_g1685366_i0	PRJNA493244	1708491	203	0.901408	1.82985824	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	62.1	2.94e-5	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g1685366	i0	92.857	0.206896551724138	42	3	21	0	130	171	3076910	3076951	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	42	62.1	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
15757406	15757406	PRJNA493244_P_NODE_1025893_length_395_cov_10.982036_g1002789_i0	PRJNA493244	1025893	395	10.982036	43.3790422	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	429	1.4899999999999999e-115	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g1002789	i0	87.668	80.9443037974684	373	41	94	4	23	392	3298161	3298531	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	31973	429	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
18309104	18309104	PRJNA493244_P_NODE_766155_length_526_cov_239.273118_g743594_i0	PRJNA493244	766155	526	239.273118	1258.57660068	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	529	1.9599999999999998e-145	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g743594	i0	86.089	317.832699619772	496	64	94	5	3	495	494	1	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	167180	529	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24682097	24682097	PRJNA493244_P_NODE_1618620_length_216_cov_2.851613_g1595495_i0	PRJNA493244	1618620	216	2.851613	6.15948408	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	209	1.0700000000000001e-49	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g1595495	i0	86.154	67.2314814814815	195	26	90	1	23	216	3298163	3298357	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	14522	209	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota 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);;