metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA666695" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA666695" 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
2437984	2437984	PRJNA666695_S_NODE_175102_length_161_cov_3.500000_g174008_i0	PRJNA666695	175102	161	3.5	5.635	Archangium	47	Bacteria	Bacteria	126	7.77e-25	NTclustered	gi\|2579687829\|gb\|CP043494.1\|	83450	g174008	i0	80.864	3.03105590062112	162	29	100	2	1	161	4508327	4508487	Archangium minus strain Cbm 6 chromosome, complete genome	blastn	488	126	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium minus
4991025	4991025	PRJNA666695_S_NODE_169004_length_165_cov_1.854839_g167910_i0	PRJNA666695	169004	165	1.854839	3.06048435	Pseudomonadati	3379134	Bacteria	Bacteria	86.1	1.36e-12	NTclustered	gi\|2318731907\|gb\|CP104804.1\|	34	g167910	i0	83.333	9.61818181818182	96	12	57	3	63	156	8779418	8779511	Myxococcus xanthus strain DK1050 chromosome	blastn	1587	86.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Myxococcus	Myxococcus xanthus
13385667	13385667	PRJNA666695_S_NODE_187671_length_154_cov_2.442478_g186577_i0	PRJNA666695	187671	154	2.442478	3.76141612	Sorangium cellulosum	56	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|1566495190\|gb\|CP012670.1\|	56	g186577	i0	94.286	0.227272727272727	35	1	23	1	25	59	7313458	7313425	Sorangium cellulosum strain So ceGT47 chromosome, complete genome	blastn	35	52.8	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	Sorangium cellulosum
15933129	15933129	PRJNA666695_S_NODE_115633_length_204_cov_3.803681_g114539_i0	PRJNA666695	115633	204	3.803681	7.75950924	uncultured Sorangium sp.	491148	Bacteria	Bacteria	204	4.6399999999999994e-48	NTclustered	gi\|310755296\|gb\|HQ213186.1\|	491148	g114539	i0	96	115.28431372549	125	5	61	0	36	160	1105	1229	Uncultured Sorangium sp. clone 3_E21 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	23518	204	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Sorangium	uncultured Sorangium sp.
19014918	19014918	PRJNA666695_S_NODE_81215_length_241_cov_2.905000_g80121_i0	PRJNA666695	81215	241	2.905	7.00105	Pendulispora	3375062	Bacteria	Bacteria	387	5.24e-103	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g80121	i0	96.186	156.381742738589	236	9	98	0	1	236	9852115	9851880	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	37688	388	0.997422680412371	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
22309358	22309358	PRJNA666695_S_NODE_27758_length_367_cov_2.279141_g26665_i0	PRJNA666695	27758	367	2.279141	8.36444747	Haliangium ochraceum	80816	Bacteria	Bacteria	58.4	7.49e-4	NTclustered	gi\|262076673\|gb\|CP001804.1\|	502025	g26665	i0	92.5	0.26158038147139	40	3	11	0	159	198	2356178	2356217	Haliangium ochraceum DSM 14365, complete genome	blastn	96	58.4	1	Bacteria	Pseudomonadati	Myxococcota		Haliangiales	Kofleriaceae	Haliangium	Haliangium ochraceum
23582661	23582661	PRJNA666695_S_NODE_103219_length_216_cov_2.891429_g102125_i0	PRJNA666695	103219	216	2.891429	6.24548664	Anaeromyxobacter dehalogenans	161493	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|219952977\|gb\|CP001359.1\|	455488	g102125	i0	100	0.912037037037037	29	0	13	0	118	146	4312867	4312895	Anaeromyxobacter dehalogenans 2CP-1 chromosome, complete genome	blastn	197	54.7	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter dehalogenans
23585773	23585773	PRJNA666695_S_NODE_68739_length_258_cov_7.953917_g67645_i0	PRJNA666695	68739	258	7.953917	20.52110586	Nannocystis punicea	2995304	Bacteria	Bacteria	73.1	1.8e-8	NTclustered	gi\|2415023655\|gb\|CP114040.1\|	2995304	g67645	i0	93.75	0.383720930232558	48	3	19	0	66	113	11313743	11313696	Nannocystis poenicansa strain FL3 chromosome, complete genome	blastn	99	73.1	1	Bacteria	Pseudomonadati	Myxococcota		Nannocystales	Nannocystaceae	Nannocystis	Nannocystis punicea

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