metadata: contig_metadata: 20 rows where bioproject = "PRJNA492363", tax_kingdom = "Pseudomonadati" and tax

20 rows where bioproject = "PRJNA492363", 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
25567341	25567341	PRJNA492363_S_NODE_97017_length_203_cov_0.901408_g96196_i0	PRJNA492363	97017	203	0.901408	1.82985824	Anaeromyxobacter sp. Fw1	1872521	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|152026452\|gb\|CP000769.1\|	404589	g96196	i0	100	0.137931034482759	28	0	14	0	115	142	4005725	4005698	Anaeromyxobacter sp. Fw109-5, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
25761184	25761184	PRJNA492363_S_NODE_10778_length_294_cov_3.605150_g9957_i0	PRJNA492363	10778	294	3.60515	10.599141	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	96.3	1.06e-20	NR	MBW2185913.1	2026735	g9957	i0	58	0.826530612244898	81	34	82.7	0	250	8	266	346	MBW2185913.1 DEAD/DEAH box helicase family protein [Deltaproteobacteria bacterium]	diamond	243	96.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
25838396	25838396	PRJNA492363_S_NODE_291_length_26721_cov_34.699812_g23_i17	PRJNA492363	291	26721	34.699812	9272.13676452	Cystobacter fuscus	43	Bacteria	Bacteria	2183	0	NR	WP_395850126.1	43	g23	i17	57	0.234646906927136	2090	868	23.3	16	19581	13354	6	2079	WP_395850126.1 AAA domain-containing protein [Cystobacter fuscus]	diamond	6270	2183	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
25839121	25839121	PRJNA492363_S_NODE_77827_length_217_cov_2.051282_g77006_i0	PRJNA492363	77827	217	2.051282	4.45128194	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	93.6	5.050000000000001e-21	NR	HSY20712.1	2268199	g77006	i0	67.2	0.80184331797235	58	19	80.2	0	43	216	124	181	HSY20712.1 hypothetical protein [Polyangiaceae bacterium]	diamond	174	93.6	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
25974160	25974160	PRJNA492363_S_NODE_118716_length_182_cov_4.206612_g117895_i0	PRJNA492363	118716	182	4.206612	7.65603384	Pendulispora albinea	2741071	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g117895	i0	100	0.164835164835165	30	0	16	0	3	32	6904058	6904087	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
26110394	26110394	PRJNA492363_S_NODE_14845_length_260_cov_1.286432_g14024_i0	PRJNA492363	14845	260	1.286432	3.3447232	Sorangium aterium	2995308	Bacteria	Bacteria	105	1.35e-25	NR	WP_272095245.1	2995308	g14024	i0	72.4	0.876923076923077	76	21	87.7	0	3	230	90	165	WP_272095245.1 SDR family oxidoreductase [Sorangium aterium]	diamond	228	105	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium atrum
26111321	26111321	PRJNA492363_S_NODE_75845_length_219_cov_1.778481_g75024_i0	PRJNA492363	75845	219	1.778481	3.89487339	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	95.5	4.17e-22	NR	MEZ4441985.1	2268199	g75024	i0	76.3	2.42465753424658	59	14	80.8	0	180	4	70	128	MEZ4441985.1 response regulator transcription factor [Polyangiaceae bacterium]	diamond	531	95.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
26382040	26382040	PRJNA492363_S_NODE_10719_length_295_cov_2.119658_g9898_i0	PRJNA492363	10719	295	2.119658	6.2529911	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	157	1.89e-44	NR	MEO8530427.1	2026735	g9898	i0	88.2	6.03050847457627	85	10	86.4	0	39	293	19	103	MEO8530427.1 efflux RND transporter permease subunit [Deltaproteobacteria bacterium]	diamond	1779	157	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
26382542	26382542	PRJNA492363_S_NODE_22263_length_246_cov_0.897297_g21442_i0	PRJNA492363	22263	246	0.897297	2.20735062	Archangium violaceum	83451	Bacteria	Bacteria	239	1.59e-58	NTclustered	gi\|2619762464\|gb\|CP137851.1\|	83451	g21442	i0	88.442	61.8170731707317	199	21	80	2	1	197	2939685	2939883	Archangium violaceum strain KYC5002 chromosome, complete genome	blastn	15207	239	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
26383908	26383908	PRJNA492363_S_NODE_98983_length_202_cov_0.907801_g98162_i0	PRJNA492363	98983	202	0.907801	1.83375802	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	69.4	1.75e-7	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g98162	i0	93.478	1.18316831683168	46	3	23	0	38	83	240106	240061	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	239	69.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
32935324	32935324	PRJNA492363_S_NODE_80673_length_213_cov_1.013158_g79852_i0	PRJNA492363	80673	213	1.013158	2.15802654	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	86.3	1.68e-18	NR	RYF11695.1	2026735	g79852	i0	62.3	2.91549295774648	69	26	97.2	0	207	1	48	116	RYF11695.1 MAG: conjugal transfer protein TraG, partial [Deltaproteobacteria bacterium]	diamond	621	86.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
32952504	32952504	PRJNA492363_S_NODE_29874_length_241_cov_1.655556_g29053_i0	PRJNA492363	29874	241	1.655556	3.98988996	Polyangia bacterium	3058050	Bacteria	Bacteria	110	3.5100000000000004e-26	NR	HEX2659345.1	3058050	g29053	i0	74.7	0.983402489626556	79	20	98.3	0	239	3	205	283	HEX2659345.1 ATP-binding protein [Polyangia bacterium]	diamond	237	110	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
32958570	32958570	PRJNA492363_S_NODE_36946_length_238_cov_1.446328_g36125_i0	PRJNA492363	36946	238	1.446328	3.44226064	Pseudomonadati	3379134	Bacteria	Bacteria	56.2	6.2e-7	NR	HAC79009.1	2026735	g36125	i0	38.5	3.95798319327731	78	48	98.3	0	4	237	488	565	HAC79009.1 selenide, water dikinase SelD [Deltaproteobacteria bacterium]	diamond	942	56.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
33020786	33020786	PRJNA492363_S_NODE_97060_length_203_cov_0.901408_g96239_i0	PRJNA492363	97060	203	0.901408	1.82985824	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	102	3.0099999999999997e-25	NR	MCO6429828.1	2026735	g96239	i0	71.6	0.990147783251232	67	19	99	0	203	3	76	142	MCO6429828.1 hypothetical protein [Deltaproteobacteria bacterium]	diamond	201	102	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
33060779	33060779	PRJNA492363_S_NODE_71797_length_222_cov_1.192547_g70976_i0	PRJNA492363	71797	222	1.192547	2.64745434	Bacteria	2	Bacteria	Bacteria	130	8.67e-34	NR	MBM4342416.1	2026735	g70976	i0	78.1	5.94594594594595	73	16	98.6	0	222	4	22	94	MBM4342416.1 urate hydroxylase PuuD [Deltaproteobacteria bacterium]	diamond	1320	130	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
33089012	33089012	PRJNA492363_S_NODE_76886_length_218_cov_1.847134_g76065_i0	PRJNA492363	76886	218	1.847134	4.02675212	unclassified Myxococcus	2648731	Bacteria	Bacteria	54.3	2.26e-6	NR	WP_223748907.1	2648731	g76065	i0	41.7	0.990825688073395	72	40	99.1	1	218	3	179	248	WP_223748907.1 MULTISPECIES: SBBP repeat-containing protein [unclassified Myxococcus]	diamond	216	54.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus
33089049	33089049	PRJNA492363_S_NODE_86190_length_209_cov_0.864865_g85369_i0	PRJNA492363	86190	209	0.864865	1.80756785	Kofleriaceae bacterium	2212474	Bacteria	Bacteria	144	5.93e-42	NR	HPH70612.1	2212474	g85369	i0	97.1	0.976076555023923	68	2	97.6	0	6	209	1	68	HPH70612.1 hypothetical protein [Kofleriaceae bacterium]	diamond	204	144	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae		Kofleriaceae bacterium
33089092	33089092	PRJNA492363_S_NODE_95054_length_204_cov_1.342657_g94233_i0	PRJNA492363	95054	204	1.342657	2.73902028	Myxococcales bacterium	2026763	Bacteria	Bacteria	57	2.03e-7	NR	MBL8976201.1	2026763	g94233	i0	44.4	1.05882352941176	72	31	92.6	1	194	6	386	457	MBL8976201.1 bifunctional 3-(3-hydroxy-phenyl)propionate/3-hydroxycinnamic acid hydroxylase [Myxococcales bacterium]	diamond	216	57	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
33129163	33129163	PRJNA492363_S_NODE_79223_length_215_cov_1.896104_g78402_i0	PRJNA492363	79223	215	1.896104	4.0766236	Pseudomonadati	3379134	Bacteria	Bacteria	74.7	4.2e-14	NR	MBS2021741.1	2026735	g78402	i0	78.3	1.93953488372093	46	10	64.2	0	50	187	27	72	MBS2021741.1 site-specific DNA-methyltransferase [Deltaproteobacteria bacterium]	diamond	417	75.1	0.994673768308922	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
33140150	33140150	PRJNA492363_S_NODE_87887_length_208_cov_1.306122_g87066_i0	PRJNA492363	87887	208	1.306122	2.71673376	Vulgatibacter sp.	1971226	Bacteria	Bacteria	73.9	2.43e-13	NR	HWV38858.1	1971226	g87066	i0	76.7	1.88942307692308	43	10	62	0	70	198	1632	1674	HWV38858.1 hypothetical protein [Vulgatibacter sp.]	diamond	393	73.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Vulgatibacteraceae	Vulgatibacter	Vulgatibacter 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);;