metadata: contig_metadata: 17 rows where bioproject = "PRJNA1129273" and tax

17 rows where bioproject = "PRJNA1129273" 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
283257	283257	PRJNA1129273_P_NODE_4681_length_330_cov_1.202335_g4401_i0	PRJNA1129273	4681	330	1.202335	3.9677055	Labilithrix luteola	1391654	Bacteria	Bacteria	492	1.54e-134	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g4401	i0	93.617	144.445454545455	329	21	99	0	1	329	7090462	7090134	Labilithrix luteola strain DSM 27648, complete genome	blastn	47667	492	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
2833912	2833912	PRJNA1129273_P_NODE_2403_length_501_cov_3.703271_g2127_i0	PRJNA1129273	2403	501	3.703271	18.55338771	Sorangium cellulosum	56	Bacteria	Bacteria	542	2.38e-149	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g2127	i0	86.444	122.61876247505	509	52	99	14	1	499	4849408	4849909	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	61432	542	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
5386421	5386421	PRJNA1129273_P_NODE_10065_length_244_cov_1.040936_g9785_i0	PRJNA1129273	10065	244	1.040936	2.53988384	Labilithrix luteola	1391654	Bacteria	Bacteria	265	2.6e-66	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g9785	i0	86.42	371.295081967213	243	32	99	1	2	243	7089278	7089036	Labilithrix luteola strain DSM 27648, complete genome	blastn	90596	265	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
7936305	7936305	PRJNA1129273_P_NODE_6807_length_275_cov_3.554455_g6527_i0	PRJNA1129273	6807	275	3.554455	9.77475125	Labilithrix luteola	1391654	Bacteria	Bacteria	331	2.9000000000000006e-86	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g6527	i0	88.489	18.6945454545455	278	26	99	4	2	275	7915569	7915844	Labilithrix luteola strain DSM 27648, complete genome	blastn	5141	331	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
9211308	9211308	PRJNA1129273_P_NODE_9808_length_245_cov_1.790698_g9528_i0	PRJNA1129273	9808	245	1.790698	4.3872101	Cystobacter fuscus	43	Bacteria	Bacteria	189	1.62e-43	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g9528	i0	82.192	2.12244897959184	219	39	89	0	2	220	7100432	7100650	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	520	189	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
9959771	9959771	PRJNA1129273_P_NODE_2848_length_447_cov_2.874332_g2569_i0	PRJNA1129273	2848	447	2.874332	12.84826404	Pseudomonadati	3379134	Bacteria	Bacteria	507	7.68e-139	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g2569	i0	89.383	161.780760626398	405	40	90	3	2	404	857	1260	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	72316	507	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
11761865	11761865	PRJNA1129273_P_NODE_5390_length_305_cov_1.099138_g5110_i0	PRJNA1129273	5390	305	1.099138	3.3523709	Sorangium cellulosum	56	Bacteria	Bacteria	339	1.95e-88	NTclustered	gi\|28395339\|gb\|AY190664.1\|	56	g5110	i0	86.928	82.7672131147541	306	34	99	5	2	304	610	912	Polyangium cellulosum strain So9881 clone 3 16S ribosomal RNA and 23S ribosomal RNA genes, partial sequence	blastn	25244	339	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
13785001	13785001	PRJNA1129273_P_NODE_1591_length_648_cov_4.833043_g1327_i0	PRJNA1129273	1591	648	4.833043	31.31811864	Polyangiaceae	49	Bacteria	Bacteria	761	0	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g1327	i0	88.18	124.873456790123	643	70	98	6	2	639	1422	2063	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	80918	761	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
13785019	13785019	PRJNA1129273_P_NODE_7271_length_268_cov_1.753846_g6991_i0	PRJNA1129273	7271	268	1.753846	4.70030728	Myxococcaceae	31	Bacteria	Bacteria	327	3.64e-85	NTclustered	gi\|470488931\|ref\|NR_076895.1\|	33	g6991	i0	88.806	189.026119402985	268	28	99	2	1	267	837	571	Myxococcus fulvus strain HW-1 23S ribosomal RNA gene, complete sequence	blastn	50659	327	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
20158107	20158107	PRJNA1129273_P_NODE_9836_length_245_cov_1.389535_g9556_i0	PRJNA1129273	9836	245	1.389535	3.40436075	Stigmatella	40	Bacteria	Bacteria	394	3.189999999999999e-105	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g9556	i0	95.885	248.367346938776	243	10	99	0	2	244	838	1080	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	60850	394	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
27828460	27828460	PRJNA1129273_P_NODE_8804_length_250_cov_1.728814_g8524_i0	PRJNA1129273	8804	250	1.728814	4.322035	Myxococcaceae bacterium	2484252	Bacteria	Bacteria	95.5	1.2299999999999997e-23	NR	MDB5213267.1	2484252	g8524	i0	69.6	3.276	69	21	82.8	0	208	2	1	69	MDB5213267.1 Acyl-CoA-binding protein [Myxococcaceae bacterium]	diamond	819	95.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae		Myxococcaceae bacterium
30038722	30038722	PRJNA1129273_P_NODE_3971_length_362_cov_1.031142_g3691_i0	PRJNA1129273	3971	362	1.031142	3.73273404	Nannocystaceae bacterium	2545255	Bacteria	Bacteria	50.1	3.63e-4	NR	MEZ4454641.1	2545255	g3691	i0	32.1	2.42817679558011	78	46	58.8	2	9	221	225	302	MEZ4454641.1 hypothetical protein [Nannocystaceae bacterium]	diamond	879	50.1	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae		Nannocystaceae bacterium
30323644	30323644	PRJNA1129273_P_NODE_10672_length_241_cov_2.750000_g10392_i0	PRJNA1129273	10672	241	2.75	6.6275	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	42.4	0.0465	NR	HEX2730302.1	2268199	g10392	i0	38.9	0.672199170124481	54	30	64.7	2	239	84	51	103	HEX2730302.1 hypothetical protein [Polyangiaceae bacterium]	diamond	162	42.4	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae bacterium
30544297	30544297	PRJNA1129273_P_NODE_7973_length_259_cov_1.446237_g7693_i0	PRJNA1129273	7973	259	1.446237	3.74575383	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	80.9	3.72e-17	NR	MBV8137980.1	2026735	g7693	i0	56.8	0.938223938223938	81	20	88	3	256	29	57	127	MBV8137980.1 class I SAM-dependent methyltransferase [Deltaproteobacteria bacterium]	diamond	243	80.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31050098	31050098	PRJNA1129273_P_NODE_10375_length_243_cov_0.905882_g10095_i0	PRJNA1129273	10375	243	0.905882	2.20129326	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	59.7	5.36e-9	NR	MBI4817722.1	2026735	g10095	i0	50	2.40740740740741	50	25	61.7	0	91	240	3	52	MBI4817722.1 MAPEG family protein [Deltaproteobacteria bacterium]	diamond	585	59.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
31133398	31133398	PRJNA1129273_P_NODE_9855_length_245_cov_0.906977_g9575_i0	PRJNA1129273	9855	245	0.906977	2.22209365	Myxococcia	32015	Bacteria	Bacteria	43.1	0.0268	NR	MBL8679454.1	2026763	g9575	i0	40	1.21224489795918	50	25	55.1	1	104	238	259	308	MBL8679454.1 trypsin-like serine protease [Myxococcales bacterium]	diamond	297	43.5	0.990804597701149	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
31334157	31334157	PRJNA1129273_P_NODE_9636_length_246_cov_1.456647_g9356_i0	PRJNA1129273	9636	246	1.456647	3.58335162	Myxococcales bacterium	2026763	Bacteria	Bacteria	42.7	0.0389	NR	HZR08877.1	2026763	g9356	i0	43.6	0.670731707317073	55	31	67.1	0	238	74	530	584	HZR08877.1 hypothetical protein [Myxococcales bacterium]	diamond	165	42.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales 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);;