metadata: contig_metadata: 12 rows where bioproject = "PRJNA929952" and tax

12 rows where bioproject = "PRJNA929952" 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
2184534	2184534	PRJNA929952_P_NODE_6262_length_492_cov_69.179266_g5131_i0	PRJNA929952	6262	492	69.179266	340.36198872	Labilithrix luteola	1391654	Bacteria	Bacteria	514	5.09e-141	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g5131	i0	85.685	239.778455284553	496	62	99	9	1	491	3941765	3942256	Labilithrix luteola strain DSM 27648, complete genome	blastn	117971	514	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
6012394	6012394	PRJNA929952_P_NODE_12405_length_310_cov_4.843416_g11112_i0	PRJNA929952	12405	310	4.843416	15.0145896	Nannocystis punicea	2995304	Bacteria	Bacteria	429	1.15e-115	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g11112	i0	91.667	230.7	312	23	99	3	1	309	7596385	7596074	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	71517	429	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
6358832	6358832	PRJNA929952_P_NODE_4265_length_605_cov_8.880208_g1973_i1	PRJNA929952	4265	605	8.880208	53.7252584	Nannocystis	53	Bacteria	Bacteria	544	8.11e-150	NTclustered	gi\|2244669\|emb\|X87286.1\|	54	g1973	i1	87.292	100.727272727273	480	55	79	6	6	482	494	18	N.exedens 23S rRNA gene	blastn	60940	547	0.994515539305302	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
6358839	6358839	PRJNA929952_P_NODE_685_length_1276_cov_87.652767_g472_i0	PRJNA929952	685	1276	87.652767	1118.44930692	Pendulispora	3375062	Bacteria	Bacteria	1443	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g472	i0	87.219	164.206896551724	1291	135	100	27	1	1276	7289555	7288280	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	209528	1450	0.995172413793103	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
9837163	9837163	PRJNA929952_P_NODE_3148_length_697_cov_4011.488024_g828_i1	PRJNA929952	3148	697	4011.488024	27960.07152728	Nannocystis sp.	1962667	Bacteria	Bacteria	691	0	NTclustered	gi\|1386873111\|gb\|MF774778.1\|	1962667	g828	i1	85.229	371.342898134864	677	94	97	6	24	697	138	811	Nannocystis sp. strain MNa11734 23S ribosomal RNA gene, partial sequence	blastn	258826	691	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis sp.
11458546	11458546	PRJNA929952_P_NODE_2669_length_744_cov_7.833566_g1973_i0	PRJNA929952	2669	744	7.833566	58.28173104	Nannocystis	53	Bacteria	Bacteria	544	1.01e-149	NTclustered	gi\|2244669\|emb\|X87286.1\|	54	g1973	i0	87.292	53.3467741935484	480	55	64	6	263	739	18	494	N.exedens 23S rRNA gene	blastn	39690	547	0.994515539305302	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
13662779	13662779	PRJNA929952_P_NODE_14311_length_276_cov_1320.558704_g13018_i0	PRJNA929952	14311	276	1320.558704	3644.74202304	Pendulispora albinea	2741071	Bacteria	Bacteria	416	7.809999999999998e-112	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g13018	i0	93.841	182.184782608696	276	17	100	0	1	276	3590566	3590291	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	50283	416	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
15282733	15282733	PRJNA929952_P_NODE_24312_length_155_cov_1.976190_g23018_i0	PRJNA929952	24312	155	1.97619	3.0630945	Pseudomonadati	3379134	Bacteria	Bacteria	113	5.76e-21	NTclustered	gi\|470488931\|ref\|NR_076895.1\|	33	g23018	i0	79.87	200.541935483871	154	31	99	0	2	155	2318	2471	Myxococcus fulvus strain HW-1 23S ribosomal RNA gene, complete sequence	blastn	31084	113	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
16212085	16212085	PRJNA929952_P_NODE_12753_length_303_cov_31.970803_g11460_i0	PRJNA929952	12753	303	31.970803	96.87153309	Chondromyces crocatus	52	Bacteria	Bacteria	383	8.81e-102	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g11460	i0	89.439	136.313531353135	303	32	100	0	1	303	1140	838	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	41303	383	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
16557337	16557337	PRJNA929952_P_NODE_753_length_1233_cov_89.725083_g525_i0	PRJNA929952	753	1233	89.725083	1106.31027339	Pendulispora	3375062	Bacteria	Bacteria	1447	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g525	i0	87.984	160.860502838605	1240	129	100	19	1	1233	7289555	7288329	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	198341	1448	0.999309392265193	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
17487410	17487410	PRJNA929952_P_NODE_12754_length_303_cov_28.583942_g11461_i0	PRJNA929952	12754	303	28.583942	86.60934426	Labilithrix luteola	1391654	Bacteria	Bacteria	494	3.9e-135	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g11461	i0	96.04	142.726072607261	303	12	100	0	1	303	3943772	3944074	Labilithrix luteola strain DSM 27648, complete genome	blastn	43246	494	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
19106215	19106215	PRJNA929952_P_NODE_15935_length_255_cov_345.920354_g14641_i0	PRJNA929952	15935	255	345.920354	882.0969027	Nannocystis	53	Bacteria	Bacteria	305	1.61e-78	NTclustered	gi\|2244669\|emb\|X87286.1\|	54	g14641	i0	88.281	314.035294117647	256	28	100	2	1	255	1161	907	N.exedens 23S rRNA gene	blastn	80079	307	0.993485342019544	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens

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