metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA695140" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA695140" and tax_phylum = "Thermodesulfobacteriota"

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
676173	676173	PRJNA695140_S_NODE_9161_length_175_cov_2.811594_g8980_i0	PRJNA695140	9161	175	2.811594	4.9202895	Taurinivorans muris	2787751	Bacteria	Bacteria	119	1.43e-22	NTclustered	gi\|2304091556\|gb\|CP065938.1\|	2787751	g8980	i0	81.208	0.851428571428571	149	26	85	2	8	155	134591	134738	Taurinivorans muris strain LT0009 chromosome, complete genome	blastn	149	119	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Taurinivorans	Taurinivorans muris
3733367	3733367	PRJNA695140_S_NODE_2163_length_355_cov_19.820755_g1982_i0	PRJNA695140	2163	355	19.820755	70.36368025	Lawsonia	41707	Bacteria	Bacteria	231	4.02e-56	NTclustered	gi\|2318587541\|gb\|CP107054.1\|	29546	g1982	i0	79.31	10.2704225352113	348	58	96	14	15	355	554725	555065	Lawsonia intracellularis strain PPE-GX01-2022 chromosome, complete genome	blastn	3646	231	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Lawsonia	Lawsonia intracellularis
4504144	4504144	PRJNA695140_S_NODE_4224_length_255_cov_1.064220_g4043_i0	PRJNA695140	4224	255	1.06422	2.713761	Maridesulfovibrio hydrothermalis	191026	Bacteria	Bacteria	145	3.7199999999999995e-30	NTclustered	gi\|432168615\|emb\|FO203522.1\|	1121451	g4043	i0	81.564	0.701960784313725	179	29	69	4	1	177	2078167	2077991	Desulfovibrio hydrothermalis AM13 = DSM 14728 chromosome, complete genome	blastn	179	145	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Maridesulfovibrio	Maridesulfovibrio hydrothermalis
5009849	5009849	PRJNA695140_S_NODE_4744_length_240_cov_101.581281_g4563_i0	PRJNA695140	4744	240	101.581281	243.7950744	Lawsonia	41707	Bacteria	Bacteria	226	1.1999999999999999e-54	NTclustered	gi\|2318587541\|gb\|CP107054.1\|	29546	g4563	i0	91.566	99.9125	166	11	69	2	61	223	653290	653455	Lawsonia intracellularis strain PPE-GX01-2022 chromosome, complete genome	blastn	23979	226	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Lawsonia	Lawsonia intracellularis
12660936	12660936	PRJNA695140_S_NODE_3130_length_296_cov_2.405405_g2949_i0	PRJNA695140	3130	296	2.405405	7.1199988	Lawsonia	41707	Bacteria	Bacteria	335	2.44e-87	NTclustered	gi\|94730694\|emb\|AM180252.1\|	363253	g2949	i0	87.543	2.92905405405405	289	36	98	0	6	294	1069274	1069562	Lawsonia intracellularis PHE/MN1-00	blastn	867	335	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Lawsonia	Lawsonia intracellularis
12660965	12660965	PRJNA695140_S_NODE_6230_length_210_cov_10.231214_g6049_i0	PRJNA695140	6230	210	10.231214	21.4855494	Lawsonia	41707	Bacteria	Bacteria	187	4.8399999999999984e-43	NTclustered	gi\|2318587541\|gb\|CP107054.1\|	29546	g6049	i0	85.955	11.552380952381	178	22	85	1	9	186	525506	525332	Lawsonia intracellularis strain PPE-GX01-2022 chromosome, complete genome	blastn	2426	187	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Lawsonia	Lawsonia intracellularis
15210178	15210178	PRJNA695140_S_NODE_5832_length_217_cov_10.233333_g5651_i0	PRJNA695140	5832	217	10.233333	22.20633261	Lawsonia	41707	Bacteria	Bacteria	135	1.85e-27	NTclustered	gi\|2318587541\|gb\|CP107054.1\|	29546	g5651	i0	83.439	2.1705069124424	157	14	70	9	7	157	1305341	1305491	Lawsonia intracellularis strain PPE-GX01-2022 chromosome, complete genome	blastn	471	135	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Lawsonia	Lawsonia intracellularis

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