metadata: contig_metadata: 19 rows where bioproject = "PRJNA983848", tax_kingdom = "Pseudomonadati" and tax

19 rows where bioproject = "PRJNA983848", tax_kingdom = "Pseudomonadati" 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
968455	968455	PRJNA983848_P_NODE_167761_length_198_cov_6.832000_g161878_i0	PRJNA983848	167761	198	6.832	13.52736	Chondromyces crocatus	52	Bacteria	Bacteria	182	2.0999999999999996e-41	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g161878	i0	86.127	83.9393939393939	173	18	86	5	2	171	2664	2833	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	16620	182	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
7345832	7345832	PRJNA983848_P_NODE_156506_length_243_cov_11.835294_g150623_i0	PRJNA983848	156506	243	11.835294	28.75976442	Myxococcales bacterium	2026763	Bacteria	Bacteria	390	4.089999999999999e-104	NTclustered	gi\|1958041644\|gb\|CP064980.1\|	2026763	g150623	i0	95.851	149.757201646091	241	10	99	0	3	243	1308903	1308663	Myxococcales bacterium isolate Fred_18-Q3-R57-64_BAT3C.417 chromosome	blastn	36391	390	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
7649559	7649559	PRJNA983848_P_NODE_160626_length_242_cov_0.923077_g154743_i0	PRJNA983848	160626	242	0.923077	2.23384634	Sorangium	39643	Bacteria	Bacteria	296	9.12e-76	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g154743	i0	88.843	103.090909090909	242	26	99	1	2	242	509	268	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	24948	296	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
8620457	8620457	PRJNA983848_P_NODE_137627_length_253_cov_1.333333_g131744_i0	PRJNA983848	137627	253	1.333333	3.37333249	Corallococcus sp. EGB	1521117	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|2094564806\|gb\|CP079946.1\|	1521117	g131744	i0	100	227.217391304348	253	0	100	0	1	253	113692	113944	Corallococcus sp. EGB chromosome, complete genome	blastn	57486	468	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. EGB
8924423	8924423	PRJNA983848_P_NODE_159007_length_242_cov_1.846154_g153124_i0	PRJNA983848	159007	242	1.846154	4.46769268	Pseudomonadati	3379134	Bacteria	Bacteria	206	1.58e-48	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g153124	i0	85.149	129.425619834711	202	28	91	2	19	220	108631	108432	Archangium gephyra strain DSM 2261, complete genome	blastn	31321	207	0.995169082125604	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
12447636	12447636	PRJNA983848_P_NODE_166710_length_218_cov_8.841379_g160827_i0	PRJNA983848	166710	218	8.841379	19.27420622	Minicystis rosea	888845	Bacteria	Bacteria	213	8.35e-51	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g160827	i0	84.615	765.146788990826	221	27	100	7	1	218	768847	769063	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	166802	213	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
14999245	14999245	PRJNA983848_P_NODE_94872_length_312_cov_1.966527_g88989_i0	PRJNA983848	94872	312	1.966527	6.13556424	Corallococcus exercitus	2316736	Bacteria	Bacteria	555	1.8199999999999994e-153	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g88989	i0	98.718	243.967948717949	312	4	100	0	1	312	88290	87979	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	76118	555	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
17548083	17548083	PRJNA983848_P_NODE_63914_length_402_cov_11.659574_g58032_i0	PRJNA983848	63914	402	11.659574	46.87148748	Myxococcales bacterium	2026763	Bacteria	Bacteria	544	5.22e-150	NTclustered	gi\|1958041644\|gb\|CP064980.1\|	2026763	g58032	i0	91.414	165.6592039801	396	34	99	0	7	402	1308712	1308317	Myxococcales bacterium isolate Fred_18-Q3-R57-64_BAT3C.417 chromosome	blastn	66595	544	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
19122874	19122874	PRJNA983848_P_NODE_162795_length_236_cov_2.196319_g156912_i0	PRJNA983848	162795	236	2.196319	5.18331284	Bacteria	2	Bacteria	Bacteria	279	8.92e-71	NTclustered	gi\|297170971\|gb\|GU567972.1\|	723556	g156912	i0	88.136	162.28813559322	236	26	100	2	1	236	28102	27869	Uncultured myxobacterium HF0200_01L06 genomic sequence	blastn	38300	281	0.99288256227758	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			uncultured myxobacterium HF0200_01L06
20094882	20094882	PRJNA983848_P_NODE_167256_length_207_cov_15.380597_g161373_i0	PRJNA983848	167256	207	15.380597	31.83783579	Myxococcales bacterium	2026763	Bacteria	Bacteria	161	2.8799999999999997e-35	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g161373	i0	80.861	110.763285024155	209	37	100	3	1	207	1313734	1313941	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	22928	161	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
23923931	23923931	PRJNA983848_P_NODE_96279_length_309_cov_5.665254_g90396_i0	PRJNA983848	96279	309	5.665254	17.50563486	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	346	1.18e-90	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g90396	i0	87.138	142.019417475728	311	33	100	6	1	309	9678217	9677912	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	43884	346	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
26937268	26937268	PRJNA983848_P_NODE_154302_length_245_cov_0.906977_g148419_i0	PRJNA983848	154302	245	0.906977	2.22209365	Bacteria	2	Bacteria	Bacteria	52.8	1.11e-5	NR	MCB9739322.1	2026735	g148419	i0	38.3	4.84897959183674	81	49	99.2	1	1	243	74	153	MCB9739322.1 ATP-binding cassette domain-containing protein [Deltaproteobacteria bacterium]	diamond	1188	53.1	0.994350282485876	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27847518	27847518	PRJNA983848_P_NODE_139224_length_252_cov_1.698324_g133341_i0	PRJNA983848	139224	252	1.698324	4.27977648	Myxococcota bacterium	2818507	Bacteria	Bacteria	42.7	0.0404	NR	HEU4429896.1	2818507	g133341	i0	45.7	0.547619047619048	46	25	54.8	0	193	56	13	58	HEU4429896.1 rhomboid family intramembrane serine protease [Myxococcota bacterium]	diamond	138	42.7	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
29268307	29268307	PRJNA983848_P_NODE_96929_length_308_cov_2.063830_g91046_i0	PRJNA983848	96929	308	2.06383	6.3565964	Myxococcota bacterium	2818507	Bacteria	Bacteria	43.5	0.035	NR	MEE2703528.1	2818507	g91046	i0	39.2	0.496753246753247	51	31	49.7	0	291	139	97	147	MEE2703528.1 1-(5-phosphoribosyl)-5-[(5-phosphoribosylamino)methylideneamino]imidazole-4-carboxamide isomerase [Myxococcota bacterium]	diamond	153	43.5	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
30822229	30822229	PRJNA983848_P_NODE_62934_length_407_cov_2.401198_g57052_i0	PRJNA983848	62934	407	2.401198	9.77287586	Pseudomonadati	3379134	Bacteria	Bacteria	53.9	2.82e-5	NR	MBW2606464.1	2026735	g57052	i0	32.3	3.62653562653563	96	62	69.3	3	73	354	164	258	MBW2606464.1 insulinase family protein [Deltaproteobacteria bacterium]	diamond	1476	54.3	0.992633517495396	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31005797	31005797	PRJNA983848_P_NODE_143514_length_250_cov_0.881356_g137631_i0	PRJNA983848	143514	250	0.881356	2.20339	Myxococcales bacterium	2026763	Bacteria	Bacteria	92.4	1.23e-19	NR	MBL8685666.1	2026763	g137631	i0	62	1.932	79	30	94.8	0	249	13	268	346	MBL8685666.1 deoxyribodipyrimidine photo-lyase [Myxococcales bacterium]	diamond	483	92.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31258640	31258640	PRJNA983848_P_NODE_159955_length_242_cov_0.923077_g154072_i0	PRJNA983848	159955	242	0.923077	2.23384634	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	138	2.2899999999999998e-38	NR	HEX2673937.1	2268199	g154072	i0	85	0.991735537190083	80	12	99.2	0	2	241	167	246	HEX2673937.1 hypothetical protein [Polyangiaceae bacterium]	diamond	240	138	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
31416787	31416787	PRJNA983848_P_NODE_107016_length_291_cov_1.935780_g101133_i0	PRJNA983848	107016	291	1.93578	5.6331198	Polyangia bacterium	3058050	Bacteria	Bacteria	41.2	0.0424	NR	HEY7954277.1	3058050	g101133	i0	29.9	0.690721649484536	67	44	69.1	1	16	216	11	74	HEY7954277.1 hypothetical protein [Polyangia bacterium]	diamond	201	41.2	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
32681398	32681398	PRJNA983848_P_NODE_1120_length_5476_cov_8.243568_g860_i0	PRJNA983848	1120	5476	8.243568	451.41778368	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	100	5.46e-17	NR	MCC6623602.1	2026735	g860	i0	32.5	0.12490869247626	228	99	11.1	8	839	1447	624	821	MCC6623602.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	684	100	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);;