metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA1061474" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA1061474" 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
2286946	2286946	PRJNA1061474_P_NODE_52042_length_246_cov_0.890173_g51796_i0	PRJNA1061474	52042	246	0.890173	2.18982558	Myxococcus	32	Bacteria	Bacteria	78.7	3.67e-10	NTclustered	gi\|441484664\|gb\|CP004025.1\|	1278073	g51796	i0	82.418	1.22357723577236	91	14	37	2	149	238	3641892	3641981	Myxococcus stipitatus DSM 14675, complete genome	blastn	301	78.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
4005358	4005358	PRJNA1061474_P_NODE_49664_length_248_cov_0.880000_g49418_i0	PRJNA1061474	49664	248	0.88	2.1824	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	220	5.81e-53	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g49418	i0	82.8	12.2298387096774	250	39	100	4	1	248	4102401	4102154	Anaeromyxobacter paludicola DNA, complete genome	blastn	3033	220	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
4005404	4005404	PRJNA1061474_P_NODE_51624_length_246_cov_0.890173_g51378_i0	PRJNA1061474	51624	246	0.890173	2.18982558	Archangium gephyra	48	Bacteria	Bacteria	128	3.59e-25	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g51378	i0	77.232	4.89430894308943	224	47	90	4	19	240	4857488	4857267	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	1204	128	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
5281708	5281708	PRJNA1061474_P_NODE_52085_length_246_cov_0.890173_g51839_i0	PRJNA1061474	52085	246	0.890173	2.18982558	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	163	9.84e-36	NTclustered	gi\|816953346\|gb\|CP011125.1\|	927083	g51839	i0	79.574	2.70731707317073	235	42	94	6	14	245	846268	846499	Sandaracinus amylolyticus strain DSM 53668, complete genome	blastn	666	163	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
6114862	6114862	PRJNA1061474_P_NODE_52105_length_246_cov_0.890173_g51859_i0	PRJNA1061474	52105	246	0.890173	2.18982558	Anaeromyxobacter	161492	Bacteria	Bacteria	368	1.94e-97	NTclustered	gi\|196170270\|gb\|CP001131.1\|	447217	g51859	i0	94.191	36.8780487804878	241	14	98	0	1	241	2940847	2941087	Anaeromyxobacter sp. K, complete genome	blastn	9072	368	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. K
6556924	6556924	PRJNA1061474_P_NODE_53126_length_245_cov_0.895349_g52880_i0	PRJNA1061474	53126	245	0.895349	2.19360505	Haliangium ochraceum	80816	Bacteria	Bacteria	193	1.25e-44	NTclustered	gi\|262076673\|gb\|CP001804.1\|	502025	g52880	i0	83.099	1.46530612244898	213	34	87	2	34	245	3137223	3137012	Haliangium ochraceum DSM 14365, complete genome	blastn	359	193	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
7831561	7831561	PRJNA1061474_P_NODE_52427_length_245_cov_0.895349_g52181_i0	PRJNA1061474	52427	245	0.895349	2.19360505	Labilithrix luteola	1391654	Bacteria	Bacteria	287	5.57e-73	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g52181	i0	91.787	65.0979591836735	207	15	84	2	39	244	9310111	9309906	Labilithrix luteola strain DSM 27648, complete genome	blastn	15949	287	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
7831693	7831693	PRJNA1061474_P_NODE_58067_length_241_cov_0.916667_g57821_i0	PRJNA1061474	58067	241	0.916667	2.20916747	Anaeromyxobacter paludicola	2918171	Bacteria	Bacteria	150	7.48e-32	NTclustered	gi\|2199271117\|dbj\|AP025592.1\|	2918171	g57821	i0	80.282	1.12448132780083	213	31	85	9	34	239	2987732	2987940	Anaeromyxobacter paludicola DNA, complete genome	blastn	271	150	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter paludicola
9106656	9106656	PRJNA1061474_P_NODE_57268_length_241_cov_0.916667_g57022_i0	PRJNA1061474	57268	241	0.916667	2.20916747	Vulgatibacter incomptus	1391653	Bacteria	Bacteria	73.1	1.67e-8	NTclustered	gi\|913607065\|gb\|CP012332.1\|	1391653	g57022	i0	90.909	0.394190871369295	55	4	23	1	7	61	2684757	2684810	Vulgatibacter incomptus strain DSM 27710, complete genome	blastn	95	73.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Vulgatibacteraceae	Vulgatibacter	Vulgatibacter incomptus
9939850	9939850	PRJNA1061474_P_NODE_50448_length_247_cov_0.885057_g50202_i0	PRJNA1061474	50448	247	0.885057	2.18609079	Myxococcus	32	Bacteria	Bacteria	124	4.66e-24	NTclustered	gi\|441484664\|gb\|CP004025.1\|	1278073	g50202	i0	88.35	41.502024291498	103	12	42	0	119	221	7662986	7663088	Myxococcus stipitatus DSM 14675, complete genome	blastn	10251	124	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
10382099	10382099	PRJNA1061474_P_NODE_46849_length_250_cov_0.870056_g46603_i0	PRJNA1061474	46849	250	0.870056	2.17514	Anaeromyxobacter dehalogenans	161493	Bacteria	Bacteria	265	2.67e-66	NTclustered	gi\|219952977\|gb\|CP001359.1\|	455488	g46603	i0	86.056	41.94	251	29	99	5	3	250	4969089	4969336	Anaeromyxobacter dehalogenans 2CP-1 chromosome, complete genome	blastn	10485	265	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
11657469	11657469	PRJNA1061474_P_NODE_50650_length_247_cov_0.885057_g50404_i0	PRJNA1061474	50650	247	0.885057	2.18609079	Labilithrix luteola	1391654	Bacteria	Bacteria	302	2.01e-77	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g50404	i0	88.664	12.3684210526316	247	28	100	0	1	247	3171338	3171584	Labilithrix luteola strain DSM 27648, complete genome	blastn	3055	302	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
12490595	12490595	PRJNA1061474_P_NODE_47890_length_249_cov_0.875000_g47644_i0	PRJNA1061474	47890	249	0.875	2.17875	Anaeromyxobacter	161492	Bacteria	Bacteria	259	1.24e-64	NTclustered	gi\|85772941\|gb\|CP000251.1\|	290397	g47644	i0	85.484	15.3694779116466	248	36	99	0	2	249	1782524	1782277	Anaeromyxobacter dehalogenans 2CP-C, complete genome	blastn	3827	261	0.992337164750958	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
14207496	14207496	PRJNA1061474_P_NODE_45752_length_251_cov_0.865169_g45506_i0	PRJNA1061474	45752	251	0.865169	2.17157419	Archangium violaceum	83451	Bacteria	Bacteria	279	9.58e-71	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g45506	i0	86.905	100.262948207171	252	29	99	2	2	251	6190165	6189916	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	25166	279	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
20579872	20579872	PRJNA1061474_P_NODE_47037_length_250_cov_0.870056_g46791_i0	PRJNA1061474	47037	250	0.870056	2.17514	Minicystis rosea	888845	Bacteria	Bacteria	263	9.61e-66	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g46791	i0	85.657	8.28	251	34	100	2	1	250	10260013	10259764	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	2070	263	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea
20579959	20579959	PRJNA1061474_P_NODE_50897_length_247_cov_0.873563_g50651_i0	PRJNA1061474	50897	247	0.873563	2.15770061	Myxococcus stipitatus	83455	Bacteria	Bacteria	117	7.810000000000001e-22	NTclustered	gi\|2722781719\|gb\|CP102770.1\|	83455	g50651	i0	78.889	1.5668016194332	180	32	72	6	55	231	6125640	6125816	Myxococcus stipitatus strain YRE12 chromosome, complete genome	blastn	387	117	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
20580117	20580117	PRJNA1061474_P_NODE_56857_length_242_cov_0.911243_g56611_i0	PRJNA1061474	56857	242	0.911243	2.20520806	Polyangium aurulentum	2567896	Bacteria	Bacteria	198	2.6499999999999997e-46	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g56611	i0	81.707	7.40909090909091	246	37	100	6	1	242	5933532	5933291	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	1793	198	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
22688512	22688512	PRJNA1061474_P_NODE_47378_length_250_cov_0.870056_g47132_i0	PRJNA1061474	47378	250	0.870056	2.17514	Corallococcus	83461	Bacteria	Bacteria	148	2.8099999999999993e-31	NTclustered	gi\|2851136330\|gb\|CP172866.1\|	184914	g47132	i0	78.049	41.524	246	46	97	8	2	243	8247019	8246778	Corallococcus coralloides strain KYC2213 chromosome, complete genome	blastn	10381	148	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
23964127	23964127	PRJNA1061474_P_NODE_50419_length_247_cov_0.885057_g50173_i0	PRJNA1061474	50419	247	0.885057	2.18609079	Myxococcales	29	Bacteria	Bacteria	189	1.6299999999999999e-43	NTclustered	gi\|2579665545\|gb\|CP043492.1\|	43	g50173	i0	82.018	54.2348178137652	228	35	91	6	23	247	6745868	6746092	Cystobacter fuscus strain Cbf 8 chromosome, complete genome	blastn	13396	189	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Cystobacter	Cystobacter fuscus
25237987	25237987	PRJNA1061474_P_NODE_56200_length_242_cov_0.911243_g55954_i0	PRJNA1061474	56200	242	0.911243	2.20520806	Myxococcaceae	31	Bacteria	Bacteria	111	3.55e-20	NTclustered	gi\|1957989826\|gb\|CP068048.1\|	34	g55954	i0	86.111	74.1735537190083	108	9	43	5	1	105	3816731	3816835	Myxococcus xanthus strain R31 chromosome, complete genome	blastn	17950	111	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);;