metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA1174207" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA1174207" 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
3591163	3591163	PRJNA1174207_P_NODE_35263_length_249_cov_0.875000_g34734_i0	PRJNA1174207	35263	249	0.875	2.17875	Myxococcales	29	Bacteria	Bacteria	383	7.04e-102	NTclustered	gi\|2244675\|emb\|X87291.1\|	41	g34734	i0	94.422	243.823293172691	251	10	100	4	1	249	1903	1655	S.aurantiaca 23S rRNA gene	blastn	60712	383	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
4868579	4868579	PRJNA1174207_P_NODE_21544_length_307_cov_3.213675_g21015_i0	PRJNA1174207	21544	307	3.213675	9.86598225	Corallococcus	83461	Bacteria	Bacteria	473	5.159999999999999e-129	NTclustered	gi\|1561763003\|gb\|CP034669.1\|	184914	g21015	i0	94.463	237.413680781759	307	17	100	0	1	307	143323	143017	Corallococcus coralloides strain B035 chromosome, complete genome	blastn	72886	473	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
5419053	5419053	PRJNA1174207_P_NODE_7485_length_589_cov_3.195736_g6963_i0	PRJNA1174207	7485	589	3.195736	18.82288504	Myxococcales bacterium	2026763	Bacteria	Bacteria	350	1.84e-91	NTclustered	gi\|1958041644\|gb\|CP064980.1\|	2026763	g6963	i0	78.214	91.3412563667233	560	113	94	8	29	584	1307718	1308272	Myxococcales bacterium isolate Fred_18-Q3-R57-64_BAT3C.417 chromosome	blastn	53800	350	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
7968632	7968632	PRJNA1174207_P_NODE_1247_length_1720_cov_7.073467_g1007_i1	PRJNA1174207	1247	1720	7.073467	121.6636324	Pendulispora brunnea	2905690	Bacteria	Bacteria	1858	0	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g1007	i1	86.314	142.910465116279	1739	200	99	30	1	1718	9038215	9036494	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	245806	1858	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
9968512	9968512	PRJNA1174207_P_NODE_1228_length_1732_cov_5.291139_g999_i0	PRJNA1174207	1228	1732	5.291139	91.64252748	Haliangium	162027	Bacteria	Bacteria	1447	0	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g999	i0	82.017	182.636258660508	1785	243	99	50	5	1732	1776	13	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	316326	1447	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
10519325	10519325	PRJNA1174207_P_NODE_31789_length_257_cov_1.673913_g31260_i0	PRJNA1174207	31789	257	1.673913	4.30195641	Nannocystis punicea	2995304	Bacteria	Bacteria	193	1.32e-44	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g31260	i0	82.432	65.7743190661479	222	37	86	2	34	254	10083498	10083718	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	16904	193	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
12519374	12519374	PRJNA1174207_P_NODE_34630_length_249_cov_3.875000_g34101_i0	PRJNA1174207	34630	249	3.875	9.64875	Archangium	47	Bacteria	Bacteria	322	1.56e-83	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g34101	i0	89.96	289.269076305221	249	25	100	0	1	249	107237	106989	Archangium gephyra strain DSM 2261, complete genome	blastn	72028	322	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
16342884	16342884	PRJNA1174207_P_NODE_12073_length_427_cov_2.474576_g11546_i0	PRJNA1174207	12073	427	2.474576	10.56643952	Myxococcia	32015	Bacteria	Bacteria	693	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g11546	i0	96.009	165.370023419204	426	17	99	0	1	426	3943843	3944268	Labilithrix luteola strain DSM 27648, complete genome	blastn	70613	693	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
17618320	17618320	PRJNA1174207_P_NODE_21474_length_308_cov_1.634043_g20945_i0	PRJNA1174207	21474	308	1.634043	5.03285244	Sorangium	39643	Bacteria	Bacteria	383	8.98e-102	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g20945	i0	89.474	112.727272727273	304	30	98	2	1	303	3690666	3690968	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	34720	383	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
18167064	18167064	PRJNA1174207_P_NODE_18795_length_327_cov_3.476378_g18266_i0	PRJNA1174207	18795	327	3.476378	11.36775606	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	579	1.1399999999999999e-160	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g18266	i0	99.071	273.645259938838	323	2	99	1	1	323	2160836	2161157	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	89482	579	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
18167311	18167311	PRJNA1174207_P_NODE_31715_length_257_cov_2.244565_g31186_i0	PRJNA1174207	31715	257	2.244565	5.76853205	Minicystis rosea	888845	Bacteria	Bacteria	289	1.64e-73	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g31186	i0	87.072	282.813229571984	263	25	100	8	1	257	768879	769138	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	72683	289	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
19441300	19441300	PRJNA1174207_P_NODE_1236_length_1726_cov_11.565638_g1007_i0	PRJNA1174207	1236	1726	11.565638	199.62291188	Minicystis rosea	888845	Bacteria	Bacteria	1748	0	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g1007	i0	85.106	141.261877172654	1739	227	99	28	6	1724	13715059	13716785	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	243818	1748	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
19441623	19441623	PRJNA1174207_P_NODE_27276_length_276_cov_1.438424_g26747_i0	PRJNA1174207	27276	276	1.438424	3.97005024	Labilithrix luteola	1391654	Bacteria	Bacteria	407	4.7e-109	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g26747	i0	93.165	142.68115942029	278	17	100	1	1	276	3942179	3942456	Labilithrix luteola strain DSM 27648, complete genome	blastn	39380	407	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
19441956	19441956	PRJNA1174207_P_NODE_43216_length_226_cov_3.045752_g42687_i0	PRJNA1174207	43216	226	3.045752	6.88339952	Pendulispora rubella	2741070	Bacteria	Bacteria	279	8.48e-71	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g42687	i0	89.035	193.261061946903	228	22	100	3	1	226	7289996	7289770	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	43677	279	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
20716905	20716905	PRJNA1174207_P_NODE_23477_length_293_cov_1.377273_g22948_i0	PRJNA1174207	23477	293	1.377273	4.03540989	Labilithrix luteola	1391654	Bacteria	Bacteria	265	3.21e-66	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g22948	i0	83.278	368.412969283276	299	39	100	8	1	293	3942096	3941803	Labilithrix luteola strain DSM 27648, complete genome	blastn	107945	265	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
21992005	21992005	PRJNA1174207_P_NODE_15658_length_364_cov_2.116838_g15129_i0	PRJNA1174207	15658	364	2.116838	7.70529032	Labilithrix luteola	1391654	Bacteria	Bacteria	497	3.69e-136	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g15129	i0	91.484	90.3516483516484	364	27	99	4	3	364	7915456	7915817	Labilithrix luteola strain DSM 27648, complete genome	blastn	32888	497	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
23268030	23268030	PRJNA1174207_P_NODE_3859_length_906_cov_5.560624_g3413_i0	PRJNA1174207	3859	906	5.560624	50.37925344	Pendulispora albinea	2741071	Bacteria	Bacteria	1210	0	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g3413	i0	90.879	121.129139072848	910	71	99	12	3	905	3589461	3588557	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	109743	1210	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea

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