metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA493828" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA493828" 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
3025395	3025395	PRJNA493828_P_NODE_16683_length_306_cov_4.879828_g16264_i0	PRJNA493828	16683	306	4.879828	14.93227368	Archangium violaceum	83451	Bacteria	Bacteria	333	9.1e-87	NTclustered	gi\|2579675135\|gb\|CP043493.1\|	83451	g16264	i0	87.205	190.212418300654	297	32	96	2	1	295	5180818	5181110	Archangium violaceum strain Cbvi 34 chromosome, complete genome	blastn	58205	333	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
4301706	4301706	PRJNA493828_P_NODE_37084_length_244_cov_1.619883_g36665_i0	PRJNA493828	37084	244	1.619883	3.95251452	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	396	8.829999999999997e-106	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g36665	i0	95.902	224.827868852459	244	10	100	0	1	244	2160609	2160852	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	54858	396	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
8127773	8127773	PRJNA493828_P_NODE_29787_length_256_cov_4.710383_g29368_i0	PRJNA493828	29787	256	4.710383	12.05858048	Myxococcales bacterium	2026763	Bacteria	Bacteria	335	2.0599999999999993e-87	NTclustered	gi\|1958041644\|gb\|CP064980.1\|	2026763	g29368	i0	90.272	135.7734375	257	24	100	1	1	256	1308248	1308504	Myxococcales bacterium isolate Fred_18-Q3-R57-64_BAT3C.417 chromosome	blastn	34758	335	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
10035012	10035012	PRJNA493828_P_NODE_29168_length_258_cov_2.329730_g28749_i0	PRJNA493828	29168	258	2.32973	6.0107034	Haliangium	162027	Bacteria	Bacteria	327	3.48e-85	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g28749	i0	89.535	44.7519379844961	258	27	100	0	1	258	234	491	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	11546	327	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
11953257	11953257	PRJNA493828_P_NODE_18170_length_295_cov_3.427928_g17751_i0	PRJNA493828	18170	295	3.427928	10.1123876	Myxococcales bacterium	2026763	Bacteria	Bacteria	209	1.54e-49	NTclustered	gi\|1958041644\|gb\|CP064980.1\|	2026763	g17751	i0	79.661	111.345762711864	295	56	99	4	3	295	1307913	1308205	Myxococcales bacterium isolate Fred_18-Q3-R57-64_BAT3C.417 chromosome	blastn	32847	209	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
13228610	13228610	PRJNA493828_P_NODE_33971_length_248_cov_2.548571_g33552_i0	PRJNA493828	33971	248	2.548571	6.32045608	Corallococcus macrosporus	35	Bacteria	Bacteria	272	1.5799999999999996e-68	NTclustered	gi\|1243045502\|gb\|CP022203.1\|	1189310	g33552	i0	86.64	17.5483870967742	247	31	99	2	3	248	5793102	5793347	Corallococcus macrosporus DSM 14697 chromosome, complete genome	blastn	4352	272	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus macrosporus
13860247	13860247	PRJNA493828_P_NODE_38651_length_242_cov_1.680473_g38232_i0	PRJNA493828	38651	242	1.680473	4.06674466	Archangium	47	Bacteria	Bacteria	302	1.96e-77	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g38232	i0	90.708	267.090909090909	226	21	93	0	1	226	107211	106986	Archangium gephyra strain DSM 2261, complete genome	blastn	64636	302	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
14503315	14503315	PRJNA493828_P_NODE_19532_length_289_cov_1.916667_g19113_i0	PRJNA493828	19532	289	1.916667	5.53916763	Nannocystis punicea	2995304	Bacteria	Bacteria	396	1.0699999999999997e-105	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g19113	i0	91.409	160.141868512111	291	22	100	3	1	289	7595998	7596287	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	46281	396	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
16409338	16409338	PRJNA493828_P_NODE_44513_length_223_cov_5.260000_g44094_i0	PRJNA493828	44513	223	5.26	11.7298	Nannocystis	53	Bacteria	Bacteria	255	1.41e-63	NTclustered	gi\|2244669\|emb\|X87286.1\|	54	g44094	i0	88.318	183.201793721973	214	24	96	1	1	213	20	233	N.exedens 23S rRNA gene	blastn	40854	255	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
17051969	17051969	PRJNA493828_P_NODE_25014_length_270_cov_3.659898_g24595_i0	PRJNA493828	25014	270	3.659898	9.8817246	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	383	7.73e-102	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g24595	i0	92.222	192.962962962963	270	21	100	0	1	270	9676406	9676675	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	52100	383	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
18326219	18326219	PRJNA493828_P_NODE_19115_length_291_cov_1.412844_g18696_i0	PRJNA493828	19115	291	1.412844	4.11137604	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	250	8.909999999999999e-62	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g18696	i0	85.039	59.1786941580756	254	28	86	10	38	286	2090651	2090403	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	17221	250	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
20232844	20232844	PRJNA493828_P_NODE_18296_length_294_cov_4.977376_g17877_i0	PRJNA493828	18296	294	4.977376	14.63348544	Myxococcales	29	Bacteria	Bacteria	516	8.05e-142	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g17877	i0	98.625	296.316326530612	291	4	99	0	1	291	4450774	4450484	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	87117	521	0.990403071017274	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
22151115	22151115	PRJNA493828_P_NODE_19538_length_289_cov_1.888889_g19119_i0	PRJNA493828	19538	289	1.888889	5.45888921	Chondromyces crocatus	52	Bacteria	Bacteria	278	4.0500000000000005e-70	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g19119	i0	85.502	92.4429065743945	269	35	94	4	21	285	1431123	1430855	Chondromyces crocatus strain Cm c5, complete genome	blastn	26716	278	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
22151464	22151464	PRJNA493828_P_NODE_42058_length_233_cov_2.750000_g41639_i0	PRJNA493828	42058	233	2.75	6.4075	Nannocystis sp.	1962667	Bacteria	Bacteria	331	2.39e-86	NTclustered	gi\|1386873111\|gb\|MF774778.1\|	1962667	g41639	i0	92.982	84.5836909871245	228	15	97	1	1	227	597	370	Nannocystis sp. strain MNa11734 23S ribosomal RNA gene, partial sequence	blastn	19708	331	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis sp.
23427310	23427310	PRJNA493828_P_NODE_40559_length_238_cov_4.606061_g40140_i0	PRJNA493828	40559	238	4.606061	10.96242518	Archangium violaceum	83451	Bacteria	Bacteria	357	4.0499999999999996e-94	NTclustered	gi\|2579675135\|gb\|CP043493.1\|	83451	g40140	i0	93.697	237.260504201681	238	15	100	0	1	238	5179992	5180229	Archangium violaceum strain Cbvi 34 chromosome, complete genome	blastn	56468	357	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
24700387	24700387	PRJNA493828_P_NODE_11440_length_341_cov_1.929104_g11021_i0	PRJNA493828	11440	341	1.929104	6.57824464	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	468	2.7e-127	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g11021	i0	92.145	218.061583577713	331	26	97	0	1	331	9678393	9678723	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	74359	468	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus

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