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

30 rows where analysis = "blastn", bioproject = "PRJNA1092581" 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
1018596	1018596	PRJNA1092581_P_NODE_76901_length_296_cov_2.730942_g76368_i0	PRJNA1092581	76901	296	2.730942	8.08358832	Sorangium	39643	Bacteria	Bacteria	60.2	1.64e-4	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g76368	i0	97.143	0.23648648648648599	35	1	12	0	241	275	12228472	12228506	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	70	60.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
1018761	1018761	PRJNA1092581_P_NODE_92901_length_264_cov_3.811518_g92368_i0	PRJNA1092581	92901	264	3.811518	10.06240752	Stigmatella	40	Bacteria	Bacteria	337	5.95e-88	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g92368	i0	90.837	218.924242424242	251	23	95	0	14	264	1560	1310	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	57796	337	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
1470630	1470630	PRJNA1092581_P_NODE_124762_length_207_cov_10.925373_g124229_i0	PRJNA1092581	124762	207	10.925373	22.61552211	uncultured Haliangium sp.	373538	Bacteria	Bacteria	217	6.07e-52	NTclustered	gi\|310755276\|gb\|HQ213166.1\|	373538	g124229	i0	96.212	3.27536231884058	132	5	64	0	56	187	1078	947	Uncultured Haliangium sp. clone 3_E01 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	678	217	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	uncultured Haliangium sp.
2746521	2746521	PRJNA1092581_P_NODE_113243_length_234_cov_26.322981_g112710_i0	PRJNA1092581	113243	234	26.322981	61.59577554	Labilithrix luteola	1391654	Bacteria	Bacteria	244	3.22e-60	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g112710	i0	87.5	73.1282051282051	216	22	91	5	1	213	3941970	3941757	Labilithrix luteola strain DSM 27648, complete genome	blastn	17112	244	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
2747840	2747840	PRJNA1092581_P_NODE_49363_length_383_cov_6.729032_g48830_i0	PRJNA1092581	49363	383	6.729032	25.77219256	Myxococcus xanthus	34	Bacteria	Bacteria	551	2.949999999999999e-152	NTclustered	gi\|13959795\|gb\|AY033402.1\|	34	g48830	i0	94.767	89.5665796344648	344	16	89	2	22	363	4026	4369	Myxococcus xanthus USC2-1p, USC2-2p, USC2-3p, USC2-4p, USC2-5p, and USC2-6p genes, complete cds	blastn	34304	551	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
3569078	3569078	PRJNA1092581_P_NODE_63003_length_333_cov_2.392308_g62470_i0	PRJNA1092581	63003	333	2.392308	7.96638564	Pseudomonadati	3379134	Bacteria	Bacteria	255	2.23e-63	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g62470	i0	85.425	27.9249249249249	247	34	74	2	20	265	5669558	5669313	Archangium gephyra strain DSM 2261, complete genome	blastn	9299	255	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
4022270	4022270	PRJNA1092581_P_NODE_106384_length_244_cov_23.192982_g105851_i0	PRJNA1092581	106384	244	23.192982	56.59087608	Labilithrix luteola	1391654	Bacteria	Bacteria	272	1.55e-68	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g105851	i0	88.789	94.5573770491803	223	23	91	2	22	243	3941757	3941978	Labilithrix luteola strain DSM 27648, complete genome	blastn	23072	272	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
4024649	4024649	PRJNA1092581_P_NODE_85004_length_279_cov_1.495146_g84471_i0	PRJNA1092581	85004	279	1.495146	4.17145734	Sorangium cellulosum	56	Bacteria	Bacteria	89.8	1.96e-13	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g84471	i0	100	2.96415770609319	48	0	17	0	226	273	7317165	7317212	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	827	89.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
4845878	4845878	PRJNA1092581_P_NODE_108964_length_241_cov_6.630952_g108431_i0	PRJNA1092581	108964	241	6.630952	15.98059432	Corallococcus	83461	Bacteria	Bacteria	403	5.199999999999998e-108	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g108431	i0	100	250.0622406639	218	0	90	0	4	221	142631	142414	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	60265	403	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
5300147	5300147	PRJNA1092581_P_NODE_57685_length_350_cov_3.144404_g57152_i0	PRJNA1092581	57685	350	3.144404	11.005414	Myxococcus xanthus	34	Bacteria	Bacteria	579	1.2299999999999996e-160	NTclustered	gi\|47778677\|gb\|AY033403.2\|	34	g57152	i0	98.187	30.2571428571429	331	6	95	0	20	350	3441	3771	Myxococcus xanthus USC3-1p, USC3-2p, USC3-3p, milk-clotting protease USC3-4p (cltC), and USC3-5p genes, complete cds	blastn	10590	579	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
5300340	5300340	PRJNA1092581_P_NODE_64765_length_327_cov_7.866142_g64232_i0	PRJNA1092581	64765	327	7.866142	25.72228434	Myxococcus xanthus	34	Bacteria	Bacteria	479	1.1899999999999996e-130	NTclustered	gi\|13959808\|gb\|AY033404.1\|	34	g64232	i0	96.864	87.6941896024465	287	6	87	3	21	304	856	1142	Myxococcus xanthus USC4-1p, USC4-2p, and USC4-3p genes, complete cds	blastn	28676	479	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
5300580	5300580	PRJNA1092581_P_NODE_74545_length_301_cov_13.267544_g74012_i0	PRJNA1092581	74545	301	13.267544	39.93530744	Myxococcus xanthus	34	Bacteria	Bacteria	442	1.4199999999999995e-119	NTclustered	gi\|47778677\|gb\|AY033403.2\|	34	g74012	i0	98.039	75.7375415282392	255	4	84	1	22	275	4096	3842	Myxococcus xanthus USC3-1p, USC3-2p, USC3-3p, milk-clotting protease USC3-4p (cltC), and USC3-5p genes, complete cds	blastn	22797	442	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
5300888	5300888	PRJNA1092581_P_NODE_86665_length_275_cov_5.896040_g86132_i0	PRJNA1092581	86665	275	5.89604	16.21411	Myxococcus xanthus	34	Bacteria	Bacteria	414	2.7999999999999992e-111	NTclustered	gi\|13959815\|gb\|AY033407.1\|	34	g86132	i0	97.107	84.8072727272727	242	6	88	1	21	261	323	564	Myxococcus xanthus USC7-1p and USC7-2p genes, complete cds	blastn	23322	414	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
6575048	6575048	PRJNA1092581_P_NODE_52386_length_370_cov_4.666667_g51853_i0	PRJNA1092581	52386	370	4.666667	17.2666679	Myxococcus xanthus	34	Bacteria	Bacteria	654	0	NTclustered	gi\|47778677\|gb\|AY033403.2\|	34	g51853	i0	98.378	20.0756756756757	370	5	99	1	2	370	4343	4712	Myxococcus xanthus USC3-1p, USC3-2p, USC3-3p, milk-clotting protease USC3-4p (cltC), and USC3-5p genes, complete cds	blastn	7428	654	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
7396286	7396286	PRJNA1092581_P_NODE_59786_length_343_cov_2.618519_g59253_i0	PRJNA1092581	59786	343	2.618519	8.98152017	Pseudomonadati	3379134	Bacteria	Bacteria	496	1.25e-135	NTclustered	gi\|13959815\|gb\|AY033407.1\|	34	g59253	i0	94.389	88.5743440233236	303	17	88	0	21	323	2909	3211	Myxococcus xanthus USC7-1p and USC7-2p genes, complete cds	blastn	30381	496	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
9125877	9125877	PRJNA1092581_P_NODE_94168_length_262_cov_3.137566_g93635_i0	PRJNA1092581	94168	262	3.137566	8.22042292	Nannocystis punicea	2995304	Bacteria	Bacteria	195	3.75e-45	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g93635	i0	84.896	22.0343511450382	192	29	73	0	30	221	2291296	2291105	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	5773	195	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
9946208	9946208	PRJNA1092581_P_NODE_15448_length_703_cov_7.065079_g14955_i0	PRJNA1092581	15448	703	7.065079	49.66750537	Sorangium	39643	Bacteria	Bacteria	200	2.37e-46	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g14955	i0	93.333	5.5049786628734	135	9	19	0	569	703	7317160	7317026	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	3870	200	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
10400162	10400162	PRJNA1092581_P_NODE_39589_length_435_cov_2.754144_g39056_i0	PRJNA1092581	39589	435	2.754144	11.9805264	Myxococcus xanthus	34	Bacteria	Bacteria	767	0	NTclustered	gi\|13959815\|gb\|AY033407.1\|	34	g39056	i0	100	95.3540229885057	415	0	95	0	1	415	1604	2018	Myxococcus xanthus USC7-1p and USC7-2p genes, complete cds	blastn	41479	767	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
12949989	12949989	PRJNA1092581_P_NODE_19811_length_625_cov_5.759058_g19292_i0	PRJNA1092581	19811	625	5.759058	35.9941125	Myxococcus xanthus	34	Bacteria	Bacteria	1013	0	NTclustered	gi\|47778677\|gb\|AY033403.2\|	34	g19292	i0	97.311	43.9952	595	10	94	5	17	605	1546	952	Myxococcus xanthus USC3-1p, USC3-2p, USC3-3p, milk-clotting protease USC3-4p (cltC), and USC3-5p genes, complete cds	blastn	27497	1013	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
14225288	14225288	PRJNA1092581_P_NODE_28872_length_516_cov_27.663657_g28340_i0	PRJNA1092581	28872	516	27.663657	142.74447012	Myxococcus xanthus	34	Bacteria	Bacteria	815	0	NTclustered	gi\|13959795\|gb\|AY033402.1\|	34	g28340	i0	97.877	98.0988372093023	471	9	91	1	10	480	470	1	Myxococcus xanthus USC2-1p, USC2-2p, USC2-3p, USC2-4p, USC2-5p, and USC2-6p genes, complete cds	blastn	50619	815	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
15498963	15498963	PRJNA1092581_P_NODE_21173_length_604_cov_6.241055_g20651_i0	PRJNA1092581	21173	604	6.241055	37.6959722	Myxococcus xanthus	34	Bacteria	Bacteria	1020	0	NTclustered	gi\|47778677\|gb\|AY033403.2\|	34	g20651	i0	97.963	34.7632450331126	589	8	97	4	1	585	2110	1522	Myxococcus xanthus USC3-1p, USC3-2p, USC3-3p, milk-clotting protease USC3-4p (cltC), and USC3-5p genes, complete cds	blastn	20997	1020	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
16774901	16774901	PRJNA1092581_P_NODE_77534_length_294_cov_7.859729_g77001_i0	PRJNA1092581	77534	294	7.859729	23.10760326	Labilithrix luteola	1391654	Bacteria	Bacteria	287	6.87e-73	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g77001	i0	85.978	32.6394557823129	271	34	91	4	25	293	9074995	9075263	Labilithrix luteola strain DSM 27648, complete genome	blastn	9596	287	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
17595515	17595515	PRJNA1092581_P_NODE_100414_length_252_cov_3.441341_g99881_i0	PRJNA1092581	100414	252	3.441341	8.67217932	Archangiaceae	39	Bacteria	Bacteria	418	1.9599999999999994e-112	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g99881	i0	96.825	312.349206349206	252	5	100	1	1	252	615	863	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	78712	420	0.995238095238095	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
19321368	19321368	PRJNA1092581_P_NODE_106456_length_244_cov_7.976608_g105923_i0	PRJNA1092581	106456	244	7.976608	19.46292352	Myxococcus xanthus	34	Bacteria	Bacteria	379	8.889999999999998e-101	NTclustered	gi\|13959818\|gb\|AY033406.1\|	34	g105923	i0	98.157	50.6434426229508	217	4	89	0	7	223	811	1027	Myxococcus xanthus USC6-1p and USC6-2p genes, complete cds	blastn	12357	379	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
20597579	20597579	PRJNA1092581_P_NODE_27517_length_530_cov_3.172867_g26985_i0	PRJNA1092581	27517	530	3.172867	16.8161951	Myxococcus xanthus	34	Bacteria	Bacteria	891	0	NTclustered	gi\|13959795\|gb\|AY033402.1\|	34	g26985	i0	97.868	96.1018867924528	516	5	96	5	21	530	1872	2387	Myxococcus xanthus USC2-1p, USC2-2p, USC2-3p, USC2-4p, USC2-5p, and USC2-6p genes, complete cds	blastn	50934	891	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
20598612	20598612	PRJNA1092581_P_NODE_67477_length_319_cov_114.898374_g66944_i0	PRJNA1092581	67477	319	114.898374	366.52581306	Myxococcus xanthus	34	Bacteria	Bacteria	409	1.54e-109	NTclustered	gi\|47778677\|gb\|AY033403.2\|	34	g66944	i0	94.757	18.8025078369906	267	4	81	10	23	279	2714	2448	Myxococcus xanthus USC3-1p, USC3-2p, USC3-3p, milk-clotting protease USC3-4p (cltC), and USC3-5p genes, complete cds	blastn	5998	409	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
20599081	20599081	PRJNA1092581_P_NODE_86437_length_276_cov_2.152709_g85904_i0	PRJNA1092581	86437	276	2.152709	5.94147684	Myxococcus xanthus	34	Bacteria	Bacteria	459	1.28e-124	NTclustered	gi\|13959815\|gb\|AY033407.1\|	34	g85904	i0	100	89.9130434782609	248	0	90	0	22	269	1953	2200	Myxococcus xanthus USC7-1p and USC7-2p genes, complete cds	blastn	24816	459	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
21420388	21420388	PRJNA1092581_P_NODE_50517_length_378_cov_4.478689_g49984_i0	PRJNA1092581	50517	378	4.478689	16.92944442	Stigmatella	40	Bacteria	Bacteria	479	1.3899999999999999e-130	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g49984	i0	90.782	191.169312169312	358	33	95	0	1	358	478	121	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	72262	479	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
23149618	23149618	PRJNA1092581_P_NODE_61079_length_339_cov_2.714286_g60546_i0	PRJNA1092581	61079	339	2.714286	9.20142954	Haliangium ochraceum	80816	Bacteria	Bacteria	237	8.230000000000001e-58	NTclustered	gi\|262076673\|gb\|CP001804.1\|	502025	g60546	i0	87.5	10.7817109144543	208	23	61	3	13	219	6790610	6790815	Haliangium ochraceum DSM 14365, complete genome	blastn	3655	237	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
24421791	24421791	PRJNA1092581_P_NODE_119980_length_222_cov_5.161074_g119447_i0	PRJNA1092581	119980	222	5.161074	11.45758428	Myxococcus xanthus	34	Bacteria	Bacteria	316	6.319999999999998e-82	NTclustered	gi\|47778677\|gb\|AY033403.2\|	34	g119447	i0	94.581	10.7432432432432	203	6	89	5	1	198	2839	3041	Myxococcus xanthus USC3-1p, USC3-2p, USC3-3p, milk-clotting protease USC3-4p (cltC), and USC3-5p genes, complete cds	blastn	2385	316	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus

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