metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA1095825" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA1095825" and tax_phylum = "Myxococcota"

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
200363	200363	PRJNA1095825_P_NODE_212901_length_267_cov_1.587629_g209838_i0	PRJNA1095825	212901	267	1.587629	4.23896943	Nannocystis punicea	2995304	Bacteria	Bacteria	261	3.73e-65	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g209838	i0	84.733	3.83895131086142	262	38	98	2	1	261	4013910	4013650	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	1025	261	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
2751875	2751875	PRJNA1095825_P_NODE_294043_length_241_cov_0.916667_g290980_i0	PRJNA1095825	294043	241	0.916667	2.20916747	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	134	7.530000000000001e-27	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g290980	i0	78.947	1.77593360995851	209	34	86	9	17	223	2330008	2330208	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	428	134	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
6122670	6122670	PRJNA1095825_P_NODE_278265_length_244_cov_0.900585_g275202_i0	PRJNA1095825	278265	244	0.900585	2.1974274	Pseudomonadati	3379134	Bacteria	Bacteria	211	3.43e-50	NTclustered	gi\|262076673\|gb\|CP001804.1\|	502025	g275202	i0	88.136	77.8934426229508	177	21	74	0	26	202	9107122	9106946	Haliangium ochraceum DSM 14365, complete genome	blastn	19006	211	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
6578882	6578882	PRJNA1095825_P_NODE_265006_length_246_cov_0.890173_g261943_i0	PRJNA1095825	265006	246	0.890173	2.18982558	Anaeromyxobacter dehalogenans	161493	Bacteria	Bacteria	300	7.19e-77	NTclustered	gi\|219952977\|gb\|CP001359.1\|	455488	g261943	i0	89.451	22.739837398374	237	25	96	0	10	246	1812402	1812166	Anaeromyxobacter dehalogenans 2CP-1 chromosome, complete genome	blastn	5594	300	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
6579139	6579139	PRJNA1095825_P_NODE_290206_length_242_cov_0.911243_g287143_i0	PRJNA1095825	290206	242	0.911243	2.20520806	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	217	7.3e-52	NTclustered	gi\|152026452\|gb\|CP000769.1\|	404589	g287143	i0	87.302	2.6900826446281	189	24	78	0	50	238	836366	836554	Anaeromyxobacter sp. Fw109-5, complete genome	blastn	651	217	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
7853601	7853601	PRJNA1095825_P_NODE_265067_length_246_cov_0.890173_g262004_i0	PRJNA1095825	265067	246	0.890173	2.18982558	Polyangium aurulentum	2567896	Bacteria	Bacteria	206	1.61e-48	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g262004	i0	82.158	90.2560975609756	241	41	98	2	1	240	11529566	11529805	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	22203	206	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
9128036	9128036	PRJNA1095825_P_NODE_209208_length_270_cov_1.228426_g206145_i0	PRJNA1095825	209208	270	1.228426	3.3167502	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	130	1.11e-25	NTclustered	gi\|2108117163\|gb\|CP070734.1\|	2026735	g206145	i0	91.489	27.5296296296296	94	8	35	0	27	120	1813911	1813818	MAG: Deltaproteobacteria bacterium isolate bin407 chromosome	blastn	7433	130	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
9128562	9128562	PRJNA1095825_P_NODE_259948_length_247_cov_0.885057_g256885_i0	PRJNA1095825	259948	247	0.885057	2.18609079	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	339	1.5299999999999998e-88	NTclustered	gi\|2107977474\|gb\|CP070783.1\|	2026735	g256885	i0	91.463	11.8704453441296	246	21	99	0	2	247	463820	463575	MAG: Deltaproteobacteria bacterium isolate bin162 chromosome	blastn	2932	339	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
9128635	9128635	PRJNA1095825_P_NODE_267888_length_246_cov_0.890173_g264825_i0	PRJNA1095825	267888	246	0.890173	2.18982558	Myxococcus xanthus	34	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1691478249\|gb\|CP017170.1\|	34	g264825	i0	94.444	0.439024390243902	36	0	14	2	210	244	8757003	8756969	Myxococcus xanthus strain GH5.1.9c20 chromosome, complete genome	blastn	108	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
11679653	11679653	PRJNA1095825_P_NODE_274130_length_245_cov_0.895349_g271067_i0	PRJNA1095825	274130	245	0.895349	2.19360505	Polyangium aurulentum	2567896	Bacteria	Bacteria	182	2.7e-41	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g271067	i0	80.932	2.96734693877551	236	39	95	5	1	233	680111	679879	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	727	182	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
11679884	11679884	PRJNA1095825_P_NODE_297610_length_241_cov_0.916667_g294547_i0	PRJNA1095825	297610	241	0.916667	2.20916747	Archangium gephyra	48	Bacteria	Bacteria	401	1.8699999999999993e-107	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g294547	i0	97.059	5.83402489626556	238	7	99	0	1	238	6594587	6594824	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	1406	401	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
12955582	12955582	PRJNA1095825_P_NODE_88271_length_404_cov_0.930514_g85208_i0	PRJNA1095825	88271	404	0.930514	3.75927656	Sorangium cellulosum	56	Bacteria	Bacteria	307	7.490000000000001e-79	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g85208	i0	80.637	3.01980198019802	408	69	99	9	1	403	5540177	5539775	Sorangium cellulosum So0157-2, complete genome	blastn	1220	307	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
17597125	17597125	PRJNA1095825_P_NODE_161734_length_307_cov_0.987179_g158671_i0	PRJNA1095825	161734	307	0.987179	3.03063953	Anaeromyxobacter	161492	Bacteria	Bacteria	132	3.58e-26	NTclustered	gi\|196170270\|gb\|CP001131.1\|	447217	g158671	i0	94.186	6.1628664495114	86	5	28	0	2	87	920538	920453	Anaeromyxobacter sp. K, complete genome	blastn	1892	132	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. K
18052887	18052887	PRJNA1095825_P_NODE_297435_length_241_cov_0.916667_g294372_i0	PRJNA1095825	297435	241	0.916667	2.20916747	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	243	1.2e-59	NTclustered	gi\|2107977474\|gb\|CP070783.1\|	2026735	g294372	i0	85.903	1.27385892116183	227	32	94	0	10	236	171975	171749	MAG: Deltaproteobacteria bacterium isolate bin162 chromosome	blastn	307	243	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
20601507	20601507	PRJNA1095825_P_NODE_211637_length_268_cov_1.579487_g208574_i0	PRJNA1095825	211637	268	1.579487	4.23302516	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	239	1.75e-58	NTclustered	gi\|2108117163\|gb\|CP070734.1\|	2026735	g208574	i0	83.206	53.7238805970149	262	42	97	2	1	261	3362223	3362483	MAG: Deltaproteobacteria bacterium isolate bin407 chromosome	blastn	14398	239	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria 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);;