metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA753704" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA753704" 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
731100	731100	PRJNA753704_P_NODE_3601_length_589_cov_7.817829_g3244_i0	PRJNA753704	3601	589	7.817829	46.04701281	Archangium violaceum	83451	Bacteria	Bacteria	459	2.94e-124	NTclustered	gi\|2579675135\|gb\|CP043493.1\|	83451	g3244	i0	81.037	400.269949066214	617	81	100	23	1	589	5180760	5181368	Archangium violaceum strain Cbvi 34 chromosome, complete genome	blastn	235759	459	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
731143	731143	PRJNA753704_P_NODE_8141_length_408_cov_3.856716_g7780_i0	PRJNA753704	8141	408	3.856716	15.73540128	Vulgatibacter incomptus	1391653	Bacteria	Bacteria	268	3.57e-67	NTclustered	gi\|913607065\|gb\|CP012332.1\|	1391653	g7780	i0	79.5	113.203431372549	400	64	97	13	11	404	179000	178613	Vulgatibacter incomptus strain DSM 27710, complete genome	blastn	46187	268	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Vulgatibacteraceae	Vulgatibacter	Vulgatibacter incomptus
2007174	2007174	PRJNA753704_P_NODE_342_length_1703_cov_19.836810_g224_i0	PRJNA753704	342	1703	19.83681	337.8208743	Minicystis rosea	888845	Bacteria	Bacteria	1934	0	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g224	i0	87.194	162.386376981797	1718	198	100	17	1	1703	13715061	13716771	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	276544	1934	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
5834624	5834624	PRJNA753704_P_NODE_20445_length_269_cov_1.632653_g20084_i0	PRJNA753704	20445	269	1.632653	4.39183657	Labilithrix luteola	1391654	Bacteria	Bacteria	414	2.73e-111	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g20084	i0	94.424	134.598513011152	269	15	100	0	1	269	7090058	7090326	Labilithrix luteola strain DSM 27648, complete genome	blastn	36207	414	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
7109743	7109743	PRJNA753704_P_NODE_20746_length_267_cov_2.304124_g20385_i0	PRJNA753704	20746	267	2.304124	6.15201108	Pendulispora brunnea	2905690	Bacteria	Bacteria	361	3.57e-95	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g20385	i0	91.011	273.142322097378	267	24	100	0	1	267	9037950	9038216	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	72929	361	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
8854970	8854970	PRJNA753704_P_NODE_1167_length_1002_cov_139.393972_g191_i1	PRJNA753704	1167	1002	139.393972	1396.72759944	Haliangium	162027	Bacteria	Bacteria	869	0	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g191	i1	82.493	137.60878243513	1011	157	100	13	1	1002	758	1757	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	137884	869	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
12210609	12210609	PRJNA753704_P_NODE_27550_length_244_cov_0.912281_g27189_i0	PRJNA753704	27550	244	0.912281	2.22596564	Minicystis rosea	888845	Bacteria	Bacteria	396	8.829999999999997e-106	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g27189	i0	95.935	159.200819672131	246	6	100	4	1	244	15982009	15982252	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	38845	396	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
12210640	12210640	PRJNA753704_P_NODE_30450_length_221_cov_6.283784_g30089_i0	PRJNA753704	30450	221	6.283784	13.88716264	Nannocystis sp.	1962667	Bacteria	Bacteria	348	2.23e-91	NTclustered	gi\|1386873111\|gb\|MF774778.1\|	1962667	g30089	i0	95.023	157.83257918552	221	11	100	0	1	221	94	314	Nannocystis sp. strain MNa11734 23S ribosomal RNA gene, partial sequence	blastn	34881	348	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis sp.
13484749	13484749	PRJNA753704_P_NODE_13651_length_323_cov_0.932000_g13290_i0	PRJNA753704	13651	323	0.932	3.01036	Minicystis rosea	888845	Bacteria	Bacteria	167	1.0400000000000001e-36	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g13290	i0	76.398	18.9318885448916	322	69	99	6	3	323	769802	769487	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	6115	167	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
18583016	18583016	PRJNA753704_P_NODE_335_length_1730_cov_73.863005_g218_i0	PRJNA753704	335	1730	73.863005	1277.8299865	Pendulispora rubella	2741070	Bacteria	Bacteria	2244	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g218	i0	90.15	156.367052023121	1736	156	100	13	1	1730	9854137	9852411	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	270515	2244	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
21133582	21133582	PRJNA753704_P_NODE_19737_length_273_cov_3.355000_g19376_i0	PRJNA753704	19737	273	3.355	9.15915	Stigmatella aurantiaca	41	Bacteria	Bacteria	230	1.0799999999999998e-55	NTclustered	gi\|309390350\|gb\|CP002271.1\|	378806	g19376	i0	87.56	69.3150183150183	209	13	73	9	49	248	7829237	7829441	Stigmatella aurantiaca DW4/3-1, complete genome	blastn	18923	230	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
22879598	22879598	PRJNA753704_P_NODE_178_length_2185_cov_197.557765_g101_i0	PRJNA753704	178	2185	197.557765	4316.63716525	Pendulispora	3375062	Bacteria	Bacteria	2237	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g101	i0	86.935	168.670480549199	2036	213	92	44	1	2004	9852174	9854188	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	368545	2239	0.99910674408218	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
22879688	22879688	PRJNA753704_P_NODE_338_length_1719_cov_80.707776_g218_i1	PRJNA753704	338	1719	80.707776	1387.36666944	Pendulispora	3375062	Bacteria	Bacteria	2211	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g218	i1	89.925	157.269924374636	1727	158	100	14	1	1719	9854137	9852419	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	270347	2211	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
22879705	22879705	PRJNA753704_P_NODE_7798_length_416_cov_9.912536_g7437_i0	PRJNA753704	7798	416	9.912536	41.236149760000004	Myxococcales	29	Bacteria	Bacteria	586	8.87e-163	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g7437	i0	92.067	317.245192307692	416	33	100	0	1	416	3637	3222	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	131974	586	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
24957684	24957684	PRJNA753704_P_NODE_30640_length_216_cov_4.727273_g30279_i0	PRJNA753704	30640	216	4.727273	10.21090968	Pendulispora albinea	2741071	Bacteria	Bacteria	296	7.98e-76	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g30279	i0	91.284	295.481481481481	218	17	100	2	1	216	3590426	3590643	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	63824	296	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);;