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

18 rows where analysis = "blastn", bioproject = "PRJNA724039" 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
711071	711071	PRJNA724039_S_NODE_14861_length_165_cov_3.460938_g14654_i0	PRJNA724039	14861	165	3.460938	5.7105477	Labilithrix luteola	1391654	Bacteria	Bacteria	239	9.87e-59	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g14654	i0	93.21	119.824242424242	162	11	98	0	2	163	7915684	7915845	Labilithrix luteola strain DSM 27648, complete genome	blastn	19771	239	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
1194121	1194121	PRJNA724039_S_NODE_14401_length_168_cov_2.076336_g14194_i0	PRJNA724039	14401	168	2.076336	3.48824448	Myxococcales	29	Bacteria	Bacteria	224	2.8299999999999995e-54	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g14194	i0	91.515	227.232142857143	165	10	96	4	6	167	452888	452725	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	38175	224	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
2469513	2469513	PRJNA724039_S_NODE_6842_length_258_cov_51.633484_g6635_i0	PRJNA724039	6842	258	51.633484	133.21438872	Polyangiaceae	49	Bacteria	Bacteria	364	2.6599999999999992e-96	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g6635	i0	92.248	166.600775193798	258	19	99	1	1	257	2443	2186	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	42983	366	0.994535519125683	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
3745927	3745927	PRJNA724039_S_NODE_2263_length_500_cov_56.265659_g2065_i0	PRJNA724039	2263	500	56.265659	281.328295	Polyangiaceae	49	Bacteria	Bacteria	532	1.43e-146	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g2065	i0	86.29	120.088	496	60	98	8	10	500	1635	1143	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	60044	532	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
4539465	4539465	PRJNA724039_S_NODE_1324_length_713_cov_17.535503_g1160_i0	PRJNA724039	1324	713	17.535503	125.02813639	Minicystis rosea	888845	Bacteria	Bacteria	774	0	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g1160	i0	86.408	165.899018232819	721	82	99	14	4	713	769595	768880	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	118286	774	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
4539602	4539602	PRJNA724039_S_NODE_5344_length_301_cov_3.276515_g5137_i0	PRJNA724039	5344	301	3.276515	9.86231015	Myxococcus sp. SDU36	2831967	Bacteria	Bacteria	451	2.36e-122	NTclustered	gi\|2513984958\|gb\|CP077414.1\|	2831967	g5137	i0	93.688	285.166112956811	301	19	100	0	1	301	850750	850450	Myxococcus sp. SDU36 chromosome, complete genome	blastn	85835	451	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus sp. SDU36
4539669	4539669	PRJNA724039_S_NODE_924_length_929_cov_18.765695_g795_i0	PRJNA724039	924	929	18.765695	174.33330655	Pendulispora rubella	2741070	Bacteria	Bacteria	1190	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g795	i0	89.892	160.653390742734	930	87	99	6	2	929	7289045	7289969	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	149247	1190	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
5022413	5022413	PRJNA724039_S_NODE_15824_length_160_cov_2.975610_g15617_i0	PRJNA724039	15824	160	2.97561	4.760976	Anaeromyxobacter	161492	Bacteria	Bacteria	185	1.2499999999999997e-42	NTclustered	gi\|470477744\|ref\|NR_076406.1\|	161493	g15617	i0	90.78	68.78125	141	10	86	3	23	160	657	517	Anaeromyxobacter dehalogenans strain 2CP-C 23S ribosomal RNA gene, complete sequence	blastn	11005	185	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
7571949	7571949	PRJNA724039_S_NODE_10306_length_202_cov_2.036364_g10099_i0	PRJNA724039	10306	202	2.036364	4.11345528	Myxococcales	29	Bacteria	Bacteria	263	7.46e-66	NTclustered	gi\|470488931\|ref\|NR_076895.1\|	33	g10099	i0	90.099	268.20297029703	202	20	100	0	1	202	1131	930	Myxococcus fulvus strain HW-1 23S ribosomal RNA gene, complete sequence	blastn	54177	263	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
7572028	7572028	PRJNA724039_S_NODE_4786_length_321_cov_5.225352_g4579_i0	PRJNA724039	4786	321	5.225352	16.77337992	Stigmatella	40	Bacteria	Bacteria	405	2.01e-108	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g4579	i0	89.474	210.317757009346	323	31	100	3	1	321	370	49	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	67512	405	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
8364455	8364455	PRJNA724039_S_NODE_1847_length_572_cov_13.671028_g1655_i0	PRJNA724039	1847	572	13.671028	78.19828016	Pendulispora rubella	2741070	Bacteria	Bacteria	590	9.67e-164	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g1655	i0	86.817	233.95979020979	531	67	92	3	44	572	7289440	7289969	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	133825	590	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
9639512	9639512	PRJNA724039_S_NODE_10468_length_200_cov_2.644172_g10261_i0	PRJNA724039	10468	200	2.644172	5.288344	Nannocystis punicea	2995304	Bacteria	Bacteria	185	1.64e-42	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g10261	i0	83.654	34.36	208	23	99	8	1	198	11216911	11216705	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	6872	185	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
13464833	13464833	PRJNA724039_S_NODE_11771_length_187_cov_7.946667_g11564_i0	PRJNA724039	11771	187	7.946667	14.86026729	Nannocystis sp.	1962667	Bacteria	Bacteria	241	3.18e-59	NTclustered	gi\|1386873111\|gb\|MF774778.1\|	1962667	g11564	i0	89.894	153.737967914439	188	17	100	2	1	187	597	411	Nannocystis sp. strain MNa11734 23S ribosomal RNA gene, partial sequence	blastn	28749	241	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis sp.
15222684	15222684	PRJNA724039_S_NODE_10432_length_200_cov_122.619632_g10225_i0	PRJNA724039	10432	200	122.619632	245.239264	Sorangium	39643	Bacteria	Bacteria	276	9.47e-70	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g10225	i0	91.5	194.57	200	17	100	0	1	200	3692069	3692268	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	38914	276	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
18562791	18562791	PRJNA724039_S_NODE_1095_length_826_cov_15.024081_g952_i0	PRJNA724039	1095	826	15.024081	124.09890906	Stigmatella aurantiaca	41	Bacteria	Bacteria	1027	0	NTclustered	gi\|309390350\|gb\|CP002271.1\|	378806	g952	i0	89.264	236.8401937046	829	78	99	11	3	826	6866624	6867446	Stigmatella aurantiaca DW4/3-1, complete genome	blastn	195630	1027	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
19045891	19045891	PRJNA724039_S_NODE_1115_length_819_cov_14.228900_g968_i0	PRJNA724039	1115	819	14.2289	116.534691	Sorangium	39643	Bacteria	Bacteria	795	0	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g968	i0	84.375	173.233211233211	832	106	100	22	1	819	11963828	11964648	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	141878	795	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
20320651	20320651	PRJNA724039_S_NODE_8536_length_225_cov_21.723404_g8329_i0	PRJNA724039	8536	225	21.723404	48.877659	Myxococcales	29	Bacteria	Bacteria	377	2.91e-100	NTclustered	gi\|470488931\|ref\|NR_076895.1\|	33	g8329	i0	96.889	244.96	225	7	100	0	1	225	1143	919	Myxococcus fulvus strain HW-1 23S ribosomal RNA gene, complete sequence	blastn	55116	377	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
23664103	23664103	PRJNA724039_S_NODE_11699_length_188_cov_2.052980_g11492_i0	PRJNA724039	11699	188	2.05298	3.8596024	Pendulispora albinea	2741071	Bacteria	Bacteria	156	1.19e-33	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g11492	i0	82.447	184.164893617021	188	24	97	7	1	183	7191592	7191409	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	34623	156	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea

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