metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA888821" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA888821" 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
862624	862624	PRJNA888821_P_NODE_17181_length_310_cov_5.029536_g17099_i0	PRJNA888821	17181	310	5.029536	15.5915616	Archangium violaceum	83451	Bacteria	Bacteria	252	2.6599999999999997e-62	NTclustered	gi\|1981856374\|gb\|CP069338.1\|	83451	g17099	i0	97.931	0.467741935483871	145	3	47	0	163	307	12546335	12546479	Archangium violaceum strain SDU34 chromosome, complete genome	blastn	145	252	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
2138008	2138008	PRJNA888821_P_NODE_1442_length_489_cov_19.276442_g1367_i0	PRJNA888821	1442	489	19.276442	94.26180138	Pendulispora albinea	2741071	Bacteria	Bacteria	279	2.01e-70	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g1367	i0	84.483	0.593047034764826	290	37	58	7	2	287	2025933	2025648	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	290	279	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
3413272	3413272	PRJNA888821_P_NODE_10643_length_310_cov_10.354430_g10561_i0	PRJNA888821	10643	310	10.35443	32.098733	Labilithrix luteola	1391654	Bacteria	Bacteria	209	1.62e-49	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g10561	i0	92.466	38.9483870967742	146	11	47	0	4	149	10935033	10935178	Labilithrix luteola strain DSM 27648, complete genome	blastn	12074	209	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
3413727	3413727	PRJNA888821_P_NODE_38283_length_243_cov_5.194118_g38200_i0	PRJNA888821	38283	243	5.194118	12.62170674	Minicystis rosea	888845	Bacteria	Bacteria	75	4.67e-9	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g38200	i0	79.091	0.452674897119342	110	21	45	2	1	109	11243629	11243521	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	110	75	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
3413735	3413735	PRJNA888821_P_NODE_38863_length_242_cov_0.911243_g38780_i0	PRJNA888821	38863	242	0.911243	2.20520806	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	425	1.11e-114	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g38780	i0	98.347	44.7892561983471	242	4	100	0	1	242	5589401	5589160	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	10839	425	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
9790824	9790824	PRJNA888821_P_NODE_33568_length_255_cov_4.912088_g33485_i0	PRJNA888821	33568	255	4.912088	12.5258244	Sorangium cellulosum	56	Bacteria	Bacteria	148	2.8699999999999997e-31	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g33485	i0	81.026	35.3450980392157	195	29	75	8	36	226	6723830	6723640	Sorangium cellulosum 'So ce 56' complete genome	blastn	9013	148	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
9791139	9791139	PRJNA888821_P_NODE_52968_length_197_cov_21.685484_g52885_i0	PRJNA888821	52968	197	21.685484	42.72040348	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	102	1.67e-17	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g52885	i0	80.292	2.2741116751269	137	26	70	1	8	144	579264	579129	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	448	102	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
12342193	12342193	PRJNA888821_P_NODE_43770_length_225_cov_26.171053_g43687_i0	PRJNA888821	43770	225	26.171053	58.88486925	Minicystis rosea	888845	Bacteria	Bacteria	145	3.21e-30	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g43687	i0	79.263	2.05777777777778	217	37	95	8	9	221	15498820	15499032	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	463	145	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
12342381	12342381	PRJNA888821_P_NODE_710_length_611_cov_16.148699_g639_i0	PRJNA888821	710	611	16.148699	98.66855089	Myxococcota bacterium	2818507	Bacteria	Bacteria	351	5.33e-92	NTclustered	gi\|2621786039\|emb\|OY782497.1\|	2818507	g639	i0	83.548	298.384615384615	389	51	63	11	1	383	2487432	2487051	MAG: Myxococcota bacterium isolate 0c961c99-2a7e-4543-b017-306f11f6fc1d genome assembly, chromosome: 1	blastn	182313	351	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
13616147	13616147	PRJNA888821_P_NODE_12051_length_310_cov_8.898734_g11969_i0	PRJNA888821	12051	310	8.898734	27.5860754	Archangium gephyra	48	Bacteria	Bacteria	63.9	1.34e-5	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g11969	i0	97.297	0.816129032258065	37	1	12	0	13	49	10487891	10487927	Archangium gephyra strain DSM 2261, complete genome	blastn	253	63.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
13616318	13616318	PRJNA888821_P_NODE_22151_length_308_cov_9.655319_g22069_i0	PRJNA888821	22151	308	9.655319	29.73838252	Sorangium cellulosum	56	Bacteria	Bacteria	134	9.98e-27	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g22069	i0	86.4	7.86688311688312	125	13	40	4	162	284	1994248	1994370	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	2423	134	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
14890706	14890706	PRJNA888821_P_NODE_25852_length_289_cov_0.847222_g25770_i0	PRJNA888821	25852	289	0.847222	2.44847158	Myxococcales bacterium	2026763	Bacteria	Bacteria	272	1.89e-68	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g25770	i0	84.397	220.965397923875	282	38	96	6	12	289	1312296	1312575	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	63859	272	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
14891155	14891155	PRJNA888821_P_NODE_51232_length_202_cov_8.775194_g51149_i0	PRJNA888821	51232	202	8.775194	17.72589188	Labilithrix luteola	1391654	Bacteria	Bacteria	291	3.42e-74	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g51149	i0	93.814	146.841584158416	194	11	96	1	1	193	3942804	3942997	Labilithrix luteola strain DSM 27648, complete genome	blastn	29662	291	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
16165363	16165363	PRJNA888821_P_NODE_18413_length_310_cov_4.080169_g18331_i0	PRJNA888821	18413	310	4.080169	12.6485239	Pendulispora rubella	2741070	Bacteria	Bacteria	167	9.909999999999998e-37	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g18331	i0	87.5	1.27741935483871	144	18	46	0	161	304	4107441	4107298	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	396	167	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
18714463	18714463	PRJNA888821_P_NODE_46635_length_215_cov_23.176056_g46552_i0	PRJNA888821	46635	215	23.176056	49.8285204	Minicystis rosea	888845	Bacteria	Bacteria	169	1.8e-37	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g46552	i0	83.243	1.05116279069767	185	29	86	2	32	215	8509832	8509649	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	226	169	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
22540087	22540087	PRJNA888821_P_NODE_9858_length_310_cov_11.303797_g9776_i0	PRJNA888821	9858	310	11.303797	35.0417707	Sorangium cellulosum	56	Bacteria	Bacteria	119	2.8200000000000003e-22	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g9776	i0	84.426	1.1	122	17	39	2	30	150	8368378	8368498	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	341	119	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
24193128	24193128	PRJNA888821_P_NODE_1219_length_515_cov_3.934389_g1144_i0	PRJNA888821	1219	515	3.934389	20.26210335	root	1	Root_unresolved	Root_unresolved	863	0	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g1144	i0	96.905	192.273786407767	517	12	100	4	1	515	2741	2227	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	99021	869	0.993095512082854	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
25088804	25088804	PRJNA888821_P_NODE_25800_length_289_cov_3.268519_g25718_i0	PRJNA888821	25800	289	3.268519	9.44601991	Sorangium cellulosum	56	Bacteria	Bacteria	189	1.95e-43	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g25718	i0	79.054	1.0242214532872	296	47	100	12	1	289	1523483	1523770	Sorangium cellulosum 'So ce 56' complete genome	blastn	296	189	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum

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