metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA473799" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA473799" 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
1095820	1095820	PRJNA473799_P_NODE_4521_length_607_cov_1.552434_g4258_i0	PRJNA473799	4521	607	1.552434	9.42327438	Pendulispora	3375062	Bacteria	Bacteria	845	0	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g4258	i0	91.901	145.257001647446	605	48	99	1	3	607	3589270	3588667	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	88171	846	0.998817966903073	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
1095841	1095841	PRJNA473799_P_NODE_47861_length_244_cov_0.900585_g47587_i0	PRJNA473799	47861	244	0.900585	2.1974274	Sorangium	39643	Bacteria	Bacteria	195	3.46e-45	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g47587	i0	82.051	19.5081967213115	234	36	95	5	1	231	6719917	6720147	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	4760	195	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
1720770	1720770	PRJNA473799_P_NODE_52222_length_242_cov_0.911243_g51948_i0	PRJNA473799	52222	242	0.911243	2.20520806	Stigmatella aurantiaca	41	Bacteria	Bacteria	307	4.21e-79	NTclustered	gi\|2244675\|emb\|X87291.1\|	41	g51948	i0	89.669	205.190082644628	242	24	99	1	1	241	25	266	S.aurantiaca 23S rRNA gene	blastn	49656	307	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
2996237	2996237	PRJNA473799_P_NODE_27183_length_264_cov_1.502618_g26909_i0	PRJNA473799	27183	264	1.502618	3.96691152	Corallococcus exercitus	2316736	Bacteria	Bacteria	248	2.87e-61	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g26909	i0	84.706	0.965909090909091	255	32	95	6	15	264	4213003	4213255	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	255	248	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
5548994	5548994	PRJNA473799_P_NODE_10225_length_329_cov_3.207031_g9951_i0	PRJNA473799	10225	329	3.207031	10.55113199	Labilithrix luteola	1391654	Bacteria	Bacteria	464	3.3599999999999995e-126	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g9951	i0	92.097	137.009118541033	329	26	100	0	1	329	7090439	7090111	Labilithrix luteola strain DSM 27648, complete genome	blastn	45076	464	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
7473826	7473826	PRJNA473799_P_NODE_46466_length_245_cov_0.895349_g46192_i0	PRJNA473799	46466	245	0.895349	2.19360505	Nannocystis	53	Bacteria	Bacteria	446	8.68e-121	NTclustered	gi\|5701901\|emb\|AJ233947.1\|	54	g46192	i0	99.59	99.9836734693878	244	1	99	0	1	244	279	36	Nannocystis exedens 16S rRNA gene, strain Na e571	blastn	24496	446	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens
8098477	8098477	PRJNA473799_P_NODE_14427_length_290_cov_3.009217_g14153_i0	PRJNA473799	14427	290	3.009217	8.7267293	Cystobacter fuscus	43	Bacteria	Bacteria	178	4.25e-40	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g14153	i0	78.361	4.79655172413793	305	45	100	13	1	290	2018083	2017785	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	1391	178	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
8748817	8748817	PRJNA473799_P_NODE_47807_length_244_cov_0.900585_g47533_i0	PRJNA473799	47807	244	0.900585	2.1974274	Myxococcia	32015	Bacteria	Bacteria	89.8	1.68e-13	NTclustered	gi\|306811856\|gb\|HQ191475.1\|	253830	g47533	i0	100	21.6926229508197	48	0	20	0	197	244	1634	1587	Uncultured Myxococcales bacterium clone MMCf1 genomic sequence	blastn	5293	89.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			uncultured Myxococcales bacterium
10024085	10024085	PRJNA473799_P_NODE_41208_length_248_cov_0.880000_g40934_i0	PRJNA473799	41208	248	0.88	2.1824	Corallococcus	83461	Bacteria	Bacteria	403	5.38e-108	NTclustered	gi\|2851136330\|gb\|CP172866.1\|	184914	g40934	i0	95.968	7.09677419354839	248	10	100	0	1	248	8358536	8358289	Corallococcus coralloides strain KYC2213 chromosome, complete genome	blastn	1760	403	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
10649739	10649739	PRJNA473799_P_NODE_8029_length_381_cov_2.038961_g7755_i0	PRJNA473799	8029	381	2.038961	7.76844141	Labilithrix luteola	1391654	Bacteria	Bacteria	608	1.719999999999999e-169	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g7755	i0	95.526	141.217847769029	380	17	99	0	1	380	3941938	3942317	Labilithrix luteola strain DSM 27648, complete genome	blastn	53804	608	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
11924635	11924635	PRJNA473799_P_NODE_55090_length_240_cov_2.053892_g54816_i0	PRJNA473799	55090	240	2.053892	4.9293408	Corallococcus interemptor	2316720	Bacteria	Bacteria	388	1.45e-103	NTclustered	gi\|2809283937\|gb\|CP102579.1\|	2316720	g54816	i0	95.833	6.95833333333333	240	10	100	0	1	240	5329781	5329542	Corallococcus interemptor strain YZPH-2 chromosome, complete genome	blastn	1670	388	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus interemptor
12574912	12574912	PRJNA473799_P_NODE_57030_length_227_cov_3.772727_g56756_i0	PRJNA473799	57030	227	3.772727	8.56409029	Anaeromyxobacter	161492	Bacteria	Bacteria	141	4.19e-29	NTclustered	gi\|85772941\|gb\|CP000251.1\|	290397	g56756	i0	90.566	40.568281938326	106	10	47	0	51	156	1948386	1948281	Anaeromyxobacter dehalogenans 2CP-C, complete genome	blastn	9209	141	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
13198991	13198991	PRJNA473799_P_NODE_10651_length_322_cov_3.493976_g10377_i0	PRJNA473799	10651	322	3.493976	11.25060272	Nannocystis pusilla	889268	Bacteria	Bacteria	420	7.19e-113	NTclustered	gi\|1386873113\|gb\|MF774780.1\|	889268	g10377	i0	90.462	106.776397515528	325	21	100	7	1	322	452	135	Nannocystis pusilla strain Na p29 23S ribosomal RNA gene, partial sequence	blastn	34382	420	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis pusilla
13199559	13199559	PRJNA473799_P_NODE_49931_length_243_cov_0.905882_g49657_i0	PRJNA473799	49931	243	0.905882	2.20129326	Minicystis rosea	888845	Bacteria	Bacteria	215	2.64e-51	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g49657	i0	83.691	95.6707818930041	233	32	95	6	1	230	6993228	6993457	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	23248	215	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
15123398	15123398	PRJNA473799_P_NODE_12032_length_310_cov_2.067511_g11758_i0	PRJNA473799	12032	310	2.067511	6.4092841	Sorangium	39643	Bacteria	Bacteria	121	7.83e-23	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g11758	i0	84	1.2	125	20	40	0	166	290	6458550	6458674	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	372	121	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
17023171	17023171	PRJNA473799_P_NODE_45474_length_245_cov_1.453488_g45200_i0	PRJNA473799	45474	245	1.453488	3.5610456	Corallococcus exercitus	2316736	Bacteria	Bacteria	431	2.4299999999999996e-116	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g45200	i0	98.367	8.9265306122449	245	4	100	0	1	245	666096	666340	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	2187	431	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
18296978	18296978	PRJNA473799_P_NODE_10315_length_328_cov_1.211765_g10041_i0	PRJNA473799	10315	328	1.211765	3.9745892	Minicystis rosea	888845	Bacteria	Bacteria	363	1.25e-95	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g10041	i0	86.747	193.701219512195	332	37	100	7	1	328	13715224	13715552	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	63534	363	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
20847480	20847480	PRJNA473799_P_NODE_47217_length_244_cov_1.801170_g46943_i0	PRJNA473799	47217	244	1.80117	4.3948548	Nannocystis punicea	2995304	Bacteria	Bacteria	444	3.11e-120	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g46943	i0	99.588	168.106557377049	243	1	99	0	2	244	7596420	7596662	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	41018	444	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
23397575	23397575	PRJNA473799_P_NODE_10579_length_324_cov_1.079681_g10305_i0	PRJNA473799	10579	324	1.079681	3.49816644	Myxococcales bacterium	2026763	Bacteria	Bacteria	265	3.5899999999999995e-66	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g10305	i0	81.873	218.521604938272	331	45	99	13	1	323	1312270	1312593	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	70801	265	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
23397857	23397857	PRJNA473799_P_NODE_31619_length_256_cov_1.371585_g31345_i0	PRJNA473799	31619	256	1.371585	3.5112576	Myxococcales bacterium	2026763	Bacteria	Bacteria	274	4.5599999999999997e-69	NTclustered	gi\|2258824976\|gb\|CP060221.1\|	2026763	g31345	i0	86.047	128.31640625	258	32	100	4	1	256	1312987	1312732	MAG: Myxococcales bacterium isolate HK-STAS-MYXO-35 chromosome, complete genome	blastn	32849	274	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales			Myxococcales bacterium
24671511	24671511	PRJNA473799_P_NODE_14240_length_291_cov_2.339450_g13966_i0	PRJNA473799	14240	291	2.33945	6.8077995	Corallococcus exercitus	2316736	Bacteria	Bacteria	440	4.919999999999998e-119	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g13966	i0	93.464	49.9690721649485	306	5	100	1	1	291	4429409	4429714	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	14541	440	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus

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