metadata: contig_metadata: 5 rows where bioproject = "PRJNA896758", tax_kingdom = "Pseudomonadati" and tax

5 rows where bioproject = "PRJNA896758", tax_kingdom = "Pseudomonadati" 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
12723503	12723503	PRJNA896758_P_NODE_9450_length_371_cov_1.825503_g9060_i0	PRJNA896758	9450	371	1.825503	6.77261613	Lawsonia	41707	Bacteria	Bacteria	542	1.72e-149	NTclustered	gi\|2318587541\|gb\|CP107054.1\|	29546	g9060	i0	92.992	304.466307277628	371	26	100	0	1	371	653832	654202	Lawsonia intracellularis strain PPE-GX01-2022 chromosome, complete genome	blastn	112957	542	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Lawsonia	Lawsonia intracellularis
18724332	18724332	PRJNA896758_P_NODE_25855_length_242_cov_0.911243_g25465_i0	PRJNA896758	25855	242	0.911243	2.20520806	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	101	6.649999999999999e-23	NR	MCG6905396.1	2049433	g25465	i0	62.7	2.76446280991736	75	28	93	0	227	3	293	367	MCG6905396.1 leucyl aminopeptidase [Desulfobacteraceae bacterium]	diamond	669	101	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
22549596	22549596	PRJNA896758_P_NODE_11898_length_333_cov_2.073077_g11508_i0	PRJNA896758	11898	333	2.073077	6.90334641	Desulfuromonas versatilis	2802975	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2065532709\|dbj\|AP024355.1\|	2802975	g11508	i0	94.444	1.05105105105105	36	0	11	2	182	216	1629224	1629258	Desulfuromonas versatilis NIT-T3 DNA, complete genome	blastn	350	54.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Desulfuromonadales	Desulfuromonadaceae	Desulfuromonas	Desulfuromonas versatilis
31066953	31066953	PRJNA896758_P_NODE_23415_length_247_cov_0.885057_g23025_i0	PRJNA896758	23415	247	0.885057	2.18609079	Desulfomicrobium norvegicum	52561	Bacteria	Bacteria	42.7	0.0373	NR	WP_092190130.1	52561	g23025	i0	34.7	0.874493927125506	72	39	80.2	2	11	208	132	201	WP_092190130.1 hemolytic protein HlpA-like protein [Desulfomicrobium norvegicum]	diamond	216	42.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium norvegicum
31604381	31604381	PRJNA896758_P_NODE_21856_length_250_cov_0.870056_g21466_i0	PRJNA896758	21856	250	0.870056	2.17514	Candidatus Dadabacteria bacterium	2080303	Bacteria	Bacteria	44.3	0.0103	NR	KAB2833988.1	2080303	g21466	i0	39.2	1.788	74	39	88.8	2	245	24	105	172	KAB2833988.1 MAG: hypothetical protein F9K51_02640 [Candidatus Dadabacteria bacterium]	diamond	447	44.3	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Candidatus Dadabacteria				Candidatus Dadabacteria 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);;