metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA505329" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA505329" 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
483400	483400	PRJNA505329_P_NODE_36421_length_177_cov_2.875000_g35950_i0	PRJNA505329	36421	177	2.875	5.08875	Labilithrix luteola	1391654	Bacteria	Bacteria	200	5.049999999999998e-47	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g35950	i0	91.724	93.1412429378531	145	11	82	1	5	149	3942500	3942357	Labilithrix luteola strain DSM 27648, complete genome	blastn	16486	200	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
3034389	3034389	PRJNA505329_P_NODE_22643_length_200_cov_3.000000_g22172_i0	PRJNA505329	22643	200	3	6	Pendulispora brunnea	2905690	Bacteria	Bacteria	139	1.3e-28	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g22172	i0	91.919	39.19	99	8	98	0	3	101	7408684	7408782	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	7838	139	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
3034523	3034523	PRJNA505329_P_NODE_35123_length_179_cov_2.376923_g34652_i0	PRJNA505329	35123	179	2.376923	4.25469217	Polyangium aurulentum	2567896	Bacteria	Bacteria	237	3.9e-58	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g34652	i0	90.909	99.4022346368715	176	16	98	0	4	179	4617758	4617583	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	17793	237	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
4310494	4310494	PRJNA505329_P_NODE_47984_length_164_cov_0.904348_g47513_i0	PRJNA505329	47984	164	0.904348	1.48313072	Minicystis rosea	888845	Bacteria	Bacteria	143	7.9e-30	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g47513	i0	83.125	16.8292682926829	160	23	96	4	4	161	770000	770157	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	2760	143	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
5587079	5587079	PRJNA505329_P_NODE_2705_length_566_cov_3.352031_g2281_i0	PRJNA505329	2705	566	3.352031	18.97249546	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	872	0	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g2281	i0	94.662	118.876325088339	562	30	99	0	4	565	9677520	9678081	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	67284	872	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
6861282	6861282	PRJNA505329_P_NODE_39346_length_173_cov_1.653226_g38875_i0	PRJNA505329	39346	173	1.653226	2.86008098	Minicystis rosea	888845	Bacteria	Bacteria	185	1.3699999999999999e-42	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g38875	i0	86.471	8.8728323699422	170	21	98	1	4	173	770314	770481	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	1535	185	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
6861385	6861385	PRJNA505329_P_NODE_47966_length_164_cov_0.904348_g47495_i0	PRJNA505329	47966	164	0.904348	1.48313072	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	141	2.84e-29	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g47495	i0	86.029	0.829268292682927	136	14	81	5	17	149	7183327	7183194	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	136	141	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
9411757	9411757	PRJNA505329_P_NODE_7628_length_264_cov_1.534884_g7157_i0	PRJNA505329	7628	264	1.534884	4.05209376	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	375	1.26e-99	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g7157	i0	92.996	342.424242424242	257	18	97	0	5	261	9676632	9676376	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	90400	375	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
11313346	11313346	PRJNA505329_P_NODE_11029_length_233_cov_3.690217_g10558_i0	PRJNA505329	11029	233	3.690217	8.59820561	Archangium	47	Bacteria	Bacteria	165	2.57e-36	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g10558	i0	96.04	228.18025751073	101	4	85	0	133	233	5100474	5100574	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	53166	165	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
13237440	13237440	PRJNA505329_P_NODE_44851_length_166_cov_2.623932_g44380_i0	PRJNA505329	44851	166	2.623932	4.35572712	Pendulispora brunnea	2905690	Bacteria	Bacteria	228	2.1499999999999997e-55	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g44380	i0	93.506	79.6144578313253	154	8	92	1	13	164	9037637	9037484	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	13216	228	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
14512365	14512365	PRJNA505329_P_NODE_35032_length_179_cov_3.161538_g34561_i0	PRJNA505329	35032	179	3.161538	5.65915302	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	95.3	2.48e-15	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g34561	i0	89.333	16.0837988826816	75	8	42	0	100	174	8617250	8617176	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	2879	95.3	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
15785966	15785966	PRJNA505329_P_NODE_23133_length_199_cov_2.813333_g22662_i0	PRJNA505329	23133	199	2.813333	5.59853267	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	316	5.55e-82	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g22662	i0	95.918	205.467336683417	196	6	98	2	1	196	8616901	8617094	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	40888	316	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
18334864	18334864	PRJNA505329_P_NODE_16595_length_232_cov_3.699454_g16124_i0	PRJNA505329	16595	232	3.699454	8.58273328	Minicystis rosea	888845	Bacteria	Bacteria	122	1.56e-23	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g16124	i0	88.889	0.426724137931034	99	11	43	0	1	99	10767597	10767695	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	99	122	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
18335351	18335351	PRJNA505329_P_NODE_8715_length_245_cov_2.816327_g8244_i0	PRJNA505329	8715	245	2.816327	6.90000115	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	198	2.68e-46	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g8244	i0	99.091	168.657142857143	110	1	86	0	4	113	8615933	8615824	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	41321	198	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
19609415	19609415	PRJNA505329_P_NODE_32736_length_183_cov_2.216418_g32265_i0	PRJNA505329	32736	183	2.216418	4.05604494	Myxococcales bacterium	2026763	Bacteria	Bacteria	211	2.43e-50	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g32265	i0	87.912	338.562841530055	182	19	98	3	1	180	1311322	1311502	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	61957	211	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
19609557	19609557	PRJNA505329_P_NODE_44976_length_166_cov_1.769231_g44505_i0	PRJNA505329	44976	166	1.769231	2.93692346	Corallococcus sp. NCRR	2996782	Bacteria	Bacteria	158	2.8599999999999993e-34	NTclustered	gi\|2415015785\|gb\|CP114039.1\|	2996782	g44505	i0	85.35	59.644578313253	157	17	93	6	11	164	8995243	8995090	Corallococcus sp. NCRR chromosome, complete genome	blastn	9901	158	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. NCRR
25336670	25336670	PRJNA505329_P_NODE_23000_length_199_cov_3.406667_g22529_i0	PRJNA505329	23000	199	3.406667	6.77926733	Archangiaceae	39	Bacteria	Bacteria	78.7	2.85e-10	NTclustered	gi\|2579656172\|gb\|CP043491.1\|	43	g22529	i0	100	1.47738693467337	42	0	21	0	44	85	5241796	5241755	Cystobacter fuscus strain Cbf 10 chromosome, complete genome	blastn	294	78.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus

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