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

18 rows where analysis = "blastn", bioproject = "PRJDB9741" 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
10985	10985	PRJDB9741_P_NODE_32621_length_165_cov_0.879310_g32304_i0	PRJDB9741	32621	165	0.87931	1.4508615	Pendulispora rubella	2741070	Bacteria	Bacteria	134	4.7900000000000005e-27	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g32304	i0	83.688	9.06666666666667	141	23	85	0	25	165	2700477	2700337	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	1496	134	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
3837036	3837036	PRJDB9741_P_NODE_19264_length_179_cov_1.569231_g18947_i0	PRJDB9741	19264	179	1.569231	2.80892349	Sorangium cellulosum	56	Bacteria	Bacteria	215	1.83e-51	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g18947	i0	89.535	1.93854748603352	172	15	96	3	9	179	11468916	11468747	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	347	215	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
6389295	6389295	PRJDB9741_P_NODE_7286_length_232_cov_1.830601_g6969_i0	PRJDB9741	7286	232	1.830601	4.24699432	Nannocystis pusilla	889268	Bacteria	Bacteria	318	1.8499999999999998e-82	NTclustered	gi\|1386873113\|gb\|MF774780.1\|	889268	g6969	i0	91.379	136.443965517241	232	20	100	0	1	232	348	117	Nannocystis pusilla strain Na p29 23S ribosomal RNA gene, partial sequence	blastn	31655	318	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis pusilla
7359489	7359489	PRJDB9741_P_NODE_24646_length_170_cov_4.636364_g24329_i0	PRJDB9741	24646	170	4.636364	7.8818188	Nannocystis	53	Bacteria	Bacteria	255	1.01e-63	NTclustered	gi\|2244669\|emb\|X87286.1\|	54	g24329	i0	94.048	321.458823529412	168	10	99	0	3	170	2896	2729	N.exedens 23S rRNA gene	blastn	54648	255	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
8937937	8937937	PRJDB9741_P_NODE_34548_length_164_cov_0.886957_g34231_i0	PRJDB9741	34548	164	0.886957	1.45460948	Minicystis rosea	888845	Bacteria	Bacteria	158	2.82e-34	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g34231	i0	84.337	5.99390243902439	166	20	99	4	1	163	9614101	9613939	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	983	158	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
13735356	13735356	PRJDB9741_P_NODE_4631_length_299_cov_1.832000_g4315_i0	PRJDB9741	4631	299	1.832	5.47768	Archangium	47	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g4315	i0	100	0.187290969899666	28	0	9	0	69	96	7254608	7254581	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
16284416	16284416	PRJDB9741_P_NODE_12613_length_191_cov_4.330986_g12296_i0	PRJDB9741	12613	191	4.330986	8.27218326	Nannocystis	53	Bacteria	Bacteria	185	1.5499999999999998e-42	NTclustered	gi\|1386873113\|gb\|MF774780.1\|	889268	g12296	i0	84.817	72.3298429319372	191	22	99	4	1	190	370	554	Nannocystis pusilla strain Na p29 23S ribosomal RNA gene, partial sequence	blastn	13815	185	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis pusilla
16587723	16587723	PRJDB9741_P_NODE_17234_length_183_cov_1.141791_g16917_i0	PRJDB9741	17234	183	1.141791	2.08947753	Sorangium cellulosum	56	Bacteria	Bacteria	289	1.0899999999999998e-73	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g16917	i0	95.082	153.289617486339	183	9	100	0	1	183	3449830	3449648	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	28052	289	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
16587801	16587801	PRJDB9741_P_NODE_26914_length_167_cov_1.991525_g26597_i0	PRJDB9741	26914	167	1.991525	3.32584675	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	265	1.65e-66	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g26597	i0	95.21	254.359281437126	167	8	100	0	1	167	2161807	2161641	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	42478	265	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
16587878	16587878	PRJDB9741_P_NODE_37494_length_162_cov_0.902655_g37177_i0	PRJDB9741	37494	162	0.902655	1.4623011	Polyangium aurulentum	2567896	Bacteria	Bacteria	76.8	8e-10	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g37177	i0	83.133	1.47530864197531	83	14	51	0	74	156	4394752	4394670	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	239	76.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
17559680	17559680	PRJDB9741_P_NODE_14674_length_187_cov_1.681159_g14357_i0	PRJDB9741	14674	187	1.681159	3.14376733	Sorangium	39643	Bacteria	Bacteria	165	1.97e-36	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g14357	i0	83.607	7.22994652406417	183	22	96	8	1	179	14141203	14141025	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	1352	165	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
18833560	18833560	PRJDB9741_P_NODE_1915_length_550_cov_2.606786_g1611_i0	PRJDB9741	1915	550	2.606786	14.337323	Nannocystis	53	Bacteria	Bacteria	760	0	NTclustered	gi\|2244669\|emb\|X87286.1\|	54	g1611	i0	91.532	146.743636363636	555	41	100	6	1	550	1106	553	N.exedens 23S rRNA gene	blastn	80709	760	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
18833562	18833562	PRJDB9741_P_NODE_19755_length_178_cov_1.782946_g19438_i0	PRJDB9741	19755	178	1.782946	3.17364388	Myxococcus	32	Bacteria	Bacteria	71.3	4.16e-8	NTclustered	gi\|2700865302\|gb\|CP147913.1\|	83455	g19438	i0	83.333	2.0561797752809	78	11	43	2	62	138	8135064	8135140	Myxococcus stipitatus strain KYC2006 chromosome, complete genome	blastn	366	71.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
20411695	20411695	PRJDB9741_P_NODE_597_length_1135_cov_8.936464_g434_i0	PRJDB9741	597	1135	8.936464	101.4288664	Labilithrix luteola	1391654	Bacteria	Bacteria	1688	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g434	i0	93.497	159.943612334802	1138	70	100	3	1	1135	7088972	7090108	Labilithrix luteola strain DSM 27648, complete genome	blastn	181536	1688	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
21687526	21687526	PRJDB9741_P_NODE_30778_length_165_cov_2.396552_g30461_i0	PRJDB9741	30778	165	2.396552	3.9543108	Nannocystis punicea	2995304	Bacteria	Bacteria	224	2.76e-54	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g30461	i0	91.018	10.4	167	13	100	2	1	165	7595613	7595779	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	1716	224	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
21687638	21687638	PRJDB9741_P_NODE_4378_length_310_cov_8.651341_g4062_i0	PRJDB9741	4378	310	8.651341	26.8191571	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	436	6.8399999999999986e-118	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g4062	i0	91.987	224.91935483871	312	23	100	2	1	310	9679310	9678999	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	69725	436	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
22962729	22962729	PRJDB9741_P_NODE_1539_length_641_cov_13.471284_g1249_i0	PRJDB9741	1539	641	13.471284	86.35093044	Labilithrix luteola	1391654	Bacteria	Bacteria	917	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1249	i0	92.523	132.886115444618	642	44	99	4	2	641	7915204	7915843	Labilithrix luteola strain DSM 27648, complete genome	blastn	85180	917	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
22962938	22962938	PRJDB9741_P_NODE_599_length_1134_cov_10.315207_g434_i1	PRJDB9741	599	1134	10.315207	116.97444738	Labilithrix luteola	1391654	Bacteria	Bacteria	1604	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g434	i1	92.207	159.678130511464	1142	76	100	9	1	1134	3942903	3941767	Labilithrix luteola strain DSM 27648, complete genome	blastn	181075	1604	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola

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