metadata: contig_metadata: 18 rows where bioproject = "PRJNA934472", tax_kingdom = "Pseudomonadati" and tax

18 rows where bioproject = "PRJNA934472", 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
2186725	2186725	PRJNA934472_P_NODE_8042_length_496_cov_2.730496_g7723_i0	PRJNA934472	8042	496	2.730496	13.54326016	Melittangium boletus	83453	Bacteria	Bacteria	902	0	NTclustered	gi\|1243026503\|gb\|CP022163.1\|	1294270	g7723	i0	99.595	219.493951612903	494	2	99	0	1	494	3597705	3597212	Melittangium boletus DSM 14713 chromosome, complete genome	blastn	108869	902	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Melittangium	Melittangium boletus
3807606	3807606	PRJNA934472_P_NODE_36403_length_247_cov_4.327586_g36025_i0	PRJNA934472	36403	247	4.327586	10.68913742	Pseudomonadati	3379134	Bacteria	Bacteria	438	1.4699999999999995e-118	NTclustered	gi\|28395338\|gb\|AY190663.1\|	56	g36025	i0	100	365.344129554656	237	0	96	0	11	247	420	184	Polyangium cellulosum strain So9881 clone 2 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	90240	438	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
7633617	7633617	PRJNA934472_P_NODE_18186_length_340_cov_1.228464_g17809_i0	PRJNA934472	18186	340	1.228464	4.1767776	Archangium	47	Bacteria	Bacteria	606	5.469999999999998e-169	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g17809	i0	98.824	276.961764705882	340	4	100	0	1	340	336832	336493	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	94167	606	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
11114494	11114494	PRJNA934472_P_NODE_19829_length_327_cov_0.893701_g19452_i0	PRJNA934472	19829	327	0.893701	2.92240227	Labilithrix luteola	1391654	Bacteria	Bacteria	512	1.17e-140	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g19452	i0	94.833	139.880733944954	329	15	100	1	1	327	3942508	3942180	Labilithrix luteola strain DSM 27648, complete genome	blastn	45741	512	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
13664541	13664541	PRJNA934472_P_NODE_25111_length_293_cov_1.977273_g24733_i0	PRJNA934472	25111	293	1.977273	5.79340989	Haliangium ochraceum	80816	Bacteria	Bacteria	187	7.139999999999998e-43	NTclustered	gi\|262076673\|gb\|CP001804.1\|	502025	g24733	i0	78.84	36.2491467576792	293	50	98	11	1	287	2900952	2901238	Haliangium ochraceum DSM 14365, complete genome	blastn	10621	187	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
13664855	13664855	PRJNA934472_P_NODE_39151_length_238_cov_4.406061_g38773_i0	PRJNA934472	39151	238	4.406061	10.48642518	Chondromyces crocatus	52	Bacteria	Bacteria	390	3.99e-104	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g38773	i0	96.218	168.239495798319	238	9	100	0	1	238	1161	1398	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	40041	390	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
17489397	17489397	PRJNA934472_P_NODE_31734_length_264_cov_1.612565_g31356_i0	PRJNA934472	31734	264	1.612565	4.2571716	Polyangium aurulentum	2567896	Bacteria	Bacteria	387	5.82e-103	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g31356	i0	93.182	76.9318181818182	264	17	100	1	1	264	443023	443285	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	20310	387	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
17489452	17489452	PRJNA934472_P_NODE_3414_length_729_cov_1.975610_g3129_i0	PRJNA934472	3414	729	1.97561	14.4021969	Pendulispora rubella	2741070	Bacteria	Bacteria	1127	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g3129	i0	94.543	181.758573388203	733	35	100	4	1	729	7289569	7288838	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	132502	1127	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
19106852	19106852	PRJNA934472_P_NODE_1375_length_1109_cov_3.013514_g1173_i0	PRJNA934472	1375	1109	3.013514	33.41987026	root	1	Root_unresolved	Root_unresolved	1517	0	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g1173	i0	91.39	124.312894499549	1115	84	100	12	1	1109	2995095	2993987	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	137863	1522	0.996714848883049	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
22587738	22587738	PRJNA934472_P_NODE_14178_length_380_cov_1.863192_g13801_i0	PRJNA934472	14178	380	1.863192	7.0801296	Melittangium boletus	83453	Bacteria	Bacteria	693	0	NTclustered	gi\|1243026503\|gb\|CP022163.1\|	1294270	g13801	i0	99.735	258.805263157895	378	1	99	0	1	378	3597850	3598227	Melittangium boletus DSM 14713 chromosome, complete genome	blastn	98346	693	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Melittangium	Melittangium boletus
22933337	22933337	PRJNA934472_P_NODE_22018_length_311_cov_3.071429_g21640_i0	PRJNA934472	22018	311	3.071429	9.55214419	root	1	Root_unresolved	Root_unresolved	298	3.38e-76	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g21640	i0	85.034	254.466237942122	294	42	94	2	17	309	9037910	9038202	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	79139	298	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
22933368	22933368	PRJNA934472_P_NODE_26798_length_285_cov_1.452830_g26420_i0	PRJNA934472	26798	285	1.45283	4.1405655	Pendulispora	3375062	Bacteria	Bacteria	409	1.3599999999999998e-109	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g26420	i0	92.632	160.150877192982	285	20	100	1	1	285	7191291	7191574	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	45643	411	0.995133819951338	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
22933401	22933401	PRJNA934472_P_NODE_33718_length_256_cov_1.967213_g33340_i0	PRJNA934472	33718	256	1.967213	5.03606528	Stigmatella	40	Bacteria	Bacteria	351	2.05e-92	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g33340	i0	91.44	463.34375	257	20	100	2	1	256	62	317	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	118616	351	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
23863264	23863264	PRJNA934472_P_NODE_23079_length_305_cov_1.431034_g22701_i0	PRJNA934472	23079	305	1.431034	4.3646537	uncultured Polyangiaceae bacterium	417999	Bacteria	Bacteria	549	8.27e-152	NTclustered	gi\|545342541\|gb\|KF505773.1\|	417999	g22701	i0	99.023	101.737704918033	307	1	100	2	1	305	192	498	Uncultured Polyangiaceae bacterium clone 5257 16S ribosomal RNA gene, partial sequence	blastn	31030	549	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		uncultured Polyangiaceae bacterium
26866975	26866975	PRJNA934472_P_NODE_37681_length_244_cov_1.543860_g37303_i0	PRJNA934472	37681	244	1.54386	3.7670184	Archangiaceae bacterium	2684409	Bacteria	Bacteria	105	2.86e-24	NR	MBM4783105.1	2684409	g37303	i0	80.2	0.995901639344262	81	16	99.6	0	2	244	240	320	MBM4783105.1 hypothetical protein [Archangiaceae bacterium]	diamond	243	105	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae		Archangiaceae bacterium
29898721	29898721	PRJNA934472_P_NODE_31011_length_267_cov_1.396907_g30633_i0	PRJNA934472	31011	267	1.396907	3.72974169	Polyangia bacterium	3058050	Bacteria	Bacteria	96.3	1.0499999999999999e-23	NR	HEX7506017.1	3058050	g30633	i0	92.6	1.84269662921348	54	4	60.7	0	162	1	1	54	HEX7506017.1 cyclic nucleotide-binding domain-containing protein [Polyangia bacterium]	diamond	492	96.3	1	Bacteria	Pseudomonadati	Myxococcota					Polyangia bacterium
30436017	30436017	PRJNA934472_P_NODE_39613_length_233_cov_2.075000_g39235_i0	PRJNA934472	39613	233	2.075	4.83475	Hyalangium sp.	2028555	Bacteria	Bacteria	103	4.449999999999999e-24	NR	WP_407742696.1	2028555	g39235	i0	58.4	2.93562231759657	77	32	99.1	0	233	3	17	93	WP_407742696.1 amidohydrolase family protein [Hyalangium sp.]	diamond	684	103	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Hyalangium	Hyalangium sp.
32016386	32016386	PRJNA934472_P_NODE_37018_length_246_cov_0.890173_g36640_i0	PRJNA934472	37018	246	0.890173	2.18982558	Polyangiaceae bacterium	2268199	Bacteria	Bacteria	84.7	3.67e-17	NR	HZO15549.1	2268199	g36640	i0	52.1	0.865853658536585	71	33	86.6	1	240	28	262	331	HZO15549.1 hypothetical protein [Polyangiaceae bacterium]	diamond	213	84.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		Polyangiaceae 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);;