metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA752278" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA752278" 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
3279500	3279500	PRJNA752278_P_NODE_77943_length_251_cov_0.865169_g77740_i0	PRJNA752278	77943	251	0.865169	2.17157419	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	217	7.619999999999999e-52	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g77740	i0	82.677	4.77689243027888	254	35	99	9	2	251	5755027	5754779	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	1199	217	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
7106814	7106814	PRJNA752278_P_NODE_76326_length_252_cov_1.530726_g76123_i0	PRJNA752278	76326	252	1.530726	3.85742952	Pseudomyxococcus hansupus	1297742	Bacteria	Bacteria	163	1.01e-35	NTclustered	gi\|891158403\|gb\|CP012109.1\|	1297742	g76123	i0	92.174	12.3253968253968	115	9	46	0	101	215	8549655	8549541	Myxococcus hansupus strain mixupus chromosome, complete genome	blastn	3106	163	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pseudomyxococcus	Pseudomyxococcus hansupus
8854008	8854008	PRJNA752278_P_NODE_46667_length_280_cov_1.893720_g46464_i0	PRJNA752278	46667	280	1.89372	5.302416	Anaeromyxobacter	161492	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|196170270\|gb\|CP001131.1\|	447217	g46464	i0	100	0.2	28	0	10	0	65	92	8666	8639	Anaeromyxobacter sp. K, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. K
9656360	9656360	PRJNA752278_P_NODE_61668_length_266_cov_1.595855_g61465_i0	PRJNA752278	61668	266	1.595855	4.2449743	Chondromyces crocatus	52	Bacteria	Bacteria	276	1.33e-69	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g61465	i0	85.551	1.18045112781955	263	38	99	0	4	266	7702217	7701955	Chondromyces crocatus strain Cm c5, complete genome	blastn	314	276	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
10129991	10129991	PRJNA752278_P_NODE_95008_length_244_cov_3.146199_g94805_i0	PRJNA752278	95008	244	3.146199	7.67672556	Myxococcus	32	Bacteria	Bacteria	263	9.34e-66	NTclustered	gi\|1691485482\|gb\|CP017169.1\|	34	g94805	i0	86.066	17.6106557377049	244	34	100	0	1	244	6543905	6543662	Myxococcus xanthus strain GH3.5.6c2 chromosome, complete genome	blastn	4297	263	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
10931435	10931435	PRJNA752278_P_NODE_41109_length_286_cov_1.112676_g40906_i0	PRJNA752278	41109	286	1.112676	3.18225336	Nannocystis punicea	2995304	Bacteria	Bacteria	270	6.7e-68	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g40906	i0	88.158	83.3426573426573	228	25	79	2	1	227	5377314	5377540	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	23836	270	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
10931710	10931710	PRJNA752278_P_NODE_56229_length_271_cov_1.818182_g56026_i0	PRJNA752278	56229	271	1.818182	4.92727322	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	257	4.9100000000000005e-64	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g56026	i0	93.605	1.2619926199262	172	11	63	0	1	172	2176431	2176260	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	342	257	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
13481090	13481090	PRJNA752278_P_NODE_30311_length_309_cov_4.567797_g30108_i0	PRJNA752278	30311	309	4.567797	14.11449273	Myxococcus stipitatus	83455	Bacteria	Bacteria	60.2	1.72e-4	NTclustered	gi\|2722781719\|gb\|CP102770.1\|	83455	g30108	i0	100	0.294498381877023	32	0	10	0	207	238	5815623	5815592	Myxococcus stipitatus strain YRE12 chromosome, complete genome	blastn	91	60.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
13481101	13481101	PRJNA752278_P_NODE_30931_length_307_cov_1.974359_g30728_i0	PRJNA752278	30931	307	1.974359	6.06128213	Labilithrix luteola	1391654	Bacteria	Bacteria	106	2.17e-18	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g30728	i0	80	14.4071661237785	175	10	53	16	1	158	10585720	10585554	Labilithrix luteola strain DSM 27648, complete genome	blastn	4423	106	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
13954919	13954919	PRJNA752278_P_NODE_46171_length_281_cov_1.177885_g45968_i0	PRJNA752278	46171	281	1.177885	3.30985685	Myxococcus	32	Bacteria	Bacteria	475	1.2999999999999999e-129	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g45968	i0	97.153	34.9608540925267	281	8	100	0	1	281	901959	901679	Myxococcus xanthus strain DK1050 chromosome	blastn	9824	475	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
14755771	14755771	PRJNA752278_P_NODE_12552_length_418_cov_37.144928_g12349_i0	PRJNA752278	12552	418	37.144928	155.26579904	uncultured Polyangium sp.	211930	Bacteria	Bacteria	664	0	NTclustered	gi\|290565305\|gb\|GU556371.1\|	211930	g12349	i0	95.215	113.322966507177	418	19	99	1	2	418	1	418	Uncultured Polyangium sp. clone 156 16S ribosomal RNA gene, partial sequence	blastn	47369	664	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	uncultured Polyangium sp.
17304934	17304934	PRJNA752278_P_NODE_110534_length_226_cov_2.516340_g110331_i0	PRJNA752278	110534	226	2.51634	5.6869284	Pseudomyxococcus hansupus	1297742	Bacteria	Bacteria	246	8.599999999999998e-61	NTclustered	gi\|891158403\|gb\|CP012109.1\|	1297742	g110331	i0	86.283	21.0265486725664	226	31	100	0	1	226	4097209	4097434	Myxococcus hansupus strain mixupus chromosome, complete genome	blastn	4752	246	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pseudomyxococcus	Pseudomyxococcus hansupus
17305720	17305720	PRJNA752278_P_NODE_48714_length_278_cov_2.073171_g48511_i0	PRJNA752278	48714	278	2.073171	5.76341538	Myxococcus xanthus	34	Bacteria	Bacteria	409	1.32e-109	NTclustered	gi\|13959795\|gb\|AY033402.1\|	34	g48511	i0	92.069	26.0359712230216	290	11	100	12	1	278	3267	2978	Myxococcus xanthus USC2-1p, USC2-2p, USC2-3p, USC2-4p, USC2-5p, and USC2-6p genes, complete cds	blastn	7238	409	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
18579431	18579431	PRJNA752278_P_NODE_51895_length_275_cov_2.049505_g51692_i0	PRJNA752278	51895	275	2.049505	5.63613875	Sorangium cellulosum	56	Bacteria	Bacteria	193	1.43e-44	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g51692	i0	85.484	8.32	186	25	67	2	91	275	1369281	1369097	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	2288	193	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
19854983	19854983	PRJNA752278_P_NODE_64616_length_263_cov_2.047368_g64413_i0	PRJNA752278	64616	263	2.047368	5.38457784	Archangium gephyra	48	Bacteria	Bacteria	287	6.05e-73	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g64413	i0	86.312	67.851711026616	263	36	100	0	1	263	9729266	9729004	Archangium gephyra strain DSM 2261, complete genome	blastn	17845	287	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
20327732	20327732	PRJNA752278_P_NODE_88556_length_247_cov_0.885057_g88353_i0	PRJNA752278	88556	247	0.885057	2.18609079	Myxococcus	32	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g88353	i0	99.595	21.0566801619433	247	1	100	0	1	247	8587710	8587464	Myxococcus xanthus strain DK1050 chromosome	blastn	5201	451	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
22404136	22404136	PRJNA752278_P_NODE_105418_length_241_cov_0.916667_g105215_i0	PRJNA752278	105418	241	0.916667	2.20916747	Sorangium cellulosum	56	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g105215	i0	100	0.116182572614108	28	0	12	0	135	162	1055748	1055775	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
22405361	22405361	PRJNA752278_P_NODE_68298_length_260_cov_1.310160_g68095_i0	PRJNA752278	68298	260	1.31016	3.406416	Myxococcus xanthus	34	Bacteria	Bacteria	475	1.1899999999999999e-129	NTclustered	gi\|13959795\|gb\|AY033402.1\|	34	g68095	i0	99.617	100.034615384615	261	0	100	1	1	260	2260	2520	Myxococcus xanthus USC2-1p, USC2-2p, USC2-3p, USC2-4p, USC2-5p, and USC2-6p genes, complete cds	blastn	26009	475	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
23680581	23680581	PRJNA752278_P_NODE_47559_length_279_cov_2.373786_g47356_i0	PRJNA752278	47559	279	2.373786	6.62286294	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	167	8.789999999999999e-37	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g47356	i0	85.535	16.8028673835125	159	23	57	0	121	279	11771435	11771277	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	4688	167	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
23680724	23680724	PRJNA752278_P_NODE_55119_length_272_cov_1.934673_g54916_i0	PRJNA752278	55119	272	1.934673	5.26231056	Myxococcus xanthus	34	Bacteria	Bacteria	494	3.45e-135	NTclustered	gi\|13959815\|gb\|AY033407.1\|	34	g54916	i0	99.631	99.25	271	0	99	1	1	270	2912	2642	Myxococcus xanthus USC7-1p and USC7-2p genes, complete cds	blastn	26996	494	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);;