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

5 rows where analysis = "blastn", bioproject = "PRJNA454503" 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
4269419	4269419	PRJNA454503_P_NODE_37704_length_229_cov_2.321429_g37375_i0	PRJNA454503	37704	229	2.321429	5.31607241	Arcobacter sp. 15-2	3374109	Bacteria	Bacteria	379	8.249999999999999e-101	NTclustered	gi\|2862971141\|dbj\|AP038804.1\|	3374109	g37375	i0	96.507	245.864628820961	229	8	100	0	1	229	342180	341952	Arcobacter sp. 15-2 DNA, complete genome	blastn	56303	379	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Arcobacter	Arcobacter sp. 15-2
16396287	16396287	PRJNA454503_P_NODE_45353_length_220_cov_2.823899_g45024_i0	PRJNA454503	45353	220	2.823899	6.2125778	Arcobacteraceae	2808963	Bacteria	Bacteria	398	2.1699999999999996e-106	NTclustered	gi\|1231709647\|emb\|LT906455.1\|	28197	g45024	i0	99.541	368.090909090909	218	1	99	0	3	220	851612	851829	Arcobacter butzleri strain NCTC12481 genome assembly, chromosome: 1	blastn	80980	401	0.992518703241895	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae	Aliarcobacter	Aliarcobacter butzleri
18294626	18294626	PRJNA454503_P_NODE_89995_length_190_cov_2.015504_g89666_i0	PRJNA454503	89995	190	2.015504	3.8294576	Campylobacter concisus	199	Bacteria	Bacteria	324	3.13e-84	NTclustered	gi\|2700477995\|gb\|CP147775.1\|	199	g89666	i0	97.368	12	190	5	100	0	1	190	1055391	1055580	Campylobacter concisus strain RMIT-O23 chromosome	blastn	2280	324	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter concisus
20220136	20220136	PRJNA454503_P_NODE_7436_length_413_cov_0.909091_g7107_i0	PRJNA454503	7436	413	0.909091	3.75454583	Arcobacter	28196	Bacteria	Bacteria	669	0	NTclustered	gi\|2907625684\|emb\|OZ223244.1\|	2808971	g7107	i0	96.107	401.796610169492	411	14	99	2	1	411	470249	469841	MAG: Arcobacteraceae bacterium isolate d8a8449e-00d2-4365-b2ae-71d708214a40 genome assembly, chromosome: 5	blastn	165942	669	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae		Arcobacteraceae bacterium
22119013	22119013	PRJNA454503_P_NODE_45158_length_221_cov_1.312500_g44829_i0	PRJNA454503	45158	221	1.3125	2.900625	Campylobacter showae	204	Bacteria	Bacteria	315	2.26e-81	NTclustered	gi\|1483583495\|emb\|LT631419.1\|	204	g44829	i0	92.308	7.76018099547511	221	17	100	0	1	221	222706	222926	Campylobacter showae genome assembly, chromosome: I	blastn	1715	315	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Campylobacteraceae	Campylobacter	Campylobacter showae

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