metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA635874" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA635874" 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
1883168	1883168	PRJNA635874_P_NODE_20882_length_347_cov_1.124088_g20735_i0	PRJNA635874	20882	347	1.124088	3.90058536	Sorangium cellulosum	56	Bacteria	Bacteria	176	1.87e-39	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g20735	i0	80.169	2.40634005763689	237	45	68	2	1	236	7932642	7932407	Sorangium cellulosum 'So ce 56' complete genome	blastn	835	176	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
1884368	1884368	PRJNA635874_P_NODE_67242_length_243_cov_0.905882_g67095_i0	PRJNA635874	67242	243	0.905882	2.20129326	Sorangium cellulosum	56	Bacteria	Bacteria	148	2.72e-31	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g67095	i0	78.226	35.2633744855967	248	42	99	12	1	242	9923432	9923673	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	8569	148	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
3157931	3157931	PRJNA635874_P_NODE_23303_length_333_cov_1.184615_g23156_i0	PRJNA635874	23303	333	1.184615	3.94476795	Nannocystis punicea	2995304	Bacteria	Bacteria	313	1.3e-80	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g23156	i0	86.254	82.5525525525526	291	37	87	3	21	310	5377277	5377565	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	27490	313	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
3158102	3158102	PRJNA635874_P_NODE_29703_length_304_cov_0.982684_g29556_i0	PRJNA635874	29703	304	0.982684	2.98735936	Myxococcus stipitatus	83455	Bacteria	Bacteria	418	2.4199999999999993e-112	NTclustered	gi\|2722781719\|gb\|CP102770.1\|	83455	g29556	i0	91.447	4	304	26	100	0	1	304	2027017	2027320	Myxococcus stipitatus strain YRE12 chromosome, complete genome	blastn	1216	418	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
4434918	4434918	PRJNA635874_P_NODE_29064_length_306_cov_1.321888_g28917_i0	PRJNA635874	29064	306	1.321888	4.04497728	Chondromyces crocatus	52	Bacteria	Bacteria	250	9.43e-62	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g28917	i0	81.494	81.6699346405229	308	53	100	3	1	306	4511603	4511298	Chondromyces crocatus strain Cm c5, complete genome	blastn	24991	250	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
5711958	5711958	PRJNA635874_P_NODE_72245_length_241_cov_0.916667_g72098_i0	PRJNA635874	72245	241	0.916667	2.20916747	Corallococcus exercitus	2316736	Bacteria	Bacteria	348	2.4700000000000004e-91	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g72098	i0	93.562	98.5850622406639	233	15	97	0	5	237	5721717	5721949	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	23759	348	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
6986036	6986036	PRJNA635874_P_NODE_40686_length_267_cov_1.190722_g40539_i0	PRJNA635874	40686	267	1.190722	3.17922774	Sorangium cellulosum	56	Bacteria	Bacteria	169	2.3299999999999997e-37	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g40539	i0	78.309	1.12734082397004	272	52	100	6	1	267	3295147	3294878	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	301	169	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
8807315	8807315	PRJNA635874_P_NODE_30367_length_301_cov_1.346491_g30220_i0	PRJNA635874	30367	301	1.346491	4.05293791	Myxococcus	32	Bacteria	Bacteria	248	3.3299999999999996e-61	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g30220	i0	82.414	60.6777408637874	290	45	95	5	4	290	5662399	5662113	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	18264	248	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
9535560	9535560	PRJNA635874_P_NODE_23548_length_332_cov_0.891892_g23401_i0	PRJNA635874	23548	332	0.891892	2.96108144	Sorangium cellulosum	56	Bacteria	Bacteria	237	8.04e-58	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g23401	i0	81.373	3.38253012048193	306	44	89	12	10	306	8328846	8328545	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	1123	237	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
14636059	14636059	PRJNA635874_P_NODE_27212_length_314_cov_1.867220_g27065_i0	PRJNA635874	27212	314	1.86722	5.8630708	Sorangium cellulosum	56	Bacteria	Bacteria	167	1.01e-36	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g27065	i0	77.817	0.904458598726115	284	53	89	10	1	279	12597074	12597352	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	284	167	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
14636971	14636971	PRJNA635874_P_NODE_61472_length_245_cov_0.895349_g61325_i0	PRJNA635874	61472	245	0.895349	2.19360505	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	189	1.62e-43	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g61325	i0	82.222	1.81632653061224	225	34	90	6	5	225	2715896	2715674	Anaeromyxobacter paludicola DNA, complete genome	blastn	445	189	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
15183255	15183255	PRJNA635874_P_NODE_73312_length_241_cov_0.916667_g73165_i0	PRJNA635874	73312	241	0.916667	2.20916747	Sorangium	39643	Bacteria	Bacteria	244	3.33e-60	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g73165	i0	86.344	15.1369294605809	227	27	93	4	17	241	5372381	5372605	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	3648	244	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
15910717	15910717	PRJNA635874_P_NODE_53793_length_248_cov_0.880000_g53646_i0	PRJNA635874	53793	248	0.88	2.1824	Corallococcus exercitus	2316736	Bacteria	Bacteria	348	2.55e-91	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g53646	i0	91.935	3.21774193548387	248	20	100	0	1	248	9127761	9127514	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	798	348	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
15911022	15911022	PRJNA635874_P_NODE_66893_length_243_cov_0.905882_g66746_i0	PRJNA635874	66893	243	0.905882	2.20129326	Archangium gephyra	48	Bacteria	Bacteria	161	3.4899999999999997e-35	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g66746	i0	80.769	1.62139917695473	208	38	85	2	1	207	9917049	9916843	Archangium gephyra strain DSM 2261, complete genome	blastn	394	161	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
15911046	15911046	PRJNA635874_P_NODE_68093_length_243_cov_0.905882_g67946_i0	PRJNA635874	68093	243	0.905882	2.20129326	Sorangium cellulosum	56	Bacteria	Bacteria	63.9	1.01e-5	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g67946	i0	82.192	0.300411522633745	73	13	30	0	31	103	4254764	4254692	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	73	63.9	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
17186017	17186017	PRJNA635874_P_NODE_62834_length_245_cov_0.895349_g62687_i0	PRJNA635874	62834	245	0.895349	2.19360505	Polyangium aurulentum	2567896	Bacteria	Bacteria	145	3.5499999999999996e-30	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g62687	i0	77.733	3.68163265306122	247	47	99	7	1	243	10911188	10910946	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	902	145	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
18459882	18459882	PRJNA635874_P_NODE_49055_length_250_cov_0.870056_g48908_i0	PRJNA635874	49055	250	0.870056	2.17514	Myxococcus sp. MH1	2982796	Bacteria	Bacteria	206	1.6399999999999998e-48	NTclustered	gi\|2321229309\|dbj\|AP026947.1\|	2982796	g48908	i0	81.673	5.38	251	42	99	3	1	249	8607195	8606947	Myxococcus sp. MH1 DNA, complete genome	blastn	1345	206	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus sp. MH1
19734440	19734440	PRJNA635874_P_NODE_49116_length_250_cov_0.870056_g48969_i0	PRJNA635874	49116	250	0.870056	2.17514	Archangium gephyra	48	Bacteria	Bacteria	209	1.27e-49	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g48969	i0	84.018	6.904	219	33	87	2	33	250	9053306	9053089	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	1726	209	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
21010151	21010151	PRJNA635874_P_NODE_48897_length_250_cov_0.870056_g48750_i0	PRJNA635874	48897	250	0.870056	2.17514	Pendulispora albinea	2741071	Bacteria	Bacteria	132	2.83e-26	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g48750	i0	83.803	2.036	142	19	56	4	77	216	1997169	1997030	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	509	132	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
21010391	21010391	PRJNA635874_P_NODE_59777_length_246_cov_0.890173_g59630_i0	PRJNA635874	59777	246	0.890173	2.18982558	Myxococcales bacterium	2026763	Bacteria	Bacteria	222	1.5999999999999996e-53	NTclustered	gi\|1958041644\|gb\|CP064980.1\|	2026763	g59630	i0	83.333	1	246	35	99	6	4	246	50510	50268	Myxococcales bacterium isolate Fred_18-Q3-R57-64_BAT3C.417 chromosome	blastn	246	222	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales 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);;