metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA715462" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA715462" 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
1982249	1982249	PRJNA715462_P_NODE_55222_length_249_cov_0.875000_g54426_i0	PRJNA715462	55222	249	0.875	2.17875	Myxococcus fulvus	33	Bacteria	Bacteria	392	1.1699999999999999e-104	NTclustered	gi\|817709775\|gb\|CP006003.1\|	1334629	g54426	i0	95.161	3.01204819277108	248	12	99	0	2	249	1965857	1966104	Myxococcus fulvus 124B02, complete genome	blastn	750	392	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
1982297	1982297	PRJNA715462_P_NODE_58342_length_247_cov_0.885057_g57546_i0	PRJNA715462	58342	247	0.885057	2.18609079	Myxococcus fulvus	33	Bacteria	Bacteria	385	1.94e-102	NTclustered	gi\|817709775\|gb\|CP006003.1\|	1334629	g57546	i0	96.552	24.4615384615385	232	8	94	0	1	232	6936882	6937113	Myxococcus fulvus 124B02, complete genome	blastn	6042	385	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
4534369	4534369	PRJNA715462_P_NODE_42864_length_272_cov_1.547739_g42068_i0	PRJNA715462	42864	272	1.547739	4.20985008	Corallococcus coralloides	184914	Bacteria	Bacteria	309	1.3400000000000002e-79	NTclustered	gi\|380727201\|gb\|CP003389.1\|	1144275	g42068	i0	87.407	71.2573529411765	270	32	99	2	1	269	3550385	3550117	Corallococcus coralloides DSM 2259, complete genome	blastn	19382	309	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
5809616	5809616	PRJNA715462_P_NODE_40485_length_279_cov_2.145631_g39689_i0	PRJNA715462	40485	279	2.145631	5.98631049	Vulgatibacter incomptus	1391653	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|913607065\|gb\|CP012332.1\|	1391653	g39689	i0	100	0.10752688172043	30	0	11	0	11	40	3124790	3124761	Vulgatibacter incomptus strain DSM 27710, complete genome	blastn	30	56.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Vulgatibacteraceae	Vulgatibacter	Vulgatibacter incomptus
5809620	5809620	PRJNA715462_P_NODE_40605_length_279_cov_1.436893_g39809_i0	PRJNA715462	40605	279	1.436893	4.00893147	Myxococcus fulvus	33	Bacteria	Bacteria	503	5.9e-138	NTclustered	gi\|817709775\|gb\|CP006003.1\|	1334629	g39809	i0	99.636	5.70609318996416	275	1	99	0	5	279	6480384	6480658	Myxococcus fulvus 124B02, complete genome	blastn	1592	503	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
5809859	5809859	PRJNA715462_P_NODE_53285_length_250_cov_0.870056_g52489_i0	PRJNA715462	53285	250	0.870056	2.17514	Myxococcus fulvus	33	Bacteria	Bacteria	318	2.02e-82	NTclustered	gi\|817709775\|gb\|CP006003.1\|	1334629	g52489	i0	96.373	12.028	193	7	77	0	58	250	1348140	1348332	Myxococcus fulvus 124B02, complete genome	blastn	3007	318	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
5810149	5810149	PRJNA715462_P_NODE_70225_length_230_cov_2.439490_g69429_i0	PRJNA715462	70225	230	2.43949	5.610827	Myxococcus fulvus	33	Bacteria	Bacteria	139	1.53e-28	NTclustered	gi\|817709775\|gb\|CP006003.1\|	1334629	g69429	i0	97.561	1.56521739130435	82	1	36	1	149	230	1011837	1011917	Myxococcus fulvus 124B02, complete genome	blastn	360	139	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
8359537	8359537	PRJNA715462_P_NODE_55307_length_249_cov_0.875000_g54511_i0	PRJNA715462	55307	249	0.875	2.17875	Myxococcus fulvus	33	Bacteria	Bacteria	351	1.98e-92	NTclustered	gi\|817709775\|gb\|CP006003.1\|	1334629	g54511	i0	96.698	4.7710843373494	212	5	84	2	1	210	1336846	1336635	Myxococcus fulvus 124B02, complete genome	blastn	1188	351	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
10910052	10910052	PRJNA715462_P_NODE_43449_length_271_cov_0.919192_g42653_i0	PRJNA715462	43449	271	0.919192	2.49101032	Labilithrix luteola	1391654	Bacteria	Bacteria	150	8.569999999999998e-32	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g42653	i0	79.186	0.81549815498155	221	42	81	4	17	235	7005568	7005786	Labilithrix luteola strain DSM 27648, complete genome	blastn	221	150	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
10910496	10910496	PRJNA715462_P_NODE_68089_length_241_cov_1.547619_g67293_i0	PRJNA715462	68089	241	1.547619	3.72976179	Myxococcus fulvus	33	Bacteria	Bacteria	326	1.16e-84	NTclustered	gi\|817709775\|gb\|CP006003.1\|	1334629	g67293	i0	98.901	11.3941908713693	182	2	76	0	1	182	1334391	1334210	Myxococcus fulvus 124B02, complete genome	blastn	2746	326	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
12185774	12185774	PRJNA715462_P_NODE_68450_length_241_cov_0.916667_g67654_i0	PRJNA715462	68450	241	0.916667	2.20916747	Myxococcus stipitatus	83455	Bacteria	Bacteria	276	1.1799999999999998e-69	NTclustered	gi\|2722781719\|gb\|CP102770.1\|	83455	g67654	i0	87.398	4.76763485477178	246	23	99	3	1	238	1988928	1989173	Myxococcus stipitatus strain YRE12 chromosome, complete genome	blastn	1149	276	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
13460206	13460206	PRJNA715462_P_NODE_70091_length_233_cov_2.737500_g69295_i0	PRJNA715462	70091	233	2.7375	6.378375	Myxococcus fulvus	33	Bacteria	Bacteria	339	1.43e-88	NTclustered	gi\|817709775\|gb\|CP006003.1\|	1334629	g69295	i0	98.942	4.46781115879828	189	2	81	0	45	233	6957583	6957395	Myxococcus fulvus 124B02, complete genome	blastn	1041	339	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
19832879	19832879	PRJNA715462_P_NODE_40716_length_279_cov_1.121359_g39920_i0	PRJNA715462	40716	279	1.121359	3.12859161	Myxococcus stipitatus	83455	Bacteria	Bacteria	60.2	1.54e-4	NTclustered	gi\|2722781719\|gb\|CP102770.1\|	83455	g39920	i0	100	0.326164874551971	32	0	11	0	60	91	5815592	5815623	Myxococcus stipitatus strain YRE12 chromosome, complete genome	blastn	91	60.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus stipitatus
19833176	19833176	PRJNA715462_P_NODE_55976_length_248_cov_0.880000_g55180_i0	PRJNA715462	55976	248	0.88	2.1824	Myxococcus fulvus	33	Bacteria	Bacteria	215	2.7e-51	NTclustered	gi\|817709775\|gb\|CP006003.1\|	1334629	g55180	i0	99.16	1.43951612903226	119	1	48	0	1	119	8151592	8151474	Myxococcus fulvus 124B02, complete genome	blastn	357	215	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
20318711	20318711	PRJNA715462_P_NODE_54456_length_249_cov_0.875000_g53660_i0	PRJNA715462	54456	249	0.875	2.17875	Myxococcus	32	Bacteria	Bacteria	200	7.61e-47	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g53660	i0	96.667	19.574297188755	120	4	48	0	130	249	971180	971299	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	4874	200	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
21108460	21108460	PRJNA715462_P_NODE_43657_length_270_cov_1.360406_g42861_i0	PRJNA715462	43657	270	1.360406	3.6730962	Myxococcus fulvus	33	Bacteria	Bacteria	488	1.5899999999999995e-133	NTclustered	gi\|817709775\|gb\|CP006003.1\|	1334629	g42861	i0	99.259	3	270	2	100	0	1	270	8507809	8507540	Myxococcus fulvus 124B02, complete genome	blastn	810	488	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
22869748	22869748	PRJNA715462_P_NODE_50598_length_251_cov_0.865169_g49802_i0	PRJNA715462	50598	251	0.865169	2.17157419	Myxococcus	32	Bacteria	Bacteria	270	5.77e-68	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g49802	i0	97.468	18.6613545816733	158	4	63	0	94	251	7240304	7240147	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	4684	270	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
23659181	23659181	PRJNA715462_P_NODE_49379_length_254_cov_1.232044_g48583_i0	PRJNA715462	49379	254	1.232044	3.12939176	Myxococcus fulvus	33	Bacteria	Bacteria	244	3.5499999999999996e-60	NTclustered	gi\|817709775\|gb\|CP006003.1\|	1334629	g48583	i0	97.241	5.25590551181102	145	3	57	1	111	254	3489125	3489269	Myxococcus fulvus 124B02, complete genome	blastn	1335	244	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
24932975	24932975	PRJNA715462_P_NODE_65000_length_243_cov_0.905882_g64204_i0	PRJNA715462	65000	243	0.905882	2.20129326	Myxococcus fulvus	33	Bacteria	Bacteria	333	6.989999999999999e-87	NTclustered	gi\|2869653495\|gb\|CP175551.1\|	33	g64204	i0	94.064	12.880658436214	219	13	90	0	1	219	475083	474865	Myxococcus fulvus strain KYC1117 chromosome, complete genome	blastn	3130	333	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus

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