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

9 rows where analysis = "blastn", bioproject = "PRJNA390533" 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
4236566	4236566	PRJNA390533_P_NODE_13524_length_517_cov_1.922594_g12553_i0	PRJNA390533	13524	517	1.922594	9.93981098	Polyangium aurulentum	2567896	Bacteria	Bacteria	156	3.75e-33	NTclustered	gi\|2235996827\|gb\|CP079217.1\|	2567896	g12553	i0	78.175	0.851063829787234	252	49	48	6	1	249	6458650	6458898	Polyangium aurulentum strain SDU3-1 chromosome, complete genome	blastn	440	156	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Polyangium	Polyangium aurulentum
10613457	10613457	PRJNA390533_P_NODE_24969_length_316_cov_1.249097_g23942_i0	PRJNA390533	24969	316	1.249097	3.94714652	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	87.9	8.11e-13	NTclustered	gi\|2108117163\|gb\|CP070734.1\|	2026735	g23942	i0	88.889	0.455696202531646	72	6	22	2	3	73	924371	924301	MAG: Deltaproteobacteria bacterium isolate bin407 chromosome	blastn	144	87.9	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium
10613458	10613458	PRJNA390533_P_NODE_25009_length_316_cov_1.220217_g23982_i0	PRJNA390533	25009	316	1.220217	3.85588572	Chondromyces crocatus	52	Bacteria	Bacteria	76.8	1.76e-9	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g23982	i0	91.228	6.38607594936709	57	3	18	2	7	62	582165	582110	Chondromyces crocatus strain Cm c5, complete genome	blastn	2018	76.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
13163617	13163617	PRJNA390533_P_NODE_45771_length_161_cov_1.204918_g44744_i0	PRJNA390533	45771	161	1.204918	1.93991798	Archangium violaceum	83451	Bacteria	Bacteria	115	1.68e-21	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g44744	i0	84.034	0.739130434782609	119	19	74	0	6	124	7596904	7597022	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	119	115	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
15105907	15105907	PRJNA390533_P_NODE_37472_length_193_cov_1.519481_g36445_i0	PRJNA390533	37472	193	1.519481	2.93259833	Haliangium	162027	Bacteria	Bacteria	156	1.23e-33	NTclustered	gi\|470485361\|ref\|NR_076697.1\|	80816	g36445	i0	83.429	71.4507772020725	175	22	89	7	1	171	209	38	Haliangium ochraceum strain SMP-2 23S ribosomal RNA gene, complete sequence	blastn	13790	156	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
16987283	16987283	PRJNA390533_P_NODE_40174_length_180_cov_1.276596_g39147_i0	PRJNA390533	40174	180	1.276596	2.2978728	Nannocystis punicea	2995304	Bacteria	Bacteria	58.4	3.28e-4	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g39147	i0	100	0.505555555555556	31	0	17	0	20	50	10580304	10580274	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	91	58.4	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea
20811093	20811093	PRJNA390533_P_NODE_11077_length_585_cov_50.532967_g10169_i0	PRJNA390533	11077	585	50.532967	295.61785695	Pendulispora brunnea	2905690	Bacteria	Bacteria	961	0	NTclustered	gi\|2698055994\|gb\|CP089982.1\|	2905690	g10169	i0	97.345	147.411965811966	565	15	97	0	21	585	7408910	7408346	Pendulispora brunnea strain MSr12523 chromosome, complete genome	blastn	86236	961	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora brunnea
20811210	20811210	PRJNA390533_P_NODE_18297_length_414_cov_1.621333_g17278_i0	PRJNA390533	18297	414	1.621333	6.71231862	Pseudomyxococcus hansupus	1297742	Bacteria	Bacteria	228	6.159999999999999e-55	NTclustered	gi\|891158403\|gb\|CP012109.1\|	1297742	g17278	i0	91.515	27.43961352657	165	14	40	0	22	186	7324657	7324493	Myxococcus hansupus strain mixupus chromosome, complete genome	blastn	11360	228	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Pseudomyxococcus	Pseudomyxococcus hansupus
24636061	24636061	PRJNA390533_P_NODE_24980_length_316_cov_1.241877_g23953_i0	PRJNA390533	24980	316	1.241877	3.92433132	Minicystis rosea	888845	Bacteria	Bacteria	87.9	8.11e-13	NTclustered	gi\|1127353251\|gb\|CP016211.1\|	888845	g23953	i0	86.42	18.2341772151899	81	9	25	2	237	316	10526975	10527054	Minicystis rosea strain DSM 24000 chromosome, complete genome	blastn	5762	87.9	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Minicystis	Minicystis rosea

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