metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA615351" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA615351" 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
1871689	1871689	PRJNA615351_P_NODE_182762_length_154_cov_0.941176_g168662_i0	PRJNA615351	182762	154	0.941176	1.44941104	uncultured Granulicella sp.	1241325	Bacteria	Bacteria	252	1.16e-62	NTclustered	gi\|2836016418\|emb\|OZ196148.1\|	1241325	g168662	i0	96.104	98.7207792207792	154	6	100	0	1	154	506550	506397	MAG: uncultured Granulicella sp. isolate 9057d4d9-b77b-4c6f-b84b-ea5519435b63 genome assembly, chromosome: 1	blastn	15203	252	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	uncultured Granulicella sp.
4423561	4423561	PRJNA615351_P_NODE_94304_length_343_cov_57.824675_g80216_i0	PRJNA615351	94304	343	57.824675	198.33863525	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	529	1.2299999999999994e-145	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g80216	i0	95.238	670.142857142857	336	13	97	3	10	343	3301031	3300697	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	229859	529	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
13349819	13349819	PRJNA615351_P_NODE_169871_length_165_cov_2.715385_g155771_i0	PRJNA615351	169871	165	2.715385	4.48038525	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2621701418\|emb\|OY760136.1\|	2910147	g155771	i0	100	0.16969696969697	28	0	17	0	100	127	1153274	1153301	MAG: Vicinamibacterales bacterium isolate f9e760c9-8bbe-4e76-9a0a-40d6f1fb97b8 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
15898545	15898545	PRJNA615351_P_NODE_171373_length_164_cov_1.255814_g157273_i0	PRJNA615351	171373	164	1.255814	2.05953496	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	58.4	2.94e-4	NTclustered	gi\|2891481964\|emb\|OZ219745.1\|	2910147	g157273	i0	100	5.0609756097561	31	0	19	0	110	140	6802565	6802535	MAG: Vicinamibacterales bacterium isolate d5a9b4ee-eb88-4731-bb2c-80bf662b4d04 genome assembly, chromosome: 2	blastn	830	58.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
17173457	17173457	PRJNA615351_P_NODE_154374_length_184_cov_1.342282_g140274_i0	PRJNA615351	154374	184	1.342282	2.46979888	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	296	6.57e-76	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g140274	i0	95.652	7.60869565217391	184	8	100	0	1	184	1689354	1689171	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	1400	296	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19722286	19722286	PRJNA615351_P_NODE_174816_length_161_cov_0.873016_g160716_i0	PRJNA615351	174816	161	0.873016	1.40555576	uncultured Thermoanaerobaculia bacterium	3036248	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2518540615\|emb\|OX638294.1\|	3036248	g160716	i0	96.875	0.372670807453416	32	1	20	0	117	148	1369587	1369556	MAG: uncultured Thermoanaerobaculia bacterium isolate 42478a12-5572-4d71-959b-92ffd854a98d genome assembly, chromosome: 1	blastn	60	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				uncultured Thermoanaerobaculia bacterium
19722478	19722478	PRJNA615351_P_NODE_55416_length_652_cov_41.706645_g42645_i0	PRJNA615351	55416	652	41.706645	271.9273254	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	955	0	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g42645	i0	93.252	145.15490797546	652	38	99	6	1	651	2368021	2367375	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	94641	955	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22273047	22273047	PRJNA615351_P_NODE_68058_length_518_cov_5.645963_g54261_i0	PRJNA615351	68058	518	5.645963	29.24608834	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	695	0	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g54261	i0	90.892	511.007722007722	527	34	100	12	1	518	715722	716243	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	264702	695	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23548138	23548138	PRJNA615351_P_NODE_15739_length_1657_cov_11.422318_g11358_i0	PRJNA615351	15739	1657	11.422318	189.26780926	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	1890	0	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g11358	i0	89.14	114.731442365721	1547	128	92	26	2	1530	1820676	1822200	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	190110	1890	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
23548182	23548182	PRJNA615351_P_NODE_173299_length_162_cov_1.566929_g159199_i0	PRJNA615351	173299	162	1.566929	2.53842498	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	91.6	2.86e-14	NTclustered	gi\|2891481964\|emb\|OZ219745.1\|	2910147	g159199	i0	81.356	33.9074074074074	118	16	71	6	1	115	2085234	2085120	MAG: Vicinamibacterales bacterium isolate d5a9b4ee-eb88-4731-bb2c-80bf662b4d04 genome assembly, chromosome: 2	blastn	5493	91.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
24821841	24821841	PRJNA615351_P_NODE_174800_length_161_cov_0.936508_g160700_i0	PRJNA615351	174800	161	0.936508	1.50777788	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	93.5	7.88e-15	NTclustered	gi\|2621706021\|emb\|OY764083.1\|	1978231	g160700	i0	77.439	2.59627329192547	164	31	100	4	1	161	1851443	1851283	MAG: Acidobacteriota bacterium isolate 715e7d27-e149-44c2-9d7f-aa5f8d263fc4 genome assembly, chromosome: 1	blastn	418	93.5	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
24822080	24822080	PRJNA615351_P_NODE_66260_length_534_cov_3.845691_g52562_i0	PRJNA615351	66260	534	3.845691	20.53598994	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	647	0	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g52562	i0	88.603	168.084269662921	544	47	100	14	1	534	3299798	3299260	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	89757	647	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);;