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

22 rows where analysis = "blastn", bioproject = "PRJNA1111146" 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
216493	216493	PRJNA1111146_P_NODE_353741_length_182_cov_0.883721_g352603_i0	PRJNA1111146	353741	182	0.883721	1.60837222	Corallococcus sp. EGB	1521117	Bacteria	Bacteria	315	1.79e-81	NTclustered	gi\|2094564806\|gb\|CP079946.1\|	1521117	g352603	i0	97.802	34.3516483516484	182	4	100	0	1	182	6365028	6364847	Corallococcus sp. EGB chromosome, complete genome	blastn	6252	315	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. EGB
216797	216797	PRJNA1111146_P_NODE_417401_length_178_cov_0.912000_g416263_i0	PRJNA1111146	417401	178	0.912	1.62336	Minicystis rosea	888845	Bacteria	Bacteria	154	4.01e-33	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g416263	i0	91.892	0.623595505617977	111	8	62	1	2	111	11179894	11179784	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	111	154	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
1490533	1490533	PRJNA1111146_P_NODE_196742_length_207_cov_1.298701_g195604_i0	PRJNA1111146	196742	207	1.298701	2.68831107	Corallococcus exercitus	2316736	Bacteria	Bacteria	357	3.43e-94	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g195604	i0	98.049	38.8502415458937	205	4	99	0	1	205	6387805	6388009	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	8042	357	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
1490539	1490539	PRJNA1111146_P_NODE_199202_length_206_cov_2.019608_g198064_i0	PRJNA1111146	199202	206	2.019608	4.16039248	Sorangium cellulosum	56	Bacteria	Bacteria	200	6.079999999999999e-47	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g198064	i0	84.729	26.6893203883495	203	27	98	3	6	206	3809825	3810025	Sorangium cellulosum 'So ce 56' complete genome	blastn	5498	200	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
1491274	1491274	PRJNA1111146_P_NODE_367842_length_181_cov_0.890625_g366704_i0	PRJNA1111146	367842	181	0.890625	1.61203125	Myxococcus sp. MH1	2982796	Bacteria	Bacteria	294	2.31e-75	NTclustered	gi\|2321229309\|dbj\|AP026947.1\|	2982796	g366704	i0	96.111	7.03314917127072	180	7	99	0	2	181	1836965	1836786	Myxococcus sp. MH1 DNA, complete genome	blastn	1273	294	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus sp. MH1
2766986	2766986	PRJNA1111146_P_NODE_313843_length_185_cov_0.863636_g312705_i0	PRJNA1111146	313843	185	0.863636	1.5977266	Myxococcus fulvus	33	Bacteria	Bacteria	281	1.8500000000000002e-71	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g312705	i0	94.054	3.15135135135135	185	11	100	0	1	185	4780832	4780648	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	583	281	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
4042371	4042371	PRJNA1111146_P_NODE_112324_length_237_cov_1.239130_g111186_i0	PRJNA1111146	112324	237	1.23913	2.9367381	Corallococcus interemptor	2316720	Bacteria	Bacteria	80.5	9.76e-11	NTclustered	gi\|2809283937\|gb\|CP102579.1\|	2316720	g111186	i0	82.292	17.2658227848101	96	13	40	4	138	231	8724334	8724241	Corallococcus interemptor strain YZPH-2 chromosome, complete genome	blastn	4092	80.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus interemptor
4043491	4043491	PRJNA1111146_P_NODE_385564_length_180_cov_0.897638_g384426_i0	PRJNA1111146	385564	180	0.897638	1.6157484	Corallococcus coralloides	184914	Bacteria	Bacteria	272	1.08e-68	NTclustered	gi\|2851136330\|gb\|CP172866.1\|	184914	g384426	i0	93.889	5.97777777777778	180	11	100	0	1	180	3631219	3631398	Corallococcus coralloides strain KYC2213 chromosome, complete genome	blastn	1076	272	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
7868970	7868970	PRJNA1111146_P_NODE_276627_length_191_cov_1.623188_g275489_i0	PRJNA1111146	276627	191	1.623188	3.10028908	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	209	9.21e-50	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g275489	i0	86.387	1.45549738219895	191	26	100	0	1	191	4696770	4696960	Anaeromyxobacter oryzae DNA, complete genome	blastn	278	209	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
9144253	9144253	PRJNA1111146_P_NODE_362888_length_181_cov_1.593750_g361750_i0	PRJNA1111146	362888	181	1.59375	2.8846875	Polyangium aurulentum	2567896	Bacteria	Bacteria	84.2	5.45e-12	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g361750	i0	77.857	2.6353591160221	140	27	76	4	10	147	10664733	10664596	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	477	84.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
9144507	9144507	PRJNA1111146_P_NODE_416348_length_178_cov_0.912000_g415210_i0	PRJNA1111146	416348	178	0.912	1.62336	Corallococcus macrosporus	35	Bacteria	Bacteria	268	1.3699999999999999e-67	NTclustered	gi\|1243045502\|gb\|CP022203.1\|	1189310	g415210	i0	93.82	5.96629213483146	178	11	100	0	1	178	5982410	5982233	Corallococcus macrosporus DSM 14697 chromosome, complete genome	blastn	1062	268	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus macrosporus
11694744	11694744	PRJNA1111146_P_NODE_239890_length_198_cov_1.572414_g238752_i0	PRJNA1111146	239890	198	1.572414	3.11337972	Corallococcus sp. NCRR	2996782	Bacteria	Bacteria	276	9.36e-70	NTclustered	gi\|2415015785\|gb\|CP114039.1\|	2996782	g238752	i0	94.886	24.7676767676768	176	9	89	0	23	198	5624464	5624639	Corallococcus sp. NCRR chromosome, complete genome	blastn	4904	276	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. NCRR
11695052	11695052	PRJNA1111146_P_NODE_314390_length_185_cov_0.863636_g313252_i0	PRJNA1111146	314390	185	0.863636	1.5977266	Corallococcus sp. EGB	1521117	Bacteria	Bacteria	303	3.95e-78	NTclustered	gi\|2094564806\|gb\|CP079946.1\|	1521117	g313252	i0	96.216	2.98378378378378	185	7	100	0	1	185	8197313	8197129	Corallococcus sp. EGB chromosome, complete genome	blastn	552	303	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. EGB
13775357	13775357	PRJNA1111146_P_NODE_415351_length_178_cov_0.912000_g414213_i0	PRJNA1111146	415351	178	0.912	1.62336	Corallococcus	83461	Bacteria	Bacteria	318	1.34e-82	NTclustered	gi\|337255776\|gb\|CP002830.1\|	35	g414213	i0	98.876	41.4101123595506	178	2	100	0	1	178	5301471	5301648	Myxococcus macrosporus strain HW-1, complete genome	blastn	7371	318	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus macrosporus
15049252	15049252	PRJNA1111146_P_NODE_182512_length_210_cov_1.305732_g181374_i0	PRJNA1111146	182512	210	1.305732	2.7420372	Myxococcaceae	31	Bacteria	Bacteria	161	2.93e-35	NTclustered	gi\|337255776\|gb\|CP002830.1\|	35	g181374	i0	80.751	28.4571428571429	213	35	100	6	1	210	3843264	3843473	Myxococcus macrosporus strain HW-1, complete genome	blastn	5976	161	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus macrosporus
15049759	15049759	PRJNA1111146_P_NODE_406292_length_179_cov_0.888889_g405154_i0	PRJNA1111146	406292	179	0.888889	1.59111131	Archangiaceae	39	Bacteria	Bacteria	226	8.439999999999999e-55	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g405154	i0	89.444	21.2737430167598	180	17	100	2	1	179	4674566	4674388	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	3808	226	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
16324501	16324501	PRJNA1111146_P_NODE_362213_length_181_cov_1.750000_g361075_i0	PRJNA1111146	362213	181	1.75	3.1675	Myxococcus	32	Bacteria	Bacteria	296	6.43e-76	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g361075	i0	96.133	2.98895027624309	181	7	100	0	1	181	1685715	1685535	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	541	298	0.993288590604027	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
18873490	18873490	PRJNA1111146_P_NODE_323915_length_184_cov_0.870229_g322777_i0	PRJNA1111146	323915	184	0.870229	1.60122136	Myxococcus	32	Bacteria	Bacteria	296	6.57e-76	NTclustered	gi\|817709775\|gb\|CP006003.1\|	1334629	g322777	i0	95.652	8.53260869565217	184	8	100	0	1	184	6229266	6229083	Myxococcus fulvus 124B02, complete genome	blastn	1570	296	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
19342176	19342176	PRJNA1111146_P_NODE_301376_length_187_cov_0.970149_g300238_i0	PRJNA1111146	301376	187	0.970149	1.81417863	Pendulispora brunnea	2905690	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g300238	i0	100	0.149732620320856	28	0	15	0	150	177	8154609	8154636	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
21423944	21423944	PRJNA1111146_P_NODE_333677_length_183_cov_1.315385_g332539_i0	PRJNA1111146	333677	183	1.315385	2.40715455	Myxococcales	29	Bacteria	Bacteria	279	6.57e-71	NTclustered	gi\|1243034522\|gb\|CP022098.1\|	43	g332539	i0	94.972	280.989071038251	179	8	97	1	1	178	389073	388895	Cystobacter fuscus strain DSM 52655 chromosome, complete genome	blastn	51421	281	0.99288256227758	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
22698862	22698862	PRJNA1111146_P_NODE_343798_length_183_cov_0.861538_g342660_i0	PRJNA1111146	343798	183	0.861538	1.57661454	Archangiaceae	39	Bacteria	Bacteria	211	2.43e-50	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g342660	i0	87.5	41.2896174863388	184	21	100	2	1	183	9683153	9683335	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	7556	211	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
22698917	22698917	PRJNA1111146_P_NODE_368058_length_181_cov_0.890625_g366920_i0	PRJNA1111146	368058	181	0.890625	1.61203125	Bacteria	2	Bacteria	Bacteria	150	5.299999999999999e-32	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g366920	i0	82.065	12.0828729281768	184	26	99	6	3	181	10236660	10236841	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	2187	150	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum

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