metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA356682" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA356682" 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
398115	398115	PRJNA356682_P_NODE_881_length_1701_cov_29.980958_g551_i1	PRJNA356682	881	1701	29.980958	509.97609558	Minicystis rosea	888845	Bacteria	Bacteria	1749	0	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g551	i1	85.398	150.321575543798	1719	214	99	33	5	1701	13715059	13716762	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	255697	1749	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
5500918	5500918	PRJNA356682_P_NODE_16785_length_348_cov_7.374545_g16094_i0	PRJNA356682	16785	348	7.374545	25.6634166	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	243	1.8200000000000002e-59	NTclustered	gi\|1950807334\|gb\|CP066680.1\|	2026735	g16094	i0	82.474	168.166666666667	291	37	81	12	19	301	309201	309485	MAG: Deltaproteobacteria bacterium isolate NC_groundwater_69_Ag_B-0.1um_32_21 chromosome	blastn	58522	243	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
5501430	5501430	PRJNA356682_P_NODE_39705_length_247_cov_0.885057_g39014_i0	PRJNA356682	39705	247	0.885057	2.18609079	Pendulispora rubella	2741070	Bacteria	Bacteria	215	2.69e-51	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g39014	i0	84.404	4.44939271255061	218	34	88	0	20	237	12170455	12170672	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	1099	215	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
6174967	6174967	PRJNA356682_P_NODE_1025_length_1561_cov_10.882392_g654_i0	PRJNA356682	1025	1561	10.882392	169.87413912	root	1	Root_unresolved	Root_unresolved	2196	0	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g654	i0	92.097	120.376040999359	1569	108	100	15	1	1561	18	1578	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	187907	2211	0.993215739484396	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
9325941	9325941	PRJNA356682_P_NODE_41928_length_244_cov_0.900585_g41237_i0	PRJNA356682	41928	244	0.900585	2.1974274	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	206	1.6e-48	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g41237	i0	83.186	3.13114754098361	226	36	92	2	20	244	2839776	2839552	Anaeromyxobacter oryzae DNA, complete genome	blastn	764	206	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
10000267	10000267	PRJNA356682_P_NODE_15468_length_360_cov_11.773519_g14778_i0	PRJNA356682	15468	360	11.773519	42.3846684	Pendulispora	3375062	Bacteria	Bacteria	516	1.01e-141	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g14778	i0	92.5	160.461111111111	360	27	100	0	1	360	7287857	7287498	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	57766	516	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
10601167	10601167	PRJNA356682_P_NODE_21649_length_311_cov_9.214286_g20958_i0	PRJNA356682	21649	311	9.214286	28.65642946	Cystobacter fuscus	43	Bacteria	Bacteria	346	1.19e-90	NTclustered	gi\|2579656172\|gb\|CP043491.1\|	43	g20958	i0	87.179	222.565916398714	312	30	99	7	1	309	7406626	7406322	Cystobacter fuscus strain Cbf 10 chromosome, complete genome	blastn	69218	346	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
11876593	11876593	PRJNA356682_P_NODE_45030_length_241_cov_0.916667_g44339_i0	PRJNA356682	45030	241	0.916667	2.20916747	Myxococcus xanthus	34	Bacteria	Bacteria	429	8.58e-116	NTclustered	gi\|1957989826\|gb\|CP068048.1\|	34	g44339	i0	98.755	23.2738589211618	241	3	100	0	1	241	9231635	9231875	Myxococcus xanthus strain R31 chromosome, complete genome	blastn	5609	429	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
13151204	13151204	PRJNA356682_P_NODE_2671_length_905_cov_9.137019_g2084_i0	PRJNA356682	2671	905	9.137019	82.69002195	Pendulispora rubella	2741070	Bacteria	Bacteria	1151	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g2084	i0	89.735	124.420994475138	906	86	99	6	1	904	7290002	7289102	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	112601	1151	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
15099905	15099905	PRJNA356682_P_NODE_14192_length_375_cov_5.943709_g13502_i0	PRJNA356682	14192	375	5.943709	22.28890875	Sorangium	39643	Bacteria	Bacteria	244	5.49e-60	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g13502	i0	81.388	199.44	317	44	82	11	67	370	3689796	3690110	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	74790	244	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
15100404	15100404	PRJNA356682_P_NODE_852_length_1747_cov_66.850657_g532_i0	PRJNA356682	852	1747	66.850657	1167.88097779	Pendulispora	3375062	Bacteria	Bacteria	1978	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g532	i0	87.217	174.301087578706	1768	189	99	32	1	1746	9854163	9852411	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	304504	1986	0.995971802618328	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
18249072	18249072	PRJNA356682_P_NODE_23855_length_299_cov_1.730088_g23164_i0	PRJNA356682	23855	299	1.730088	5.17296312	Myxococcales bacterium	2026763	Bacteria	Bacteria	464	3.0099999999999996e-126	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g23164	i0	94.667	61.695652173913	300	14	100	2	1	299	1312986	1312688	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	18447	464	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
18923845	18923845	PRJNA356682_P_NODE_3555_length_761_cov_8.537791_g2917_i0	PRJNA356682	3555	761	8.537791	64.97258951	Myxococcaceae	31	Bacteria	Bacteria	745	0	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g2917	i0	85.195	218.220762155059	743	91	96	19	29	761	3676	4409	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	166066	745	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
20799558	20799558	PRJNA356682_P_NODE_877_length_1708_cov_27.154128_g551_i0	PRJNA356682	877	1708	27.154128	463.79250624	Minicystis rosea	888845	Bacteria	Bacteria	1834	0	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g551	i0	86.195	151.080210772834	1724	205	99	29	5	1708	13715059	13716769	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	258045	1834	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
21474266	21474266	PRJNA356682_P_NODE_8577_length_477_cov_22.242574_g7888_i0	PRJNA356682	8577	477	22.242574	106.09707798	Myxococcaceae	31	Bacteria	Bacteria	662	0	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g7888	i0	91.841	324.03144654088	478	33	100	4	1	477	379937	379465	Myxococcus xanthus strain DK1050 chromosome	blastn	154563	665	0.995488721804511	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
22074283	22074283	PRJNA356682_P_NODE_35678_length_251_cov_1.842697_g34987_i0	PRJNA356682	35678	251	1.842697	4.62516947	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|152026452\|gb\|CP000769.1\|	404589	g34987	i0	100	0.111553784860558	28	0	11	0	170	197	5163841	5163868	Anaeromyxobacter sp. Fw109-5, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
22749434	22749434	PRJNA356682_P_NODE_8198_length_488_cov_13.925301_g7509_i0	PRJNA356682	8198	488	13.925301	67.95546888	Stigmatella	40	Bacteria	Bacteria	645	1.7199999999999994e-180	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g7509	i0	90.871	275.768442622951	482	42	99	2	8	488	287	767	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	134575	645	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
24624070	24624070	PRJNA356682_P_NODE_41920_length_244_cov_0.900585_g41229_i0	PRJNA356682	41920	244	0.900585	2.1974274	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	124	4.599999999999999e-24	NTclustered	gi\|2108117163\|gb\|CP070734.1\|	2026735	g41229	i0	86.726	0.463114754098361	113	13	46	2	133	244	1378532	1378421	MAG: Deltaproteobacteria bacterium isolate bin407 chromosome	blastn	113	124	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria 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);;