metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA565584" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA565584" 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
554310	554310	PRJNA565584_P_NODE_108361_length_289_cov_1.425926_g107209_i0	PRJNA565584	108361	289	1.425926	4.12092614	Pendulispora albinea	2741071	Bacteria	Bacteria	196	1.17e-45	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g107209	i0	79.038	53.6747404844291	291	57	100	4	1	289	423573	423861	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	15512	196	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
1133873	1133873	PRJNA565584_P_NODE_122561_length_280_cov_1.487923_g121409_i0	PRJNA565584	122561	280	1.487923	4.1661844	Myxococcus	32	Bacteria	Bacteria	512	9.85e-141	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g121409	i0	99.643	28.6821428571429	280	1	100	0	1	280	10451429	10451708	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	8031	512	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
1134390	1134390	PRJNA565584_P_NODE_179581_length_249_cov_0.875000_g178429_i0	PRJNA565584	179581	249	0.875	2.17875	Myxococcus	32	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g178429	i0	99.598	2.99598393574297	249	1	100	0	1	249	6436097	6436345	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	746	455	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
1135625	1135625	PRJNA565584_P_NODE_92661_length_310_cov_2.645570_g91509_i0	PRJNA565584	92661	310	2.64557	8.201267	Myxococcus	32	Bacteria	Bacteria	278	4.39e-70	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g91509	i0	100	14.6064516129032	150	0	97	0	1	150	9328349	9328200	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	4528	278	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
3108406	3108406	PRJNA565584_P_NODE_73023_length_348_cov_1.000000_g71872_i0	PRJNA565584	73023	348	1	3.48	Myxococcus landrumensis	2813577	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|1998497960\|gb\|CP071091.1\|	2813577	g71872	i0	94.444	0.425287356321839	36	0	10	2	138	171	2127829	2127794	Myxococcus landrumus strain SCHIC003 chromosome	blastn	148	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus landrumensis
5659950	5659950	PRJNA565584_P_NODE_205645_length_243_cov_0.905882_g204493_i0	PRJNA565584	205645	243	0.905882	2.20129326	Minicystis rosea	888845	Bacteria	Bacteria	158	4.51e-34	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g204493	i0	86.806	0.707818930041152	144	15	58	4	1	142	1695526	1695385	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	172	158	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
5659958	5659958	PRJNA565584_P_NODE_206205_length_243_cov_0.905882_g205053_i0	PRJNA565584	206205	243	0.905882	2.20129326	Archangium gephyra	48	Bacteria	Bacteria	433	6.69e-117	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g205053	i0	98.765	13.8847736625514	243	3	100	0	1	243	8204157	8203915	Archangium gephyra strain DSM 2261, complete genome	blastn	3374	433	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
5660790	5660790	PRJNA565584_P_NODE_45745_length_441_cov_2.051630_g44594_i0	PRJNA565584	45745	441	2.05163	9.0476883	Sorangium cellulosum	56	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g44594	i0	90.698	0.0975056689342404	43	3	10	1	215	257	6737401	6737360	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	43	56.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
6237580	6237580	PRJNA565584_P_NODE_140925_length_268_cov_1.579487_g139773_i0	PRJNA565584	140925	268	1.579487	4.23302516	Pseudomonadati	3379134	Bacteria	Bacteria	165	3.02e-36	NTclustered	gi\|1243026503\|gb\|CP022163.1\|	1294270	g139773	i0	78.884	91.1791044776119	251	47	93	6	19	266	8365247	8365000	Melittangium boletus DSM 14713 chromosome, complete genome	blastn	24436	165	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Melittangium	Melittangium boletus
6932772	6932772	PRJNA565584_P_NODE_124166_length_279_cov_1.495146_g123014_i0	PRJNA565584	124166	279	1.495146	4.17145734	Pendulispora albinea	2741071	Bacteria	Bacteria	220	6.66e-53	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g123014	i0	80.935	96.5519713261649	278	53	99	0	1	278	10379904	10380181	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	26938	220	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
8207343	8207343	PRJNA565584_P_NODE_107647_length_289_cov_3.097222_g106495_i0	PRJNA565584	107647	289	3.097222	8.95097158	Myxococcus sp. MH1	2982796	Bacteria	Bacteria	278	4.0500000000000005e-70	NTclustered	gi\|2321229309\|dbj\|AP026947.1\|	2982796	g106495	i0	99.346	15.1833910034602	153	1	100	0	1	153	3671417	3671265	Myxococcus sp. MH1 DNA, complete genome	blastn	4388	278	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus sp. MH1
8208459	8208459	PRJNA565584_P_NODE_164547_length_252_cov_2.569832_g163395_i0	PRJNA565584	164547	252	2.569832	6.47597664	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	244	3.51e-60	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g163395	i0	84.553	1.4047619047619	246	38	98	0	1	246	183601	183356	Anaeromyxobacter paludicola DNA, complete genome	blastn	354	244	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
8208977	8208977	PRJNA565584_P_NODE_196287_length_245_cov_0.895349_g195135_i0	PRJNA565584	196287	245	0.895349	2.19360505	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	158	4.56e-34	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g195135	i0	84.049	14.3795918367347	163	26	67	0	8	170	1601093	1600931	Anaeromyxobacter paludicola DNA, complete genome	blastn	3523	158	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
8786617	8786617	PRJNA565584_P_NODE_116387_length_284_cov_1.450237_g115235_i0	PRJNA565584	116387	284	1.450237	4.11867308	Myxococcus	32	Bacteria	Bacteria	525	1.2899999999999994e-144	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g115235	i0	100	29.943661971831	284	0	100	0	1	284	775819	776102	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	8504	525	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
8786693	8786693	PRJNA565584_P_NODE_122807_length_280_cov_1.391304_g121655_i0	PRJNA565584	122807	280	1.391304	3.8956512	Myxococcus	32	Bacteria	Bacteria	507	4.58e-139	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g121655	i0	99.286	2.99285714285714	280	2	100	0	1	280	9299324	9299603	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	838	507	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
8787324	8787324	PRJNA565584_P_NODE_189167_length_246_cov_2.369942_g188015_i0	PRJNA565584	189167	246	2.369942	5.83005732	Myxococcus	32	Bacteria	Bacteria	364	2.509999999999999e-96	NTclustered	gi\|2700865302\|gb\|CP147913.1\|	83455	g188015	i0	93.522	255.077235772358	247	12	99	4	1	245	4689719	4689963	Myxococcus stipitatus strain KYC2006 chromosome, complete genome	blastn	62749	364	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
10062812	10062812	PRJNA565584_P_NODE_171028_length_250_cov_1.740113_g169876_i0	PRJNA565584	171028	250	1.740113	4.3502825	Myxococcus	32	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g169876	i0	99.6	3.9	250	1	100	0	1	250	6362159	6361910	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	975	457	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
12035400	12035400	PRJNA565584_P_NODE_210450_length_242_cov_0.911243_g209298_i0	PRJNA565584	210450	242	0.911243	2.20520806	Pendulispora albinea	2741071	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g209298	i0	100	0.115702479338843	28	0	12	0	73	100	10865856	10865883	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
13888500	13888500	PRJNA565584_P_NODE_204091_length_243_cov_0.905882_g202939_i0	PRJNA565584	204091	243	0.905882	2.20129326	Myxococcus	32	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g202939	i0	100	86.1687242798354	243	0	100	0	1	243	9531747	9531505	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	20939	449	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
14584155	14584155	PRJNA565584_P_NODE_154432_length_259_cov_1.752688_g153280_i0	PRJNA565584	154432	259	1.752688	4.53946192	Labilithrix luteola	1391654	Bacteria	Bacteria	67.6	8.42e-7	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g153280	i0	83.544	1.2972972972973	79	6	31	4	24	102	8005060	8005131	Labilithrix luteola strain DSM 27648, complete genome	blastn	336	67.6	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
15857225	15857225	PRJNA565584_P_NODE_115193_length_285_cov_1.202830_g114041_i0	PRJNA565584	115193	285	1.20283	3.4280655	Polyangium aurulentum	2567896	Bacteria	Bacteria	178	4.16e-40	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g114041	i0	78.521	3.42456140350877	284	52	98	8	3	282	10017601	10017879	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	976	178	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
17132794	17132794	PRJNA565584_P_NODE_145074_length_265_cov_2.109375_g143922_i0	PRJNA565584	145074	265	2.109375	5.58984375	Myxococcus sp. MH1	2982796	Bacteria	Bacteria	484	2.0199999999999998e-132	NTclustered	gi\|2321229309\|dbj\|AP026947.1\|	2982796	g143922	i0	99.623	13.7094339622642	265	1	100	0	1	265	2625627	2625891	Myxococcus sp. MH1 DNA, complete genome	blastn	3633	484	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus sp. MH1
18985614	18985614	PRJNA565584_P_NODE_170275_length_251_cov_0.865169_g169123_i0	PRJNA565584	170275	251	0.865169	2.17157419	Myxococcus	32	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1691464223\|gb\|CP017171.1\|	34	g169123	i0	100	0.231075697211155	29	0	12	0	104	132	7153585	7153613	Myxococcus xanthus strain KF3.2.8c11 chromosome, complete genome	blastn	58	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
19684412	19684412	PRJNA565584_P_NODE_96136_length_305_cov_1.659483_g94984_i0	PRJNA565584	96136	305	1.659483	5.06142315	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	60.2	1.7e-4	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g94984	i0	87.5	0.183606557377049	56	2	18	4	189	244	1266305	1266355	Anaeromyxobacter oryzae DNA, complete genome	blastn	56	60.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
20261001	20261001	PRJNA565584_P_NODE_199676_length_244_cov_0.900585_g198524_i0	PRJNA565584	199676	244	0.900585	2.1974274	Myxococcus	32	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g198524	i0	99.59	4.13114754098361	244	1	100	0	1	244	7112276	7112519	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	1008	446	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
20958582	20958582	PRJNA565584_P_NODE_220097_length_231_cov_3.443038_g218945_i0	PRJNA565584	220097	231	3.443038	7.95341778	Corallococcus coralloides	184914	Bacteria	Bacteria	348	2.3500000000000006e-91	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g218945	i0	93.939	251.121212121212	231	13	100	1	1	231	144447	144676	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	58009	348	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
20959953	20959953	PRJNA565584_P_NODE_87717_length_317_cov_1.881148_g86565_i0	PRJNA565584	87717	317	1.881148	5.96323916	Myxococcus fulvus	33	Bacteria	Bacteria	217	9.95e-52	NTclustered	gi\|817709775\|gb\|CP006003.1\|	1334629	g86565	i0	80.952	65.5331230283912	273	52	86	0	34	306	6089945	6089673	Myxococcus fulvus 124B02, complete genome	blastn	20774	217	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
21536300	21536300	PRJNA565584_P_NODE_175317_length_249_cov_2.267045_g174165_i0	PRJNA565584	175317	249	2.267045	5.64494205	Myxococcus	32	Bacteria	Bacteria	422	1.49e-113	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g174165	i0	97.189	3	249	7	100	0	1	249	4891041	4891289	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	747	422	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
22810983	22810983	PRJNA565584_P_NODE_121738_length_281_cov_0.937500_g120586_i0	PRJNA565584	121738	281	0.9375	2.634375	root	1	Root_unresolved	Root_unresolved	329	1.07e-85	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g120586	i0	88.321	123.889679715302	274	32	99	0	7	280	3690890	3690617	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	34813	331	0.993957703927492	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
23509828	23509828	PRJNA565584_P_NODE_68119_length_360_cov_1.334495_g66968_i0	PRJNA565584	68119	360	1.334495	4.804182	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	263	1.4500000000000001e-65	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g66968	i0	80.814	84.6194444444444	344	58	94	7	21	360	3269111	3269450	Anaeromyxobacter oryzae DNA, complete genome	blastn	30463	263	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
25360103	25360103	PRJNA565584_P_NODE_109620_length_288_cov_1.827907_g108468_i0	PRJNA565584	109620	288	1.827907	5.26437216	Myxococcus	32	Bacteria	Bacteria	532	7.8e-147	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g108468	i0	100	6.80555555555556	288	0	100	0	1	288	6795048	6794761	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	1960	532	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
25361117	25361117	PRJNA565584_P_NODE_222760_length_226_cov_2.013072_g221608_i0	PRJNA565584	222760	226	2.013072	4.54954272	Pseudomonadati	3379134	Bacteria	Bacteria	100	7.08e-17	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g221608	i0	91.667	12.1106194690265	72	6	32	0	8	79	2978669	2978740	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	2737	100	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus

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