metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA1137393" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA1137393" 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
1559229	1559229	PRJNA1137393_P_NODE_11302_length_247_cov_6.095960_g10786_i0	PRJNA1137393	11302	247	6.09596	15.0570212	Archangium violaceum	83451	Bacteria	Bacteria	320	5.54e-83	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g10786	i0	90.244	255.279352226721	246	22	99	2	3	247	585330	585086	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	63054	320	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
1559332	1559332	PRJNA1137393_P_NODE_44302_length_168_cov_0.873950_g43786_i0	PRJNA1137393	44302	168	0.87395	1.468236	Vulgatibacter incomptus	1391653	Bacteria	Bacteria	134	4.9000000000000005e-27	NTclustered	gi\|913607065\|gb\|CP012332.1\|	1391653	g43786	i0	82.781	1.92857142857143	151	24	89	2	4	153	4205002	4204853	Vulgatibacter incomptus strain DSM 27710, complete genome	blastn	324	134	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Vulgatibacteraceae	Vulgatibacter	Vulgatibacter incomptus
4111770	4111770	PRJNA1137393_P_NODE_4304_length_438_cov_1.359897_g3790_i0	PRJNA1137393	4304	438	1.359897	5.95634886	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	244	6.51e-60	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g3790	i0	83.271	20.7716894977169	269	41	61	4	28	293	1383776	1383509	Anaeromyxobacter paludicola DNA, complete genome	blastn	9098	244	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
6662543	6662543	PRJNA1137393_P_NODE_286_length_1760_cov_8.794857_g170_i0	PRJNA1137393	286	1760	8.794857	154.7894832	Minicystis rosea	888845	Bacteria	Bacteria	2084	0	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g170	i0	88.139	153.379545454545	1779	175	100	28	1	1760	13716822	13715061	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	269948	2084	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
8685216	8685216	PRJNA1137393_P_NODE_8347_length_288_cov_7.359833_g7831_i0	PRJNA1137393	8347	288	7.359833	21.19631904	Nannocystis	53	Bacteria	Bacteria	444	3.76e-120	NTclustered	gi\|2244669\|emb\|X87286.1\|	54	g7831	i0	94.444	215.625	288	16	100	0	1	288	2444	2157	N.exedens 23S rRNA gene	blastn	62100	444	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
10488233	10488233	PRJNA1137393_P_NODE_27769_length_185_cov_1.330882_g27253_i0	PRJNA1137393	27769	185	1.330882	2.4621317	Sorangium cellulosum	56	Bacteria	Bacteria	211	2.46e-50	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g27253	i0	89.017	4.69189189189189	173	15	92	4	1	171	5625091	5624921	Sorangium cellulosum 'So ce 56' complete genome	blastn	868	211	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
11235375	11235375	PRJNA1137393_P_NODE_11129_length_249_cov_1.800000_g10613_i0	PRJNA1137393	11129	249	1.8	4.482	Bacteria	2	Bacteria	Bacteria	279	9.5e-71	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g10613	i0	87.2	121.55421686747	250	26	99	6	2	249	3449944	3449699	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	30267	279	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
12510754	12510754	PRJNA1137393_P_NODE_11770_length_243_cov_1.582474_g11254_i0	PRJNA1137393	11770	243	1.582474	3.84541182	Sorangium	39643	Bacteria	Bacteria	278	3.3200000000000004e-70	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g11254	i0	87.243	295.942386831276	243	31	100	0	1	243	4330506	4330748	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	71914	278	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
14313645	14313645	PRJNA1137393_P_NODE_33672_length_176_cov_1.488189_g33156_i0	PRJNA1137393	33672	176	1.488189	2.61921264	Melittangium boletus	83453	Bacteria	Bacteria	106	1.12e-18	NTclustered	gi\|1243026503\|gb\|CP022163.1\|	1294270	g33156	i0	96.825	9.64204545454546	63	2	36	0	56	118	4717511	4717449	Melittangium boletus DSM 14713 chromosome, complete genome	blastn	1697	106	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Melittangium	Melittangium boletus
14313770	14313770	PRJNA1137393_P_NODE_70352_length_162_cov_0.920354_g69836_i0	PRJNA1137393	70352	162	0.920354	1.49097348	Stigmatella aurantiaca	41	Bacteria	Bacteria	76.8	8e-10	NTclustered	gi\|309390350\|gb\|CP002271.1\|	378806	g69836	i0	80.198	0.623456790123457	101	20	62	0	9	109	2857927	2858027	Stigmatella aurantiaca DW4/3-1, complete genome	blastn	101	76.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
15059724	15059724	PRJNA1137393_P_NODE_21932_length_196_cov_1.891156_g21416_i0	PRJNA1137393	21932	196	1.891156	3.70666576	Myxococcales	29	Bacteria	Bacteria	228	2.619999999999999e-55	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g21416	i0	91.515	219.280612244898	165	14	84	0	2	166	3844	3680	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	42979	230	0.991304347826087	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
15059802	15059802	PRJNA1137393_P_NODE_6652_length_330_cov_7.651246_g6136_i0	PRJNA1137393	6652	330	7.651246	25.2491118	Archangium	47	Bacteria	Bacteria	555	1.9399999999999994e-153	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g6136	i0	96.97	298.036363636364	330	10	100	0	1	330	5101198	5100869	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	98352	555	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
15059805	15059805	PRJNA1137393_P_NODE_6752_length_327_cov_16.985612_g6236_i0	PRJNA1137393	6752	327	16.985612	55.54295124	Sorangium	39643	Bacteria	Bacteria	448	3.359999999999999e-121	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g6236	i0	91.411	272.544342507645	326	28	99	0	2	327	3692394	3692069	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	89122	448	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
16861756	16861756	PRJNA1137393_P_NODE_13494_length_230_cov_2.596685_g12978_i0	PRJNA1137393	13494	230	2.596685	5.9723755	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	183	6.979999999999997e-42	NTclustered	gi\|1958031866\|gb\|CP064976.1\|	2026735	g12978	i0	81.659	104.530434782609	229	34	99	4	3	230	2385083	2384862	MAG: Deltaproteobacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.279_cln chromosome, complete genome	blastn	24042	183	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
16861765	16861765	PRJNA1137393_P_NODE_15874_length_218_cov_1.230769_g15358_i0	PRJNA1137393	15874	218	1.230769	2.68307642	Myxococcales bacterium	2026763	Bacteria	Bacteria	143	1.11e-29	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g15358	i0	78.924	76.3394495412844	223	37	100	10	1	218	1312731	1312514	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	16642	143	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
16861774	16861774	PRJNA1137393_P_NODE_1914_length_716_cov_2.404798_g1462_i0	PRJNA1137393	1914	716	2.404798	17.21835368	Vulgatibacter incomptus	1391653	Bacteria	Bacteria	558	3.46e-154	NTclustered	gi\|913607065\|gb\|CP012332.1\|	1391653	g1462	i0	81.25	236.826815642458	720	110	99	22	3	708	179256	178548	Vulgatibacter incomptus strain DSM 27710, complete genome	blastn	169568	558	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Vulgatibacteraceae	Vulgatibacter	Vulgatibacter incomptus
18136389	18136389	PRJNA1137393_P_NODE_2295_length_643_cov_18.383838_g1816_i0	PRJNA1137393	2295	643	18.383838	118.20807834	Nannocystis punicea	2995304	Bacteria	Bacteria	841	0	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g1816	i0	90.498	145.830482115086	642	53	99	4	2	641	7595821	7595186	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	93769	841	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
18136433	18136433	PRJNA1137393_P_NODE_37835_length_171_cov_0.926230_g37319_i0	PRJNA1137393	37835	171	0.92623	1.5838533	Minicystis rosea	888845	Bacteria	Bacteria	202	1.34e-47	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g37319	i0	87.931	32.7777777777778	174	17	100	4	1	171	768848	769020	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	5605	202	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
18136561	18136561	PRJNA1137393_P_NODE_6755_length_327_cov_10.496403_g6239_i0	PRJNA1137393	6755	327	10.496403	34.32323781	Sorangium cellulosum	56	Bacteria	Bacteria	429	1.2199999999999999e-115	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g6239	i0	90.303	291.207951070336	330	28	100	4	1	327	3451863	3451535	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	95225	429	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
20158494	20158494	PRJNA1137393_P_NODE_276_length_1782_cov_274.842470_g165_i0	PRJNA1137393	276	1782	274.84247	4897.6928154	Sorangium	39643	Bacteria	Bacteria	2041	0	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g165	i0	87.388	136.221099887767	1792	208	100	17	1	1782	1	1784	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	242746	2041	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
20158570	20158570	PRJNA1137393_P_NODE_7856_length_298_cov_4.875502_g7340_i0	PRJNA1137393	7856	298	4.875502	14.52899596	Archangium	47	Bacteria	Bacteria	377	4.02e-100	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g7340	i0	89.597	256.063758389262	298	30	100	1	1	298	5100355	5100059	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	76307	377	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
20686247	20686247	PRJNA1137393_P_NODE_64557_length_164_cov_0.860870_g64041_i0	PRJNA1137393	64557	164	0.86087	1.4118268	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	152	1.31e-32	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g64041	i0	84.868	83.4207317073171	152	22	92	1	8	158	546776	546625	Anaeromyxobacter oryzae DNA, complete genome	blastn	13681	152	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
21434042	21434042	PRJNA1137393_P_NODE_7817_length_299_cov_2.876000_g7301_i0	PRJNA1137393	7817	299	2.876	8.59924	Stigmatella	40	Bacteria	Bacteria	263	1.18e-65	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g7301	i0	82.895	140.732441471572	304	40	99	7	1	298	1684	1387	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	42079	263	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
21961613	21961613	PRJNA1137393_P_NODE_6518_length_334_cov_12.922807_g6002_i0	PRJNA1137393	6518	334	12.922807	43.16217538	Nannocystis punicea	2995304	Bacteria	Bacteria	62.1	5.23e-5	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g6002	i0	100	0.62874251497006	33	0	10	0	302	334	12689874	12689842	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	210	62.1	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
23237082	23237082	PRJNA1137393_P_NODE_5459_length_374_cov_1.113846_g4943_i0	PRJNA1137393	5459	374	1.113846	4.16578404	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	647	0	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g4943	i0	97.861	632.593582887701	374	8	100	0	1	374	947203	947576	Anaeromyxobacter oryzae DNA, complete genome	blastn	236590	647	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
23984356	23984356	PRJNA1137393_P_NODE_1819_length_736_cov_10.429403_g1374_i0	PRJNA1137393	1819	736	10.429403	76.76040608	Stigmatella	40	Bacteria	Bacteria	784	0	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g1374	i0	86.062	238.858695652174	739	92	99	11	3	736	1106	1838	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	175800	784	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
24510614	24510614	PRJNA1137393_P_NODE_19960_length_202_cov_1.385621_g19444_i0	PRJNA1137393	19960	202	1.385621	2.79895442	Myxococcales bacterium	2026763	Bacteria	Bacteria	195	2.76e-45	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g19444	i0	84.158	463.450495049505	202	31	100	1	1	202	1312106	1311906	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	93617	195	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);;