metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA727760" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA727760" and tax_phylum = "Pseudomonadota"

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

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