metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA841653" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA841653" 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
830029	830029	PRJNA841653_P_NODE_12221_length_474_cov_3.543641_g11550_i0	PRJNA841653	12221	474	3.543641	16.79685834	Polyangium aurulentum	2567896	Bacteria	Bacteria	721	0	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g11550	i0	94.093	175.318565400844	474	28	100	0	1	474	442700	442227	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	83101	721	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
830681	830681	PRJNA841653_P_NODE_45241_length_250_cov_0.870056_g44567_i0	PRJNA841653	45241	250	0.870056	2.17514	Sorangium cellulosum	56	Bacteria	Bacteria	89.8	1.73e-13	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g44567	i0	82.857	0.764	105	12	40	6	123	223	926217	926319	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	191	89.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
830752	830752	PRJNA841653_P_NODE_48861_length_248_cov_0.880000_g48187_i0	PRJNA841653	48861	248	0.88	2.1824	Labilithrix luteola	1391654	Bacteria	Bacteria	230	9.65e-56	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g48187	i0	85.65	6.25	223	26	89	4	29	248	3215084	3215303	Labilithrix luteola strain DSM 27648, complete genome	blastn	1550	230	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
830793	830793	PRJNA841653_P_NODE_51541_length_247_cov_0.885057_g50867_i0	PRJNA841653	51541	247	0.885057	2.18609079	Myxococcus stipitatus	83455	Bacteria	Bacteria	281	2.62e-71	NTclustered	gi\|2700865302\|gb\|CP147913.1\|	83455	g50867	i0	87.654	11.7368421052632	243	28	98	2	1	242	542254	542013	Myxococcus stipitatus strain KYC2006 chromosome, complete genome	blastn	2899	281	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
831004	831004	PRJNA841653_P_NODE_6281_length_679_cov_2.676568_g5651_i0	PRJNA841653	6281	679	2.676568	18.17389672	Labilithrix luteola	1391654	Bacteria	Bacteria	806	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g5651	i0	88.253	133.120765832106	681	71	99	9	1	676	3942433	3941757	Labilithrix luteola strain DSM 27648, complete genome	blastn	90389	806	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
3381714	3381714	PRJNA841653_P_NODE_56963_length_244_cov_0.900585_g56289_i0	PRJNA841653	56963	244	0.900585	2.1974274	Labilithrix luteola	1391654	Bacteria	Bacteria	305	1.53e-78	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g56289	i0	90.213	2.88934426229508	235	21	96	2	6	239	8811450	8811217	Labilithrix luteola strain DSM 27648, complete genome	blastn	705	305	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
3381812	3381812	PRJNA841653_P_NODE_62483_length_241_cov_0.916667_g61809_i0	PRJNA841653	62483	241	0.916667	2.20916747	Labilithrix luteola	1391654	Bacteria	Bacteria	344	3.199999999999999e-90	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g61809	i0	92.827	208.892116182573	237	17	98	0	1	237	3942270	3942034	Labilithrix luteola strain DSM 27648, complete genome	blastn	50343	344	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
3782461	3782461	PRJNA841653_P_NODE_18723_length_377_cov_1.519737_g18051_i0	PRJNA841653	18723	377	1.519737	5.72940849	Sorangium	39643	Bacteria	Bacteria	379	1.45e-100	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g18051	i0	85.185	92.5437665782493	378	46	99	9	4	377	3689570	3689941	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	34889	379	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
4659162	4659162	PRJNA841653_P_NODE_48724_length_248_cov_0.880000_g48050_i0	PRJNA841653	48724	248	0.88	2.1824	Labilithrix luteola	1391654	Bacteria	Bacteria	220	5.81e-53	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g48050	i0	85.714	11.5846774193548	210	28	84	2	15	223	3282656	3282448	Labilithrix luteola strain DSM 27648, complete genome	blastn	2873	220	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
5933593	5933593	PRJNA841653_P_NODE_30825_length_293_cov_2.068182_g30151_i0	PRJNA841653	30825	293	2.068182	6.05977326	Archangium violaceum	83451	Bacteria	Bacteria	211	4.24e-50	NTclustered	gi\|2619762464\|gb\|CP137851.1\|	83451	g30151	i0	85.096	119.675767918089	208	29	71	2	1	207	704939	704733	Archangium violaceum strain KYC5002 chromosome, complete genome	blastn	35065	211	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
5933951	5933951	PRJNA841653_P_NODE_49545_length_248_cov_0.880000_g48871_i0	PRJNA841653	49545	248	0.88	2.1824	Myxococcus stipitatus	83455	Bacteria	Bacteria	95.3	3.67e-15	NTclustered	gi\|2700865302\|gb\|CP147913.1\|	83455	g48871	i0	74.704	2.57661290322581	253	45	96	18	9	247	6338151	6337904	Myxococcus stipitatus strain KYC2006 chromosome, complete genome	blastn	639	95.3	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
6334512	6334512	PRJNA841653_P_NODE_10065_length_528_cov_2.854945_g9398_i0	PRJNA841653	10065	528	2.854945	15.0741096	Myxococcia	32015	Bacteria	Bacteria	488	3.3299999999999998e-133	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g9398	i0	83.939	115.92803030303	523	71	97	11	1	513	4848198	4848717	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	61210	488	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
8883571	8883571	PRJNA841653_P_NODE_1387_length_1774_cov_3.234568_g1142_i0	PRJNA841653	1387	1774	3.234568	57.38123632	Sorangium	39643	Bacteria	Bacteria	2004	0	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g1142	i0	87.22	130.997745208568	1784	199	99	28	1	1766	8621323	8623095	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	232390	2004	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
13584590	13584590	PRJNA841653_P_NODE_58131_length_243_cov_0.905882_g57457_i0	PRJNA841653	58131	243	0.905882	2.20129326	Sorangium cellulosum	56	Bacteria	Bacteria	154	5.84e-33	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g57457	i0	82.386	11.6543209876543	176	31	72	0	33	208	4978936	4978761	Sorangium cellulosum 'So ce 56' complete genome	blastn	2832	154	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
16132737	16132737	PRJNA841653_P_NODE_13653_length_446_cov_1.852547_g12982_i0	PRJNA841653	13653	446	1.852547	8.26235962	Polyangium aurulentum	2567896	Bacteria	Bacteria	665	0	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g12982	i0	94.47	118.807174887892	434	21	97	3	14	446	2743546	2743977	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	52988	665	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
16133391	16133391	PRJNA841653_P_NODE_43933_length_251_cov_0.865169_g43259_i0	PRJNA841653	43933	251	0.865169	2.17157419	Anaeromyxobacter dehalogenans	161493	Bacteria	Bacteria	154	6.06e-33	NTclustered	gi\|85772941\|gb\|CP000251.1\|	290397	g43259	i0	82.682	2.37848605577689	179	25	70	5	2	177	2172542	2172717	Anaeromyxobacter dehalogenans 2CP-C, complete genome	blastn	597	154	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
16133429	16133429	PRJNA841653_P_NODE_46173_length_250_cov_0.870056_g45499_i0	PRJNA841653	46173	250	0.870056	2.17514	Sorangium cellulosum	56	Bacteria	Bacteria	185	2.14e-42	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g45499	i0	82.243	2.484	214	38	86	0	5	218	5560942	5561155	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	621	185	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
16133521	16133521	PRJNA841653_P_NODE_51813_length_246_cov_1.531792_g51139_i0	PRJNA841653	51813	246	1.531792	3.76820832	Corallococcus coralloides	184914	Bacteria	Bacteria	246	9.5e-61	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g51139	i0	85.185	1.90243902439024	243	33	98	2	2	241	6308127	6307885	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	468	246	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
19082277	19082277	PRJNA841653_P_NODE_32935_length_285_cov_1.212264_g32261_i0	PRJNA841653	32935	285	1.212264	3.4549524	Anaeromyxobacter	161492	Bacteria	Bacteria	309	1.41e-79	NTclustered	gi\|85772941\|gb\|CP000251.1\|	290397	g32261	i0	87.05	78.6385964912281	278	30	96	5	11	285	4560635	4560361	Anaeromyxobacter dehalogenans 2CP-C, complete genome	blastn	22412	309	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
19956911	19956911	PRJNA841653_P_NODE_34076_length_281_cov_1.120192_g33402_i0	PRJNA841653	34076	281	1.120192	3.14773952	Chondromyces crocatus	52	Bacteria	Bacteria	331	2.97e-86	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g33402	i0	91.393	118.003558718861	244	18	86	3	1	242	1430093	1429851	Chondromyces crocatus strain Cm c5, complete genome	blastn	33159	331	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
19957252	19957252	PRJNA841653_P_NODE_52236_length_246_cov_0.890173_g51562_i0	PRJNA841653	52236	246	0.890173	2.18982558	Minicystis rosea	888845	Bacteria	Bacteria	167	7.61e-37	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g51562	i0	79.916	49.5243902439024	239	38	95	9	11	244	10104791	10104558	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	12183	167	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
19957348	19957348	PRJNA841653_P_NODE_57796_length_243_cov_0.905882_g57122_i0	PRJNA841653	57796	243	0.905882	2.20129326	Anaeromyxobacter dehalogenans	161493	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|219952977\|gb\|CP001359.1\|	455488	g57122	i0	100	0.242798353909465	30	0	12	0	25	54	1588438	1588409	Anaeromyxobacter dehalogenans 2CP-1 chromosome, complete genome	blastn	59	56.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
20357180	20357180	PRJNA841653_P_NODE_43136_length_251_cov_1.679775_g42462_i0	PRJNA841653	43136	251	1.679775	4.21623525	Archangium	47	Bacteria	Bacteria	58.4	4.89e-4	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g42462	i0	91.111	0.358565737051793	45	0	17	4	33	75	4035247	4035289	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	90	58.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
21632589	21632589	PRJNA841653_P_NODE_2157_length_1237_cov_11.926976_g1764_i0	PRJNA841653	2157	1237	11.926976	147.53669312	Myxococcia	32015	Bacteria	Bacteria	1482	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1764	i0	89.008	187.633791430881	1210	115	97	15	31	1227	3942965	3941761	Labilithrix luteola strain DSM 27648, complete genome	blastn	232103	1482	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
22507001	22507001	PRJNA841653_P_NODE_20418_length_361_cov_1.302083_g19744_i0	PRJNA841653	20418	361	1.302083	4.70051963	Anaeromyxobacter sp. K	447217	Bacteria	Bacteria	217	1.15e-51	NTclustered	gi\|196170270\|gb\|CP001131.1\|	447217	g19744	i0	80.328	69.7423822714681	305	44	82	14	46	342	3743631	3743335	Anaeromyxobacter sp. K, complete genome	blastn	25177	217	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. K
22507695	22507695	PRJNA841653_P_NODE_54978_length_245_cov_0.895349_g54304_i0	PRJNA841653	54978	245	0.895349	2.19360505	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	213	9.59e-51	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g54304	i0	83.264	1.18367346938776	239	32	96	8	11	245	3378914	3378680	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	290	213	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
23782387	23782387	PRJNA841653_P_NODE_1419_length_1730_cov_45.558238_g1167_i0	PRJNA841653	1419	1730	45.558238	788.1575174	Minicystis rosea	888845	Bacteria	Bacteria	1862	0	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g1167	i0	86.345	161.435260115607	1743	197	99	35	3	1719	13716774	13715047	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	279283	1862	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
23782981	23782981	PRJNA841653_P_NODE_43559_length_251_cov_0.865169_g42885_i0	PRJNA841653	43559	251	0.865169	2.17157419	Sorangium cellulosum	56	Bacteria	Bacteria	159	1.3e-34	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g42885	i0	81.373	42.7290836653386	204	30	80	8	49	248	415571	415770	Sorangium cellulosum So0157-2, complete genome	blastn	10725	159	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
25056655	25056655	PRJNA841653_P_NODE_33960_length_281_cov_1.466346_g33286_i0	PRJNA841653	33960	281	1.466346	4.12043226	Labilithrix luteola	1391654	Bacteria	Bacteria	303	6.48e-78	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g33286	i0	86.572	22.6334519572954	283	28	98	7	6	281	3943192	3943471	Labilithrix luteola strain DSM 27648, complete genome	blastn	6360	303	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
25457538	25457538	PRJNA841653_P_NODE_60340_length_242_cov_0.911243_g59666_i0	PRJNA841653	60340	242	0.911243	2.20520806	Myxococcus	32	Bacteria	Bacteria	158	4.49e-34	NTclustered	gi\|2722781719\|gb\|CP102770.1\|	83455	g59666	i0	80.09	3.60743801652893	221	36	90	5	17	233	5064567	5064783	Myxococcus stipitatus strain YRE12 chromosome, complete genome	blastn	873	159	0.993710691823899	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus

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