metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1241156" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA1241156" 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
349948	349948	PRJNA1241156_S_NODE_48761_length_279_cov_2.656780_g48301_i0	PRJNA1241156	48761	279	2.65678	7.4124162	Sneathia vaginalis	187101	Bacteria	Bacteria	366	8.08e-97	NTclustered	gi\|808076794\|gb\|CP011280.1\|	187101	g48301	i0	98.095	2.63440860215054	210	4	75	0	1	210	402193	402402	Sneathia vaginalis strain SN35 chromosome, complete genome	blastn	735	366	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
4177464	4177464	PRJNA1241156_S_NODE_62264_length_249_cov_1.417476_g61804_i0	PRJNA1241156	62264	249	1.417476	3.52951524	Sneathia vaginalis	187101	Bacteria	Bacteria	388	1.51e-103	NTclustered	gi\|808076794\|gb\|CP011280.1\|	187101	g61804	i0	99.531	2.59437751004016	213	1	86	0	22	234	529303	529515	Sneathia vaginalis strain SN35 chromosome, complete genome	blastn	646	388	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
6727987	6727987	PRJNA1241156_S_NODE_55026_length_264_cov_2.927602_g54566_i0	PRJNA1241156	55026	264	2.927602	7.72886928	Sneathia vaginalis	187101	Bacteria	Bacteria	438	1.5799999999999996e-118	NTclustered	gi\|808076794\|gb\|CP011280.1\|	187101	g54566	i0	98.785	6.06818181818182	247	1	93	2	20	264	394766	394520	Sneathia vaginalis strain SN35 chromosome, complete genome	blastn	1602	438	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
8003226	8003226	PRJNA1241156_S_NODE_37507_length_309_cov_3.417293_g37047_i0	PRJNA1241156	37507	309	3.417293	10.55943537	Sneathia vaginalis	187101	Bacteria	Bacteria	547	3.0199999999999986e-151	NTclustered	gi\|808076794\|gb\|CP011280.1\|	187101	g37047	i0	100	24.8252427184466	296	0	96	0	14	309	599236	598941	Sneathia vaginalis strain SN35 chromosome, complete genome	blastn	7671	547	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
10553834	10553834	PRJNA1241156_S_NODE_24949_length_347_cov_3.046053_g24489_i0	PRJNA1241156	24949	347	3.046053	10.56980391	Sneathia vaginalis	187101	Bacteria	Bacteria	586	7.279999999999998e-163	NTclustered	gi\|2769795739\|gb\|CP160094.1\|	187101	g24489	i0	99.08	2.81844380403458	326	3	94	0	22	347	366512	366837	Sneathia vaginalis strain CCUG_64370 chromosome, complete genome	blastn	978	586	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
10553884	10553884	PRJNA1241156_S_NODE_28249_length_336_cov_2.539249_g27789_i0	PRJNA1241156	28249	336	2.539249	8.53187664	Sneathia vaginalis	187101	Bacteria	Bacteria	586	7.029999999999997e-163	NTclustered	gi\|808076794\|gb\|CP011280.1\|	187101	g27789	i0	99.381	2.88392857142857	323	2	96	0	1	323	973880	973558	Sneathia vaginalis strain SN35 chromosome, complete genome	blastn	969	586	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
14378949	14378949	PRJNA1241156_S_NODE_34772_length_316_cov_8.208791_g34312_i0	PRJNA1241156	34772	316	8.208791	25.93977956	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	523	5.219999999999999e-144	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g34312	i0	98.007	95.8132911392405	301	6	95	0	1	301	51768	52068	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	30277	523	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
24576092	24576092	PRJNA1241156_S_NODE_27900_length_337_cov_3.112245_g27440_i0	PRJNA1241156	27900	337	3.112245	10.48826565	Sneathia vaginalis	187101	Bacteria	Bacteria	577	4.2399999999999996e-160	NTclustered	gi\|808076794\|gb\|CP011280.1\|	187101	g27440	i0	99.371	3.08308605341246	318	2	94	0	1	318	1289675	1289992	Sneathia vaginalis strain SN35 chromosome, complete genome	blastn	1039	577	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis

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