metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA488043" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA488043" 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
5553424	5553424	PRJNA488043_P_NODE_18745_length_184_cov_3.916129_g16503_i0	PRJNA488043	18745	184	3.916129	7.20567736	Labilithrix luteola	1391654	Bacteria	Bacteria	246	6.71e-61	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g16503	i0	91.16	194.619565217391	181	16	98	0	1	181	3943876	3944056	Labilithrix luteola strain DSM 27648, complete genome	blastn	35810	246	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
11301283	11301283	PRJNA488043_P_NODE_8389_length_397_cov_199.040761_g6185_i0	PRJNA488043	8389	397	199.040761	790.19182117	Pendulispora	3375062	Bacteria	Bacteria	459	1.9199999999999997e-124	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g6185	i0	89.16	117.128463476071	369	38	93	2	30	397	7289859	7289492	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	46500	459	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
11301308	11301308	PRJNA488043_S_NODE_569_length_247_cov_6.958716_g558_i0	PRJNA488043	569	247	6.958716	17.18802852	Myxococcaceae	31	Bacteria	Bacteria	165	2.75e-36	NTclustered	gi\|470488931\|ref\|NR_076895.1\|	33	g558	i0	85.987	165.914979757085	157	19	63	2	1	156	1352	1506	Myxococcus fulvus strain HW-1 23S ribosomal RNA gene, complete sequence	blastn	40981	165	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus fulvus
19575732	19575732	PRJNA488043_P_NODE_4856_length_610_cov_4.137694_g2977_i0	PRJNA488043	4856	610	4.137694	25.2399334	Pendulispora albinea	2741071	Bacteria	Bacteria	845	0	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g2977	i0	91.694	130.618032786885	614	44	100	6	1	610	3589480	3588870	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	79677	845	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
22126484	22126484	PRJNA488043_S_NODE_1518_length_157_cov_6.039062_g1507_i0	PRJNA488043	1518	157	6.039062	9.48132734	Chondromyces crocatus	52	Bacteria	Bacteria	200	4.369999999999999e-47	NTclustered	gi\|169977285\|emb\|AM946600.1\|	52	g1507	i0	89.744	98.3630573248408	156	16	99	0	1	156	1569	1414	Chondromyces crocatus ajudazol biosynthesis gene cluster, strain Cmc5	blastn	15443	200	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus

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