metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJEB28062" and tax

25 rows where analysis = "blastn", bioproject = "PRJEB28062" 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
24332	24332	PRJEB28062_P_NODE_22941_length_780_cov_27.769448_g20766_i0	PRJEB28062	22941	780	27.769448	216.6016944	Cystobacter fuscus	43	Bacteria	Bacteria	370	1.9e-97	NTclustered	gi\|2579656172\|gb\|CP043491.1\|	43	g20766	i0	75.968	32.0935897435897	749	163	95	17	18	757	9696278	9695538	Cystobacter fuscus strain Cbf 10 chromosome, complete genome	blastn	25033	370	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
25339	25339	PRJEB28062_P_NODE_71421_length_406_cov_6.414414_g69060_i0	PRJEB28062	71421	406	6.414414	26.04252084	Nannocystis punicea	2995304	Bacteria	Bacteria	252	3.5799999999999997e-62	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g69060	i0	79.943	3.01970443349754	349	64	85	6	22	367	292963	292618	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	1226	252	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
986850	986850	PRJEB28062_P_NODE_101941_length_309_cov_2.538136_g99578_i0	PRJEB28062	101941	309	2.538136	7.84284024	Sorangium	39643	Bacteria	Bacteria	307	5.58e-79	NTclustered	gi\|507148211\|ref\|NR_103018.1\|	56	g99578	i0	86.102	61.7281553398058	295	29	92	7	1	285	1474	1766	Sorangium cellulosum strain So ce 56 23S ribosomal RNA gene, complete sequence	blastn	19074	307	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
986972	986972	PRJEB28062_P_NODE_117761_length_266_cov_1.844560_g115398_i0	PRJEB28062	117761	266	1.84456	4.9065296	Sorangium	39643	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g115398	i0	88.889	0.338345864661654	45	3	16	2	124	166	10474430	10474474	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	90	54.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
1299350	1299350	PRJEB28062_P_NODE_57542_length_463_cov_15.717949_g55187_i0	PRJEB28062	57542	463	15.717949	72.77410387	Polyangium aurulentum	2567896	Bacteria	Bacteria	418	3.849999999999999e-112	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g55187	i0	84.964	38.2613390928726	419	55	90	7	22	436	11899474	11899888	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	17715	418	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
2263016	2263016	PRJEB28062_P_NODE_64182_length_434_cov_2.160665_g61821_i0	PRJEB28062	64182	434	2.160665	9.3772861	root	1	Root_unresolved	Root_unresolved	403	1e-107	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g61821	i0	87.464	100.405529953917	351	42	80	1	25	373	4848783	4848433	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	43576	403	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
2575065	2575065	PRJEB28062_P_NODE_61563_length_445_cov_4.309140_g59203_i0	PRJEB28062	61563	445	4.30914	19.175673	Nannocystis punicea	2995304	Bacteria	Bacteria	357	8.15e-94	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g59203	i0	84.658	0.820224719101124	365	48	82	5	73	436	255631	255988	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	365	357	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
2575590	2575590	PRJEB28062_P_NODE_88923_length_348_cov_6.621818_g86561_i0	PRJEB28062	88923	348	6.621818	23.04392664	Nannocystis sp.	1962667	Bacteria	Bacteria	298	3.83e-76	NTclustered	gi\|1386873111\|gb\|MF774778.1\|	1962667	g86561	i0	83.333	129.045977011494	330	48	93	6	24	348	351	678	Nannocystis sp. strain MNa11734 23S ribosomal RNA gene, partial sequence	blastn	44908	298	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis sp.
4814937	4814937	PRJEB28062_P_NODE_13064_length_1062_cov_25.806876_g11287_i0	PRJEB28062	13064	1062	25.806876	274.06902312	Stigmatella	40	Bacteria	Bacteria	1225	0	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g11287	i0	93.568	257.391713747646	824	50	94	3	17	839	775	1596	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	273350	1225	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
6402154	6402154	PRJEB28062_P_NODE_131766_length_237_cov_35.853659_g129402_i0	PRJEB28062	131766	237	35.853659	84.97317183	Labilithrix luteola	1391654	Bacteria	Bacteria	265	2.51e-66	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g129402	i0	88.94	367.26582278481	217	20	91	3	1	215	7089176	7088962	Labilithrix luteola strain DSM 27648, complete genome	blastn	87042	265	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
7365501	7365501	PRJEB28062_P_NODE_85886_length_358_cov_7.508772_g83524_i0	PRJEB28062	85886	358	7.508772	26.88140376	Myxococcus	32	Bacteria	Bacteria	544	4.59e-150	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g83524	i0	97.778	21.9832402234637	315	7	88	0	23	337	3778547	3778861	Myxococcus xanthus strain DK1050 chromosome	blastn	7870	549	0.990892531876138	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
16289561	16289561	PRJEB28062_P_NODE_104073_length_303_cov_1.017391_g101710_i0	PRJEB28062	104073	303	1.017391	3.08269473	Sorangium	39643	Bacteria	Bacteria	316	9.06e-82	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g101710	i0	85.714	58.5247524752475	301	41	99	2	1	300	1368528	1368229	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	17733	316	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
16601799	16601799	PRJEB28062_P_NODE_51094_length_498_cov_2.261176_g48745_i0	PRJEB28062	51094	498	2.261176	11.26065648	Haliangium ochraceum	80816	Bacteria	Bacteria	265	5.74e-66	NTclustered	gi\|262076673\|gb\|CP001804.1\|	502025	g48745	i0	81.791	0.779116465863454	335	44	65	16	20	345	3166515	3166841	Haliangium ochraceum DSM 14365, complete genome	blastn	388	265	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
17875494	17875494	PRJEB28062_P_NODE_123295_length_253_cov_1.772222_g120931_i0	PRJEB28062	123295	253	1.772222	4.48372166	Archangium gephyra	48	Bacteria	Bacteria	244	3.53e-60	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g120931	i0	85.776	0.91699604743083	232	31	91	2	23	253	11042641	11042411	Archangium gephyra strain DSM 2261, complete genome	blastn	232	244	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
17876458	17876458	PRJEB28062_P_NODE_45235_length_535_cov_3.134199_g42896_i0	PRJEB28062	45235	535	3.134199	16.76796465	Cystobacter fuscus	43	Bacteria	Bacteria	335	4.659999999999999e-87	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g42896	i0	81.295	44.2261682242991	417	74	78	3	10	424	11325746	11325332	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	23661	335	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
19150576	19150576	PRJEB28062_P_NODE_55856_length_472_cov_1.854637_g53502_i0	PRJEB28062	55856	472	1.854637	8.75388664	Labilithrix luteola	1391654	Bacteria	Bacteria	761	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g53502	i0	95.763	151.98093220339	472	20	100	0	1	472	3942772	3942301	Labilithrix luteola strain DSM 27648, complete genome	blastn	71735	761	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
19150592	19150592	PRJEB28062_P_NODE_56336_length_469_cov_17.876263_g53982_i0	PRJEB28062	56336	469	17.876263	83.83967347	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	276	2.49e-69	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g53982	i0	79.695	59.2963752665245	394	70	83	10	47	435	3289316	3288928	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	27810	276	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
19150885	19150885	PRJEB28062_P_NODE_7116_length_1481_cov_11.136364_g5813_i0	PRJEB28062	7116	1481	11.136364	164.92955084	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	662	0	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g5813	i0	79.958	0.729237002025658	958	144	64	39	96	1036	7610530	7609604	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	1080	662	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
20425452	20425452	PRJEB28062_P_NODE_41517_length_563_cov_1.497959_g39182_i0	PRJEB28062	41517	563	1.497959	8.43350917	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	313	2.31e-80	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g39182	i0	79.193	58.1953818827709	471	82	82	12	103	562	7964765	7965230	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	32764	313	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
20426030	20426030	PRJEB28062_P_NODE_70017_length_411_cov_8.822485_g67656_i0	PRJEB28062	70017	411	8.822485	36.26041335	Polyangium aurulentum	2567896	Bacteria	Bacteria	145	6.33e-30	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g67656	i0	92.929	0.403892944038929	99	7	24	0	290	388	3031553	3031651	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	166	145	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
21702019	21702019	PRJEB28062_P_NODE_65878_length_427_cov_4.141243_g63517_i0	PRJEB28062	65878	427	4.141243	17.68310761	Archangium violaceum	83451	Bacteria	Bacteria	163	1.82e-35	NTclustered	gi\|1981856374\|gb\|CP069338.1\|	83451	g63517	i0	84.337	1.26229508196721	166	26	39	0	209	374	4449390	4449225	Archangium violaceum strain SDU34 chromosome, complete genome	blastn	539	163	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
21702091	21702091	PRJEB28062_P_NODE_69858_length_412_cov_2.507375_g67497_i0	PRJEB28062	69858	412	2.507375	10.330385	Sorangium cellulosum	56	Bacteria	Bacteria	228	6.1299999999999984e-55	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g67497	i0	81.754	3.38592233009709	285	41	68	10	113	391	14314181	14313902	Sorangium cellulosum So0157-2, complete genome	blastn	1395	228	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
21702264	21702264	PRJEB28062_P_NODE_79138_length_380_cov_1.423453_g76776_i0	PRJEB28062	79138	380	1.423453	5.4091214	Pendulispora albinea	2741071	Bacteria	Bacteria	276	1.9699999999999999e-69	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g76776	i0	82.209	52.95	326	52	85	6	56	378	6667033	6667355	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	20121	276	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
21702337	21702337	PRJEB28062_P_NODE_82778_length_368_cov_2.684746_g80416_i0	PRJEB28062	82778	368	2.684746	9.87986528	Nannocystis punicea	2995304	Bacteria	Bacteria	255	2.48e-63	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g80416	i0	81.875	79.3505434782609	320	42	85	13	47	358	4956372	4956683	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	29201	255	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
21702617	21702617	PRJEB28062_P_NODE_98218_length_320_cov_2.493927_g95856_i0	PRJEB28062	98218	320	2.493927	7.9805664	Polyangium aurulentum	2567896	Bacteria	Bacteria	187	7.89e-43	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g95856	i0	79.078	38.571875	282	52	87	5	36	312	8167428	8167707	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	12343	187	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum

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