metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA597223" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA597223" 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
2416209	2416209	PRJNA597223_P_NODE_8922_length_582_cov_186.881170_g7352_i0	PRJNA597223	8922	582	186.88117	1087.6484094	Myxococcia	32015	Bacteria	Bacteria	863	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g7352	i0	93.46	137.798969072165	581	38	99	0	1	581	7089725	7090305	Labilithrix luteola strain DSM 27648, complete genome	blastn	80199	863	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
10773198	10773198	PRJNA597223_P_NODE_21369_length_346_cov_4.877814_g19530_i0	PRJNA597223	21369	346	4.877814	16.87723644	Labilithrix luteola	1391654	Bacteria	Bacteria	446	1.29e-120	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g19530	i0	89.943	201.384393063584	348	31	100	4	1	346	3942296	3941951	Labilithrix luteola strain DSM 27648, complete genome	blastn	69679	446	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
12619934	12619934	PRJNA597223_P_NODE_9670_length_558_cov_10.074570_g8042_i0	PRJNA597223	9670	558	10.07457	56.2161006	Pendulispora	3375062	Bacteria	Bacteria	839	0	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g8042	i0	93.907	171.584229390681	558	30	100	3	1	558	7288976	7289529	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	95744	839	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
14598151	14598151	PRJNA597223_P_NODE_56152_length_188_cov_2.241830_g54306_i0	PRJNA597223	56152	188	2.24183	4.2146404	Polyangium aurulentum	2567896	Bacteria	Bacteria	159	9.229999999999999e-35	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g54306	i0	94.286	7.88297872340426	105	4	92	2	1	104	443064	443167	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	1482	159	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
16443487	16443487	PRJNA597223_P_NODE_55693_length_188_cov_669.947712_g53847_i0	PRJNA597223	55693	188	669.947712	1259.50169856	Pendulispora	3375062	Bacteria	Bacteria	257	3.1800000000000004e-64	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g53847	i0	91.444	557.574468085106	187	16	99	0	1	187	7289010	7288824	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	104824	257	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
17146693	17146693	PRJNA597223_P_NODE_34254_length_250_cov_7.395349_g32408_i0	PRJNA597223	34254	250	7.395349	18.4883725	Pendulispora albinea	2741071	Bacteria	Bacteria	255	1.61e-63	NTclustered	gi\|2698035964\|gb\|CP089984.1\|	2741071	g32408	i0	85.433	52.936	254	27	99	9	1	248	3589471	3589222	Pendulispora albinea strain MSr11954 chromosome, complete genome	blastn	13234	255	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora albinea
17146807	17146807	PRJNA597223_P_NODE_43794_length_213_cov_6.280899_g41948_i0	PRJNA597223	43794	213	6.280899	13.37831487	Labilithrix luteola	1391654	Bacteria	Bacteria	333	5.979999999999998e-87	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g41948	i0	94.836	148.112676056338	213	11	100	0	1	213	3943857	3944069	Labilithrix luteola strain DSM 27648, complete genome	blastn	31548	333	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
22246378	22246378	PRJNA597223_P_NODE_5418_length_749_cov_143.446779_g4152_i0	PRJNA597223	5418	749	143.446779	1074.41637471	Labilithrix luteola	1391654	Bacteria	Bacteria	1114	0	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g4152	i0	93.583	142.069425901202	748	46	99	2	2	748	7089559	7090305	Labilithrix luteola strain DSM 27648, complete genome	blastn	106410	1114	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
22817831	22817831	PRJNA597223_P_NODE_1838_length_1249_cov_273.705107_g1198_i0	PRJNA597223	1838	1249	273.705107	3418.57678643	Haliangium	162027	Bacteria	Bacteria	1170	0	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g1198	i0	83.797	155.436349079263	1259	177	99	23	5	1249	1776	531	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	194140	1170	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
23521640	23521640	PRJNA597223_P_NODE_6279_length_695_cov_155.963636_g4910_i0	PRJNA597223	6279	695	155.963636	1083.9472702	Pendulispora brunnea	2905690	Bacteria	Bacteria	957	0	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g4910	i0	92.782	137.174100719424	665	42	95	6	1	662	7408722	7408061	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	95336	957	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
24795205	24795205	PRJNA597223_P_NODE_42640_length_217_cov_2.461538_g40794_i0	PRJNA597223	42640	217	2.461538	5.34153746	Nannocystis exedens	54	Bacteria	Bacteria	368	1.68e-97	NTclustered	gi\|2244669\|emb\|X87286.1\|	54	g40794	i0	97.235	114.884792626728	217	6	100	0	1	217	1343	1127	N.exedens 23S rRNA gene	blastn	24930	368	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis exedens

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