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

5 rows where analysis = "blastn", bioproject = "PRJNA975724" 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
2222899	2222899	PRJNA975724_S_NODE_93262_length_231_cov_3.221519_g93081_i0	PRJNA975724	93262	231	3.221519	7.44170889	Pyxidicoccus parkwayensis	2813578	Bacteria	Bacteria	339	1.41e-88	NTclustered	gi\|1998505907\|gb\|CP071090.1\|	2813578	g93081	i0	93.103	316.874458874459	232	14	100	2	1	231	2161256	2161486	Pyxidicoccus parkwaysis strain SCPEA02 chromosome	blastn	73198	339	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pyxidicoccus	Pyxidicoccus parkwayensis
6370870	6370870	PRJNA975724_S_NODE_1245_length_757_cov_2.409357_g1098_i0	PRJNA975724	1245	757	2.409357	18.23883249	Stigmatella	40	Bacteria	Bacteria	880	0	NTclustered	gi\|507148216\|ref\|NR_103023.1\|	41	g1098	i0	88.63	227.455746367239	730	74	96	6	28	754	11	734	Stigmatella aurantiaca strain DW4/3-1 23S ribosomal RNA gene, complete sequence	blastn	172184	880	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Stigmatella	Stigmatella aurantiaca
9873567	9873567	PRJNA975724_S_NODE_1228_length_759_cov_8.960641_g1081_i0	PRJNA975724	1228	759	8.960641	68.01126519	Labilithrix luteola	1391654	Bacteria	Bacteria	979	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g1081	i0	90.331	160.02766798419	755	61	98	9	15	759	3942048	3942800	Labilithrix luteola strain DSM 27648, complete genome	blastn	121461	979	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
16250428	16250428	PRJNA975724_S_NODE_93_length_1655_cov_10.932996_g85_i0	PRJNA975724	93	1655	10.932996	180.9410838	Pendulispora rubella	2741070	Bacteria	Bacteria	2091	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g85	i0	89.908	154.658006042296	1635	149	98	14	1	1627	9852518	9854144	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	255959	2091	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
17524993	17524993	PRJNA975724_S_NODE_72534_length_259_cov_1.241935_g72353_i0	PRJNA975724	72534	259	1.241935	3.21661165	Pendulispora albinea	2741071	Bacteria	Bacteria	60.2	1.41e-4	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g72353	i0	91.111	0.173745173745174	45	2	17	2	36	80	4379336	4379294	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	45	60.2	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea

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