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

8 rows where analysis = "blastn", bioproject = "PRJNA971593" 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
6047293	6047293	PRJNA971593_P_NODE_11685_length_353_cov_1.689286_g11536_i0	PRJNA971593	11685	353	1.689286	5.96317958	Labilithrix luteola	1391654	Bacteria	Bacteria	183	1.1299999999999998e-41	NTclustered	gi\|913610804\|gb\|CP012333.1\|	1391654	g11536	i0	80.579	1.6628895184136	242	44	68	3	1	240	10981567	10981807	Labilithrix luteola strain DSM 27648, complete genome	blastn	587	183	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Labilitrichaceae	Labilithrix	Labilithrix luteola
6370421	6370421	PRJNA971593_P_NODE_6445_length_480_cov_1.132678_g6297_i0	PRJNA971593	6445	480	1.132678	5.4368544	Corallococcus	83461	Bacteria	Bacteria	62.1	7.77e-5	NTclustered	gi\|380727201\|gb\|CP003389.1\|	1144275	g6297	i0	86.441	0.847916666666667	59	5	12	1	118	176	2680242	2680297	Corallococcus coralloides DSM 2259, complete genome	blastn	407	62.1	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Myxococcaceae	Corallococcus	Corallococcus coralloides
11147852	11147852	PRJNA971593_P_NODE_22049_length_251_cov_0.865169_g21900_i0	PRJNA971593	22049	251	0.865169	2.17157419	Archangium violaceum	83451	Bacteria	Bacteria	396	9.119999999999996e-106	NTclustered	gi\|1985695619\|gb\|CP069396.1\|	83451	g21900	i0	95.2	14.207171314741	250	12	99	0	2	251	107802	107553	Archangium violaceum strain SDU8 chromosome, complete genome	blastn	3566	396	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium violaceum
14972222	14972222	PRJNA971593_P_NODE_23592_length_249_cov_0.875000_g23443_i0	PRJNA971593	23592	249	0.875	2.17875	Archangium gephyra	48	Bacteria	Bacteria	444	3.18e-120	NTclustered	gi\|2809295724\|gb\|CP102578.1\|	48	g23443	i0	98.8	54.3935742971888	250	2	100	1	1	249	5626645	5626396	Archangium gephyra strain SDU49 chromosome, complete genome	blastn	13544	444	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Archangiaceae	Archangium	Archangium gephyra
17522465	17522465	PRJNA971593_P_NODE_6134_length_491_cov_1.289474_g5986_i0	PRJNA971593	6134	491	1.289474	6.33131734	Chondromyces crocatus	52	Bacteria	Bacteria	302	4.3100000000000004e-77	NTclustered	gi\|908353314\|gb\|CP012159.1\|	52	g5986	i0	78.443	42.6782077393075	501	81	99	23	3	491	2787023	2786538	Chondromyces crocatus strain Cm c5, complete genome	blastn	20955	302	1	Bacteria	Pseudomonadati	Myxococcota		Polyangiales	Polyangiaceae	Chondromyces	Chondromyces crocatus
18795945	18795945	PRJNA971593_P_NODE_13815_length_324_cov_1.107570_g13666_i0	PRJNA971593	13815	324	1.10757	3.5885268	Pendulispora rubella	2741070	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|2698045512\|gb\|CP089929.1\|	2741070	g13666	i0	92.105	0.234567901234568	38	2	11	1	239	275	11312599	11312636	Pendulispora rubella strain MSr11368 chromosome, complete genome	blastn	76	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Pendulisporaceae	Pendulispora	Pendulispora rubella
21668506	21668506	PRJNA971593_P_NODE_10457_length_374_cov_1.697674_g10308_i0	PRJNA971593	10457	374	1.697674	6.34930076	Anaeromyxobacter	161492	Bacteria	Bacteria	52.8	0.036	NTclustered	gi\|196170270\|gb\|CP001131.1\|	447217	g10308	i0	100	0.149732620320856	28	0	7	0	183	210	8639	8666	Anaeromyxobacter sp. K, complete genome	blastn	56	52.8	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia	Myxococcales	Anaeromyxobacteraceae	Anaeromyxobacter	Anaeromyxobacter sp. K
25170371	25170371	PRJNA971593_P_NODE_19860_length_266_cov_1.637306_g19711_i0	PRJNA971593	19860	266	1.637306	4.35523396	Deltaproteobacteria bacterium	2026735	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2108253172\|gb\|CP070689.1\|	2026735	g19711	i0	96.97	0.12406015037594	33	1	12	0	84	116	1793159	1793127	MAG: Deltaproteobacteria bacterium isolate bin63 chromosome	blastn	33	56.5	1	Bacteria	Pseudomonadati	Myxococcota	Myxococcia				Deltaproteobacteria bacterium

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