metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJEB29441" and tax

19 rows where analysis = "blastn", bioproject = "PRJEB29441" 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
2263570	2263570	PRJEB29441_P_NODE_28362_length_197_cov_1.108108_g27921_i0	PRJEB29441	28362	197	1.108108	2.18297276	Myxococcaceae	31	Bacteria	Bacteria	298	1.98e-76	NTclustered	gi\|545790946\|gb\|KF270709.1\|	83456	g27921	i0	94	239.07614213198	200	6	100	6	1	197	388	192	Myxococcus virescens strain Mxv76 23S ribosomal RNA gene, partial sequence	blastn	47098	298	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus virescens
3538889	3538889	PRJEB29441_P_NODE_34763_length_177_cov_1.593750_g34322_i0	PRJEB29441	34763	177	1.59375	2.8209375	Myxococcia	32015	Bacteria	Bacteria	185	1.4099999999999999e-42	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g34322	i0	94.215	83.9717514124294	121	7	68	0	57	177	3941887	3941767	Labilithrix luteola strain DSM 27648, complete genome	blastn	14863	185	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
3852666	3852666	PRJEB29441_P_NODE_28524_length_196_cov_1.734694_g28083_i0	PRJEB29441	28524	196	1.734694	3.40000024	Labilithrix luteola	1391654	Bacteria	Bacteria	241	3.37e-59	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g28083	i0	88.776	224.867346938776	196	22	100	0	1	196	7089172	7088977	Labilithrix luteola strain DSM 27648, complete genome	blastn	44074	241	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
4816158	4816158	PRJEB29441_P_NODE_33144_length_182_cov_1.127820_g32703_i0	PRJEB29441	33144	182	1.12782	2.0526324	root	1	Root_unresolved	Root_unresolved	276	8.440000000000001e-70	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g32703	i0	94.054	165.318681318681	185	5	100	6	1	182	2464	2283	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	30088	276	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
4816247	4816247	PRJEB29441_P_NODE_44724_length_163_cov_0.894737_g44283_i0	PRJEB29441	44724	163	0.894737	1.45842131	Corallococcus	83461	Bacteria	Bacteria	121	3.669999999999999e-23	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g44283	i0	92.771	37.398773006135	83	6	51	0	1	83	143796	143878	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	6096	121	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
7365892	7365892	PRJEB29441_P_NODE_3286_length_676_cov_157.039872_g2914_i0	PRJEB29441	3286	676	157.039872	1061.58953472	root	1	Root_unresolved	Root_unresolved	780	0	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g2914	i0	87.518	129.37426035503	689	69	100	13	1	676	2064	1380	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	87457	780	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
7679143	7679143	PRJEB29441_P_NODE_7987_length_408_cov_275.844011_g7548_i0	PRJEB29441	7987	408	275.844011	1125.44356488	Labilithrix luteola	1391654	Bacteria	Bacteria	597	4.009999999999999e-166	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g7548	i0	93.12	137.191176470588	407	28	99	0	2	408	7090059	7090465	Labilithrix luteola strain DSM 27648, complete genome	blastn	55974	597	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
11504957	11504957	PRJEB29441_P_NODE_6010_length_483_cov_14.658986_g5576_i0	PRJEB29441	6010	483	14.658986	70.80290238	Labilithrix luteola	1391654	Bacteria	Bacteria	773	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g5576	i0	95.464	157.192546583851	485	20	100	2	1	483	3942800	3942316	Labilithrix luteola strain DSM 27648, complete genome	blastn	75924	773	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
15016050	15016050	PRJEB29441_P_NODE_1812_length_916_cov_22.636678_g1563_i0	PRJEB29441	1812	916	22.636678	207.35197048	Pendulispora	3375062	Bacteria	Bacteria	1112	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g1563	i0	88.636	117.260917030568	924	91	99	12	2	916	9852411	9853329	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	107411	1112	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
15328417	15328417	PRJEB29441_P_NODE_14833_length_283_cov_14.863248_g14392_i0	PRJEB29441	14833	283	14.863248	42.06299184	Labilithrix luteola	1391654	Bacteria	Bacteria	372	1.76e-98	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g14392	i0	98.571	236.254416961131	210	3	74	0	74	283	3944599	3944390	Labilithrix luteola strain DSM 27648, complete genome	blastn	66860	372	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
16603229	16603229	PRJEB29441_P_NODE_22394_length_223_cov_2.591954_g21953_i0	PRJEB29441	22394	223	2.591954	5.78005742	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	390	3.689999999999999e-104	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g21953	i0	98.206	233.878923766816	223	4	100	0	1	223	2161592	2161814	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	52155	390	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
17566025	17566025	PRJEB29441_P_NODE_1434_length_1025_cov_16.512295_g1220_i0	PRJEB29441	1434	1025	16.512295	169.25102375	Myxococcia	32015	Bacteria	Bacteria	1245	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1220	i0	88.621	180.798048780488	1037	100	99	15	1	1024	3942800	3941769	Labilithrix luteola strain DSM 27648, complete genome	blastn	185318	1245	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
17566244	17566244	PRJEB29441_P_NODE_4534_length_567_cov_8.830116_g4115_i0	PRJEB29441	4534	567	8.830116	50.06675772	Myxococcia	32015	Bacteria	Bacteria	649	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g4115	i0	87.413	133.913580246914	572	63	100	9	1	567	3942333	3941766	Labilithrix luteola strain DSM 27648, complete genome	blastn	75929	654	0.992354740061162	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
18840011	18840011	PRJEB29441_P_NODE_37675_length_169_cov_4.091667_g37234_i0	PRJEB29441	37675	169	4.091667	6.91491723	Myxococcales	29	Bacteria	Bacteria	307	2.73e-79	NTclustered	gi\|545790941\|gb\|KF270704.1\|	35	g37234	i0	99.412	251.360946745562	170	0	100	1	1	169	554	723	Corallococcus macrosporus strain Ccm7 23S ribosomal RNA gene, partial sequence	blastn	42480	307	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus macrosporus
20427512	20427512	PRJEB29441_P_NODE_4797_length_548_cov_5.965932_g4115_i1	PRJEB29441	4797	548	5.965932	32.69330736	Labilithrix luteola	1391654	Bacteria	Bacteria	641	2.52e-179	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g4115	i1	87.95	137.591240875912	556	52	100	11	1	548	3941785	3942333	Labilithrix luteola strain DSM 27648, complete genome	blastn	75400	641	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
21390399	21390399	PRJEB29441_P_NODE_26297_length_205_cov_1.275641_g25856_i0	PRJEB29441	26297	205	1.275641	2.61506405	Sorangium	39643	Bacteria	Bacteria	313	7.4399999999999995e-81	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g25856	i0	94.175	132.868292682927	206	11	100	1	1	205	3689994	3689789	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	27238	313	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
21703550	21703550	PRJEB29441_P_NODE_4758_length_551_cov_15.400398_g4339_i0	PRJEB29441	4758	551	15.400398	84.85619298	Pendulispora rubella	2741070	Bacteria	Bacteria	865	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g4339	i0	95.1	170.838475499093	551	23	100	3	1	551	7288976	7289522	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	94132	865	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
24252465	24252465	PRJEB29441_P_NODE_38140_length_168_cov_2.025210_g37699_i0	PRJEB29441	38140	168	2.02521	3.4023528	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	267	4.63e-67	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g37699	i0	95.238	16.0119047619048	168	8	100	0	1	168	1384069	1383902	Anaeromyxobacter paludicola DNA, complete genome	blastn	2690	267	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
24252580	24252580	PRJEB29441_P_NODE_46840_length_161_cov_0.910714_g46399_i0	PRJEB29441	46840	161	0.910714	1.46624954	Labilithrix luteola	1391654	Bacteria	Bacteria	161	2.13e-35	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g46399	i0	85	4.26086956521739	160	22	99	2	1	159	7915815	7915657	Labilithrix luteola strain DSM 27648, complete genome	blastn	686	161	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola

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