metadata: contig_metadata: 21 rows where bioproject = "PRJEB8827", tax_kingdom = "Pseudomonadati" and tax

21 rows where bioproject = "PRJEB8827", tax_kingdom = "Pseudomonadati" 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
25617535	25617535	PRJEB8827b_S_NODE_10561_length_193_cov_3.924051_g10509_i0	PRJEB8827	10561	193	3.924051	7.57341843	root	1	Root_unresolved	Root_unresolved	211	2.59e-50	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g10509	i0	96.825	73.2383419689119	126	4	65	0	36	161	3690788	3690663	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	14135	211	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
25617549	25617549	PRJEB8827b_S_NODE_35169_length_169_cov_2.194030_g35117_i0	PRJEB8827	35169	169	2.19403	3.7079107	Sorangium	39643	Bacteria	Bacteria	267	4.63e-67	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g35117	i0	97.436	407.970414201183	156	4	92	0	14	169	6777321	6777476	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	68947	267	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
25665471	25665471	PRJEB8827b_S_NODE_58_length_766_cov_4.049248_g14_i0	PRJEB8827	58	766	4.049248	31.01723968	Minicystis rosea	888845	Bacteria	Bacteria	913	0	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g14	i0	96.886	174.607049608355	546	15	71	2	3	547	769479	770023	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	133749	913	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
25665695	25665695	PRJEB8827e_S_NODE_426_length_521_cov_25.576132_g404_i0	PRJEB8827	426	521	25.576132	133.25164772	Minicystis rosea	888845	Bacteria	Bacteria	747	0	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g404	i0	93.452	115.982725527831	504	32	97	1	1	503	769969	770472	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	60427	747	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
25801595	25801595	PRJEB8827b_S_NODE_5635_length_206_cov_1.309942_g5583_i0	PRJEB8827	5635	206	1.309942	2.69848052	Myxococcales bacterium	2026763	Bacteria	Bacteria	116	8.47e-31	NR	MSP25910.1	2026763	g5583	i0	80.7	0.830097087378641	57	11	83	0	6	176	136	192	MSP25910.1 superoxide dismutase [Myxococcales bacterium]	diamond	171	116	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
25802338	25802338	PRJEB8827g_S_NODE_2155_length_218_cov_39.748634_g2134_i0	PRJEB8827	2155	218	39.748634	86.65202212	uncultured Sorangium sp.	491148	Bacteria	Bacteria	239	1.38e-58	NTclustered	gi\|310755296\|gb\|HQ213186.1\|	491148	g2134	i0	100	80.9816513761468	129	0	59	0	28	156	1101	1229	Uncultured Sorangium sp. clone 3_E21 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	17654	239	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	uncultured Sorangium sp.
25937807	25937807	PRJEB8827b_S_NODE_1156_length_279_cov_10.344262_g1104_i0	PRJEB8827	1156	279	10.344262	28.86049098	Sorangium cellulosum So ce56	448385	Bacteria	Bacteria	394	3.709999999999999e-105	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g1104	i0	97.021	238.139784946237	235	6	84	1	25	258	3488253	3488019	Sorangium cellulosum 'So ce 56' complete genome	blastn	66441	394	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
25938357	25938357	PRJEB8827f_S_NODE_3188_length_246_cov_43.473934_g3168_i0	PRJEB8827	3188	246	43.473934	106.94587764	Pendulispora rubella	2741070	Bacteria	Bacteria	246	9.5e-61	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g3168	i0	87.383	117.243902439024	214	27	87	0	1	214	7289802	7290015	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	28842	246	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
26026034	26026034	PRJEB8827f_S_NODE_476_length_448_cov_36.409201_g456_i0	PRJEB8827	476	448	36.409201	163.11322048	Polyangiaceae	49	Bacteria	Bacteria	664	0	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g456	i0	95.642	198.377232142857	413	18	92	0	35	447	3692402	3691990	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	88873	669	0.992526158445441	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
26073813	26073813	PRJEB8827c_S_NODE_1221_length_174_cov_1.366906_g1208_i0	PRJEB8827	1221	174	1.366906	2.37841644	Polyangium aurulentum	2567896	Bacteria	Bacteria	213	6.35e-51	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g1208	i0	88.636	32.9137931034483	176	18	100	1	1	174	443120	443295	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	5727	213	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
26210487	26210487	PRJEB8827f_S_NODE_22_length_1141_cov_20.405063_g17_i0	PRJEB8827	22	1141	20.405063	232.82176883	Minicystis rosea	888845	Bacteria	Bacteria	1664	0	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g17	i0	93.363	145.052585451358	1130	67	99	8	1	1125	13716120	13714994	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	165505	1664	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
26210550	26210550	PRJEB8827f_S_NODE_30_length_1096_cov_19.635250_g17_i1	PRJEB8827	30	1096	19.63525	215.20234	Minicystis rosea	888845	Bacteria	Bacteria	1312	0	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g17	i1	89.893	152.521897810219	1029	91	93	13	59	1080	13716016	13714994	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	167164	1312	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
26210678	26210678	PRJEB8827f_S_NODE_590_length_425_cov_46.964103_g570_i0	PRJEB8827	590	425	46.964103	199.59743775	Minicystis rosea	888845	Bacteria	Bacteria	568	3.289999999999999e-157	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g570	i0	94.34	99.9411764705882	371	20	87	1	56	425	770472	770102	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	42475	568	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
26297888	26297888	PRJEB8827f_S_NODE_11358_length_178_cov_3.944056_g11338_i0	PRJEB8827	11358	178	3.944056	7.02041968	Corallococcus	83461	Bacteria	Bacteria	180	6.62e-41	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g11338	i0	85.393	184.095505617978	178	21	98	4	1	174	142592	142416	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	32769	180	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
26298020	26298020	PRJEB8827h_S_NODE_1126_length_282_cov_14.412955_g1107_i0	PRJEB8827	1126	282	14.412955	40.6445331	root	1	Root_unresolved	Root_unresolved	350	8.239999999999999e-92	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g1107	i0	93.277	147.758865248227	238	15	84	1	45	282	899	663	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	41668	350	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
26434018	26434018	PRJEB8827f_S_NODE_3327_length_242_cov_6.391304_g3307_i0	PRJEB8827	3327	242	6.391304	15.46695568	Stigmatella	40	Bacteria	Bacteria	351	1.92e-92	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g3307	i0	94.69	243.326446280992	226	12	93	0	17	242	228	3	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	58885	351	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
26434116	26434116	PRJEB8827h_S_NODE_1407_length_261_cov_11.106195_g1388_i0	PRJEB8827	1407	261	11.106195	28.98716895	Sorangium	39643	Bacteria	Bacteria	357	4.4999999999999997e-94	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g1388	i0	95.928	184.662835249042	221	8	87	1	19	238	2993962	2994182	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	48197	357	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
26482123	26482123	PRJEB8827b_S_NODE_2088_length_239_cov_5.808824_g2036_i0	PRJEB8827	2088	239	5.808824	13.88308936	Polyangium aurulentum	2567896	Bacteria	Bacteria	255	1.53e-63	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g2036	i0	89.268	28.4769874476987	205	20	85	1	19	221	443303	443099	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	6806	255	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
26482960	26482960	PRJEB8827h_S_NODE_2768_length_217_cov_1139.280220_g2749_i0	PRJEB8827	2768	217	1139.28022	2472.2380774	uncultured Sorangium sp.	491148	Bacteria	Bacteria	239	1.37e-58	NTclustered	gi\|310755296\|gb\|HQ213186.1\|	491148	g2749	i0	100	79.1705069124424	129	0	59	0	54	182	1229	1101	Uncultured Sorangium sp. clone 3_E21 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	17180	239	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	uncultured Sorangium sp.
32931339	32931339	PRJEB8827h_S_NODE_2465_length_222_cov_2.491979_g2446_i0	PRJEB8827	2465	222	2.491979	5.53219338	Myxococcota bacterium	2818507	Bacteria	Bacteria	53.9	3.3e-6	NR	MFK7930480.1	2818507	g2446	i0	72.5	1.43243243243243	40	9	54.1	1	144	25	488	525	MFK7930480.1 ATP-binding protein [Myxococcota bacterium]	diamond	318	53.9	1	Bacteria	Pseudomonadati	Myxococcota					Myxococcota bacterium
33025985	33025985	PRJEB8827f_S_NODE_17380_length_168_cov_2.105263_g17360_i0	PRJEB8827	17380	168	2.105263	3.53684184	Pseudomonadati	3379134	Bacteria	Bacteria	85.1	4.58e-18	NR	MCL5126502.1	2026735	g17360	i0	78.8	15.8035714285714	52	11	92.9	0	168	13	241	292	MCL5126502.1 acetyl-CoA C-acyltransferase [Deltaproteobacteria bacterium]	diamond	2655	85.1	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);;