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

11 rows where analysis = "blastn", bioproject = "PRJNA764222" 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
1205771	1205771	PRJNA764222_S_NODE_4901_length_311_cov_2.712121_g4743_i0	PRJNA764222	4901	311	2.712121	8.43469631	Lawsonia	41707	Bacteria	Bacteria	237	7.48e-58	NTclustered	gi\|2318587541\|gb\|CP107054.1\|	29546	g4743	i0	80.656	2.94212218649518	305	59	98	0	6	310	940027	939723	Lawsonia intracellularis strain PPE-GX01-2022 chromosome, complete genome	blastn	915	237	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Lawsonia	Lawsonia intracellularis
2481163	2481163	PRJNA764222_S_NODE_15242_length_232_cov_1.870270_g15084_i0	PRJNA764222	15242	232	1.87027	4.3390264	Lawsonia	41707	Bacteria	Bacteria	111	3.37e-20	NTclustered	gi\|2318587541\|gb\|CP107054.1\|	29546	g15084	i0	84.956	1.46120689655172	113	13	48	3	79	189	379202	379312	Lawsonia intracellularis strain PPE-GX01-2022 chromosome, complete genome	blastn	339	111	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Lawsonia	Lawsonia intracellularis
5034127	5034127	PRJNA764222_S_NODE_5024_length_309_cov_3.049618_g4866_i0	PRJNA764222	5024	309	3.049618	9.42331962	Lawsonia	41707	Bacteria	Bacteria	315	3.3299999999999993e-81	NTclustered	gi\|2318587541\|gb\|CP107054.1\|	29546	g4866	i0	85.065	2.99029126213592	308	46	99	0	1	308	187413	187106	Lawsonia intracellularis strain PPE-GX01-2022 chromosome, complete genome	blastn	924	315	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Lawsonia	Lawsonia intracellularis
6309874	6309874	PRJNA764222_S_NODE_6905_length_288_cov_2.468880_g6747_i0	PRJNA764222	6905	288	2.46888	7.1103744	Lawsonia	41707	Bacteria	Bacteria	152	2.55e-32	NTclustered	gi\|2318587541\|gb\|CP107054.1\|	29546	g6747	i0	76.703	2.90625	279	61	96	4	1	277	1341481	1341205	Lawsonia intracellularis strain PPE-GX01-2022 chromosome, complete genome	blastn	837	152	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Lawsonia	Lawsonia intracellularis
8858917	8858917	PRJNA764222_S_NODE_28327_length_175_cov_2.414062_g28169_i0	PRJNA764222	28327	175	2.414062	4.2246085	Lawsonia	41707	Bacteria	Bacteria	84.2	5.23e-12	NTclustered	gi\|2318588786\|gb\|CP107055.1\|	29546	g28169	i0	84.091	1.50857142857143	88	13	50	1	3	90	165097	165011	Lawsonia intracellularis strain PPE-GX01-2022 plasmid pl01, complete sequence	blastn	264	84.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Lawsonia	Lawsonia intracellularis
12224246	12224246	PRJNA764222_S_NODE_14230_length_237_cov_2.426316_g14072_i0	PRJNA764222	14230	237	2.426316	5.75036892	Maridesulfovibrio sp.	2795000	Bacteria	Bacteria	63.9	9.83e-6	NTclustered	gi\|2621785158\|emb\|OY781616.1\|	2795000	g14072	i0	81.013	0.333333333333333	79	15	33	0	159	237	2328063	2327985	MAG: Maridesulfovibrio sp. isolate 7570950b-8a73-422e-b528-09704edcd613 genome assembly, chromosome: 1	blastn	79	63.9	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Maridesulfovibrio	Maridesulfovibrio sp.
15234317	15234317	PRJNA764222_S_NODE_3652_length_334_cov_9.804878_g3494_i0	PRJNA764222	3652	334	9.804878	32.74829252	Lawsonia	41707	Bacteria	Bacteria	200	1.06e-46	NTclustered	gi\|2318587541\|gb\|CP107054.1\|	29546	g3494	i0	84.038	12.2095808383234	213	29	63	5	100	310	554900	554691	Lawsonia intracellularis strain PPE-GX01-2022 chromosome, complete genome	blastn	4078	200	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Lawsonia	Lawsonia intracellularis
19057594	19057594	PRJNA764222_S_NODE_6955_length_288_cov_1.634855_g6797_i0	PRJNA764222	6955	288	1.634855	4.7083824	Lawsonia	41707	Bacteria	Bacteria	180	1.17e-40	NTclustered	gi\|2318587541\|gb\|CP107054.1\|	29546	g6797	i0	78.648	2.92708333333333	281	52	96	7	12	288	305017	305293	Lawsonia intracellularis strain PPE-GX01-2022 chromosome, complete genome	blastn	843	180	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Lawsonia	Lawsonia intracellularis
21607969	21607969	PRJNA764222_S_NODE_3517_length_338_cov_2.436426_g3359_i0	PRJNA764222	3517	338	2.436426	8.23511988	Lawsonia	41707	Bacteria	Bacteria	342	1.69e-89	NTclustered	gi\|2318587541\|gb\|CP107054.1\|	29546	g3359	i0	84.911	11.8668639053254	338	51	100	0	1	338	466520	466857	Lawsonia intracellularis strain PPE-GX01-2022 chromosome, complete genome	blastn	4011	342	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Lawsonia	Lawsonia intracellularis
24157399	24157399	PRJNA764222_S_NODE_14439_length_236_cov_2.179894_g14281_i0	PRJNA764222	14439	236	2.179894	5.14454984	Lawsonia	41707	Bacteria	Bacteria	276	1.15e-69	NTclustered	gi\|2318587541\|gb\|CP107054.1\|	29546	g14281	i0	88.034	4.95762711864407	234	27	99	1	1	234	754083	753851	Lawsonia intracellularis strain PPE-GX01-2022 chromosome, complete genome	blastn	1170	276	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Lawsonia	Lawsonia intracellularis
25432375	25432375	PRJNA764222_S_NODE_14120_length_238_cov_1.649215_g13962_i0	PRJNA764222	14120	238	1.649215	3.9251317	Lawsonia	41707	Bacteria	Bacteria	185	2.0199999999999998e-42	NTclustered	gi\|2318587541\|gb\|CP107054.1\|	29546	g13962	i0	81.385	2.91176470588235	231	39	96	4	10	238	857541	857313	Lawsonia intracellularis strain PPE-GX01-2022 chromosome, complete genome	blastn	693	185	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);;