metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA669701" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA669701" 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
635222	635222	PRJNA669701_P_NODE_119541_length_247_cov_4.160920_g119146_i0	PRJNA669701	119541	247	4.16092	10.2774724	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	78.7	3.68e-10	NTclustered	gi\|152026452\|gb\|CP000769.1\|	404589	g119146	i0	82.955	2.96761133603239	88	13	35	2	1	87	2782959	2782873	Anaeromyxobacter sp. Fw109-5, complete genome	blastn	733	78.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
636499	636499	PRJNA669701_P_NODE_87221_length_273_cov_2.110000_g86826_i0	PRJNA669701	87221	273	2.11	5.7603	Cystobacter fuscus	43	Bacteria	Bacteria	220	6.49e-53	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g86826	i0	90.854	4.19413919413919	164	15	60	0	2	165	2466911	2467074	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	1145	220	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
3715627	3715627	PRJNA669701_P_NODE_142683_length_241_cov_0.916667_g142288_i0	PRJNA669701	142683	241	0.916667	2.20916747	Myxococcus	32	Bacteria	Bacteria	99	2.75e-16	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g142288	i0	80	12.0207468879668	140	22	57	5	72	208	2425113	2424977	Myxococcus xanthus strain DK1050 chromosome	blastn	2897	99	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
4464299	4464299	PRJNA669701_P_NODE_87444_length_273_cov_1.540000_g87049_i0	PRJNA669701	87444	273	1.54	4.2042	Labilithrix luteola	1391654	Bacteria	Bacteria	390	4.6799999999999996e-104	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g87049	i0	92.62	148.952380952381	271	20	99	0	1	271	3942266	3941996	Labilithrix luteola strain DSM 27648, complete genome	blastn	40664	390	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
5738799	5738799	PRJNA669701_P_NODE_139825_length_241_cov_4.613095_g139430_i0	PRJNA669701	139825	241	4.613095	11.11755895	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	324	4.16e-84	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g139430	i0	91.489	91.0165975103734	235	20	98	0	5	239	931710	931944	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	21935	324	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
5739241	5739241	PRJNA669701_P_NODE_43765_length_360_cov_1.327526_g43370_i0	PRJNA669701	43765	360	1.327526	4.7790936	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	259	1.87e-64	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g43370	i0	80.332	9.92222222222222	361	55	99	13	1	353	171375	171727	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	3572	259	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
7013495	7013495	PRJNA669701_P_NODE_104306_length_254_cov_1.701657_g103911_i0	PRJNA669701	104306	254	1.701657	4.32220878	Labilithrix luteola	1391654	Bacteria	Bacteria	252	2.12e-62	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g103911	i0	84.646	1.22834645669291	254	37	99	2	2	254	9189817	9189565	Labilithrix luteola strain DSM 27648, complete genome	blastn	312	252	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
10092478	10092478	PRJNA669701_P_NODE_132808_length_244_cov_0.900585_g132413_i0	PRJNA669701	132808	244	0.900585	2.1974274	Corallococcus	83461	Bacteria	Bacteria	300	7.12e-77	NTclustered	gi\|337255776\|gb\|CP002830.1\|	35	g132413	i0	89.451	20.344262295082	237	25	97	0	8	244	8125411	8125647	Myxococcus macrosporus strain HW-1, complete genome	blastn	4964	300	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus macrosporus
12115813	12115813	PRJNA669701_P_NODE_99730_length_259_cov_1.720430_g99335_i0	PRJNA669701	99730	259	1.72043	4.4559137	Pendulispora rubella	2741070	Bacteria	Bacteria	335	2.089999999999999e-87	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g99335	i0	89.961	70.8571428571429	259	26	100	0	1	259	10024228	10024486	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	18352	335	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
12643074	12643074	PRJNA669701_P_NODE_121530_length_247_cov_0.885057_g121135_i0	PRJNA669701	121530	247	0.885057	2.18609079	Myxococcus	32	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g121135	i0	99.595	18.1983805668016	247	1	100	0	1	247	5190234	5190480	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	4495	451	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
14664756	14664756	PRJNA669701_P_NODE_42512_length_364_cov_3.154639_g42117_i0	PRJNA669701	42512	364	3.154639	11.48288596	Labilithrix luteola	1391654	Bacteria	Bacteria	497	3.69e-136	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g42117	i0	91.507	116.233516483516	365	25	99	4	4	364	7090526	7090164	Labilithrix luteola strain DSM 27648, complete genome	blastn	42309	497	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
14665455	14665455	PRJNA669701_P_NODE_95052_length_264_cov_2.188482_g94657_i0	PRJNA669701	95052	264	2.188482	5.77759248	Cystobacter fuscus	43	Bacteria	Bacteria	191	4.899999999999998e-44	NTclustered	gi\|2579656172\|gb\|CP043491.1\|	43	g94657	i0	80.075	57.0416666666667	266	45	99	8	3	264	1707494	1707233	Cystobacter fuscus strain Cbf 10 chromosome, complete genome	blastn	15059	191	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
19761880	19761880	PRJNA669701_P_NODE_109936_length_251_cov_0.865169_g109541_i0	PRJNA669701	109936	251	0.865169	2.17157419	Pseudomyxococcus hansupus	1297742	Bacteria	Bacteria	261	3.47e-65	NTclustered	gi\|891158403\|gb\|CP012109.1\|	1297742	g109541	i0	85.83	40.3625498007968	247	34	98	1	6	251	1194995	1195241	Myxococcus hansupus strain mixupus chromosome, complete genome	blastn	10131	261	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pseudomyxococcus	Pseudomyxococcus hansupus
21038000	21038000	PRJNA669701_P_NODE_147817_length_226_cov_2.960784_g147422_i0	PRJNA669701	147817	226	2.960784	6.69137184	Pendulispora albinea	2741071	Bacteria	Bacteria	254	5.14e-63	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g147422	i0	87.111	4.98672566371681	225	27	99	2	3	226	9010042	9009819	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	1127	254	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
22312655	22312655	PRJNA669701_P_NODE_136718_length_242_cov_1.887574_g136323_i0	PRJNA669701	136718	242	1.887574	4.56792908	Archangium gephyra	48	Bacteria	Bacteria	243	1.2100000000000004e-59	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g136323	i0	84.711	80.6694214876033	242	37	100	0	1	242	5457925	5457684	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	19522	243	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
22841956	22841956	PRJNA669701_P_NODE_62718_length_310_cov_2.556962_g62323_i0	PRJNA669701	62718	310	2.556962	7.9265822	Sorangium	39643	Bacteria	Bacteria	187	7.61e-43	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g62323	i0	89.262	2.3	149	16	95	0	161	309	5638856	5639004	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	713	187	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
24861566	24861566	PRJNA669701_P_NODE_139240_length_242_cov_0.911243_g138845_i0	PRJNA669701	139240	242	0.911243	2.20520806	Minicystis rosea	888845	Bacteria	Bacteria	182	2.66e-41	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g138845	i0	81.223	0.946280991735537	229	39	94	4	1	227	4580475	4580701	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	229	182	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea

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