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

14 rows where analysis = "blastn", bioproject = "PRJNA704949" and tax_clade = "delta/epsilon subdivisions"

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_clade	tax_class	tax_order	tax_family	tax_genus	tax_species
5800810	5800810	PRJNA704949_P_NODE_378985_length_441_cov_1.678571_g363928_i0	PRJNA704949	378985	441	1.678571	7.40249811	Bradymonas sediminis	1548548	Bacteria	Bacteria	241	8.48e-59	NTclustered	gi\|1406952946\|gb\|CP030032.1\|	1548548	g363928	i0	77.169	8.90929705215419	438	85	98	14	1	432	54651	55079	Bradymonas sediminis strain FA350 chromosome, complete genome	blastn	3929	241	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
6290196	6290196	PRJNA704949_P_NODE_1329485_length_217_cov_2.119048_g1314148_i0	PRJNA704949	1329485	217	2.119048	4.59833416	Myxococcota	2818505	Bacteria	Bacteria	259	1.05e-64	NTclustered	gi\|2874253659\|emb\|OY969087.1\|	34034	g1314148	i0	90.722	87.5576036866359	194	18	89	0	24	217	3506880	3507073	MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1	blastn	19000	259	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
6292034	6292034	PRJNA704949_P_NODE_2000865_length_167_cov_0.881356_g1985526_i0	PRJNA704949	2000865	167	0.881356	1.47186452	Pseudomonadota	1224	Bacteria	Bacteria	69.4	1.39e-7	NTclustered	gi\|1695542189\|gb\|CP041186.1\|	2292766	g1985526	i0	95.349	29.6287425149701	43	2	26	0	119	161	3148681	3148723	Persicimonas caeni strain YN101 chromosome	blastn	4948	69.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
11393304	11393304	PRJNA704949_P_NODE_523369_length_376_cov_2.431193_g508083_i0	PRJNA704949	523369	376	2.431193	9.14128568	Thermodesulfobacteriota	200940	Bacteria	Bacteria	100	1.26e-16	NTclustered	gi\|2242725236\|gb\|CP026657.1\|	2946587	g508083	i0	90.667	3.20744680851064	75	7	20	0	216	290	2505364	2505438	Deltaproteobacteria bacterium Smac51 chromosome, complete genome	blastn	1206	100	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium Smac51
12174610	12174610	PRJNA704949_P_NODE_2158650_length_162_cov_1.380531_g2143311_i0	PRJNA704949	2158650	162	1.380531	2.23646022	Bradymonas sediminis	1548548	Bacteria	Bacteria	117	4.71e-22	NTclustered	gi\|1406952946\|gb\|CP030032.1\|	1548548	g2143311	i0	83.74	31.358024691358	123	20	76	0	1	123	3997086	3997208	Bradymonas sediminis strain FA350 chromosome, complete genome	blastn	5080	117	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Bradymonas	Bradymonas sediminis
13442129	13442129	PRJNA704949_P_NODE_1301991_length_220_cov_2.245614_g1286654_i0	PRJNA704949	1301991	220	2.2456140000000002	4.9403508	Persicimonas caeni	2292766	Bacteria	Bacteria	122	1.4599999999999995e-23	NTclustered	gi\|1695542189\|gb\|CP041186.1\|	2292766	g1286654	i0	96	6.07727272727273	75	3	34	0	146	220	2699065	2699139	Persicimonas caeni strain YN101 chromosome	blastn	1337	122	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
13446067	13446067	PRJNA704949_P_NODE_1792191_length_178_cov_1.465116_g1776852_i0	PRJNA704949	1792191	178	1.465116	2.60790648	uncultured delta proteobacterium	34034	Bacteria	Bacteria	128	2.43e-25	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g1776852	i0	82.639	0.966292134831461	144	25	81	0	20	163	3257325	3257468	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	172	128	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
13942868	13942868	PRJNA704949_P_NODE_316751_length_479_cov_1.841860_g301875_i0	PRJNA704949	316751	479	1.84186	8.8225094	Bacteria	2	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|2874253674\|emb\|OY969108.1\|	34034	g301875	i0	97.143	1.32985386221294	35	0	7	1	316	349	2292739	2292773	MAG: uncultured delta proteobacterium isolate MFD01828.bin.c.1 genome assembly, chromosome: 1	blastn	637	58.4	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
14719387	14719387	PRJNA704949_P_NODE_1550912_length_196_cov_2.476190_g1535573_i0	PRJNA704949	1550912	196	2.47619	4.8533324	uncultured delta proteobacterium	34034	Bacteria	Bacteria	117	5.93e-22	NTclustered	gi\|2874253999\|emb\|OY970324.1\|	34034	g1535573	i0	86.667	29.8928571428571	105	14	54	0	7	111	4032894	4032790	MAG: uncultured delta proteobacterium isolate MFD05502.bin.1.132 genome assembly, chromosome: 1	blastn	5859	117	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
14722568	14722568	PRJNA704949_P_NODE_1958372_length_168_cov_1.310924_g1943033_i0	PRJNA704949	1958372	168	1.310924	2.20235232	uncultured delta proteobacterium	34034	Bacteria	Bacteria	119	1.37e-22	NTclustered	gi\|2874253659\|emb\|OY969087.1\|	34034	g1943033	i0	79.878	1.16071428571429	164	31	97	2	1	163	5640717	5640555	MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1	blastn	195	119	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
15999516	15999516	PRJNA704949_P_NODE_350753_length_457_cov_2.174020_g335765_i0	PRJNA704949	350753	457	2.17402	9.9352714	uncultured delta proteobacterium	34034	Bacteria	Bacteria	322	3.06e-83	NTclustered	gi\|2874253659\|emb\|OY969087.1\|	34034	g335765	i0	81.481	1.54485776805252	405	64	88	8	57	457	283733	283336	MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1	blastn	706	322	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
17265374	17265374	PRJNA704949_P_NODE_1176034_length_235_cov_1.623656_g1160697_i0	PRJNA704949	1176034	235	1.623656	3.8155916	uncultured delta proteobacterium	34034	Bacteria	Bacteria	113	9.53e-21	NTclustered	gi\|2874254016\|emb\|OY970341.1\|	34034	g1160697	i0	94.595	36.3702127659574	74	2	31	2	4	76	4039142	4039070	MAG: uncultured delta proteobacterium isolate MFD01231.bin.c.2 genome assembly, chromosome: 1	blastn	8547	113	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
22367952	22367952	PRJNA704949_P_NODE_1583058_length_194_cov_1.075862_g1567719_i0	PRJNA704949	1583058	194	1.075862	2.08717228	Persicimonas caeni	2292766	Bacteria	Bacteria	174	3.42e-39	NTclustered	gi\|1695542189\|gb\|CP041186.1\|	2292766	g1567719	i0	84.358	81.6546391752577	179	26	92	2	17	194	3872880	3873057	Persicimonas caeni strain YN101 chromosome	blastn	15841	174	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
24919665	24919665	PRJNA704949_P_NODE_191280_length_597_cov_2.135036_g177228_i0	PRJNA704949	191280	597	2.135036	12.74616492	Persicimonas caeni	2292766	Bacteria	Bacteria	206	4.279999999999999e-48	NTclustered	gi\|1695542189\|gb\|CP041186.1\|	2292766	g177228	i0	78.182	21.001675041876	330	66	55	6	260	586	4476275	4476601	Persicimonas caeni strain YN101 chromosome	blastn	12538	206	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni

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