metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA611476" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA611476" 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
589734	589734	PRJNA611476_P_NODE_60481_length_284_cov_1.350711_g59690_i0	PRJNA611476	60481	284	1.350711	3.83601924	Archangium gephyra	48	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g59690	i0	100	0.0985915492957746	28	0	10	0	71	98	2863139	2863166	Archangium gephyra strain DSM 2261, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
1864838	1864838	PRJNA611476_P_NODE_108722_length_243_cov_0.905882_g107931_i0	PRJNA611476	108722	243	0.905882	2.20129326	Nannocystis punicea	2995304	Bacteria	Bacteria	132	2.7300000000000003e-26	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g107931	i0	81.212	2.59670781893004	165	29	67	2	39	202	2255640	2255477	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	631	132	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
1865292	1865292	PRJNA611476_P_NODE_34202_length_357_cov_2.760563_g33411_i0	PRJNA611476	34202	357	2.760563	9.85520991	Pendulispora brunnea	2905690	Bacteria	Bacteria	134	1.17e-26	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g33411	i0	74.847	8.74229691876751	326	67	89	14	21	337	10987909	10988228	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	3121	134	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
1865303	1865303	PRJNA611476_P_NODE_35302_length_353_cov_1.321429_g34511_i0	PRJNA611476	35302	353	1.321429	4.66464437	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g34511	i0	100	0.164305949008499	30	0	8	0	322	351	3033640	3033611	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	58	56.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
1865831	1865831	PRJNA611476_P_NODE_72122_length_262_cov_1.624339_g71331_i0	PRJNA611476	72122	262	1.624339	4.25576818	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g71331	i0	100	0.244274809160305	29	0	11	0	188	216	6906669	6906697	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	64	54.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
4416441	4416441	PRJNA611476_P_NODE_106904_length_244_cov_0.900585_g106113_i0	PRJNA611476	106904	244	0.900585	2.1974274	Vulgatibacter incomptus	1391653	Bacteria	Bacteria	231	2.63e-56	NTclustered	gi\|913607065\|gb\|CP012332.1\|	1391653	g106113	i0	84.322	1.09426229508197	236	37	97	0	3	238	921241	921476	Vulgatibacter incomptus strain DSM 27710, complete genome	blastn	267	231	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Vulgatibacteraceae	Vulgatibacter	Vulgatibacter incomptus
5692707	5692707	PRJNA611476_P_NODE_1325_length_1701_cov_5.936118_g903_i0	PRJNA611476	1325	1701	5.936118	100.97336718	Pendulispora albinea	2741071	Bacteria	Bacteria	2141	0	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g903	i0	89.486	143.597883597884	1712	155	99	19	2	1701	7190413	7192111	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	244260	2141	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
6251729	6251729	PRJNA611476_P_NODE_47745_length_314_cov_1.236515_g46954_i0	PRJNA611476	47745	314	1.236515	3.8826571	Anaeromyxobacter	161492	Bacteria	Bacteria	425	1.4999999999999999e-114	NTclustered	gi\|470482295\|ref\|NR_076524.1\|	404589	g46954	i0	91.083	140.449044585987	314	28	100	0	1	314	220	533	Anaeromyxobacter sp. Fw109-5 strain Fw109-5 23S ribosomal RNA, complete sequence	blastn	44101	425	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. Fw109-5
6251815	6251815	PRJNA611476_P_NODE_57705_length_289_cov_1.199074_g56914_i0	PRJNA611476	57705	289	1.199074	3.46532386	Myxococcia	32015	Bacteria	Bacteria	241	5.32e-59	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g56914	i0	81.973	26.3114186851211	294	43	100	10	1	289	10326257	10326545	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	7604	241	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
6967504	6967504	PRJNA611476_P_NODE_1946_length_1412_cov_3.613891_g1442_i0	PRJNA611476	1946	1412	3.613891	51.02814092	Polyangium aurulentum	2567896	Bacteria	Bacteria	719	0	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g1442	i0	76.865	52.9058073654391	1314	279	92	23	1	1303	6458897	6457598	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	74703	719	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
6967880	6967880	PRJNA611476_P_NODE_45186_length_321_cov_1.241935_g44395_i0	PRJNA611476	45186	321	1.241935	3.98661135	Vulgatibacter incomptus	1391653	Bacteria	Bacteria	496	1.16e-135	NTclustered	gi\|913607065\|gb\|CP012332.1\|	1391653	g44395	i0	94.671	290.582554517134	319	17	99	0	1	319	179926	179608	Vulgatibacter incomptus strain DSM 27710, complete genome	blastn	93277	496	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Vulgatibacteraceae	Vulgatibacter	Vulgatibacter incomptus
6968342	6968342	PRJNA611476_P_NODE_80306_length_251_cov_0.865169_g79515_i0	PRJNA611476	80306	251	0.865169	2.17157419	Corallococcus sp. CAG:1435	1262867	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2729058728\|emb\|OZ007028.1\|	1262867	g79515	i0	100	1	251	0	100	0	1	251	694010	694260	MAG: Corallococcus sp. CAG:1435 isolate metabat2_pooled_hifiasm.1119 MAG genome assembly, chromosome: 1	blastn	251	464	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. CAG:1435
7525429	7525429	PRJNA611476_P_NODE_12946_length_545_cov_2.139831_g12158_i0	PRJNA611476	12946	545	2.139831	11.66207895	Anaeromyxobacter	161492	Bacteria	Bacteria	198	6.51e-46	NTclustered	gi\|85772941\|gb\|CP000251.1\|	290397	g12158	i0	79.853	51.1045871559633	273	53	50	2	10	281	690951	691222	Anaeromyxobacter dehalogenans 2CP-C, complete genome	blastn	27852	198	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
7526024	7526024	PRJNA611476_P_NODE_78826_length_251_cov_0.865169_g78035_i0	PRJNA611476	78826	251	0.865169	2.17157419	Pseudomonadati	3379134	Bacteria	Bacteria	231	2.7199999999999997e-56	NTclustered	gi\|1981856374\|gb\|CP069338.1\|	83451	g78035	i0	86.893	37.394422310757	206	27	82	0	37	242	10483202	10483407	Archangium violaceum strain SDU34 chromosome, complete genome	blastn	9386	231	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
8241906	8241906	PRJNA611476_P_NODE_103007_length_245_cov_0.895349_g102216_i0	PRJNA611476	103007	245	0.895349	2.19360505	Labilithrix luteola	1391654	Bacteria	Bacteria	276	1.21e-69	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g102216	i0	86.939	1.13469387755102	245	32	100	0	1	245	7997059	7996815	Labilithrix luteola strain DSM 27648, complete genome	blastn	278	276	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
8243155	8243155	PRJNA611476_P_NODE_85967_length_249_cov_0.875000_g85176_i0	PRJNA611476	85967	249	0.875	2.17875	Archangium gephyra	48	Bacteria	Bacteria	416	6.939999999999999e-112	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g85176	i0	96.787	39.5261044176707	249	8	100	0	1	249	9156061	9155813	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	9842	416	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
8801176	8801176	PRJNA611476_P_NODE_85447_length_249_cov_1.505682_g84656_i0	PRJNA611476	85447	249	1.505682	3.74914818	Sorangium	39643	Bacteria	Bacteria	60.2	1.35e-4	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g84656	i0	97.143	0.767068273092369	35	1	14	0	7	41	5217013	5217047	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	191	60.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
10794248	10794248	PRJNA611476_P_NODE_83609_length_250_cov_0.870056_g82818_i0	PRJNA611476	83609	250	0.870056	2.17514	Vulgatibacter incomptus	1391653	Bacteria	Bacteria	252	2.08e-62	NTclustered	gi\|913607065\|gb\|CP012332.1\|	1391653	g82818	i0	84.98	3.012	253	32	100	6	1	250	2737988	2737739	Vulgatibacter incomptus strain DSM 27710, complete genome	blastn	753	252	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Vulgatibacteraceae	Vulgatibacter	Vulgatibacter incomptus
11351519	11351519	PRJNA611476_P_NODE_55109_length_295_cov_1.040541_g54318_i0	PRJNA611476	55109	295	1.040541	3.06959595	Myxococcus	32	Bacteria	Bacteria	196	1.2e-45	NTclustered	gi\|1691485482\|gb\|CP017169.1\|	34	g54318	i0	80.534	27.0983050847458	262	45	88	6	1	259	3964507	3964765	Myxococcus xanthus strain GH3.5.6c2 chromosome, complete genome	blastn	7994	196	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
14618702	14618702	PRJNA611476_P_NODE_62632_length_280_cov_1.487923_g61841_i0	PRJNA611476	62632	280	1.487923	4.1661844	Polyangium aurulentum	2567896	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g61841	i0	100	0.1	28	0	10	0	109	136	8630957	8630930	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
17725628	17725628	PRJNA611476_P_NODE_18694_length_459_cov_1.481865_g17904_i0	PRJNA611476	18694	459	1.481865	6.80176035	Myxococcus	32	Bacteria	Bacteria	848	0	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g17904	i0	100	290.089324618736	459	0	100	0	1	459	3407606	3408064	Myxococcus xanthus strain DK1050 chromosome	blastn	133151	848	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
18441559	18441559	PRJNA611476_P_NODE_44795_length_322_cov_1.341365_g44004_i0	PRJNA611476	44795	322	1.341365	4.3191953	Pendulispora albinea	2741071	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g44004	i0	100	0.093167701863354	30	0	9	0	285	314	11118759	11118730	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
19715422	19715422	PRJNA611476_P_NODE_105876_length_244_cov_0.900585_g105085_i0	PRJNA611476	105876	244	0.900585	2.1974274	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g105085	i0	100	0.114754098360656	28	0	11	0	131	158	2497102	2497075	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
19716236	19716236	PRJNA611476_P_NODE_58056_length_288_cov_1.432558_g57265_i0	PRJNA611476	58056	288	1.432558	4.12576704	Anaeromyxobacter dehalogenans	161493	Bacteria	Bacteria	222	1.9199999999999999e-53	NTclustered	gi\|85772941\|gb\|CP000251.1\|	290397	g57265	i0	81.404	26.4756944444444	285	41	97	9	1	279	469164	469442	Anaeromyxobacter dehalogenans 2CP-C, complete genome	blastn	7625	222	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
20991336	20991336	PRJNA611476_P_NODE_112497_length_242_cov_0.911243_g111706_i0	PRJNA611476	112497	242	0.911243	2.20520806	Nannocystis punicea	2995304	Bacteria	Bacteria	215	2.63e-51	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g111706	i0	83.193	96.1528925619835	238	36	98	3	7	242	8047118	8046883	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	23269	215	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
20991362	20991362	PRJNA611476_P_NODE_114337_length_242_cov_0.911243_g113546_i0	PRJNA611476	114337	242	0.911243	2.20520806	Anaeromyxobacter dehalogenans	161493	Bacteria	Bacteria	82.4	2.78e-11	NTclustered	gi\|85772941\|gb\|CP000251.1\|	290397	g113546	i0	85.185	2.39669421487603	81	10	33	2	161	240	958795	958716	Anaeromyxobacter dehalogenans 2CP-C, complete genome	blastn	580	82.4	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
20991742	20991742	PRJNA611476_P_NODE_35197_length_353_cov_2.657143_g34406_i0	PRJNA611476	35197	353	2.657143	9.37971479	Pendulispora albinea	2741071	Bacteria	Bacteria	141	6.920000000000001e-29	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g34406	i0	79.358	23.8413597733711	218	31	58	9	125	330	2910079	2909864	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	8416	141	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
20991763	20991763	PRJNA611476_P_NODE_37017_length_347_cov_1.124088_g36226_i0	PRJNA611476	37017	347	1.124088	3.90058536	Corallococcus sp. EGB	1521117	Bacteria	Bacteria	350	1.04e-91	NTclustered	gi\|2094564806\|gb\|CP079946.1\|	1521117	g36226	i0	84.928	168.763688760807	345	52	99	0	1	345	5890682	5891026	Corallococcus sp. EGB chromosome, complete genome	blastn	58561	350	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. EGB
22267279	22267279	PRJNA611476_P_NODE_89318_length_248_cov_1.320000_g88527_i0	PRJNA611476	89318	248	1.32	3.2736	Archangium gephyra	48	Bacteria	Bacteria	259	1.23e-64	NTclustered	gi\|827418478\|gb\|CP011509.1\|	48	g88527	i0	87.336	92.3387096774194	229	25	92	3	17	243	3228876	3229102	Archangium gephyra strain DSM 2261, complete genome	blastn	22900	259	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
25374404	25374404	PRJNA611476_P_NODE_60120_length_285_cov_1.023585_g59329_i0	PRJNA611476	60120	285	1.023585	2.91721725	Myxococcus	32	Bacteria	Bacteria	521	1.6699999999999996e-143	NTclustered	gi\|1957989826\|gb\|CP068048.1\|	34	g59329	i0	99.649	241.108771929825	285	1	100	0	1	285	377671	377955	Myxococcus xanthus strain R31 chromosome, complete genome	blastn	68716	521	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus

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