metadata: contig_metadata: 14 rows where bioproject = "PRJNA1036688" and tax

14 rows where bioproject = "PRJNA1036688" 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
3996150	3996150	PRJNA1036688_P_NODE_3064_length_378_cov_3.058651_g2774_i0	PRJNA1036688	3064	378	3.058651	11.56170078	Pendulispora rubella	2741070	Bacteria	Bacteria	610	4.739999999999999e-170	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g2774	i0	95.767	152.518518518519	378	16	100	0	1	378	7289129	7289506	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	57652	610	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
5272482	5272482	PRJNA1036688_P_NODE_12005_length_152_cov_1.678261_g11713_i0	PRJNA1036688	12005	152	1.678261	2.55095672	Nannocystis pusilla	889268	Bacteria	Bacteria	193	7.02e-45	NTclustered	gi\|1386873113\|gb\|MF774780.1\|	889268	g11713	i0	89.474	130.026315789474	152	16	100	0	1	152	208	359	Nannocystis pusilla strain Na p29 23S ribosomal RNA gene, partial sequence	blastn	19764	193	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis pusilla
6111264	6111264	PRJNA1036688_P_NODE_7425_length_205_cov_1.851190_g7133_i0	PRJNA1036688	7425	205	1.85119	3.7949395	Archangium	47	Bacteria	Bacteria	294	2.69e-75	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g7133	i0	92.683	352.8	205	14	100	1	1	205	107195	106992	Archangium gephyra strain DSM 2261, complete genome	blastn	72324	294	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
7822291	7822291	PRJNA1036688_P_NODE_6147_length_236_cov_1.537688_g5855_i0	PRJNA1036688	6147	236	1.537688	3.62894368	Stigmatella aurantiaca	41	Bacteria	Bacteria	270	5.37e-68	NTclustered	gi\|2244675\|emb\|X87291.1\|	41	g5855	i0	87.607	345.546610169492	234	28	99	1	3	236	23	255	S.aurantiaca 23S rRNA gene	blastn	81549	270	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
8661269	8661269	PRJNA1036688_P_NODE_8307_length_191_cov_1.214286_g8015_i0	PRJNA1036688	8307	191	1.214286	2.31928626	Myxococcus	32	Bacteria	Bacteria	206	1.19e-48	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g8015	i0	86.243	34.8324607329843	189	26	99	0	3	191	2879	2691	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	6653	206	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
9097215	9097215	PRJNA1036688_P_NODE_10568_length_164_cov_1.976378_g10276_i0	PRJNA1036688	10568	164	1.976378	3.24125992	Sorangium cellulosum	56	Bacteria	Bacteria	183	4.65e-42	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g10276	i0	86.905	36.0853658536585	168	16	100	6	1	164	3449180	3449345	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	5918	183	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
12486984	12486984	PRJNA1036688_P_NODE_8470_length_188_cov_2.715232_g8178_i0	PRJNA1036688	8470	188	2.715232	5.10463616	Myxococcales	29	Bacteria	Bacteria	187	4.2299999999999985e-43	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g8178	i0	93.6	186.223404255319	125	8	66	0	64	188	3901	3777	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	35010	187	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
14198229	14198229	PRJNA1036688_P_NODE_11132_length_159_cov_1.893443_g10840_i0	PRJNA1036688	11132	159	1.893443	3.01057437	Pendulispora albinea	2741071	Bacteria	Bacteria	217	4.41e-52	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g10840	i0	91.25	167.477987421384	160	12	100	2	1	159	3589643	3589485	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	26629	217	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
15472503	15472503	PRJNA1036688_P_NODE_6493_length_226_cov_2.455026_g6201_i0	PRJNA1036688	6493	226	2.455026	5.54835876	Nannocystis exedens	54	Bacteria	Bacteria	324	3.86e-84	NTclustered	gi\|2244669\|emb\|X87286.1\|	54	g6201	i0	93.213	170.323008849558	221	14	97	1	3	222	668	888	N.exedens 23S rRNA gene	blastn	38493	324	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
16310468	16310468	PRJNA1036688_P_NODE_2633_length_419_cov_2.376963_g2343_i0	PRJNA1036688	2633	419	2.376963	9.95947497	root	1	Root_unresolved	Root_unresolved	425	2.06e-114	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g2343	i0	85.106	213.443914081146	423	55	100	7	1	419	9038213	9037795	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	89433	425	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
18021519	18021519	PRJNA1036688_P_NODE_1235_length_640_cov_9.116086_g983_i0	PRJNA1036688	1235	640	9.116086	58.3429504	Labilithrix luteola	1391654	Bacteria	Bacteria	913	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g983	i0	92.598	140.596875	635	47	99	0	1	635	7089816	7090450	Labilithrix luteola strain DSM 27648, complete genome	blastn	89982	913	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
18859726	18859726	PRJNA1036688_P_NODE_8935_length_182_cov_1.786207_g8643_i0	PRJNA1036688	8935	182	1.786207	3.25089674	Nannocystis	53	Bacteria	Bacteria	211	2.41e-50	NTclustered	gi\|2244669\|emb\|X87286.1\|	54	g8643	i0	87.912	73.4120879120879	182	19	99	3	3	182	749	569	N.exedens 23S rRNA gene	blastn	13361	213	0.990610328638498	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
19295503	19295503	PRJNA1036688_P_NODE_6816_length_218_cov_1.906077_g6524_i0	PRJNA1036688	6816	218	1.906077	4.15524786	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	303	4.82e-78	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g6524	i0	92.13	74.5045871559633	216	15	100	2	4	218	1383481	1383267	Anaeromyxobacter paludicola DNA, complete genome	blastn	16242	303	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
25234342	25234342	PRJNA1036688_P_NODE_9000_length_181_cov_2.381944_g8708_i0	PRJNA1036688	9000	181	2.381944	4.31131864	Corallococcus	83461	Bacteria	Bacteria	307	2.97e-79	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g8708	i0	97.238	248.491712707182	181	5	100	0	1	181	143100	142920	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	44977	307	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides

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