metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA611476" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA611476" and tax_phylum = "Campylobacterota"

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
2423531	2423531	PRJNA611476_P_NODE_84082_length_250_cov_0.870056_g83291_i0	PRJNA611476	84082	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2562786027\|gb\|CP120256.1\|	197	g83291	i0	100	101	250	0	100	0	1	250	1483332	1483581	Campylobacter jejuni strain PS_41_2021 chromosome, complete genome	blastn	25250	462	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
4975885	4975885	PRJNA611476_P_NODE_21084_length_435_cov_1.472376_g20293_i0	PRJNA611476	21084	435	1.472376	6.4048356	root	1	Root_unresolved	Root_unresolved	804	0	NTclustered	gi\|2562786027\|gb\|CP120256.1\|	197	g20293	i0	100	102.004597701149	435	0	100	0	1	435	1303903	1303469	Campylobacter jejuni strain PS_41_2021 chromosome, complete genome	blastn	44372	804	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
6251550	6251550	PRJNA611476_P_NODE_29565_length_378_cov_1.259016_g28774_i0	PRJNA611476	29565	378	1.259016	4.75908048	root	1	Root_unresolved	Root_unresolved	699	0	NTclustered	gi\|1248684020\|gb\|CP023546.1\|	195	g28774	i0	100	104	378	0	100	0	1	378	23939	23562	Campylobacter coli strain CFSAN032805 plasmid pCFSAN032805_1, complete sequence	blastn	39312	699	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
8800396	8800396	PRJNA611476_P_NODE_101107_length_245_cov_0.895349_g100316_i0	PRJNA611476	101107	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|2323232558\|gb\|CP109813.1\|	195	g100316	i0	99.592	102	245	1	100	0	1	245	559552	559796	Campylobacter coli strain CC20JX12 chromosome, complete genome	blastn	24990	448	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
8801129	8801129	PRJNA611476_P_NODE_78327_length_251_cov_0.865169_g77536_i0	PRJNA611476	78327	251	0.865169	2.17157419	root	1	Root_unresolved	Root_unresolved	464	2.47e-126	NTclustered	gi\|2562786027\|gb\|CP120256.1\|	197	g77536	i0	100	111.892430278884	251	0	100	0	1	251	1482540	1482290	Campylobacter jejuni strain PS_41_2021 chromosome, complete genome	blastn	28085	464	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
11351430	11351430	PRJNA611476_P_NODE_44969_length_322_cov_0.931727_g44178_i0	PRJNA611476	44969	322	0.931727	3.00016094	Bacteria	2	Bacteria	Bacteria	590	5.18e-164	NTclustered	gi\|2473671727\|gb\|CP047214.1\|	195	g44178	i0	99.689	342.953416149068	322	1	100	0	1	322	614457	614136	Campylobacter coli strain QL_1_15 chromosome, complete genome	blastn	110431	595	0.991596638655462	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter coli
16450653	16450653	PRJNA611476_P_NODE_3533_length_1039_cov_3.181159_g2889_i0	PRJNA611476	3533	1039	3.181159	33.05224201	Campylobacter	194	Bacteria	Bacteria	71.3	2.91e-7	NTclustered	gi\|777189043\|emb\|LN831025.1\|	197	g2889	i0	92	5.12704523580366	50	4	6	0	88	137	903397	903348	Campylobacter jejuni genome assembly NCTC11351, chromosome : 1	blastn	5327	71.3	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
20274654	20274654	PRJNA611476_P_NODE_75476_length_256_cov_1.262295_g74685_i0	PRJNA611476	75476	256	1.262295	3.2314752	Bacteria	2	Bacteria	Bacteria	224	4.659999999999999e-54	NTclustered	gi\|2562721999\|gb\|CP120314.1\|	197	g74685	i0	87.692	86.734375	195	20	75	3	1	193	1302428	1302236	Campylobacter jejuni strain PS_1_2021 chromosome, complete genome	blastn	22204	224	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni
22825196	22825196	PRJNA611476_P_NODE_36758_length_348_cov_1.036364_g35967_i0	PRJNA611476	36758	348	1.036364	3.60654672	root	1	Root_unresolved	Root_unresolved	621	1.9999999999999997e-173	NTclustered	gi\|2562786027\|gb\|CP120256.1\|	197	g35967	i0	98.851	101	348	4	100	0	1	348	1303259	1302912	Campylobacter jejuni strain PS_41_2021 chromosome, complete genome	blastn	35148	621	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter jejuni

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