metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA432257" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA432257" 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
428972	428972	PRJNA432257_S_NODE_104441_length_172_cov_3.377778_g104060_i0	PRJNA432257	104441	172	3.377778	5.80977816	Polyangium aurulentum	2567896	Bacteria	Bacteria	119	1.4000000000000002e-22	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g104060	i0	82.27	0.819767441860465	141	22	81	3	13	151	3601479	3601340	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	141	119	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
429868	429868	PRJNA432257_S_NODE_54941_length_223_cov_3.091398_g54560_i0	PRJNA432257	54941	223	3.091398	6.89381754	Polyangium aurulentum	2567896	Bacteria	Bacteria	78.7	3.27e-10	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g54560	i0	91.379	1.62780269058296	58	3	26	2	2	58	11191341	11191397	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	363	78.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
1704639	1704639	PRJNA432257_S_NODE_49342_length_232_cov_10.133333_g48961_i0	PRJNA432257	49342	232	10.133333	23.50933256	Polyangium aurulentum	2567896	Bacteria	Bacteria	303	5.19e-78	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g48961	i0	94	74.3663793103448	200	12	86	0	1	200	6879225	6879424	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	17253	303	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
1705009	1705009	PRJNA432257_S_NODE_78362_length_194_cov_96.579618_g77981_i0	PRJNA432257	78362	194	96.579618	187.36445892	Polyangium aurulentum	2567896	Bacteria	Bacteria	178	2.6499999999999993e-40	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g77981	i0	92.683	1.25773195876289	123	9	63	0	35	157	10927342	10927220	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	244	178	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
3639837	3639837	PRJNA432257_S_NODE_563_length_1565_cov_178.744110_g533_i0	PRJNA432257	563	1565	178.74411	2797.3453215	Polyangiaceae	49	Bacteria	Bacteria	1784	0	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g533	i0	92.454	140.51821086262	1259	79	80	15	273	1524	4848710	4849959	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	219911	1792	0.995535714285714	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
4256801	4256801	PRJNA432257_S_NODE_53924_length_224_cov_228.695187_g53543_i0	PRJNA432257	53924	224	228.695187	512.27721888	Cystobacter fuscus	43	Bacteria	Bacteria	244	3.0599999999999997e-60	NTclustered	gi\|1243034522\|gb\|CP022098.1\|	43	g53543	i0	90.052	202.013392857143	191	15	84	4	37	224	388538	388727	Cystobacter fuscus strain DSM 52655 chromosome, complete genome	blastn	45251	244	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
5533819	5533819	PRJNA432257_S_NODE_75165_length_198_cov_1.453416_g74784_i0	PRJNA432257	75165	198	1.453416	2.87776368	Polyangium aurulentum	2567896	Bacteria	Bacteria	154	4.5700000000000005e-33	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g74784	i0	81.347	1.82323232323232	193	32	96	4	1	191	4907797	4907987	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	361	154	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
6191585	6191585	PRJNA432257_S_NODE_110925_length_165_cov_2.640625_g110544_i0	PRJNA432257	110925	165	2.640625	4.35703125	Myxococcus	32	Bacteria	Bacteria	69.4	1.37e-7	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g110544	i0	82.895	1.23636363636364	76	13	46	0	17	92	3393950	3393875	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	204	69.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
6807296	6807296	PRJNA432257_S_NODE_37086_length_258_cov_55.457014_g36705_i0	PRJNA432257	37086	258	55.457014	143.07909612	Minicystis rosea	888845	Bacteria	Bacteria	183	7.98e-42	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g36705	i0	81.333	11.6937984496124	225	42	87	0	4	228	10576454	10576230	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	3017	183	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
6807998	6807998	PRJNA432257_S_NODE_92586_length_182_cov_2.144828_g92205_i0	PRJNA432257	92586	182	2.144828	3.90358696	Cystobacter fuscus	43	Bacteria	Bacteria	122	1.16e-23	NTclustered	gi\|1243034522\|gb\|CP022098.1\|	43	g92205	i0	80.357	16.3241758241758	168	27	91	6	14	178	4829779	4829943	Cystobacter fuscus strain DSM 52655 chromosome, complete genome	blastn	2971	122	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
8082786	8082786	PRJNA432257_S_NODE_30287_length_278_cov_18.518672_g29906_i0	PRJNA432257	30287	278	18.518672	51.48190816	Polyangium aurulentum	2567896	Bacteria	Bacteria	263	1.09e-65	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g29906	i0	86.809	4.42446043165468	235	31	85	0	34	268	7740369	7740603	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	1230	263	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
11908529	11908529	PRJNA432257_S_NODE_49170_length_232_cov_134.974359_g48789_i0	PRJNA432257	49170	232	134.974359	313.14051288	Polyangium aurulentum	2567896	Bacteria	Bacteria	276	1.13e-69	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g48789	i0	92.268	99.6077586206897	194	15	84	0	38	231	6880258	6880065	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	23109	276	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
14457935	14457935	PRJNA432257_S_NODE_111972_length_164_cov_2.188976_g111591_i0	PRJNA432257	111972	164	2.188976	3.58992064	Polyangium aurulentum	2567896	Bacteria	Bacteria	156	1.01e-33	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g111591	i0	85.714	7.26219512195122	147	21	90	0	18	164	10967877	10967731	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	1191	156	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
17666518	17666518	PRJNA432257_S_NODE_9354_length_418_cov_97.850394_g9007_i0	PRJNA432257	9354	418	97.850394	409.01464692	Anaeromyxobacter	161492	Bacteria	Bacteria	453	9.44e-123	NTclustered	gi\|152026452\|gb\|CP000769.1\|	404589	g9007	i0	90	103.588516746411	350	35	84	0	10	359	2980870	2981219	Anaeromyxobacter sp. Fw109-5, complete genome	blastn	43300	453	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
19555678	19555678	PRJNA432257_S_NODE_51936_length_228_cov_1.282723_g51555_i0	PRJNA432257	51936	228	1.282723	2.92460844	Cystobacter fuscus	43	Bacteria	Bacteria	182	2.48e-41	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g51555	i0	81.696	38.4868421052632	224	36	97	5	7	227	1087281	1087502	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	8775	182	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
20831723	20831723	PRJNA432257_S_NODE_72977_length_200_cov_3.092025_g72596_i0	PRJNA432257	72977	200	3.092025	6.18405	Polyangium aurulentum	2567896	Bacteria	Bacteria	257	3.4300000000000005e-64	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g72596	i0	92.265	0.905	181	14	91	0	7	187	6871743	6871563	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	181	257	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
22106774	22106774	PRJNA432257_S_NODE_81438_length_191_cov_223.584416_g81057_i0	PRJNA432257	81438	191	223.584416	427.04623456	Polyangium aurulentum	2567896	Bacteria	Bacteria	104	4.47e-18	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g81057	i0	86.957	0.481675392670157	92	12	48	0	78	169	5912487	5912578	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	92	104	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
24655731	24655731	PRJNA432257_S_NODE_23200_length_306_cov_2.620818_g22819_i0	PRJNA432257	23200	306	2.620818	8.01970308	Polyangium aurulentum	2567896	Bacteria	Bacteria	411	4.089999999999999e-110	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g22819	i0	91.089	101.313725490196	303	27	99	0	4	306	2672690	2672992	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	31002	411	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum

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