metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJEB81327" and tax

18 rows where analysis = "blastn", bioproject = "PRJEB81327" 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
139667	139667	PRJEB81327_P_NODE_24961_length_287_cov_2.705607_g24353_i0	PRJEB81327	24961	287	2.705607	7.76509209	Labilithrix luteola	1391654	Bacteria	Bacteria	353	6.5e-93	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g24353	i0	88.85	139.296167247387	287	32	100	0	1	287	7089263	7088977	Labilithrix luteola strain DSM 27648, complete genome	blastn	39978	353	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
2689821	2689821	PRJEB81327_P_NODE_29443_length_279_cov_1.868932_g28835_i0	PRJEB81327	29443	279	1.868932	5.21432028	Corallococcus sp. NCRR	2996782	Bacteria	Bacteria	111	4.18e-20	NTclustered	gi\|2415015785\|gb\|CP114039.1\|	2996782	g28835	i0	90.588	0.304659498207885	85	7	30	1	1	84	6105848	6105932	Corallococcus sp. NCRR chromosome, complete genome	blastn	85	111	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. NCRR
3965661	3965661	PRJEB81327_P_NODE_10244_length_427_cov_1.629944_g9636_i0	PRJEB81327	10244	427	1.629944	6.95986088	Pendulispora rubella	2741070	Bacteria	Bacteria	652	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g9636	i0	94.379	153.11943793910999	427	20	100	3	1	427	7289593	7289171	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	65382	652	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
3965907	3965907	PRJEB81327_P_NODE_31524_length_275_cov_3.460396_g30916_i0	PRJEB81327	31524	275	3.460396	9.516089	Sorangium cellulosum	56	Bacteria	Bacteria	91.6	5.36e-14	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g30916	i0	80.142	29.4945454545455	141	12	47	12	36	165	13161227	13161092	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	8111	91.6	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
3966393	3966393	PRJEB81327_P_NODE_9264_length_453_cov_2.213158_g8656_i0	PRJEB81327	9264	453	2.213158	10.02560574	Labilithrix luteola	1391654	Bacteria	Bacteria	787	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g8656	i0	98.013	174.83885209713	453	9	100	0	1	453	3943817	3944269	Labilithrix luteola strain DSM 27648, complete genome	blastn	79202	787	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
5242857	5242857	PRJEB81327_P_NODE_9125_length_457_cov_1.760417_g8517_i0	PRJEB81327	9125	457	1.760417	8.04510569	Labilithrix luteola	1391654	Bacteria	Bacteria	701	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g8517	i0	94.311	131.560175054705	457	26	100	0	1	457	7090345	7089889	Labilithrix luteola strain DSM 27648, complete genome	blastn	60123	701	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
6518132	6518132	PRJEB81327_P_NODE_46266_length_251_cov_0.865169_g45658_i0	PRJEB81327	46266	251	0.865169	2.17157419	Sorangium cellulosum	56	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g45658	i0	96.97	0.370517928286853	33	1	13	0	77	109	12189098	12189066	Sorangium cellulosum 'So ce 56' complete genome	blastn	93	56.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
6518354	6518354	PRJEB81327_P_NODE_62046_length_242_cov_3.295858_g61438_i0	PRJEB81327	62046	242	3.295858	7.97597636	Labilithrix luteola	1391654	Bacteria	Bacteria	364	2.4699999999999992e-96	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g61438	i0	93.802	178.694214876033	242	15	100	0	1	242	3943755	3943514	Labilithrix luteola strain DSM 27648, complete genome	blastn	43244	364	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
7792424	7792424	PRJEB81327_P_NODE_62307_length_242_cov_1.822485_g61699_i0	PRJEB81327	62307	242	1.822485	4.4104137	Phaselicystis flava	525924	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1493633220\|gb\|MH908922.1\|	525924	g61699	i0	100	0.115702479338843	28	0	12	0	194	221	17587	17560	Phaselicystis flava strain MSr9315 t3pks biosynthetic gene cluster, complete sequence	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Phaselicystidaceae	Phaselicystis	Phaselicystis flava
11618137	11618137	PRJEB81327_P_NODE_16930_length_328_cov_1.752941_g16322_i0	PRJEB81327	16930	328	1.752941	5.74964648	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|2108340089\|gb\|CP070660.1\|	2026735	g16322	i0	100	0.0853658536585366	28	0	9	0	163	190	169915	169888	MAG: Deltaproteobacteria bacterium isolate bin79 chromosome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
15442747	15442747	PRJEB81327_P_NODE_68213_length_228_cov_2.412903_g67605_i0	PRJEB81327	68213	228	2.412903	5.50141884	Stigmatella aurantiaca	41	Bacteria	Bacteria	241	4.04e-59	NTclustered	gi\|309390350\|gb\|CP002271.1\|	378806	g67605	i0	86.222	7.42543859649123	225	28	97	3	1	222	3586568	3586792	Stigmatella aurantiaca DW4/3-1, complete genome	blastn	1693	241	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
16299384	16299384	PRJEB81327_P_NODE_11413_length_402_cov_0.927052_g10805_i0	PRJEB81327	11413	402	0.927052	3.72674904	Myxococcus	32	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|2722781719\|gb\|CP102770.1\|	83455	g10805	i0	96.875	0.159203980099502	32	1	8	0	257	288	9852968	9852937	Myxococcus stipitatus strain YRE12 chromosome, complete genome	blastn	64	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
16716352	16716352	PRJEB81327_P_NODE_19554_length_310_cov_3.109705_g18946_i0	PRJEB81327	19554	310	3.109705	9.6400855	Nannocystis punicea	2995304	Bacteria	Bacteria	272	2.04e-68	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g18946	i0	81.763	1.06129032258065	329	36	99	11	1	308	10795205	10795530	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	329	272	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
16716905	16716905	PRJEB81327_P_NODE_65174_length_241_cov_0.916667_g64566_i0	PRJEB81327	65174	241	0.916667	2.20916747	Nannocystis punicea	2995304	Bacteria	Bacteria	429	8.58e-116	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g64566	i0	98.755	110.639004149378	241	3	100	0	1	241	7595805	7595565	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	26664	429	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
16716906	16716906	PRJEB81327_P_NODE_65314_length_241_cov_0.916667_g64706_i0	PRJEB81327	65314	241	0.916667	2.20916747	Archangium gephyra	48	Bacteria	Bacteria	424	3.99e-114	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g64706	i0	98.34	41.9211618257261	241	4	100	0	1	241	1372234	1371994	Archangium gephyra strain DSM 2261, complete genome	blastn	10103	424	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
17991092	17991092	PRJEB81327_P_NODE_12995_length_375_cov_1.506623_g12387_i0	PRJEB81327	12995	375	1.506623	5.64983625	Labilithrix luteola	1391654	Bacteria	Bacteria	632	9.999999999999998e-177	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g12387	i0	97.067	154.704	375	11	100	0	1	375	3942316	3942690	Labilithrix luteola strain DSM 27648, complete genome	blastn	58014	632	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
21816802	21816802	PRJEB81327_P_NODE_53718_length_247_cov_0.885057_g53110_i0	PRJEB81327	53718	247	0.885057	2.18609079	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g53110	i0	100	0.11336032388664	28	0	11	0	1	28	10266766	10266739	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
24365785	24365785	PRJEB81327_P_NODE_47540_length_250_cov_2.361582_g46932_i0	PRJEB81327	47540	250	2.361582	5.903955	Myxococcus xanthus	34	Bacteria	Bacteria	425	1.16e-114	NTclustered	gi\|13959795\|gb\|AY033402.1\|	34	g46932	i0	97.6	99.952	250	3	100	3	1	250	4629	4875	Myxococcus xanthus USC2-1p, USC2-2p, USC2-3p, USC2-4p, USC2-5p, and USC2-6p genes, complete cds	blastn	24988	425	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);;