metadata: contig_metadata: 24 rows where bioproject = "PRJNA488043" and tax

24 rows where bioproject = "PRJNA488043" 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
5553424	5553424	PRJNA488043_P_NODE_18745_length_184_cov_3.916129_g16503_i0	PRJNA488043	18745	184	3.916129	7.20567736	Labilithrix luteola	1391654	Bacteria	Bacteria	246	6.71e-61	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g16503	i0	91.16	194.619565217391	181	16	98	0	1	181	3943876	3944056	Labilithrix luteola strain DSM 27648, complete genome	blastn	35810	246	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
11301283	11301283	PRJNA488043_P_NODE_8389_length_397_cov_199.040761_g6185_i0	PRJNA488043	8389	397	199.040761	790.19182117	Pendulispora	3375062	Bacteria	Bacteria	459	1.9199999999999997e-124	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g6185	i0	89.16	117.128463476071	369	38	93	2	30	397	7289859	7289492	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	46500	459	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
11301308	11301308	PRJNA488043_S_NODE_569_length_247_cov_6.958716_g558_i0	PRJNA488043	569	247	6.958716	17.18802852	Myxococcaceae	31	Bacteria	Bacteria	165	2.75e-36	NTclustered	gi\|470488931\|ref\|NR_076895.1\|	33	g558	i0	85.987	165.914979757085	157	19	63	2	1	156	1352	1506	Myxococcus fulvus strain HW-1 23S ribosomal RNA gene, complete sequence	blastn	40981	165	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
19575732	19575732	PRJNA488043_P_NODE_4856_length_610_cov_4.137694_g2977_i0	PRJNA488043	4856	610	4.137694	25.2399334	Pendulispora albinea	2741071	Bacteria	Bacteria	845	0	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g2977	i0	91.694	130.618032786885	614	44	100	6	1	610	3589480	3588870	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	79677	845	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
22126356	22126356	PRJNA488043_P_NODE_21318_length_160_cov_1.587786_g19076_i0	PRJNA488043	21318	160	1.587786	2.5404576	Myxococcales bacterium	2026763	Bacteria	Bacteria	98.6	1.22e-22	NR	MBL0198546.1	2026763	g19076	i0	88.7	0.99375	53	6	99.4	0	160	2	7	59	MBL0198546.1 hypothetical protein [Myxococcales bacterium]	diamond	159	98.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
22126484	22126484	PRJNA488043_S_NODE_1518_length_157_cov_6.039062_g1507_i0	PRJNA488043	1518	157	6.039062	9.48132734	Chondromyces crocatus	52	Bacteria	Bacteria	200	4.369999999999999e-47	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g1507	i0	89.744	98.3630573248408	156	16	99	0	1	156	1569	1414	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	15443	200	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
26696387	26696387	PRJNA488043_P_NODE_18501_length_187_cov_1.905063_g16259_i0	PRJNA488043	18501	187	1.905063	3.56246781	Myxococcales bacterium	2026763	Bacteria	Bacteria	85.5	1.69e-19	NR	MBL0220001.1	2026763	g16259	i0	83.3	0.770053475935829	48	8	77	0	186	43	83	130	MBL0220001.1 hypothetical protein [Myxococcales bacterium]	diamond	144	85.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
26759699	26759699	PRJNA488043_P_NODE_6501_length_496_cov_1.974304_g4436_i0	PRJNA488043	6501	496	1.974304	9.79254784	Nannocystaceae bacterium	2545255	Bacteria	Bacteria	59.7	2.18e-7	NR	MEE9382825.1	2545255	g4436	i0	56.9	0.86491935483871	51	19	29	1	27	170	136	186	MEE9382825.1 ASCH domain-containing protein [Nannocystaceae bacterium]	diamond	429	59.7	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae		Nannocystaceae bacterium
26791596	26791596	PRJNA488043_P_NODE_18801_length_184_cov_1.709677_g16559_i0	PRJNA488043	18801	184	1.709677	3.14580568	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	94.7	1.23e-22	NR	HQY59798.1	2268199	g16559	i0	73.3	0.978260869565217	60	16	97.8	0	182	3	61	120	HQY59798.1 hypothetical protein [Polyangiaceae bacterium]	diamond	180	94.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
26823330	26823330	PRJNA488043_P_NODE_8741_length_383_cov_2.079096_g6524_i0	PRJNA488043	8741	383	2.079096	7.96293768	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	57.8	9.36e-7	NR	MDF3069182.1	2268199	g6524	i0	28.3	0.939947780678851	120	79	90.9	2	10	357	122	238	MDF3069182.1 hypothetical protein [Polyangiaceae bacterium]	diamond	360	57.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
27044742	27044742	PRJNA488043_P_NODE_4902_length_607_cov_2.065744_g3015_i0	PRJNA488043	4902	607	2.065744	12.53906608	Myxococcales bacterium	2026763	Bacteria	Bacteria	239	4.13e-76	NR	MBL0198569.1	2026763	g3015	i0	74.5	1.59143327841845	161	37	77.6	1	471	1	18	178	MBL0198569.1 PD-(D/E)XK nuclease family protein [Myxococcales bacterium]	diamond	966	239	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
27266047	27266047	PRJNA488043_P_NODE_21203_length_161_cov_1.409091_g18961_i0	PRJNA488043	21203	161	1.409091	2.26863651	Polyangiales bacterium	3034171	Bacteria	Bacteria	62.8	8.66e-10	NR	MEZ4391981.1	3034171	g18961	i0	70.2	0.875776397515528	47	14	87.6	0	20	160	1	47	MEZ4391981.1 hypothetical protein [Polyangiales bacterium]	diamond	141	62.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales			Polyangiales bacterium
27929218	27929218	PRJNA488043_P_NODE_12885_length_263_cov_2.974359_g10644_i0	PRJNA488043	12885	263	2.974359	7.82256417	Polyangia bacterium	3058050	Bacteria	Bacteria	65.1	7.35e-11	NR	MFO0578713.1	3058050	g10644	i0	43.9	0.935361216730038	82	46	93.5	0	253	8	53	134	MFO0578713.1 hypothetical protein [Polyangia bacterium]	diamond	246	65.1	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
28402803	28402803	PRJNA488043_P_NODE_5866_length_534_cov_1.661386_g3870_i0	PRJNA488043	5866	534	1.661386	8.87180124	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	87.8	1.12e-16	NR	HPH70271.1	2212474	g3870	i0	32.5	1.10674157303371	197	95	89.3	3	529	53	237	433	HPH70271.1 hypothetical protein [Kofleriaceae bacterium]	diamond	591	87.8	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
28971143	28971143	PRJNA488043_P_NODE_21768_length_156_cov_2.070866_g19526_i0	PRJNA488043	21768	156	2.070866	3.23055096	Myxococcales bacterium	2026763	Bacteria	Bacteria	49.7	4.73e-6	NR	MBK6463560.1	2026763	g19526	i0	69	0.557692307692308	29	9	55.8	0	155	69	62	90	MBK6463560.1 hypothetical protein [Myxococcales bacterium]	diamond	87	49.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
29397617	29397617	PRJNA488043_P_NODE_6069_length_521_cov_2.004065_g4043_i0	PRJNA488043	6069	521	2.004065	10.44117865	root	1	Root_unresolved	Root_unresolved	63.2	1.05e-8	NR	MBU6163091.1	2026763	g4043	i0	45.9	1.09404990403071	98	49	56.4	2	296	3	78	171	MBU6163091.1 hypothetical protein [Myxococcales bacterium]	diamond	570	63.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
29665366	29665366	PRJNA488043_P_NODE_21270_length_160_cov_2.274809_g19028_i0	PRJNA488043	21270	160	2.274809	3.6396944	Myxococcales bacterium	2026763	Bacteria	Bacteria	88.2	1.01e-20	NR	MBL0220001.1	2026763	g19028	i0	86.3	0.95625	51	7	95.6	0	1	153	17	67	MBL0220001.1 hypothetical protein [Myxococcales bacterium]	diamond	153	88.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
29665371	29665371	PRJNA488043_P_NODE_6350_length_505_cov_2.397059_g4302_i0	PRJNA488043	6350	505	2.397059	12.10514795	Polyangia bacterium	3058050	Bacteria	Bacteria	135	5.679999999999999e-37	NR	MFO0578693.1	3058050	g4302	i0	48.1	1.74653465346535	156	78	92.1	2	38	502	1	154	MFO0578693.1 hypothetical protein [Polyangia bacterium]	diamond	882	135	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
29886922	29886922	PRJNA488043_P_NODE_7871_length_421_cov_2.441327_g5689_i0	PRJNA488043	7871	421	2.441327	10.27798667	Polyangia bacterium	3058050	Bacteria	Bacteria	118	4.76e-28	NR	MFO0578686.1	3058050	g5689	i0	46.8	0.990498812351544	139	73	98.3	1	419	6	329	467	MFO0578686.1 DUF935 family protein [Polyangia bacterium]	diamond	417	118	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
30455846	30455846	PRJNA488043_P_NODE_18053_length_191_cov_2.450617_g15811_i0	PRJNA488043	18053	191	2.450617	4.68067847	Polyangia bacterium	3058050	Bacteria	Bacteria	51.6	6.45e-6	NR	MFO0578675.1	3058050	g15811	i0	46.2	1.02094240837696	65	30	94.2	2	190	11	81	145	MFO0578675.1 hypothetical protein [Polyangia bacterium]	diamond	195	51.6	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
30455857	30455857	PRJNA488043_P_NODE_6553_length_492_cov_2.622030_g4480_i0	PRJNA488043	6553	492	2.62203	12.9003876	Polyangia bacterium	3058050	Bacteria	Bacteria	109	8.01e-25	NR	MFO0578695.1	3058050	g4480	i0	47.5	0.719512195121951	118	62	72	0	1	354	283	400	MFO0578695.1 phage protein Gp37 [Polyangia bacterium]	diamond	354	109	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
31213346	31213346	PRJNA488043_P_NODE_18575_length_186_cov_2.458599_g16333_i0	PRJNA488043	18575	186	2.458599	4.57299414	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	114	9e-31	NR	HPH68572.1	2212474	g16333	i0	90.2	0.983870967741935	61	6	98.4	0	185	3	86	146	HPH68572.1 hypothetical protein [Kofleriaceae bacterium]	diamond	183	114	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
32511151	32511151	PRJNA488043_P_NODE_20939_length_163_cov_1.835821_g18697_i0	PRJNA488043	20939	163	1.835821	2.99238823	Myxococcales bacterium	2026763	Bacteria	Bacteria	105	9.82e-26	NR	MBL0197628.1	2026763	g18697	i0	100	0.993865030674847	54	0	99.4	0	2	163	107	160	MBL0197628.1 Mu-like prophage major head subunit gpT family protein [Myxococcales bacterium]	diamond	162	105	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32762961	32762961	PRJNA488043_P_NODE_8940_length_376_cov_2.184438_g6720_i0	PRJNA488043	8940	376	2.184438	8.21348688	Nannocystaceae bacterium	2545255	Bacteria	Bacteria	59.7	7.44e-8	NR	MEE9382825.1	2545255	g6720	i0	56.9	1.71542553191489	51	19	38.3	1	27	170	136	186	MEE9382825.1 ASCH domain-containing protein [Nannocystaceae bacterium]	diamond	645	59.7	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae		Nannocystaceae 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);;