metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA1104180" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA1104180" 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
212300	212300	PRJNA1104180_P_NODE_15401_length_275_cov_1.524752_g15259_i0	PRJNA1104180	15401	275	1.524752	4.193068	Labilithrix luteola	1391654	Bacteria	Bacteria	261	3.86e-65	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g15259	i0	85.375	1.69818181818182	253	35	92	2	4	255	6125313	6125062	Labilithrix luteola strain DSM 27648, complete genome	blastn	467	261	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
212336	212336	PRJNA1104180_P_NODE_18021_length_261_cov_1.606383_g17879_i0	PRJNA1104180	18021	261	1.606383	4.19265963	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	219	2.22e-52	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g17879	i0	82.171	84.9463601532567	258	43	99	3	1	258	5438128	5438382	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	22171	219	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
1487146	1487146	PRJNA1104180_P_NODE_3842_length_463_cov_4.307692_g3700_i0	PRJNA1104180	3842	463	4.307692	19.94461396	Archangium violaceum	83451	Bacteria	Bacteria	845	0	NTclustered	gi\|2619762464\|gb\|CP137851.1\|	83451	g3700	i0	99.568	260.552915766739	463	2	100	0	1	463	8031524	8031986	Archangium violaceum strain KYC5002 chromosome, complete genome	blastn	120636	845	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
6590284	6590284	PRJNA1104180_P_NODE_10666_length_310_cov_3.054852_g10524_i0	PRJNA1104180	10666	310	3.054852	9.4700412	Labilithrix luteola	1391654	Bacteria	Bacteria	178	4.58e-40	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g10524	i0	88.435	0.474193548387097	147	17	47	0	161	307	9638164	9638018	Labilithrix luteola strain DSM 27648, complete genome	blastn	147	178	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
6590323	6590323	PRJNA1104180_P_NODE_13766_length_285_cov_1.000000_g13624_i0	PRJNA1104180	13766	285	1	2.85	Pendulispora brunnea	2905690	Bacteria	Bacteria	427	3.74e-115	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g13624	i0	93.993	174.382456140351	283	16	100	1	4	285	7408903	7408621	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	49699	427	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
7398185	7398185	PRJNA1104180_P_NODE_8766_length_333_cov_3.376923_g8624_i0	PRJNA1104180	8766	333	3.376923	11.24515359	Myxococcia	32015	Bacteria	Bacteria	346	1.2899999999999999e-90	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g8624	i0	86.068	204.738738738739	323	37	97	2	10	332	3943954	3944268	Labilithrix luteola strain DSM 27648, complete genome	blastn	68178	346	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
11691175	11691175	PRJNA1104180_P_NODE_4630_length_428_cov_3.236620_g4488_i0	PRJNA1104180	4630	428	3.23662	13.8527336	Archangium violaceum	83451	Bacteria	Bacteria	780	0	NTclustered	gi\|2619762464\|gb\|CP137851.1\|	83451	g4488	i0	99.533	358.084112149533	428	2	100	0	1	428	3535	3108	Archangium violaceum strain KYC5002 chromosome, complete genome	blastn	153260	780	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
12499152	12499152	PRJNA1104180_P_NODE_2610_length_545_cov_3.730932_g2469_i0	PRJNA1104180	2610	545	3.730932	20.3335794	Archangiaceae	39	Bacteria	Bacteria	431	5.889999999999998e-116	NTclustered	gi\|2579656172\|gb\|CP043491.1\|	43	g2469	i0	81.204	236.611009174312	548	91	100	10	1	545	395989	396527	Cystobacter fuscus strain Cbf 10 chromosome, complete genome	blastn	128953	431	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
14241115	14241115	PRJNA1104180_P_NODE_18492_length_258_cov_4.227027_g18350_i0	PRJNA1104180	18492	258	4.227027	10.90572966	Cystobacter fuscus	43	Bacteria	Bacteria	455	1.53e-123	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g18350	i0	98.45	307.437984496124	258	4	100	0	1	258	4450770	4450513	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	79319	455	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
15514992	15514992	PRJNA1104180_P_NODE_21753_length_248_cov_2.337143_g21610_i0	PRJNA1104180	21753	248	2.337143	5.79611464	Sorangium cellulosum	56	Bacteria	Bacteria	270	5.69e-68	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g21610	i0	86.454	99.2137096774194	251	28	100	6	1	248	12571360	12571607	Sorangium cellulosum 'So ce 56' complete genome	blastn	24605	270	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
16789528	16789528	PRJNA1104180_P_NODE_2354_length_571_cov_42.100402_g2213_i0	PRJNA1104180	2354	571	42.100402	240.39329542	Myxococcales bacterium	2026763	Bacteria	Bacteria	320	1.3999999999999995e-82	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g2213	i0	77.738	128.325744308231	557	100	95	23	20	562	1314236	1313690	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	73274	320	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
16789572	16789572	PRJNA1104180_P_NODE_26454_length_241_cov_0.916667_g26311_i0	PRJNA1104180	26454	241	0.916667	2.20916747	Corallococcus sp. EGB	1521117	Bacteria	Bacteria	147	9.67e-31	NTclustered	gi\|2094564806\|gb\|CP079946.1\|	1521117	g26311	i0	79.07	4.50207468879668	215	43	89	2	25	238	2692204	2692417	Corallococcus sp. EGB chromosome, complete genome	blastn	1085	147	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. EGB
18063989	18063989	PRJNA1104180_P_NODE_16635_length_268_cov_2.297436_g16493_i0	PRJNA1104180	16635	268	2.297436	6.15712848	Sorangium cellulosum	56	Bacteria	Bacteria	154	6.54e-33	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g16493	i0	87.591	2.74253731343284	137	11	50	5	135	268	8570517	8570650	Sorangium cellulosum So0157-2, complete genome	blastn	735	154	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
18871815	18871815	PRJNA1104180_P_NODE_12975_length_289_cov_1.680556_g12833_i0	PRJNA1104180	12975	289	1.680556	4.85680684	Polyangiaceae	49	Bacteria	Bacteria	143	1.54e-29	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g12833	i0	84.564	2.08304498269896	149	18	51	4	11	156	12079303	12079449	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	602	143	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
21889223	21889223	PRJNA1104180_P_NODE_26138_length_241_cov_1.494048_g25995_i0	PRJNA1104180	26138	241	1.494048	3.60065568	Archangium gephyra	48	Bacteria	Bacteria	180	9.539999999999999e-41	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g25995	i0	82.439	5.47717842323651	205	36	85	0	29	233	9051437	9051233	Archangium gephyra strain DSM 2261, complete genome	blastn	1320	180	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
24438134	24438134	PRJNA1104180_P_NODE_12060_length_296_cov_2.560538_g11918_i0	PRJNA1104180	12060	296	2.560538	7.57919248	Sorangium cellulosum	56	Bacteria	Bacteria	97.1	1.25e-15	NTclustered	gi\|161158851\|emb\|AM746676.1\|	448385	g11918	i0	78.912	0.496621621621622	147	27	49	4	151	295	7668186	7668042	Sorangium cellulosum 'So ce 56' complete genome	blastn	147	97.1	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum

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