metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA615351" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA615351" 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
595866	595866	PRJNA615351_P_NODE_57421_length_627_cov_4.988176_g44427_i0	PRJNA615351	57421	627	4.988176	31.27586352	Sorangium cellulosum	56	Bacteria	Bacteria	839	0	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g44427	i0	90.852	122.781499202552	634	47	100	10	1	627	3450012	3450641	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	76984	839	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
1149948	1149948	PRJNA615351_P_NODE_139261_length_207_cov_7.255814_g125161_i0	PRJNA615351	139261	207	7.255814	15.01953498	Sorangium	39643	Bacteria	Bacteria	355	1.23e-93	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g125161	i0	97.585	276.734299516908	207	5	100	0	1	207	3692269	3692063	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	57284	355	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
4423363	4423363	PRJNA615351_P_NODE_43004_length_843_cov_42.042079_g32099_i0	PRJNA615351	43004	843	42.042079	354.41472597	Labilithrix luteola	1391654	Bacteria	Bacteria	54.7	0.024	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g32099	i0	100	0.0344009489916963	29	0	3	0	634	662	9099169	9099141	Labilithrix luteola strain DSM 27648, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
5699258	5699258	PRJNA615351_P_NODE_183105_length_153_cov_1.940678_g169005_i0	PRJNA615351	183105	153	1.940678	2.96923734	Sorangium cellulosum	56	Bacteria	Bacteria	156	9.29e-34	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g169005	i0	84.967	75.5947712418301	153	23	100	0	1	153	14379475	14379323	Sorangium cellulosum So0157-2, complete genome	blastn	11566	156	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
9524180	9524180	PRJNA615351_P_NODE_36468_length_973_cov_6.089552_g26948_i0	PRJNA615351	36468	973	6.089552	59.25134096	Minicystis rosea	888845	Bacteria	Bacteria	1083	0	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g26948	i0	86.965	179.251798561151	982	105	99	20	4	973	13716256	13715286	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	174412	1083	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
10078560	10078560	PRJNA615351_P_NODE_86468_length_385_cov_2.894286_g72397_i0	PRJNA615351	86468	385	2.894286	11.1430011	Pseudomonadati	3379134	Bacteria	Bacteria	187	9.649999999999999e-43	NTclustered	gi\|2579656172\|gb\|CP043491.1\|	43	g72397	i0	81.778	37.3402597402597	225	39	58	2	1	224	11312104	11311881	Cystobacter fuscus strain Cbf 10 chromosome, complete genome	blastn	14376	187	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
10799743	10799743	PRJNA615351_P_NODE_117889_length_256_cov_1.764706_g103790_i0	PRJNA615351	117889	256	1.764706	4.51764736	Cystobacter fuscus	43	Bacteria	Bacteria	67.6	8.31e-7	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g103790	i0	95.238	0.328125	42	2	16	0	144	185	6491769	6491728	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	84	67.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
13349808	13349808	PRJNA615351_P_NODE_166331_length_169_cov_1.783582_g152231_i0	PRJNA615351	166331	169	1.783582	3.01425358	Melittangium boletus	83453	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|1243026503\|gb\|CP022163.1\|	1294270	g152231	i0	100	0.165680473372781	28	0	17	0	142	169	9376706	9376733	Melittangium boletus DSM 14713 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Melittangium	Melittangium boletus
13349841	13349841	PRJNA615351_P_NODE_176271_length_159_cov_1.612903_g162171_i0	PRJNA615351	176271	159	1.612903	2.56451577	Melittangium boletus	83453	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|1243026503\|gb\|CP022163.1\|	1294270	g162171	i0	100	0.176100628930818	28	0	18	0	16	43	109399	109426	Melittangium boletus DSM 14713 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Melittangium	Melittangium boletus
14624375	14624375	PRJNA615351_P_NODE_115892_length_262_cov_1.066079_g101793_i0	PRJNA615351	115892	262	1.066079	2.79312698	Myxococcales bacterium	2026763	Bacteria	Bacteria	272	1.69e-68	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g101793	i0	85.714	105.454198473282	266	28	100	9	1	262	1312988	1312729	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	27629	272	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
14624523	14624523	PRJNA615351_P_NODE_170972_length_164_cov_2.062016_g156872_i0	PRJNA615351	170972	164	2.062016	3.38170624	Archangium gephyra	48	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g156872	i0	96.875	0.195121951219512	32	0	19	1	123	153	2191252	2191221	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	32	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
14624603	14624603	PRJNA615351_P_NODE_22652_length_1361_cov_3.573152_g16481_i0	PRJNA615351	22652	1361	3.573152	48.63059872	Myxococcota bacterium	2818507	Bacteria	Bacteria	60.2	8.33e-4	NTclustered	gi\|2907625649\|emb\|OZ223209.1\|	2818507	g16481	i0	92.683	0.0301249081557678	41	3	3	0	3	43	1891034	1891074	MAG: Myxococcota bacterium isolate 6e5ad1d4-156e-4916-952c-8a0b14857fe9 genome assembly, chromosome: 1	blastn	41	60.2	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
14624781	14624781	PRJNA615351_P_NODE_63652_length_559_cov_5.986641_g50128_i0	PRJNA615351	63652	559	5.986641	33.46532319	Labilithrix luteola	1391654	Bacteria	Bacteria	688	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g50128	i0	88.869	119.397137745975	566	53	100	7	1	559	7090656	7090094	Labilithrix luteola strain DSM 27648, complete genome	blastn	66743	688	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
15178381	15178381	PRJNA615351_P_NODE_177512_length_158_cov_1.520325_g163412_i0	PRJNA615351	177512	158	1.520325	2.4021135	Myxococcus	32	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g163412	i0	100	0.753164556962025	29	0	18	0	28	56	9313755	9313783	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	119	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
15898399	15898399	PRJNA615351_P_NODE_122733_length_243_cov_1.903846_g108633_i0	PRJNA615351	122733	243	1.903846	4.62634578	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	427	3.11e-115	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g108633	i0	98.354	234.901234567901	243	4	100	0	1	243	2161802	2161560	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	57081	427	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
15898825	15898825	PRJNA615351_P_NODE_66193_length_535_cov_2.290000_g52498_i0	PRJNA615351	66193	535	2.29	12.2515	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	56.5	0.004	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g52498	i0	89.362	0.0878504672897196	47	2	8	3	160	204	765826	765871	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	47	56.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
17173401	17173401	PRJNA615351_P_NODE_139254_length_207_cov_23.715116_g125154_i0	PRJNA615351	139254	207	23.715116	49.09029012	Minicystis rosea	888845	Bacteria	Bacteria	339	1.2399999999999998e-88	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g125154	i0	96.135	168.676328502415	207	8	100	0	1	207	771131	771337	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	34916	339	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
17173642	17173642	PRJNA615351_P_NODE_37654_length_947_cov_115.322368_g27875_i0	PRJNA615351	37654	947	115.322368	1092.10282496	Labilithrix luteola	1391654	Bacteria	Bacteria	54.7	0.027	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g27875	i0	100	0.030623020063358	29	0	3	0	182	210	9099141	9099169	Labilithrix luteola strain DSM 27648, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
17727885	17727885	PRJNA615351_P_NODE_37954_length_940_cov_52.033149_g28103_i0	PRJNA615351	37954	940	52.033149	489.1116006	Pendulispora	3375062	Bacteria	Bacteria	1282	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g28103	i0	91.533	156.222340425532	933	75	99	3	7	939	7288824	7289752	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	146849	1288	0.995341614906832	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
20276333	20276333	PRJNA615351_P_NODE_109216_length_283_cov_1.431452_g95117_i0	PRJNA615351	109216	283	1.431452	4.05100916	Corallococcus	83461	Bacteria	Bacteria	110	1.53e-19	NTclustered	gi\|337255776\|gb\|CP002830.1\|	35	g95117	i0	82.031	1.80565371024735	128	23	45	0	155	282	6558488	6558361	Myxococcus macrosporus strain HW-1, complete genome	blastn	511	110	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus macrosporus
24101891	24101891	PRJNA615351_P_NODE_95419_length_338_cov_2.359736_g81327_i0	PRJNA615351	95419	338	2.359736	7.97590768	Bacteria	2	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|817709775\|gb\|CP006003.1\|	1334629	g81327	i0	96.774	0.257396449704142	31	1	9	0	61	91	10017572	10017542	Myxococcus fulvus 124B02, complete genome	blastn	87	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
25376312	25376312	PRJNA615351_P_NODE_142400_length_202_cov_1.562874_g128300_i0	PRJNA615351	142400	202	1.562874	3.15700548	Myxococcales	29	Bacteria	Bacteria	340	3.35e-89	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g128300	i0	97.044	190.569306930693	203	5	100	1	1	202	451874	451672	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	38495	340	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus

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