metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJEB14664" and tax

7 rows where analysis = "blastn", bioproject = "PRJEB14664" and tax_kingdom = "Fusobacteriati"

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
4813614	4813614	PRJEB14664_P_NODE_5644_length_352_cov_1.466877_g5514_i0	PRJEB14664	5644	352	1.466877	5.16340704	Cetobacterium	180162	Bacteria	Bacteria	508	1.64e-139	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g5514	i0	93.314	19.7045454545455	344	23	98	0	5	348	67131	67474	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	6936	508	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7363417	7363417	PRJEB14664_P_NODE_11226_length_223_cov_2.127660_g11096_i0	PRJEB14664	11226	223	2.12766	4.7446818	Cetobacterium	180162	Bacteria	Bacteria	344	2.92e-90	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g11096	i0	94.595	15.2421524663677	222	12	99	0	1	222	1341944	1341723	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	3399	344	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12774876	12774876	PRJEB14664_P_NODE_8591_length_269_cov_1.149573_g8461_i0	PRJEB14664	8591	269	1.149573	3.09235137	Cetobacterium somerae	188913	Bacteria	Bacteria	475	1.2299999999999999e-129	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g8461	i0	98.513	30.5873605947955	269	4	100	0	1	269	1743443	1743711	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	8228	475	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13739172	13739172	PRJEB14664_P_NODE_10471_length_234_cov_1.125628_g10341_i0	PRJEB14664	10471	234	1.125628	2.63396952	Cetobacterium	180162	Bacteria	Bacteria	422	1.39e-113	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g10341	i0	99.145	196.034188034188	234	2	100	0	1	234	1630341	1630574	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	45872	422	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
15013633	15013633	PRJEB14664_P_NODE_9452_length_251_cov_3.578704_g9322_i0	PRJEB14664	9452	251	3.578704	8.98254704	Cetobacterium	180162	Bacteria	Bacteria	418	1.9499999999999994e-112	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g9322	i0	96.8	101.792828685259	250	8	99	0	2	251	1903375	1903624	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	25550	418	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22973286	22973286	PRJEB14664_P_NODE_9419_length_252_cov_1.806452_g9289_i0	PRJEB14664	9419	252	1.806452	4.55225904	Cetobacterium somerae	188913	Bacteria	Bacteria	409	1.18e-109	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g9289	i0	95.72	11.0595238095238	257	5	100	4	1	252	1523626	1523371	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	2787	409	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
23938109	23938109	PRJEB14664_P_NODE_18999_length_156_cov_1.388430_g18869_i0	PRJEB14664	18999	156	1.38843	2.1659508	Cetobacterium	180162	Bacteria	Bacteria	289	9e-74	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g18869	i0	100	5	156	0	100	0	1	156	1904627	1904472	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	780	289	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae

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