metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA605033" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA605033" 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
581195	581195	PRJNA605033_P_NODE_121101_length_221_cov_5.193548_g119532_i0	PRJNA605033	121101	221	5.193548	11.47774108	Archangium gephyra	48	Bacteria	Bacteria	67.6	7e-7	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g119532	i0	95.238	0.316742081447964	42	2	19	0	19	60	9391804	9391763	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	70	67.6	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
582031	582031	PRJNA605033_P_NODE_196701_length_167_cov_1.878788_g195132_i0	PRJNA605033	196701	167	1.878788	3.13757596	Corallococcus sp. NCRR	2996782	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2415015785\|gb\|CP114039.1\|	2996782	g195132	i0	100	0.173652694610778	29	0	17	0	120	148	2275624	2275652	Corallococcus sp. NCRR chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus sp. NCRR
1858641	1858641	PRJNA605033_P_NODE_4082_length_718_cov_4.076135_g2820_i0	PRJNA605033	4082	718	4.076135	29.2666493	Labilithrix luteola	1391654	Bacteria	Bacteria	745	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g2820	i0	90.636	101.569637883008	566	46	78	6	156	717	3942332	3941770	Labilithrix luteola strain DSM 27648, complete genome	blastn	72927	745	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
2419923	2419923	PRJNA605033_P_NODE_10982_length_419_cov_3.127604_g9453_i0	PRJNA605033	10982	419	3.127604	13.10466076	Archangiaceae	39	Bacteria	Bacteria	564	4.19e-156	NTclustered	gi\|1243034522\|gb\|CP022098.1\|	43	g9453	i0	91.505	261.639618138425	412	31	98	3	5	413	389252	388842	Cystobacter fuscus strain DSM 52655 chromosome, complete genome	blastn	109627	568	0.992957746478873	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
2421094	2421094	PRJNA605033_P_NODE_61802_length_224_cov_3.253968_g60233_i0	PRJNA605033	61802	224	3.253968	7.28888832	Archangium	47	Bacteria	Bacteria	381	2.2299999999999993e-101	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g60233	i0	97.321	251.102678571429	224	6	100	0	1	224	5100879	5101102	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	56247	381	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
3132885	3132885	PRJNA605033_P_NODE_185903_length_172_cov_1.678832_g184334_i0	PRJNA605033	185903	172	1.678832	2.88759104	Sorangium cellulosum	56	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g184334	i0	94.444	0.209302325581395	36	2	21	0	5	40	5872259	5872224	Sorangium cellulosum So0157-2, complete genome	blastn	36	56.5	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
3133162	3133162	PRJNA605033_P_NODE_216243_length_160_cov_0.960000_g214674_i0	PRJNA605033	216243	160	0.96	1.536	Sorangium cellulosum	56	Bacteria	Bacteria	152	1.2699999999999998e-32	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g214674	i0	83.951	1.0125	162	22	100	4	1	160	4298658	4298817	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	162	152	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
3133274	3133274	PRJNA605033_P_NODE_23003_length_305_cov_4.448148_g21442_i0	PRJNA605033	23003	305	4.448148	13.5668514	Labilithrix luteola	1391654	Bacteria	Bacteria	436	6.719999999999999e-118	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g21442	i0	92.484	143.977049180328	306	21	100	2	1	305	7090147	7090451	Labilithrix luteola strain DSM 27648, complete genome	blastn	43913	436	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
3133300	3133300	PRJNA605033_P_NODE_233563_length_154_cov_1.680672_g231994_i0	PRJNA605033	233563	154	1.680672	2.58823488	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	89.8	9.63e-14	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g231994	i0	93.333	3.15584415584416	60	4	39	0	1	60	2603533	2603474	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	486	89.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
3697275	3697275	PRJNA605033_P_NODE_47363_length_243_cov_2.769231_g45795_i0	PRJNA605033	47363	243	2.769231	6.72923133	Archangium	47	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g45795	i0	99.177	213.127572016461	243	2	100	0	1	243	12592179	12592421	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	51790	438	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
4409076	4409076	PRJNA605033_P_NODE_137904_length_207_cov_0.930233_g136335_i0	PRJNA605033	137904	207	0.930233	1.92558231	Archangium violaceum	83451	Bacteria	Bacteria	230	7.7999999999999985e-56	NTclustered	gi\|2619762464\|gb\|CP137851.1\|	83451	g136335	i0	86.957	99.231884057971	207	23	99	4	1	205	5847650	5847446	Archangium violaceum strain KYC5002 chromosome, complete genome	blastn	20541	230	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
6248334	6248334	PRJNA605033_P_NODE_113745_length_222_cov_1.732620_g112176_i0	PRJNA605033	113745	222	1.73262	3.8464164	Anaeromyxobacter	161492	Bacteria	Bacteria	65.8	2.53e-6	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g112176	i0	83.824	0.504504504504504	68	11	31	0	155	222	1527726	1527793	Anaeromyxobacter oryzae DNA, complete genome	blastn	112	65.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
6959543	6959543	PRJNA605033_P_NODE_104726_length_222_cov_1.877005_g103157_i0	PRJNA605033	104726	222	1.877005	4.1669511	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	87.9	5.4e-13	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g103157	i0	92.063	2.64864864864865	63	4	28	1	13	75	1426845	1426906	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	588	87.9	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
6961355	6961355	PRJNA605033_P_NODE_69166_length_222_cov_3.219251_g67597_i0	PRJNA605033	69166	222	3.219251	7.14673722	Corallococcus exercitus	2316736	Bacteria	Bacteria	89.8	1.5e-13	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g67597	i0	93.333	1.62612612612613	60	4	27	0	163	222	9164282	9164223	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	361	89.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
7522629	7522629	PRJNA605033_P_NODE_142366_length_201_cov_11.108434_g140797_i0	PRJNA605033	142366	201	11.108434	22.32795234	Sorangium	39643	Bacteria	Bacteria	220	4.53e-53	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g140797	i0	86.567	267.616915422886	201	26	99	1	2	201	3689408	3689608	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	53791	220	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
7522822	7522822	PRJNA605033_P_NODE_166686_length_182_cov_2.006803_g165117_i0	PRJNA605033	166686	182	2.006803	3.65238146	Myxococcota	2818505	Bacteria	Bacteria	235	1.43e-57	NTclustered	gi\|166033772\|gb\|EU262998.1\|	43	g165117	i0	90.11	119.912087912088	182	16	100	2	1	182	25	204	Cystobacter fuscus strain NM03 16S ribosomal RNA gene, complete sequence	blastn	21824	235	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
8234420	8234420	PRJNA605033_P_NODE_110807_length_222_cov_1.780749_g109238_i0	PRJNA605033	110807	222	1.780749	3.95326278	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g109238	i0	100	0.126126126126126	28	0	13	0	172	199	2244061	2244034	Anaeromyxobacter paludicola DNA, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
8235650	8235650	PRJNA605033_P_NODE_241427_length_152_cov_1.025641_g239858_i0	PRJNA605033	241427	152	1.025641	1.55897432	Sorangium cellulosum	56	Bacteria	Bacteria	73.1	9.54e-9	NTclustered	gi\|520999024\|gb\|CP003969.1\|	1254432	g239858	i0	92.157	1.58552631578947	51	4	34	0	3	53	10993544	10993594	Sorangium cellulosum So0157-2, complete genome	blastn	241	73.1	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
12061374	12061374	PRJNA605033_P_NODE_193150_length_169_cov_1.097015_g191581_i0	PRJNA605033	193150	169	1.097015	1.85395535	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	145	2.26e-30	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g191581	i0	85.915	111.272189349112	142	13	81	7	31	167	6579399	6579260	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	18805	145	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
13335931	13335931	PRJNA605033_P_NODE_167231_length_182_cov_1.278912_g165662_i0	PRJNA605033	167231	182	1.278912	2.32761984	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	99	1.96e-16	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g165662	i0	78.235	1.92307692307692	170	25	90	9	2	165	8283159	8283322	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	350	99	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
13336813	13336813	PRJNA605033_P_NODE_30951_length_275_cov_1.108333_g29385_i0	PRJNA605033	30951	275	1.108333	3.04791575	Myxococcus xanthus	34	Bacteria	Bacteria	134	8.77e-27	NTclustered	gi\|1691464223\|gb\|CP017171.1\|	34	g29385	i0	85.827	10.08	127	16	46	2	70	195	3509431	3509306	Myxococcus xanthus strain KF3.2.8c11 chromosome, complete genome	blastn	2772	134	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
15884055	15884055	PRJNA605033_P_NODE_10233_length_433_cov_12.743719_g8711_i0	PRJNA605033	10233	433	12.743719	55.18030327	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	440	7.639999999999997e-119	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g8711	i0	85.126	435.482678983834	437	57	99	7	2	433	8617443	8617010	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	188564	440	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
15885388	15885388	PRJNA605033_P_NODE_238653_length_152_cov_4.051282_g237084_i0	PRJNA605033	238653	152	4.051282	6.15794864	Archangium violaceum	83451	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g237084	i0	90.476	0.276315789473684	42	4	28	0	1	42	2845541	2845582	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	42	56.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
17160538	17160538	PRJNA605033_P_NODE_3874_length_740_cov_44.289362_g2636_i0	PRJNA605033	3874	740	44.289362	327.7412788	Minicystis rosea	888845	Bacteria	Bacteria	787	0	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g2636	i0	85.981	128.897297297297	749	90	100	13	1	740	770514	769772	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	95384	787	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
18435015	18435015	PRJNA605033_P_NODE_49055_length_241_cov_1.733010_g47487_i0	PRJNA605033	49055	241	1.73301	4.1765541	Anaeromyxobacter oryzae	2918170	Bacteria	Bacteria	130	9.74e-26	NTclustered	gi\|2199265233\|dbj\|AP025591.1\|	2918170	g47487	i0	80.838	1.33195020746888	167	30	69	2	74	239	793151	792986	Anaeromyxobacter oryzae DNA, complete genome	blastn	321	130	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter oryzae
18996499	18996499	PRJNA605033_P_NODE_17095_length_344_cov_6.592233_g15543_i0	PRJNA605033	17095	344	6.592233	22.67728152	Polyangiales	3031712	Bacteria	Bacteria	499	9.67e-137	NTclustered	gi\|1566478966\|gb\|CP012672.1\|	56	g15543	i0	93.003	167.468023255814	343	23	99	1	1	343	3690383	3690042	Sorangium cellulosum strain So ce836 chromosome, complete genome	blastn	57609	503	0.992047713717694	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
22259864	22259864	PRJNA605033_P_NODE_36498_length_261_cov_3.411504_g34931_i0	PRJNA605033	36498	261	3.411504	8.90402544	Archangium violaceum	83451	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g34931	i0	100	0.10727969348659	28	0	11	0	174	201	2601184	2601157	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
24097015	24097015	PRJNA605033_P_NODE_191219_length_169_cov_3.686567_g189650_i0	PRJNA605033	191219	169	3.686567	6.23029823	Archangium	47	Bacteria	Bacteria	204	3.68e-48	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g189650	i0	89.937	145.467455621302	159	14	94	2	11	168	3995813	3995656	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	24584	204	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus

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