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

13 rows where analysis = "blastn", bioproject = "PRJNA1067370" 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
2731427	2731427	PRJNA1067370_P_NODE_48883_length_299_cov_1.048673_g48335_i0	PRJNA1067370	48883	299	1.048673	3.13553227	Minicystis rosea	888845	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g48335	i0	100	0.0936454849498328	28	0	9	0	227	254	11150877	11150850	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
2731598	2731598	PRJNA1067370_P_NODE_79263_length_251_cov_1.297753_g78714_i0	PRJNA1067370	79263	251	1.297753	3.25736003	Corallococcus coralloides	184914	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|380727201\|gb\|CP003389.1\|	1144275	g78714	i0	94.444	0.143426294820717	36	1	14	1	162	196	8913597	8913632	Corallococcus coralloides DSM 2259, complete genome	blastn	36	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
4007276	4007276	PRJNA1067370_P_NODE_34864_length_336_cov_1.171103_g34316_i0	PRJNA1067370	34864	336	1.171103	3.93490608	Archangium violaceum	83451	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2619762464\|gb\|CP137851.1\|	83451	g34316	i0	96.875	0.19047619047619	32	1	10	0	52	83	4562695	4562664	Archangium violaceum strain KYC5002 chromosome, complete genome	blastn	64	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
4841337	4841337	PRJNA1067370_P_NODE_68584_length_267_cov_1.051546_g68035_i0	PRJNA1067370	68584	267	1.051546	2.80762782	Polyangiaceae	49	Bacteria	Bacteria	372	1.65e-98	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g68035	i0	91.791	193.786516853933	268	20	100	2	1	267	2570	2304	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	51741	372	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
6558942	6558942	PRJNA1067370_P_NODE_67926_length_268_cov_1.184615_g67377_i0	PRJNA1067370	67926	268	1.184615	3.1747682	Labilithrix luteola	1391654	Bacteria	Bacteria	473	4.419999999999999e-129	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g67377	i0	98.507	152.208955223881	268	4	100	0	1	268	3943877	3944144	Labilithrix luteola strain DSM 27648, complete genome	blastn	40792	473	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
7833742	7833742	PRJNA1067370_P_NODE_91587_length_248_cov_0.880000_g91038_i0	PRJNA1067370	91587	248	0.88	2.1824	Corallococcus sp. EGB	1521117	Bacteria	Bacteria	259	1.23e-64	NTclustered	gi\|2094564806\|gb\|CP079946.1\|	1521117	g91038	i0	87.013	3.57661290322581	231	29	93	1	17	246	2285457	2285227	Corallococcus sp. EGB chromosome, complete genome	blastn	887	259	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. EGB
9108640	9108640	PRJNA1067370_P_NODE_7608_length_650_cov_3.077990_g7083_i0	PRJNA1067370	7608	650	3.07799	20.006935	Nannocystis punicea	2995304	Bacteria	Bacteria	357	1.22e-93	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g7083	i0	82.326	72.0415384615385	430	58	66	12	24	449	5377565	5377150	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	46827	357	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
10383855	10383855	PRJNA1067370_P_NODE_111989_length_242_cov_0.911243_g111440_i0	PRJNA1067370	111989	242	0.911243	2.20520806	Stigmatella aurantiaca	41	Bacteria	Bacteria	279	9.19e-71	NTclustered	gi\|309390350\|gb\|CP002271.1\|	378806	g111440	i0	87.603	103.913223140496	242	28	99	2	2	242	3613763	3613523	Stigmatella aurantiaca DW4/3-1, complete genome	blastn	25147	279	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
15040963	15040963	PRJNA1067370_P_NODE_57912_length_283_cov_1.261905_g57363_i0	PRJNA1067370	57912	283	1.261905	3.57119115	Polyangiales	3031712	Bacteria	Bacteria	396	1.05e-105	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g57363	i0	91.873	230.014134275618	283	23	100	0	1	283	9679047	9679329	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	65094	396	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
15483780	15483780	PRJNA1067370_P_NODE_67873_length_268_cov_1.184615_g67324_i0	PRJNA1067370	67873	268	1.184615	3.1747682	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	394	3.54e-105	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g67324	i0	93.284	326.544776119403	268	17	99	1	1	267	2161245	2161512	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	87514	394	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
19306572	19306572	PRJNA1067370_P_NODE_55256_length_287_cov_1.327103_g54707_i0	PRJNA1067370	55256	287	1.327103	3.80878561	Nannocystis punicea	2995304	Bacteria	Bacteria	403	6.36e-108	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g54707	i0	91.986	28.7526132404181	287	23	100	0	1	287	1867075	1866789	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	8252	403	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
20582144	20582144	PRJNA1067370_P_NODE_68117_length_267_cov_2.360825_g67568_i0	PRJNA1067370	68117	267	2.360825	6.30340275	Labilithrix luteola	1391654	Bacteria	Bacteria	364	2.759999999999999e-96	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g67568	i0	91.353	206.501872659176	266	23	99	0	2	267	3942267	3942002	Labilithrix luteola strain DSM 27648, complete genome	blastn	55136	364	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
24406656	24406656	PRJNA1067370_P_NODE_2340_length_1097_cov_2.235352_g1976_i0	PRJNA1067370	2340	1097	2.235352	24.52181144	Labilithrix luteola	1391654	Bacteria	Bacteria	1611	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1976	i0	93.182	136.424794895169	1100	70	100	5	1	1097	7090688	7089591	Labilithrix luteola strain DSM 27648, complete genome	blastn	149658	1611	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);;