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

19 rows where analysis = "blastn", bioproject = "PRJNA193544" 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
365891	365891	PRJNA193544_S_NODE_2921_length_162_cov_11.293233_g2906_i0	PRJNA193544	2921	162	11.293233	18.29503746	Polyangium aurulentum	2567896	Bacteria	Bacteria	191	2.74e-44	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g2906	i0	90.909	91.0925925925926	143	11	96	2	13	155	443534	443394	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	14757	191	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
365910	365910	PRJNA193544_S_NODE_801_length_273_cov_5.790984_g786_i0	PRJNA193544	801	273	5.790984	15.80938632	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	285	2.2699999999999996e-72	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g786	i0	86.923	120.747252747253	260	27	95	6	16	273	8615877	8616131	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	32964	285	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
1640674	1640674	PRJNA193544_S_NODE_2662_length_169_cov_48.478571_g2647_i0	PRJNA193544	2662	169	48.478571	81.92878499	Pajaroellobacter abortibovis	1882918	Bacteria	Bacteria	263	5.989999999999999e-66	NTclustered	gi\|1127377833\|gb\|CP016908.1\|	1882918	g2647	i0	94.675	247.520710059172	169	9	100	0	1	169	1549455	1549623	Pajaroellobacter abortibovis strain BTF92-0548A/99-0131, genome	blastn	41831	263	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Pajaroellobacter	Pajaroellobacter abortibovis
1640704	1640704	PRJNA193544_S_NODE_962_length_255_cov_4.969027_g947_i0	PRJNA193544	962	255	4.969027	12.67101885	Minicystis rosea	888845	Bacteria	Bacteria	274	4.54e-69	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g947	i0	86.154	113.572549019608	260	28	100	7	1	255	13715556	13715300	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	28961	274	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
5469201	5469201	PRJNA193544_S_NODE_1325_length_223_cov_15.489691_g1310_i0	PRJNA193544	1325	223	15.489691	34.542010929999996	Pendulispora albinea	2741071	Bacteria	Bacteria	279	8.34e-71	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g1310	i0	89.908	127.730941704036	218	20	97	2	1	216	3588866	3589083	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	28484	279	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
5469251	5469251	PRJNA193544_S_NODE_765_length_278_cov_22.317269_g750_i0	PRJNA193544	765	278	22.317269	62.04200782	Pendulispora brunnea	2905690	Bacteria	Bacteria	420	6.09e-113	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g750	i0	94.485	153.881294964029	272	15	98	0	5	276	9037566	9037295	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	42779	420	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
9293988	9293988	PRJNA193544_S_NODE_2988_length_160_cov_53.832061_g2973_i0	PRJNA193544	2988	160	53.832061	86.1312976	uncultured Myxococcales bacterium	253830	Bacteria	Bacteria	252	1.22e-62	NTclustered	gi\|922323127\|gb\|KT453611.1\|	253830	g2973	i0	95	107.9875	160	8	100	0	1	160	1312	1153	Uncultured Myxococcales clone 349-11 16S ribosomal RNA gene, partial sequence	blastn	17278	252	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			uncultured Myxococcales bacterium
9983286	9983286	PRJNA193544_S_NODE_2248_length_182_cov_52.542484_g2233_i0	PRJNA193544	2248	182	52.542484	95.62732088	Myxococcus	32	Bacteria	Bacteria	187	4.07e-43	NTclustered	gi\|1691485482\|gb\|CP017169.1\|	34	g2233	i0	86.905	214.324175824176	168	20	92	2	1	167	375045	374879	Myxococcus xanthus strain GH3.5.6c2 chromosome, complete genome	blastn	39007	187	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
10569963	10569963	PRJNA193544_S_NODE_2189_length_184_cov_7.703226_g2174_i0	PRJNA193544	2189	184	7.703226	14.17393584	Pendulispora albinea	2741071	Bacteria	Bacteria	167	5.37e-37	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g2174	i0	85.03	4.53804347826087	167	21	90	4	1	165	3587985	3588149	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	835	167	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
11844438	11844438	PRJNA193544_S_NODE_1530_length_212_cov_11.491803_g1515_i0	PRJNA193544	1530	212	11.491803	24.36262236	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	320	4.63e-83	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g1515	i0	94.258	267.995283018868	209	12	99	0	4	212	2161394	2161186	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	56815	320	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
12533896	12533896	PRJNA193544_S_NODE_710_length_285_cov_13.007812_g695_i0	PRJNA193544	710	285	13.007812	37.0722642	Pseudomonadati	3379134	Bacteria	Bacteria	172	1.94e-38	NTclustered	gi\|913607065\|gb\|CP012332.1\|	1391653	g695	i0	85.207	108.119298245614	169	23	59	2	115	282	180129	180296	Vulgatibacter incomptus strain DSM 27710, complete genome	blastn	30814	172	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Vulgatibacteraceae	Vulgatibacter	Vulgatibacter incomptus
16357664	16357664	PRJNA193544_S_NODE_2433_length_176_cov_52.945578_g2418_i0	PRJNA193544	2433	176	52.945578	93.18421728	Myxococcales	29	Bacteria	Bacteria	141	3.08e-29	NTclustered	gi\|545790940\|gb\|KF270703.1\|	33	g2418	i0	89.381	153.556818181818	113	11	64	1	65	176	223	335	Myxococcus fulvus strain Mxf428 23S ribosomal RNA gene, partial sequence	blastn	27026	141	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
16357665	16357665	PRJNA193544_S_NODE_2553_length_173_cov_4.118056_g2538_i0	PRJNA193544	2553	173	4.118056	7.12423688	Stigmatella	40	Bacteria	Bacteria	187	3.82e-43	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g2538	i0	94.309	125.156069364162	123	5	70	2	53	173	704	582	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	21652	187	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
17632864	17632864	PRJNA193544_S_NODE_1914_length_195_cov_7.855422_g1899_i0	PRJNA193544	1914	195	7.855422	15.3180729	Polyangiaceae	49	Bacteria	Bacteria	276	9.18e-70	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g1899	i0	93.548	200.841025641026	186	11	95	1	8	193	11964725	11964909	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	39164	278	0.992805755395683	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
19491880	19491880	PRJNA193544_S_NODE_2036_length_190_cov_7.708075_g2021_i0	PRJNA193544	2036	190	7.708075	14.6453425	Labilithrix luteola	1391654	Bacteria	Bacteria	159	9.349999999999999e-35	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g2021	i0	82.796	11.9736842105263	186	24	96	7	8	190	3943358	3943178	Labilithrix luteola strain DSM 27648, complete genome	blastn	2275	159	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
20767415	20767415	PRJNA193544_S_NODE_2137_length_186_cov_4.178344_g2122_i0	PRJNA193544	2137	186	4.178344	7.77171984	Labilithrix luteola	1391654	Bacteria	Bacteria	132	1.99e-26	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g2122	i0	80.791	12.0376344086022	177	26	92	7	15	186	3943351	3943178	Labilithrix luteola strain DSM 27648, complete genome	blastn	2239	132	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
21457001	21457001	PRJNA193544_S_NODE_197_length_402_cov_13.123324_g182_i0	PRJNA193544	197	402	13.123324	52.75576248	Myxococcia	32015	Bacteria	Bacteria	520	8.789999999999999e-143	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g182	i0	90.226	133.116915422886	399	37	99	2	3	400	11964909	11964512	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	53513	525	0.990476190476191	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
23318001	23318001	PRJNA193544_S_NODE_2259_length_182_cov_3.104575_g2244_i0	PRJNA193544	2259	182	3.104575	5.6503265	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	215	1.87e-51	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g2244	i0	87.912	74.4010989010989	182	22	100	0	1	182	8616060	8616241	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	13541	215	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
23318034	23318034	PRJNA193544_S_NODE_979_length_252_cov_17771.560538_g964_i0	PRJNA193544	979	252	17771.560538	44784.33255576	Chondromyces crocatus	52	Bacteria	Bacteria	250	7.55e-62	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g964	i0	87.671	175.015873015873	219	22	86	5	34	250	1275	1490	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	44104	250	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus

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