metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA631119" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA631119" 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
603283	603283	PRJNA631119_P_NODE_5961_length_470_cov_4.440806_g5843_i0	PRJNA631119	5961	470	4.440806	20.8717882	Labilithrix luteola	1391654	Bacteria	Bacteria	486	1.0599999999999998e-132	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g5843	i0	85.474	247.76170212766	475	60	100	9	1	470	3942241	3941771	Labilithrix luteola strain DSM 27648, complete genome	blastn	116448	486	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
1879301	1879301	PRJNA631119_P_NODE_10862_length_371_cov_1.701342_g10744_i0	PRJNA631119	10862	371	1.701342	6.31197882	Corallococcus exercitus	2316736	Bacteria	Bacteria	150	1.22e-31	NTclustered	gi\|2809270164\|gb\|CP102577.1\|	2316736	g10744	i0	88.618	27.7681940700809	123	14	33	0	3	125	7614608	7614730	Corallococcus exercitus strain SDU142 chromosome, complete genome	blastn	10302	150	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus exercitus
4431021	4431021	PRJNA631119_P_NODE_40284_length_232_cov_4.540881_g40166_i0	PRJNA631119	40284	232	4.540881	10.53484392	Sandaracinus amylolyticus	927083	Bacteria	Bacteria	60.2	1.24e-4	NTclustered	gi\|2183633570\|gb\|CP070225.1\|	927083	g40166	i0	97.222	7.87931034482759	36	0	19	1	7	41	4632932	4632967	Sandaracinus strain MSr10575 (SBSa001) chromosome, complete sequence	blastn	1828	60.2	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Sandaracinaceae	Sandaracinus	Sandaracinus amylolyticus
9531681	9531681	PRJNA631119_P_NODE_17688_length_310_cov_3.172996_g17570_i0	PRJNA631119	17688	310	3.172996	9.8362876	uncultured Polyangiaceae bacterium	417999	Bacteria	Bacteria	564	3.0099999999999996e-156	NTclustered	gi\|304569644\|gb\|HQ111161.1\|	417999	g17570	i0	99.675	99.2322580645161	308	1	99	0	1	308	1085	1392	Uncultured Polyangiaceae bacterium clone cuticle_16 16S ribosomal RNA gene, partial sequence	blastn	30762	564	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae		uncultured Polyangiaceae bacterium
13357414	13357414	PRJNA631119_P_NODE_22531_length_284_cov_1.473934_g22413_i0	PRJNA631119	22531	284	1.473934	4.18597256	Labilithrix luteola	1391654	Bacteria	Bacteria	353	6.42e-93	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g22413	i0	89.161	96.8943661971831	286	27	100	4	1	284	3942260	3941977	Labilithrix luteola strain DSM 27648, complete genome	blastn	27518	353	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
18455267	18455267	PRJNA631119_P_NODE_21495_length_289_cov_1.814815_g21377_i0	PRJNA631119	21495	289	1.814815	5.24481535	Pendulispora brunnea	2905690	Bacteria	Bacteria	448	2.9199999999999997e-121	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g21377	i0	94.774	129.847750865052	287	15	99	0	3	289	7408529	7408243	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	37526	448	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
24829592	24829592	PRJNA631119_P_NODE_7400_length_430_cov_3.095238_g7282_i0	PRJNA631119	7400	430	3.095238	13.3095234	Labilithrix luteola	1391654	Bacteria	Bacteria	542	2.02e-149	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g7282	i0	89.45	112.904651162791	436	36	99	7	2	430	3943484	3943052	Labilithrix luteola strain DSM 27648, complete genome	blastn	48549	542	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola

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