metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA382357" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA382357" and tax_phylum = "Thermodesulfobacteriota"

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
403022	403022	PRJNA382357_P_NODE_151761_length_203_cov_10.746479_g151022_i0	PRJNA382357	151761	203	10.746479	21.81535237	Geobacter pickeringii	345632	Bacteria	Bacteria	63.9	8.17e-6	NTclustered	gi\|747129828\|gb\|CP009788.1\|	345632	g151022	i0	95	0.911330049261084	40	2	37	0	123	162	2420362	2420323	Geobacter pickeringii strain G13, complete genome	blastn	185	63.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter pickeringii
2954596	2954596	PRJNA382357_P_NODE_51523_length_324_cov_1.224335_g50784_i0	PRJNA382357	51523	324	1.224335	3.9668454	Desulfarculaceae bacterium	2528248	Bacteria	Bacteria	60.2	1.82e-4	NTclustered	gi\|2621780225\|emb\|OY776512.1\|	2528248	g50784	i0	100	1.44444444444444	32	0	10	0	293	324	4381675	4381644	MAG: Desulfarculaceae bacterium isolate e2237022-3439-453f-a1e0-3d3180ebaa11 genome assembly, chromosome: 1	blastn	468	60.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae		Desulfarculaceae bacterium
4231157	4231157	PRJNA382357_P_NODE_50464_length_327_cov_1.323308_g49725_i0	PRJNA382357	50464	327	1.323308	4.32721716	Geobacter benzoatilyticus	2815309	Bacteria	Bacteria	235	2.84e-57	NTclustered	gi\|2004017374\|gb\|CP071382.1\|	2815309	g49725	i0	86.916	112.351681957187	214	22	65	6	1	212	489020	489229	Geobacter benzoatilyticus strain Jerry-YX chromosome, complete genome	blastn	36739	235	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geobacter	Geobacter benzoatilyticus
4231304	4231304	PRJNA382357_P_NODE_59784_length_303_cov_2.400826_g59045_i0	PRJNA382357	59784	303	2.400826	7.27450278	Geopsychrobacteraceae bacterium	3065857	Bacteria	Bacteria	87.9	7.74e-13	NTclustered	gi\|2621702214\|emb\|OY760196.1\|	3065857	g59045	i0	96.226	18.4587458745875	53	2	17	0	169	221	713978	713926	MAG: Geopsychrobacteraceae bacterium isolate 3ac22823-4ae2-415b-96ed-595fc0828211 genome assembly, chromosome: 1	blastn	5593	87.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Geopsychrobacteraceae		Geopsychrobacteraceae bacterium
10002558	10002558	PRJNA382357_P_NODE_11648_length_618_cov_3.235189_g10934_i0	PRJNA382357	11648	618	3.235189	19.99346802	Geobacteraceae	213422	Bacteria	Bacteria	399	1.9e-106	NTclustered	gi\|1886376207\|dbj\|AP023213.1\|	60035	g10934	i0	82.516	131.883495145631	469	69	76	9	1	467	3608782	3608325	Geobacter bremensis R4 DNA, complete genome	blastn	81504	399	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Citrifermentans	Citrifermentans bremense
13829092	13829092	PRJNA382357_P_NODE_93371_length_249_cov_14.276596_g92632_i0	PRJNA382357	93371	249	14.276596	35.54872404	Desulfosarcina	2299	Bacteria	Bacteria	182	2.75e-41	NTclustered	gi\|2621713517\|emb\|OY771548.1\|	218289	g92632	i0	93.443	183.598393574297	122	8	49	0	94	215	92240	92361	MAG: uncultured Desulfosarcina sp. isolate c75788b4-9dc9-432e-af07-dc879bdb42fc genome assembly, chromosome: 1	blastn	45716	182	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfosarcinaceae	Desulfosarcina	uncultured Desulfosarcina sp.
15706629	15706629	PRJNA382357_P_NODE_48133_length_334_cov_1.761905_g47394_i0	PRJNA382357	48133	334	1.761905	5.8847627	Desulfarculus baarsii	453230	Bacteria	Bacteria	217	1.06e-51	NTclustered	gi\|301638057\|gb\|CP002085.1\|	644282	g47394	i0	87.978	46.0149700598802	183	22	55	0	102	284	874793	874975	Desulfarculus baarsii DSM 2075, complete genome	blastn	15369	217	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae	Desulfarculus	Desulfarculus baarsii
16980710	16980710	PRJNA382357_P_NODE_172154_length_165_cov_36.567308_g171415_i0	PRJNA382357	172154	165	36.567308	60.3360582	Syntrophus buswellii	43774	Bacteria	Bacteria	195	2.17e-45	NTclustered	gi\|2869717242\|gb\|CP175563.1\|	43774	g171415	i0	87.879	17.4787878787879	165	20	100	0	1	165	33980	33816	Syntrophus buswellii strain DM-2 chromosome, complete genome	blastn	2884	195	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae	Syntrophus	Syntrophus buswellii
18256194	18256194	PRJNA382357_P_NODE_94135_length_249_cov_0.792553_g93396_i0	PRJNA382357	94135	249	0.792553	1.97345697	uncultured Desulfobacter sp.	240139	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2621717585\|emb\|OY775937.1\|	240139	g93396	i0	100	0.116465863453815	29	0	12	0	4	32	4282414	4282386	MAG: uncultured Desulfobacter sp. isolate 6579293f-26f5-4e71-a9db-d48b61c722da genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae	Desulfobacter	uncultured Desulfobacter sp.
18927126	18927126	PRJNA382357_P_NODE_96015_length_246_cov_5.194595_g95276_i0	PRJNA382357	96015	246	5.194595	12.7787037	Desulfobulbaceae	213121	Bacteria	Bacteria	119	2.16e-22	NTclustered	gi\|296923907\|gb\|CP001940.1\|	589865	g95276	i0	95.89	50.1422764227642	73	3	50	0	12	84	279684	279612	Desulfurivibrio alkaliphilus AHT2, complete genome	blastn	12335	119	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobulbia	Desulfobulbales	Desulfobulbaceae	Desulfurivibrio	Desulfurivibrio alkaliphilus
22751829	22751829	PRJNA382357_P_NODE_20518_length_487_cov_2.624413_g19784_i0	PRJNA382357	20518	487	2.624413	12.78089131	Pseudomonadati	3379134	Bacteria	Bacteria	466	1.4299999999999997e-126	NTclustered	gi\|2869717242\|gb\|CP175563.1\|	43774	g19784	i0	84.146	234.11704312115	492	67	100	8	1	487	2333244	2332759	Syntrophus buswellii strain DM-2 chromosome, complete genome	blastn	114015	466	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Syntrophia	Syntrophales	Syntrophaceae	Syntrophus	Syntrophus buswellii

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);;