metadata: contig_metadata: 14 rows where bioproject = "PRJNA591127" and tax

14 rows where bioproject = "PRJNA591127" 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
565107	565107	PRJNA591127_P_NODE_2421_length_453_cov_3.896635_g2255_i0	PRJNA591127	2421	453	3.896635	17.65175655	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	721	0	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g2255	i0	95.364	228.984547461369	453	21	100	0	1	453	2160780	2160328	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	103730	721	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
3116037	3116037	PRJNA591127_P_NODE_28163_length_153_cov_1.732759_g27994_i0	PRJNA591127	28163	153	1.732759	2.65112127	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	278	1.9e-70	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g27994	i0	99.346	96.2941176470588	153	1	100	0	1	153	8616443	8616291	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	14733	278	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
3116125	3116125	PRJNA591127_P_NODE_9083_length_244_cov_2.449275_g8915_i0	PRJNA591127	9083	244	2.449275	5.976231	Archangium gephyra	48	Bacteria	Bacteria	424	4.05e-114	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g8915	i0	97.951	268.725409836066	244	5	100	0	1	244	109153	109396	Archangium gephyra strain DSM 2261, complete genome	blastn	65569	424	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
4392583	4392583	PRJNA591127_P_NODE_26464_length_161_cov_1.258065_g26295_i0	PRJNA591127	26464	161	1.258065	2.02548465	Minicystis rosea	888845	Bacteria	Bacteria	154	3.5600000000000004e-33	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g26295	i0	91.892	27.7080745341615	111	7	68	2	1	110	768851	768960	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	4461	154	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
8218317	8218317	PRJNA591127_P_NODE_30127_length_151_cov_3.122807_g29958_i0	PRJNA591127	30127	151	3.122807	4.71543857	Corallococcus exercitus	2316736	Bacteria	Bacteria	257	2.43e-64	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g29958	i0	97.351	229.801324503311	151	4	100	0	1	151	87479	87329	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	34700	257	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
11342023	11342023	PRJNA591127_P_NODE_12189_length_211_cov_1.040230_g12020_i0	PRJNA591127	12189	211	1.04023	2.1948853	Anaeromyxobacter	161492	Bacteria	Bacteria	366	5.83e-97	NTclustered	gi\|470482295\|ref\|NR_076524.1\|	404589	g12020	i0	98.104	72.9241706161137	211	3	100	1	1	211	641	850	Anaeromyxobacter sp. Fw109-5 strain Fw109-5 23S ribosomal RNA, complete sequence	blastn	15387	366	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
17142745	17142745	PRJNA591127_P_NODE_26054_length_163_cov_1.238095_g25885_i0	PRJNA591127	26054	163	1.238095	2.01809485	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	239	9.72e-59	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g25885	i0	93.21	3.98773006134969	162	11	99	0	1	162	9678019	9677858	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	650	239	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
17716676	17716676	PRJNA591127_P_NODE_24094_length_174_cov_1.846715_g23925_i0	PRJNA591127	24094	174	1.846715	3.2132841	Archangium	47	Bacteria	Bacteria	294	2.1999999999999998e-75	NTclustered	gi\|545790935\|gb\|KF270698.1\|	83450	g23925	i0	97.126	117.155172413793	174	5	100	0	1	174	247	74	Cystobacter minus strain Cbm6 23S ribosomal RNA gene, partial sequence	blastn	20385	294	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
20967264	20967264	PRJNA591127_P_NODE_23457_length_178_cov_2.574468_g23288_i0	PRJNA591127	23457	178	2.574468	4.58255304	Archangium violaceum	83451	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g23288	i0	100	0.157303370786517	28	0	16	0	127	154	2601184	2601157	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
22242288	22242288	PRJNA591127_P_NODE_598_length_795_cov_3.431398_g503_i0	PRJNA591127	598	795	3.431398	27.2796141	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	1271	0	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g503	i0	95.609	239.594968553459	797	28	100	5	1	795	4163402	4164193	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	190478	1271	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
24090694	24090694	PRJNA591127_P_NODE_23039_length_181_cov_1.250000_g22870_i0	PRJNA591127	23039	181	1.25	2.2625	Sorangium	39643	Bacteria	Bacteria	211	2.4e-50	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g22870	i0	87.778	102.596685082873	180	22	99	0	2	181	4848736	4848557	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	18570	213	0.990610328638498	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
25364916	25364916	PRJNA591127_P_NODE_120_length_1368_cov_29.471826_g91_i0	PRJNA591127	120	1368	29.471826	403.17457968	Myxococcales	29	Bacteria	Bacteria	673	0	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g91	i0	82.581	165.320906432749	798	105	58	27	512	1298	1445	671	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	226159	673	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
28406190	28406190	PRJNA591127_P_NODE_16506_length_197_cov_2.793750_g16337_i0	PRJNA591127	16506	197	2.79375	5.5036875	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	42.7	0.02	NR	HBO68893.1	2026735	g16337	i0	68	1.12690355329949	25	8	38.1	0	2	76	213	237	HBO68893.1 UDP-glucuronate decarboxylase [Deltaproteobacteria bacterium]	diamond	222	42.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
29903702	29903702	PRJNA591127_P_NODE_15011_length_197_cov_3.606250_g14842_i0	PRJNA591127	15011	197	3.60625	7.1043125	Pseudomonadati	3379134	Bacteria	Bacteria	52	1.1e-5	NR	MCH7914433.1	2026735	g14842	i0	88	1.90355329949239	25	3	38.1	0	1	75	484	508	MCH7914433.1 DEAD/DEAH box helicase [Deltaproteobacteria bacterium]	diamond	375	52	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria 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);;