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

17 rows where analysis = "blastn", bioproject = "PRJNA533623" 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
4333880	4333880	PRJNA533623_P_NODE_5964_length_940_cov_1.898749_g4678_i0	PRJNA533623	5964	940	1.898749	17.8482406	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	228	1.47e-54	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g4678	i0	76.162	3.7063829787234	495	82	50	28	9	474	794820	794333	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	3484	228	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
6883968	6883968	PRJNA533623_P_NODE_32126_length_397_cov_2.964286_g30355_i0	PRJNA533623	32126	397	2.964286	11.76821542	Haliangium ochraceum	80816	Bacteria	Bacteria	193	2.15e-44	NTclustered	gi\|262076673\|gb\|CP001804.1\|	502025	g30355	i0	77.419	1	341	66	84	8	29	362	9338410	9338074	Haliangium ochraceum DSM 14365, complete genome	blastn	397	193	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
6884075	6884075	PRJNA533623_P_NODE_36666_length_365_cov_6.164474_g34894_i0	PRJNA533623	36666	365	6.164474	22.5003301	Cystobacter fuscus	43	Bacteria	Bacteria	150	1.19e-31	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g34894	i0	83.333	0.443835616438356	162	27	44	0	193	354	1150718	1150557	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	162	150	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
9435363	9435363	PRJNA533623_P_NODE_64548_length_238_cov_1.384181_g62767_i0	PRJNA533623	64548	238	1.384181	3.29435078	Archangium gephyra	48	Bacteria	Bacteria	135	2.06e-27	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g62767	i0	80.925	49.7352941176471	173	31	72	2	11	182	11408312	11408483	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	11837	135	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
9435608	9435608	PRJNA533623_P_NODE_77708_length_200_cov_3.280576_g75927_i0	PRJNA533623	77708	200	3.280576	6.561152	Cystobacter fuscus	43	Bacteria	Bacteria	124	3.63e-24	NTclustered	gi\|1243034522\|gb\|CP022098.1\|	43	g75927	i0	83.453	15.89	139	18	68	4	19	154	4237050	4236914	Cystobacter fuscus strain DSM 52655 chromosome, complete genome	blastn	3178	124	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
10710687	10710687	PRJNA533623_P_NODE_45969_length_313_cov_4.250000_g44193_i0	PRJNA533623	45969	313	4.25	13.3025	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	102	2.87e-17	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g44193	i0	78.182	0.527156549520767	165	33	52	3	137	300	3823009	3822847	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	165	102	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
11985622	11985622	PRJNA533623_P_NODE_57550_length_263_cov_3.831683_g55770_i0	PRJNA533623	57550	263	3.831683	10.07732629	Cystobacter fuscus	43	Bacteria	Bacteria	141	4.9799999999999993e-29	NTclustered	gi\|2579656172\|gb\|CP043491.1\|	43	g55770	i0	82.317	4.60456273764259	164	27	62	2	56	218	7082327	7082489	Cystobacter fuscus strain Cbf 10 chromosome, complete genome	blastn	1211	141	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
13260381	13260381	PRJNA533623_P_NODE_42871_length_329_cov_1.686567_g41097_i0	PRJNA533623	42871	329	1.686567	5.54880543	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	60.2	1.85e-4	NTclustered	gi\|152026452\|gb\|CP000769.1\|	404589	g41097	i0	100	0.270516717325228	32	0	10	0	223	254	3123070	3123039	Anaeromyxobacter sp. Fw109-5, complete genome	blastn	89	60.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
13260944	13260944	PRJNA533623_P_NODE_69391_length_222_cov_1.267081_g67610_i0	PRJNA533623	69391	222	1.267081	2.81291982	Corallococcus coralloides	184914	Bacteria	Bacteria	154	5.2500000000000005e-33	NTclustered	gi\|2851136330\|gb\|CP172866.1\|	184914	g67610	i0	81.122	6.64414414414414	196	33	87	4	8	201	783017	782824	Corallococcus coralloides strain KYC2213 chromosome, complete genome	blastn	1475	154	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
14535213	14535213	PRJNA533623_P_NODE_36012_length_369_cov_4.363636_g34240_i0	PRJNA533623	36012	369	4.363636	16.10181684	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	438	2.3e-118	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g34240	i0	89.235	84.6937669376694	353	34	95	3	2	352	4401598	4401248	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	31252	438	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
14535768	14535768	PRJNA533623_P_NODE_60632_length_251_cov_13.094737_g58852_i0	PRJNA533623	60632	251	13.094737	32.86778987	Polyangium aurulentum	2567896	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g58852	i0	100	0.231075697211155	30	0	12	0	111	140	7496863	7496892	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	58	56.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
15808766	15808766	PRJNA533623_P_NODE_22213_length_492_cov_7.969838_g20460_i0	PRJNA533623	22213	492	7.969838	39.21160296	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	316	1.54e-81	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g20460	i0	81.748	1.66666666666667	389	61	78	10	109	492	3600663	3600280	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	820	316	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
15809325	15809325	PRJNA533623_P_NODE_45433_length_316_cov_1.850980_g43657_i0	PRJNA533623	45433	316	1.85098	5.8490968	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	178	4.68e-40	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g43657	i0	78.598	27.6645569620253	271	56	85	2	26	295	6110847	6110578	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	8742	178	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
15809413	15809413	PRJNA533623_P_NODE_49473_length_296_cov_69.919149_g47694_i0	PRJNA533623	49473	296	69.919149	206.96068104	Melittangium boletus	83453	Bacteria	Bacteria	86.1	2.71e-12	NTclustered	gi\|1243026503\|gb\|CP022163.1\|	1294270	g47694	i0	80.645	6.31081081081081	124	12	38	6	10	121	5892840	5892717	Melittangium boletus DSM 14713 chromosome, complete genome	blastn	1868	86.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Melittangium	Melittangium boletus
15809544	15809544	PRJNA533623_P_NODE_55273_length_272_cov_3.739336_g53493_i0	PRJNA533623	55273	272	3.739336	10.17099392	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	248	2.97e-61	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g53493	i0	85.417	79.9963235294118	240	34	88	1	11	249	1787523	1787762	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	21759	248	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
20908946	20908946	PRJNA533623_P_NODE_59937_length_254_cov_2.782383_g58157_i0	PRJNA533623	59937	254	2.782383	7.06725282	Nannocystis punicea	2995304	Bacteria	Bacteria	235	2.13e-57	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g58157	i0	91.279	7.00393700787402	172	15	68	0	18	189	12267157	12267328	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	1779	235	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
21520116	21520116	PRJNA533623_P_NODE_62017_length_246_cov_35.508108_g60237_i0	PRJNA533623	62017	246	35.508108	87.34994568	Myxococcus	32	Bacteria	Bacteria	333	7.089999999999999e-87	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g60237	i0	96.97	4.99186991869919	198	6	80	0	24	221	6953359	6953162	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	1228	333	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus

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