metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA1146029" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA1146029" 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
2840981	2840981	PRJNA1146029_P_NODE_2323_length_564_cov_2.509165_g2048_i0	PRJNA1146029	2323	564	2.509165	14.1516906	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	1009	0	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g2048	i0	98.936	227.462765957447	564	6	100	0	1	564	4163392	4163955	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	128289	1009	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
5393200	5393200	PRJNA1146029_P_NODE_11105_length_284_cov_1.037915_g10824_i0	PRJNA1146029	11105	284	1.037915	2.9476786	Nannocystis punicea	2995304	Bacteria	Bacteria	167	8.979999999999999e-37	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g10824	i0	80.263	2.54225352112676	228	40	79	5	51	275	8102055	8102280	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	722	167	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
5393469	5393469	PRJNA1146029_P_NODE_7085_length_335_cov_1.393130_g6807_i0	PRJNA1146029	7085	335	1.39313	4.6669855	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	483	9.449999999999997e-132	NTclustered	gi\|470482295\|ref\|NR_076524.1\|	404589	g6807	i0	93.03	245.994029850746	330	23	99	0	6	335	2175	2504	Anaeromyxobacter sp. Fw109-5 strain Fw109-5 23S ribosomal RNA, complete sequence	blastn	82408	483	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
6136462	6136462	PRJNA1146029_P_NODE_16625_length_250_cov_0.870056_g16344_i0	PRJNA1146029	16625	250	0.870056	2.17514	Polyangiales	3031712	Bacteria	Bacteria	329	9.34e-86	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g16344	i0	90.4	97.236	250	24	100	0	1	250	4069918	4069669	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	24309	329	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
6136491	6136491	PRJNA1146029_P_NODE_22545_length_229_cov_3.378205_g22263_i0	PRJNA1146029	22545	229	3.378205	7.73608945	Archangium	47	Bacteria	Bacteria	172	1.5e-38	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g22263	i0	91.27	41.1091703056769	126	11	55	0	1	126	3696583	3696708	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	9414	172	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
9217980	9217980	PRJNA1146029_P_NODE_11848_length_279_cov_1.417476_g11567_i0	PRJNA1146029	11848	279	1.417476	3.95475804	Stigmatella aurantiaca	41	Bacteria	Bacteria	217	8.61e-52	NTclustered	gi\|309390350\|gb\|CP002271.1\|	378806	g11567	i0	81.004	44.0465949820789	279	47	99	6	2	277	9657642	9657917	Stigmatella aurantiaca DW4/3-1, complete genome	blastn	12289	217	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
9218063	9218063	PRJNA1146029_P_NODE_15828_length_251_cov_1.539326_g15547_i0	PRJNA1146029	15828	251	1.539326	3.86370826	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g15547	i0	100	0.111553784860558	28	0	11	0	37	64	988417	988390	Anaeromyxobacter oryzae DNA, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
11768959	11768959	PRJNA1146029_P_NODE_990_length_899_cov_2.533898_g774_i0	PRJNA1146029	990	899	2.533898	22.77974302	Anaeromyxobacter sp. Fw109-5	404589	Bacteria	Bacteria	649	0	NTclustered	gi\|470482295\|ref\|NR_076524.1\|	404589	g774	i0	80.2	266.810901001112	899	150	98	20	1	885	1901	1017	Anaeromyxobacter sp. Fw109-5 strain Fw109-5 23S ribosomal RNA, complete sequence	blastn	239863	649	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
14318883	14318883	PRJNA1146029_P_NODE_1092_length_856_cov_2.839080_g867_i0	PRJNA1146029	1092	856	2.83908	24.3025248	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	1413	0	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g867	i0	96.495	262.079439252336	856	28	100	1	1	856	2160354	2161207	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	224340	1413	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
16336106	16336106	PRJNA1146029_P_NODE_9533_length_295_cov_1.387387_g9252_i0	PRJNA1146029	9533	295	1.387387	4.09279165	Myxococcaceae	31	Bacteria	Bacteria	540	4.79e-149	NTclustered	gi\|470488931\|ref\|NR_076895.1\|	33	g9252	i0	99.661	294.430508474576	295	1	100	0	1	295	2941	2647	Myxococcus fulvus strain HW-1 23S ribosomal RNA gene, complete sequence	blastn	86857	540	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
16867178	16867178	PRJNA1146029_P_NODE_15634_length_252_cov_2.983240_g15353_i0	PRJNA1146029	15634	252	2.98324	7.5177648	Pendulispora brunnea	2905690	Bacteria	Bacteria	222	1.65e-53	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g15353	i0	82.927	5.24603174603175	246	42	98	0	7	252	12419656	12419411	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	1322	222	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
18141703	18141703	PRJNA1146029_P_NODE_11575_length_281_cov_1.144231_g11294_i0	PRJNA1146029	11575	281	1.144231	3.21528911	Sorangium cellulosum	56	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g11294	i0	100	0.099644128113879	28	0	10	0	250	277	12200095	12200068	Sorangium cellulosum 'So ce 56' complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
19416186	19416186	PRJNA1146029_P_NODE_19476_length_245_cov_1.709302_g19195_i0	PRJNA1146029	19476	245	1.709302	4.1877899	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	139	1.6499999999999999e-28	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g19195	i0	77.6	1.93061224489796	250	42	99	14	1	243	10118891	10119133	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	473	139	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
23242639	23242639	PRJNA1146029_P_NODE_8339_length_313_cov_1.904167_g8058_i0	PRJNA1146029	8339	313	1.904167	5.96004271	Labilithrix luteola	1391654	Bacteria	Bacteria	556	5.09e-154	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g8058	i0	98.722	158.044728434505	313	4	100	0	1	313	3942878	3942566	Labilithrix luteola strain DSM 27648, complete genome	blastn	49468	556	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola

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