metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1059246" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1059246" 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
177521	177521	PRJNA1059246_P_NODE_71501_length_242_cov_0.911243_g70875_i0	PRJNA1059246	71501	242	0.911243	2.20520806	Cystobacter fuscus	43	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g70875	i0	100	0.231404958677686	28	0	12	0	205	232	6013165	6013138	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
1451622	1451622	PRJNA1059246_P_NODE_33022_length_378_cov_1.009836_g32396_i0	PRJNA1059246	33022	378	1.009836	3.81718008	Sorangium cellulosum	56	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g32396	i0	96.97	0.0873015873015873	33	1	9	0	277	309	3245802	3245834	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	33	56.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
1451645	1451645	PRJNA1059246_P_NODE_34922_length_365_cov_2.407534_g34296_i0	PRJNA1059246	34922	365	2.407534	8.7874991	Corallococcus coralloides	184914	Bacteria	Bacteria	278	5.2500000000000006e-70	NTclustered	gi\|380727201\|gb\|CP003389.1\|	1144275	g34296	i0	80.833	140.049315068493	360	63	99	5	8	364	3747362	3747006	Corallococcus coralloides DSM 2259, complete genome	blastn	51118	278	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
2286767	2286767	PRJNA1059246_P_NODE_51282_length_285_cov_1.452830_g50656_i0	PRJNA1059246	51282	285	1.45283	4.1405655	Bacteria	2	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g50656	i0	100	0.196491228070175	28	0	10	0	155	182	7661010	7660983	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
2727335	2727335	PRJNA1059246_P_NODE_2063_length_1707_cov_14.922889_g1126_i1	PRJNA1059246	2063	1707	14.922889	254.73371523	Labilithrix luteola	1391654	Bacteria	Bacteria	2499	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1126	i1	93.112	141.260105448155	1713	107	100	8	1	1707	7088986	7090693	Labilithrix luteola strain DSM 27648, complete genome	blastn	241131	2499	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
2727696	2727696	PRJNA1059246_P_NODE_48603_length_295_cov_1.270270_g47977_i0	PRJNA1059246	48603	295	1.27027	3.7472965	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	407	5.069999999999999e-109	NTclustered	gi\|470482295\|ref\|NR_076524.1\|	404589	g47977	i0	91.525	131.362711864407	295	25	100	0	1	295	320	26	Anaeromyxobacter sp. Fw109-5 strain Fw109-5 23S ribosomal RNA, complete sequence	blastn	38752	407	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
3562256	3562256	PRJNA1059246_P_NODE_68163_length_245_cov_0.895349_g67537_i0	PRJNA1059246	68163	245	0.895349	2.19360505	Myxococcales	29	Bacteria	Bacteria	344	3.26e-90	NTclustered	gi\|545790941\|gb\|KF270704.1\|	35	g67537	i0	91.968	239.90612244898	249	14	100	6	1	245	544	298	Corallococcus macrosporus strain Ccm7 23S ribosomal RNA gene, partial sequence	blastn	58777	344	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus macrosporus
4839455	4839455	PRJNA1059246_P_NODE_29244_length_407_cov_1.152695_g28619_i0	PRJNA1059246	29244	407	1.152695	4.69146865	Pseudomonadati	3379134	Bacteria	Bacteria	226	2.1699999999999998e-54	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g28619	i0	80.128	66.6093366093366	312	54	76	8	23	330	2574232	2573925	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	27110	228	0.991228070175439	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
4839604	4839604	PRJNA1059246_P_NODE_69724_length_244_cov_0.900585_g69098_i0	PRJNA1059246	69724	244	0.900585	2.1974274	root	1	Root_unresolved	Root_unresolved	52.8	0.022	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g69098	i0	100	0.573770491803279	28	0	11	0	1	28	2594736	2594709	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	140	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
5279470	5279470	PRJNA1059246_P_NODE_1285_length_2057_cov_9.730343_g608_i3	PRJNA1059246	1285	2057	9.730343	200.15315551	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	60.2	0.001	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g608	i3	100	0.0155566358774915	32	0	2	0	722	753	1304905	1304936	Anaeromyxobacter paludicola DNA, complete genome	blastn	32	60.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
6554919	6554919	PRJNA1059246_P_NODE_32646_length_380_cov_1.589577_g32020_i0	PRJNA1059246	32646	380	1.589577	6.0403926	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	531	3.82e-146	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g32020	i0	91.864	160.257894736842	381	29	100	2	1	380	1383512	1383133	Anaeromyxobacter paludicola DNA, complete genome	blastn	60898	531	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
9104429	9104429	PRJNA1059246_P_NODE_19988_length_509_cov_2.100917_g19370_i0	PRJNA1059246	19988	509	2.100917	10.69366753	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	52.8	0.05	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g19370	i0	90.244	0.0805500982318271	41	2	8	1	68	108	6674289	6674251	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	41	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
19302592	19302592	PRJNA1059246_P_NODE_2336_length_1610_cov_2.382563_g2106_i0	PRJNA1059246	2336	1610	2.382563	38.3592643	Cystobacter fuscus	43	Bacteria	Bacteria	58.4	0.004	NTclustered	gi\|2579656172\|gb\|CP043491.1\|	43	g2106	i0	92.683	0.0254658385093168	41	1	2	2	1064	1103	11058330	11058369	Cystobacter fuscus strain Cbf 10 chromosome, complete genome	blastn	41	58.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus

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