metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA1118794" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA1118794" 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
230440	230440	PRJNA1118794_P_NODE_20521_length_335_cov_4.339695_g19771_i0	PRJNA1118794	20521	335	4.339695	14.53797825	Nannocystis punicea	2995304	Bacteria	Bacteria	65.8	4.06e-6	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g19771	i0	100	0.683582089552239	35	0	10	0	299	333	12689874	12689840	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	229	65.8	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
2300244	2300244	PRJNA1118794_P_NODE_16002_length_367_cov_2.057823_g15252_i0	PRJNA1118794	16002	367	2.057823	7.55221041	root	1	Root_unresolved	Root_unresolved	556	6.06e-154	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g15252	i0	94.231	143.362397820163	364	21	99	0	4	367	1701	2064	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	52614	560	0.992857142857143	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
2300290	2300290	PRJNA1118794_P_NODE_26822_length_305_cov_3.780172_g26072_i0	PRJNA1118794	26822	305	3.780172	11.5295246	Pseudomonadati	3379134	Bacteria	Bacteria	78.7	4.69e-10	NTclustered	gi\|2108014508\|gb\|CP070770.1\|	2026735	g26072	i0	81.25	7.18032786885246	96	18	31	0	57	152	2856805	2856900	MAG: Deltaproteobacteria bacterium isolate bin23 chromosome	blastn	2190	78.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
3575530	3575530	PRJNA1118794_P_NODE_40203_length_268_cov_1.676923_g39453_i0	PRJNA1118794	40203	268	1.676923	4.49415364	Corallococcus	83461	Bacteria	Bacteria	222	1.77e-53	NTclustered	gi\|2851136330\|gb\|CP172866.1\|	184914	g39453	i0	84.12	19.1194029850746	233	33	86	4	38	268	3702514	3702284	Corallococcus coralloides strain KYC2213 chromosome, complete genome	blastn	5124	222	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
4057674	4057674	PRJNA1118794_P_NODE_51864_length_250_cov_0.870056_g51114_i0	PRJNA1118794	51864	250	0.870056	2.17514	Sorangium cellulosum	56	Bacteria	Bacteria	244	3.48e-60	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g51114	i0	85.356	81.976	239	31	95	4	1	237	3108569	3108333	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	20494	244	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
5333362	5333362	PRJNA1118794_P_NODE_13205_length_396_cov_1.430341_g12455_i0	PRJNA1118794	13205	396	1.430341	5.66415036	Pendulispora albinea	2741071	Bacteria	Bacteria	451	3.1999999999999997e-122	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g12455	i0	87.406	114.14898989899	397	44	99	4	3	396	3589474	3589081	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	45203	451	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
5334096	5334096	PRJNA1118794_P_NODE_71125_length_242_cov_0.911243_g70375_i0	PRJNA1118794	71125	242	0.911243	2.20520806	Cystobacter fuscus	43	Bacteria	Bacteria	206	1.58e-48	NTclustered	gi\|1243034522\|gb\|CP022098.1\|	43	g70375	i0	82.979	58.6157024793388	235	33	95	7	10	240	7209811	7209580	Cystobacter fuscus strain DSM 52655 chromosome, complete genome	blastn	14185	206	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
6127865	6127865	PRJNA1118794_P_NODE_33845_length_282_cov_2.210526_g33095_i0	PRJNA1118794	33845	282	2.210526	6.23368332	Haliangium	162027	Bacteria	Bacteria	298	3.03e-76	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g33095	i0	88.889	102.007092198582	243	26	99	1	40	282	1138	897	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	28766	298	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
6608739	6608739	PRJNA1118794_P_NODE_39006_length_271_cov_1.272727_g38256_i0	PRJNA1118794	39006	271	1.272727	3.44909017	Vulgatibacter incomptus	1391653	Bacteria	Bacteria	324	4.77e-84	NTclustered	gi\|913607065\|gb\|CP012332.1\|	1391653	g38256	i0	88.561	259.915129151292	271	26	100	5	1	271	179886	179621	Vulgatibacter incomptus strain DSM 27710, complete genome	blastn	70437	324	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Vulgatibacteraceae	Vulgatibacter	Vulgatibacter incomptus
7402726	7402726	PRJNA1118794_P_NODE_1586_length_1171_cov_2.278689_g1104_i0	PRJNA1118794	1586	1171	2.278689	26.68344819	Polyangiales	3031712	Bacteria	Bacteria	953	0	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g1104	i0	81.772	241.721605465414	1174	183	99	28	10	1169	13716242	13715086	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	283056	961	0.991675338189386	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
7402728	7402728	PRJNA1118794_P_NODE_16086_length_366_cov_2.344710_g15336_i0	PRJNA1118794	16086	366	2.34471	8.5816386	Myxococcaceae	31	Bacteria	Bacteria	348	3.96e-91	NTclustered	gi\|545790947\|gb\|KF270710.1\|	34	g15336	i0	84.225	210.245901639344	374	41	99	17	2	366	463	99	Myxococcus xanthus strain Mxx132 23S ribosomal RNA gene, partial sequence	blastn	76950	351	0.991452991452991	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
7402873	7402873	PRJNA1118794_P_NODE_646_length_1753_cov_7.872619_g390_i0	PRJNA1118794	646	1753	7.872619	138.00701107	Haliangium	162027	Bacteria	Bacteria	1384	0	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g390	i0	81.191	160.577866514546	1797	271	100	50	1	1753	1776	3	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	281493	1395	0.992114695340502	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
7883970	7883970	PRJNA1118794_P_NODE_67147_length_243_cov_1.676471_g66397_i0	PRJNA1118794	67147	243	1.676471	4.0738245300000004	Sorangium cellulosum	56	Bacteria	Bacteria	235	2.03e-57	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g66397	i0	84.519	63.2510288065844	239	35	98	2	7	243	3905866	3906104	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	15370	235	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
9158936	9158936	PRJNA1118794_P_NODE_9208_length_465_cov_1.609694_g8460_i0	PRJNA1118794	9208	465	1.609694	7.4850771	Pendulispora rubella	2741070	Bacteria	Bacteria	538	2.8399999999999987e-148	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g8460	i0	87.58	321.47311827957	467	54	100	4	1	465	7289539	7290003	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	149485	538	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
12503826	12503826	PRJNA1118794_P_NODE_33590_length_283_cov_1.447619_g32840_i0	PRJNA1118794	33590	283	1.447619	4.09676177	Sorangium	39643	Bacteria	Bacteria	254	6.67e-63	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g32840	i0	82.986	190.911660777385	288	41	99	6	1	282	4330515	4330800	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	54028	254	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
12503905	12503905	PRJNA1118794_P_NODE_650_length_1747_cov_7.756870_g390_i1	PRJNA1118794	650	1747	7.75687	135.5125189	Haliangium	162027	Bacteria	Bacteria	1415	0	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g390	i1	81.564	172.634230108758	1790	263	99	45	1	1746	1776	10	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	301592	1415	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
12984480	12984480	PRJNA1118794_P_NODE_36111_length_277_cov_1.500000_g35361_i0	PRJNA1118794	36111	277	1.5	4.155	Vulgatibacter incomptus	1391653	Bacteria	Bacteria	226	1.42e-54	NTclustered	gi\|913607065\|gb\|CP012332.1\|	1391653	g35361	i0	82.143	50.1913357400722	280	35	99	13	3	277	178990	178721	Vulgatibacter incomptus strain DSM 27710, complete genome	blastn	13903	226	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Vulgatibacteraceae	Vulgatibacter	Vulgatibacter incomptus
14260012	14260012	PRJNA1118794_P_NODE_66472_length_244_cov_0.900585_g65722_i0	PRJNA1118794	66472	244	0.900585	2.1974274	Stigmatella aurantiaca	41	Bacteria	Bacteria	416	6.769999999999999e-112	NTclustered	gi\|309390350\|gb\|CP002271.1\|	378806	g65722	i0	97.541	91.2581967213115	244	5	100	1	1	244	7829492	7829250	Stigmatella aurantiaca DW4/3-1, complete genome	blastn	22267	416	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
14260100	14260100	PRJNA1118794_P_NODE_74872_length_237_cov_2.737805_g74122_i0	PRJNA1118794	74872	237	2.737805	6.48859785	Stigmatella aurantiaca	41	Bacteria	Bacteria	416	6.5499999999999985e-112	NTclustered	gi\|2244675\|emb\|X87291.1\|	41	g74122	i0	98.312	245.742616033755	237	4	100	0	1	237	1254	1490	S.aurantiaca 23S rRNA gene	blastn	58241	416	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
15532906	15532906	PRJNA1118794_P_NODE_10053_length_445_cov_2.190860_g9305_i0	PRJNA1118794	10053	445	2.19086	9.749327	Vulgatibacter incomptus	1391653	Bacteria	Bacteria	518	3.53e-142	NTclustered	gi\|913607065\|gb\|CP012332.1\|	1391653	g9305	i0	87.778	134.676404494382	450	46	100	9	1	445	180437	179992	Vulgatibacter incomptus strain DSM 27710, complete genome	blastn	59931	518	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Vulgatibacteraceae	Vulgatibacter	Vulgatibacter incomptus
16807913	16807913	PRJNA1118794_P_NODE_474_length_1986_cov_13.041819_g274_i0	PRJNA1118794	474	1986	13.041819	259.01052534	Minicystis rosea	888845	Bacteria	Bacteria	2708	0	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g274	i0	91.296	162.309164149043	1999	153	100	17	1	1986	13717047	13715057	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	322346	2708	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
17602596	17602596	PRJNA1118794_P_NODE_10254_length_441_cov_1.885870_g9506_i0	PRJNA1118794	10254	441	1.88587	8.3166867	Pendulispora	3375062	Bacteria	Bacteria	521	2.7e-143	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g9506	i0	88.063	449.179138321995	444	47	100	6	1	441	3587755	3588195	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	198088	521	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
21426926	21426926	PRJNA1118794_P_NODE_29237_length_295_cov_2.427928_g28487_i0	PRJNA1118794	29237	295	2.427928	7.1623876	Sorangium	39643	Bacteria	Bacteria	453	6.420000000000001e-123	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g28487	i0	94.276	280.430508474576	297	15	100	2	1	295	3692099	3692395	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	82727	453	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
21908005	21908005	PRJNA1118794_P_NODE_698_length_1700_cov_4.384143_g427_i0	PRJNA1118794	698	1700	4.384143	74.530431	Pendulispora albinea	2741071	Bacteria	Bacteria	2279	0	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g427	i0	90.925	141.057058823529	1708	137	100	14	1	1700	7190417	7192114	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	239797	2279	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
24456586	24456586	PRJNA1118794_P_NODE_14600_length_380_cov_1.723127_g13850_i0	PRJNA1118794	14600	380	1.723127	6.5478826	Pendulispora brunnea	2905690	Bacteria	Bacteria	575	1.7399999999999994e-159	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g13850	i0	93.963	160.547368421053	381	21	99	2	2	380	9037361	9037741	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	61008	575	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
24456781	24456781	PRJNA1118794_P_NODE_29280_length_295_cov_1.729730_g28530_i0	PRJNA1118794	29280	295	1.72973	5.1027035	Sorangium cellulosum	56	Bacteria	Bacteria	346	1.12e-90	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g28530	i0	87.838	173.4	296	35	100	1	1	295	4849936	4849641	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	51153	346	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum

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