metadata: contig_metadata: 16 rows where bioproject = "PRJNA812001", tax_phylum = "Myxococcota" and tax

16 rows where bioproject = "PRJNA812001", tax_phylum = "Myxococcota" and tax_superkingdom = "Bacteria"

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
810224	810224	PRJNA812001_P_NODE_10641_length_482_cov_12.841076_g10395_i0	PRJNA812001	10641	482	12.841076	61.89398632	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	101	1.34e-22	NR	HRG98789.1	2268199	g10395	i0	58.2	0.566390041493776	91	37	56.6	1	206	478	82	171	HRG98789.1 hypothetical protein [Polyangiaceae bacterium]	diamond	273	101	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
11428259	11428259	PRJNA812001_P_NODE_42969_length_303_cov_1.830435_g42723_i0	PRJNA812001	42969	303	1.830435	5.54621805	Polyangiaceae	49	Bacteria	Bacteria	313	1.17e-80	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g42723	i0	86.879	124.442244224422	282	33	92	4	1	280	1736	2015	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	37706	313	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
16113495	16113495	PRJNA812001_P_NODE_7893_length_552_cov_1.557411_g7648_i0	PRJNA812001	7893	552	1.557411	8.59690872	Cystobacter fuscus	43	Bacteria	Bacteria	322	3.75e-83	NTclustered	gi\|2579656172\|gb\|CP043491.1\|	43	g7648	i0	77.716	54.0090579710145	543	110	97	11	1	537	9696015	9695478	Cystobacter fuscus strain Cbf 10 chromosome, complete genome	blastn	29813	322	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
18662586	18662586	PRJNA812001_P_NODE_99735_length_247_cov_0.885057_g99489_i0	PRJNA812001	99735	247	0.885057	2.18609079	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	141	2.86e-39	NR	HEX4517286.1	2268199	g99489	i0	84	2.95141700404858	81	13	98.4	0	2	244	212	292	HEX4517286.1 DNA-formamidopyrimidine glycosylase family protein [Polyangiaceae bacterium]	diamond	729	141	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
25036912	25036912	PRJNA812001_P_NODE_22660_length_364_cov_3.109966_g22414_i0	PRJNA812001	22660	364	3.109966	11.32027624	Pseudomonadati	3379134	Bacteria	Bacteria	172	2.81e-49	NR	AYM52646.1	2022431	g22414	i0	71.4	5.52197802197802	112	32	92.3	0	9	344	15	126	AYM52646.1 FMN oxidoreductase [Aetherobacter sp.]	diamond	2010	172	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Aetherobacter	Aetherobacter sp.
25037336	25037336	PRJNA812001_P_NODE_6880_length_591_cov_1.594595_g6636_i0	PRJNA812001	6880	591	1.594595	9.42405645	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	277	1.83e-84	NR	MCS6901027.1	2268199	g6636	i0	71.6	0.928934010152284	183	52	92.9	0	589	41	660	842	MCS6901027.1 leucine--tRNA ligase [Polyangiaceae bacterium]	diamond	549	277	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
30307546	30307546	PRJNA812001_P_NODE_35632_length_320_cov_1.356275_g35386_i0	PRJNA812001	35632	320	1.356275	4.34008	Polyangia bacterium	3058050	Bacteria	Bacteria	152	1.6399999999999996e-43	NR	HZS40194.1	3058050	g35386	i0	70.1	1.003125	107	29	98.4	2	319	5	102	207	HZS40194.1 hypothetical protein [Polyangia bacterium]	diamond	321	152	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
30496742	30496742	PRJNA812001_P_NODE_135493_length_240_cov_3.425150_g135247_i0	PRJNA812001	135493	240	3.42515	8.22036	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	80.5	7.74e-17	NR	HSQ63318.1	2268199	g135247	i0	52.1	0.9125	73	34	90	1	239	24	82	154	HSQ63318.1 hypothetical protein [Polyangiaceae bacterium]	diamond	219	80.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
30686053	30686053	PRJNA812001_P_NODE_5613_length_654_cov_3.182444_g5375_i0	PRJNA812001	5613	654	3.182444	20.81318376	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	223	2.1499999999999998e-67	NR	HEX7600614.1	2268199	g5375	i0	56.7	0.954128440366973	208	86	94.5	3	5	622	117	322	HEX7600614.1 acyltransferase family protein [Polyangiaceae bacterium]	diamond	624	223	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
30875746	30875746	PRJNA812001_P_NODE_12894_length_445_cov_1.680108_g12648_i0	PRJNA812001	12894	445	1.680108	7.4764806	Polyangia bacterium	3058050	Bacteria	Bacteria	95.5	1.28e-20	NR	HEX4458895.1	3058050	g12648	i0	49.5	0.667415730337079	99	44	62.7	2	159	437	4	102	HEX4458895.1 hypothetical protein [Polyangia bacterium]	diamond	297	95.5	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
31318185	31318185	PRJNA812001_P_NODE_53615_length_284_cov_1.426540_g53369_i0	PRJNA812001	53615	284	1.42654	4.0513736	Myxococcales bacterium	2026763	Bacteria	Bacteria	112	1.93e-26	NR	MBK7402913.1	2026763	g53369	i0	51	1.01408450704225	96	45	99.3	1	283	2	542	637	MBK7402913.1 WD40 repeat domain-containing protein [Myxococcales bacterium]	diamond	288	112	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
32054505	32054505	PRJNA812001_P_NODE_100778_length_247_cov_0.885057_g100532_i0	PRJNA812001	100778	247	0.885057	2.18609079	Bacteria	2	Bacteria	Bacteria	58.2	7.77e-8	NR	HXK16573.1	2268199	g100532	i0	73.7	3.24291497975709	38	10	46.2	0	115	2	1	38	HXK16573.1 hypothetical protein [Polyangiaceae bacterium]	diamond	801	58.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
32077398	32077398	PRJNA812001_P_NODE_62398_length_272_cov_1.276382_g62152_i0	PRJNA812001	62398	272	1.276382	3.47175904	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	64.3	2.45e-10	NR	HEX7601725.1	2268199	g62152	i0	49.3	0.827205882352941	75	35	82.7	1	254	30	1	72	HEX7601725.1 hypothetical protein [Polyangiaceae bacterium]	diamond	225	64.3	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
32592439	32592439	PRJNA812001_P_NODE_123739_length_243_cov_0.905882_g123493_i0	PRJNA812001	123739	243	0.905882	2.20129326	Polyangiales	3031712	Bacteria	Bacteria	140	2.29e-41	NR	WP_146647385.1	1391654	g123493	i0	86.8	3.75308641975309	76	10	93.8	0	230	3	3	78	WP_146647385.1 SCP2 sterol-binding domain-containing protein [Labilithrix luteola]	diamond	912	140	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
32835375	32835375	PRJNA812001_P_NODE_44360_length_300_cov_2.211454_g44114_i0	PRJNA812001	44360	300	2.211454	6.634362	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	58.2	2.77e-7	NR	MBK9259551.1	2268199	g44114	i0	52.7	1.1	55	26	55	0	3	167	689	743	MBK9259551.1 hypothetical protein [Polyangiaceae bacterium]	diamond	330	58.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
32835379	32835379	PRJNA812001_P_NODE_73100_length_258_cov_0.854054_g72854_i0	PRJNA812001	73100	258	0.854054	2.20345932	Archangium sp.	1872627	Bacteria	Bacteria	80.5	7.65e-16	NR	WP_309895088.1	1872627	g72854	i0	53.5	2.31395348837209	71	29	77.9	2	205	5	202	272	WP_309895088.1 hypothetical protein [Archangium sp.]	diamond	597	80.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium sp.

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