metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA560932" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA560932" 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
3095804	3095804	PRJNA560932_P_NODE_61923_length_244_cov_1.385965_g61567_i0	PRJNA560932	61923	244	1.385965	3.3817546	Labilithrix luteola	1391654	Bacteria	Bacteria	351	1.9399999999999998e-92	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g61567	i0	93.617	125.44262295082	235	15	96	0	1	235	3942992	3943226	Labilithrix luteola strain DSM 27648, complete genome	blastn	30608	351	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
9473207	9473207	PRJNA560932_P_NODE_31388_length_323_cov_0.924000_g31032_i0	PRJNA560932	31388	323	0.924	2.98452	Myxococcus landrumensis	2813577	Bacteria	Bacteria	75	6.47e-9	NTclustered	gi\|1998497960\|gb\|CP071091.1\|	2813577	g31032	i0	80.189	4.03405572755418	106	16	33	5	218	322	3997896	3997795	Myxococcus landrumus strain SCHIC003 chromosome	blastn	1303	75	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus landrumensis
10749034	10749034	PRJNA560932_P_NODE_4329_length_820_cov_8.303882_g4022_i0	PRJNA560932	4329	820	8.303882	68.0918324	Nannocystis punicea	2995304	Bacteria	Bacteria	363	3.35e-95	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g4022	i0	82.558	57.9756097560976	430	57	52	12	356	781	5377150	5377565	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	47540	363	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
16433265	16433265	PRJNA560932_P_NODE_513_length_1750_cov_8.954085_g424_i0	PRJNA560932	513	1750	8.954085	156.6964875	Pendulispora	3375062	Bacteria	Bacteria	1956	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g424	i0	87.025	175.858285714286	1765	192	99	32	6	1748	9854163	9852414	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	307752	1964	0.995926680244399	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
17122594	17122594	PRJNA560932_P_NODE_67894_length_230_cov_2.057325_g67538_i0	PRJNA560932	67894	230	2.057325	4.7318475	Labilithrix luteola	1391654	Bacteria	Bacteria	313	8.53e-81	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g67538	i0	91.266	204.178260869565	229	20	99	0	2	230	3942020	3942248	Labilithrix luteola strain DSM 27648, complete genome	blastn	46961	313	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
18396321	18396321	PRJNA560932_P_NODE_12775_length_489_cov_1.665865_g12421_i0	PRJNA560932	12775	489	1.665865	8.14607985	Myxococcus sp. SDU36	2831967	Bacteria	Bacteria	60.2	2.85e-4	NTclustered	gi\|2513984958\|gb\|CP077414.1\|	2831967	g12421	i0	100	0.208588957055215	32	0	7	0	163	194	3852032	3852001	Myxococcus sp. SDU36 chromosome, complete genome	blastn	102	60.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus sp. SDU36
19671179	19671179	PRJNA560932_P_NODE_37816_length_296_cov_1.035874_g37460_i0	PRJNA560932	37816	296	1.035874	3.06618704	Melittangium boletus	83453	Bacteria	Bacteria	342	1.4599999999999996e-89	NTclustered	gi\|1243026503\|gb\|CP022163.1\|	1294270	g37460	i0	87.713	96.3445945945946	293	36	99	0	2	294	8359599	8359891	Melittangium boletus DSM 14713 chromosome, complete genome	blastn	28518	342	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Melittangium	Melittangium boletus
22221885	22221885	PRJNA560932_P_NODE_56778_length_248_cov_0.880000_g56422_i0	PRJNA560932	56778	248	0.88	2.1824	Sorangium cellulosum	56	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1338588479\|gb\|CP012673.1\|	56	g56422	i0	100	5.61290322580645	29	0	12	0	175	203	114339	114311	Sorangium cellulosum strain So ce26 chromosome, complete genome	blastn	1392	54.7	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
24082454	24082454	PRJNA560932_P_NODE_16839_length_428_cov_2.183099_g16483_i0	PRJNA560932	16839	428	2.183099	9.34366372	Myxococcus	32	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g16483	i0	96.875	1.1214953271028	32	1	7	0	131	162	1006057	1006026	Myxococcus xanthus strain DK1050 chromosome	blastn	480	54.7	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);;