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

10 rows where analysis = "blastn", bioproject = "PRJNA727760" and tax_superkingdom = "Bacteria"

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
3746558	3746558	PRJNA727760_S_NODE_503_length_687_cov_2.333876_g480_i0	PRJNA727760	503	687	2.333876	16.03372812	Pseudomonadati	3379134	Bacteria	Bacteria	93.5	4.04e-14	NTclustered	gi\|2166246132\|dbj\|LC663124.1\|	1869227	g480	i0	93.651	125.052401746725	63	2	16	2	1	62	16	77	Bacterium ARSSAG-00002529 DNA, putative prophage region, clone: 00002529_pp1	blastn	85911	93.5	1	Bacteria							bacterium
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
10916744	10916744	PRJNA727760_S_NODE_1129_length_440_cov_1.299728_g1101_i0	PRJNA727760	1129	440	1.299728	5.7188032	bacterium	1869227	Bacteria	Bacteria	121	1.15e-22	NTclustered	gi\|2166246132\|dbj\|LC663124.1\|	1869227	g1101	i0	92.941	131.129545454545	85	3	19	3	358	440	88	5	Bacterium ARSSAG-00002529 DNA, putative prophage region, clone: 00002529_pp1	blastn	57697	121	1	Bacteria							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
16497753	16497753	PRJNA727760_S_NODE_3273_length_255_cov_1.648352_g3245_i0	PRJNA727760	3273	255	1.648352	4.2032976	Pseudomonadati	3379134	Bacteria	Bacteria	89.8	1.77e-13	NTclustered	gi\|2166246132\|dbj\|LC663124.1\|	1869227	g3245	i0	96.364	188.278431372549	55	0	21	2	2	55	24	77	Bacterium ARSSAG-00002529 DNA, putative prophage region, clone: 00002529_pp1	blastn	48011	89.8	1	Bacteria							bacterium
19046596	19046596	PRJNA727760_S_NODE_3655_length_245_cov_1.790698_g3627_i0	PRJNA727760	3655	245	1.790698	4.3872101	Staphylococcus	1279	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1899862668\|gb\|CP061041.1\|	1292	g3627	i0	100	100	245	0	100	0	1	245	1658203	1658447	Staphylococcus warneri strain WS479 chromosome, complete genome	blastn	24500	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri

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