metadata: contig_metadata: 8 rows where bioproject = "PRJNA727760" and tax

8 rows where bioproject = "PRJNA727760" and tax_kingdom = "Pseudomonadati"

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
2470114	2470114	PRJNA727760_S_NODE_1222_length_422_cov_2.601719_g1194_i0	PRJNA727760	1222	422	2.601719	10.97925418	root	1	Root_unresolved	Root_unresolved	52.8	0.041	NTclustered	gi\|959230911\|emb\|LN899826.1\|	305	g1194	i0	100	0.265402843601896	28	0	7	0	1	28	111808	111781	Ralstonia solanacearum genome assembly 9 genomes, chromosome : VIII	blastn	112	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia solanacearum
4541063	4541063	PRJNA727760_S_NODE_1704_length_351_cov_1.687050_g1676_i0	PRJNA727760	1704	351	1.68705	5.9215455	Porphyrobacter sp. GA68	2883480	Bacteria	Bacteria	96.7	1.18e-20	NR	WP_228244238.1	2883480	g1676	i0	96.2	0.452991452991453	53	2	45.3	0	44	202	5	57	WP_228244238.1 alpha/beta fold hydrolase [Porphyrobacter sp. GA68]	diamond	159	96.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Erythrobacteraceae	Porphyrobacter	Porphyrobacter sp. GA68
4541067	4541067	PRJNA727760_S_NODE_324_length_839_cov_2.039164_g307_i0	PRJNA727760	324	839	2.039164	17.10858596	Klebsiella pneumoniae	573	Bacteria	Bacteria	75	1.8e-8	NTclustered	gi\|2523005509\|gb\|CP040712.1\|	573	g307	i0	97.727	40.0738974970203	44	0	5	1	795	837	254341	254298	Klebsiella pneumoniae strain 16HN-35 plasmid p16HN-35_Vir, complete sequence	blastn	33622	75	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
6298852	6298852	PRJNA727760_S_NODE_3345_length_253_cov_1.205556_g3317_i0	PRJNA727760	3345	253	1.205556	3.05005668	Pseudomonadati	3379134	Bacteria	Bacteria	87.9	6.29e-13	NTclustered	gi\|2523005509\|gb\|CP040712.1\|	573	g3317	i0	96.296	187.03162055336	54	0	21	2	199	251	254341	254289	Klebsiella pneumoniae strain 16HN-35 plasmid p16HN-35_Vir, complete sequence	blastn	47319	87.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
7572640	7572640	PRJNA727760_S_NODE_486_length_700_cov_2.622010_g463_i0	PRJNA727760	486	700	2.62201	18.35407	Bacteria	2	Bacteria	Bacteria	69.4	6.94e-7	NTclustered	gi\|959220006\|emb\|LN899824.1\|	305	g463	i0	97.5	48.1028571428571	40	1	6	0	658	697	5780954	5780915	Ralstonia solanacearum genome assembly 9 genomes, chromosome : VI	blastn	33672	69.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia solanacearum
8365948	8365948	PRJNA727760_S_NODE_3067_length_263_cov_1.068421_g3039_i0	PRJNA727760	3067	263	1.068421	2.80994723	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	93.5	1.41e-14	NTclustered	gi\|2166246725\|dbj\|LC663157.1\|	2049433	g3039	i0	96.491	184.053231939164	57	0	21	2	1	56	6738	6683	Desulfobacteraceae bacterium ARSSAG-00001218 DNA, putative prophage region, clone: 00001218_pp2	blastn	48406	93.5	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
10916747	10916747	PRJNA727760_S_NODE_649_length_607_cov_2.209738_g624_i0	PRJNA727760	649	607	2.209738	13.41310966	Klebsiella pneumoniae	573	Bacteria	Bacteria	87.9	1.65e-12	NTclustered	gi\|2523005509\|gb\|CP040712.1\|	573	g624	i0	96.296	75.7808896210873	54	0	9	2	2	54	254289	254341	Klebsiella pneumoniae strain 16HN-35 plasmid p16HN-35_Vir, complete sequence	blastn	45999	87.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
32297313	32297313	PRJNA727760_S_NODE_1659_length_357_cov_4.971831_g1631_i0	PRJNA727760	1659	357	4.971831	17.74943667	Pseudomonas syringae group genomosp. 7	251699	Bacteria	Bacteria	43.9	0.0117	NR	WP_395587240.1	251699	g1631	i0	48.7	0.65546218487395	78	22	58.8	8	115	324	4	71	WP_395587240.1 hypothetical protein [Pseudomonas syringae group genomosp. 7]	diamond	234	43.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas syringae group genomosp. 7

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