metadata: contig_metadata: 26 rows where bioproject = "PRJNA498309", tax_kingdom = "Pseudomonadati" and tax

26 rows where bioproject = "PRJNA498309", 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
481621	481621	PRJNA498309_P_NODE_97981_length_199_cov_1.709877_g95832_i0	PRJNA498309	97981	199	1.709877	3.40265523	Myxococcus sp. MH1	2982796	Bacteria	Bacteria	158	3.56e-34	NTclustered	gi\|2321229309\|dbj\|AP026947.1\|	2982796	g95832	i0	82.199	55.5829145728643	191	26	94	8	5	191	5265649	5265463	Myxococcus sp. MH1 DNA, complete genome	blastn	11061	158	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus sp. MH1
4308147	4308147	PRJNA498309_P_NODE_76344_length_263_cov_1.438053_g74195_i0	PRJNA498309	76344	263	1.438053	3.78207939	Archangium violaceum	83451	Bacteria	Bacteria	99	3.04e-16	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g74195	i0	83.654	0.775665399239544	104	17	40	0	158	261	12605473	12605576	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	204	99	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
6211858	6211858	PRJNA498309_P_NODE_116185_length_161_cov_2.048387_g114036_i0	PRJNA498309	116185	161	2.048387	3.29790307	Pseudomonadati	3379134	Bacteria	Bacteria	292	7.24e-75	NTclustered	gi\|166033772\|gb\|EU262998.1\|	43	g114036	i0	99.379	112	161	1	100	0	1	161	518	678	Cystobacter fuscus strain NM03 16S ribosomal RNA gene, complete sequence	blastn	18032	292	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
6857733	6857733	PRJNA498309_P_NODE_108386_length_176_cov_1.561151_g106237_i0	PRJNA498309	108386	176	1.561151	2.74762576	Pendulispora albinea	2741071	Bacteria	Bacteria	134	5.1500000000000005e-27	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g106237	i0	80.925	0.982954545454545	173	29	97	4	6	176	4357918	4358088	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	173	134	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
6858156	6858156	PRJNA498309_P_NODE_25186_length_574_cov_17.590317_g23249_i0	PRJNA498309	25186	574	17.590317	100.96841958	Nannocystis punicea	2995304	Bacteria	Bacteria	148	7.019999999999999e-31	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g23249	i0	83.75	0.278745644599303	160	22	28	4	362	519	7243545	7243388	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	160	148	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
15783530	15783530	PRJNA498309_P_NODE_48153_length_386_cov_29.157593_g46017_i0	PRJNA498309	48153	386	29.157593	112.54830898	Polyangium aurulentum	2567896	Bacteria	Bacteria	425	1.88e-114	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g46017	i0	90.683	180.878238341969	322	26	83	4	44	364	444456	444774	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	69819	425	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
18960223	18960223	PRJNA498309_P_NODE_21635_length_623_cov_1.726962_g19777_i0	PRJNA498309	21635	623	1.726962	10.75897326	Myxococcus	32	Bacteria	Bacteria	99	7.83e-16	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g19777	i0	80.147	1.10593900481541	136	23	22	4	47	180	432801	432934	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	689	99	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
22156789	22156789	PRJNA498309_P_NODE_114678_length_164_cov_1.409449_g112529_i0	PRJNA498309	114678	164	1.409449	2.31149636	Corallococcus sp. EGB	1521117	Bacteria	Bacteria	117	4.79e-22	NTclustered	gi\|2094564806\|gb\|CP079946.1\|	1521117	g112529	i0	91.667	4.45731707317073	84	7	51	0	75	158	5518242	5518325	Corallococcus sp. EGB chromosome, complete genome	blastn	731	117	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. EGB
23433168	23433168	PRJNA498309_P_NODE_38799_length_445_cov_16.828431_g36719_i0	PRJNA498309	38799	445	16.828431	74.88651795	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	249	9.98e-79	NR	MBI3759687.1	2026735	g36719	i0	88.7	0.950561797752809	141	16	95.1	0	22	444	282	422	MBI3759687.1 TolC family protein [Deltaproteobacteria bacterium]	diamond	423	249	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
23434762	23434762	PRJNA498309_S_NODE_37219_length_231_cov_294.693878_g35051_i0	PRJNA498309	37219	231	294.693878	680.74285818	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	300	6.68e-77	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g35051	i0	93.532	64.5281385281385	201	13	87	0	1	201	948448	948248	Anaeromyxobacter oryzae DNA, complete genome	blastn	14906	300	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
26887409	26887409	PRJNA498309_P_NODE_57061_length_341_cov_2.351974_g54913_i0	PRJNA498309	57061	341	2.351974	8.02023134	Myxococcales bacterium	2026763	Bacteria	Bacteria	136	6.73e-35	NR	MBK7395444.1	2026763	g54913	i0	67.4	0.809384164222874	92	29	80.9	1	24	299	467	557	MBK7395444.1 hypothetical protein [Myxococcales bacterium]	diamond	276	136	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
26918865	26918865	PRJNA498309_P_NODE_3882_length_1764_cov_2.780544_g2953_i0	PRJNA498309	3882	1764	2.780544	49.04879616	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	352	2.44e-111	NR	MBI5327092.1	2026735	g2953	i0	75.9	0.387755102040816	228	55	38.8	0	1762	1079	272	499	MBI5327092.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	684	352	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27139912	27139912	PRJNA498309_S_NODE_39062_length_218_cov_517.896175_g36894_i0	PRJNA498309	39062	218	517.896175	1129.0136615	Myxococcales bacterium	2026763	Bacteria	Bacteria	60.1	9.36e-9	NR	MEA2698107.1	2026763	g36894	i0	42.9	1.73394495412844	63	32	81.2	1	182	6	16	78	MEA2698107.1 hypothetical protein [Myxococcales bacterium]	diamond	378	60.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
27203208	27203208	PRJNA498309_P_NODE_31082_length_508_cov_8.252654_g29072_i0	PRJNA498309	31082	508	8.252654	41.92348232	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	84.3	2.24e-15	NR	MCP4372961.1	2026735	g29072	i0	35.6	1.83661417322835	160	64	94.5	2	489	10	1762	1882	MCP4372961.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	933	84.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
27313947	27313947	PRJNA498309_S_NODE_6783_length_1064_cov_26.015549_g5270_i0	PRJNA498309	6783	1064	26.015549	276.80544136	Bacteria	2	Bacteria	Bacteria	336	1.1599999999999999e-110	NR	WP_211241634.1	43	g5270	i0	70.5	8.66729323308271	234	69	66	0	702	1	4	237	WP_211241634.1 NADP-dependent oxidoreductase [Cystobacter fuscus]	diamond	9222	336	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
27582479	27582479	PRJNA498309_P_NODE_61284_length_322_cov_1.957895_g59136_i0	PRJNA498309	61284	322	1.957895	6.3044219	Myxococcales bacterium	2026763	Bacteria	Bacteria	99.8	9.39e-22	NR	MFT3926649.1	2026763	g59136	i0	58	0.754658385093168	81	34	75.5	0	78	320	1	81	MFT3926649.1 protein kinase [Myxococcales bacterium]	diamond	243	99.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
28119269	28119269	PRJNA498309_S_NODE_6405_length_1110_cov_20.190698_g4920_i0	PRJNA498309	6405	1110	20.190698	224.1167478	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	399	4.9299999999999985e-133	NR	MBI5327092.1	2026735	g4920	i0	73.2	1.47027027027027	272	72	73.5	1	1091	276	229	499	MBI5327092.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	1632	399	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28182219	28182219	PRJNA498309_P_NODE_56766_length_342_cov_5.281967_g54618_i0	PRJNA498309	56766	342	5.281967	18.06432714	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	102	5.28e-23	NR	MDP2339769.1	2026735	g54618	i0	55	0.87719298245614	100	43	87.7	1	23	322	186	283	MDP2339769.1 acyltransferase [Deltaproteobacteria bacterium]	diamond	300	102	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
28640183	28640183	PRJNA498309_P_NODE_36627_length_462_cov_2.555294_g34567_i0	PRJNA498309	36627	462	2.555294	11.80545828	Pseudomonadati	3379134	Bacteria	Bacteria	225	1.68e-70	NR	WP_211241634.1	43	g34567	i0	73	8.92207792207792	152	41	98.7	0	5	460	88	239	WP_211241634.1 NADP-dependent oxidoreductase [Cystobacter fuscus]	diamond	4122	226	0.995575221238938	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
28877031	28877031	PRJNA498309_P_NODE_56048_length_345_cov_9.178571_g53900_i0	PRJNA498309	56048	345	9.178571	31.66606995	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	123	3.33e-31	NR	TMA52296.1	2026735	g53900	i0	76.5	0.704347826086957	81	19	70.4	0	101	343	176	256	TMA52296.1 MAG: hypothetical protein E6J80_12430, partial [Deltaproteobacteria bacterium]	diamond	243	123	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29319047	29319047	PRJNA498309_P_NODE_30089_length_518_cov_4.313929_g28094_i0	PRJNA498309	30089	518	4.313929	22.34615222	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	296	2.5099999999999996e-99	NR	HVK87712.1	2212474	g28094	i0	91.1	0.909266409266409	157	14	90.9	0	1	471	79	235	HVK87712.1 hypothetical protein [Kofleriaceae bacterium]	diamond	471	296	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
29729314	29729314	PRJNA498309_P_NODE_26110_length_562_cov_12.634286_g24160_i0	PRJNA498309	26110	562	12.634286	71.00468732	Corallococcus	83461	Bacteria	Bacteria	172	7.76e-51	NR	WP_121723575.1	83461	g24160	i0	47.2	1.71886120996441	161	85	85.9	0	504	22	1	161	WP_121723575.1 MULTISPECIES: FMN-binding negative transcriptional regulator [Corallococcus]	diamond	966	172	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus
29950698	29950698	PRJNA498309_P_NODE_42131_length_423_cov_1.341969_g40016_i0	PRJNA498309	42131	423	1.341969	5.67652887	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	57.8	1.29e-6	NR	HWP05252.1	2268199	g40016	i0	86.7	0.673758865248227	30	4	21.3	0	331	420	3	32	HWP05252.1 glycosyltransferase [Polyangiaceae bacterium]	diamond	285	57.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
30582359	30582359	PRJNA498309_P_NODE_77873_length_257_cov_4.595455_g75724_i0	PRJNA498309	77873	257	4.595455	11.81031935	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	83.2	2.21e-17	NR	HEX4514982.1	2268199	g75724	i0	50	1.96108949416342	84	42	98.1	0	3	254	54	137	HEX4514982.1 histidine phosphatase family protein [Polyangiaceae bacterium]	diamond	504	83.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
32005330	32005330	PRJNA498309_P_NODE_71298_length_281_cov_1.721311_g69149_i0	PRJNA498309	71298	281	1.721311	4.83688391	Myxococcota bacterium	2818507	Bacteria	Bacteria	61.6	1.3e-8	NR	MEM9459086.1	2818507	g69149	i0	44.7	0.811387900355872	76	41	81.1	1	21	248	352	426	MEM9459086.1 right-handed parallel beta-helix repeat-containing protein [Myxococcota bacterium]	diamond	228	61.6	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
32652881	32652881	PRJNA498309_P_NODE_45540_length_402_cov_2.558904_g43408_i0	PRJNA498309	45540	402	2.558904	10.28679408	Bacteria candidate phyla	1783234	Bacteria	Bacteria	134	7.59e-35	NR	MCY4488154.1	2026735	g43408	i0	53	15.7462686567164	115	53	85.8	1	365	21	16	129	MCY4488154.1 cupin domain-containing protein [Deltaproteobacteria bacterium]	diamond	6330	134	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);;