metadata: contig_metadata: 9 rows where bioproject = "PRJNA1073183" and tax

9 rows where bioproject = "PRJNA1073183" 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
6119237	6119237	PRJNA1073183_P_NODE_28585_length_248_cov_1.760000_g28490_i0	PRJNA1073183	28585	248	1.76	4.3648	Cetobacterium	180162	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g28490	i0	100	494.560483870968	248	0	100	0	1	248	280504	280751	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	122651	459	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8669290	8669290	PRJNA1073183_P_NODE_30287_length_246_cov_0.890173_g30192_i0	PRJNA1073183	30287	246	0.890173	2.18982558	Cetobacterium	180162	Bacteria	Bacteria	438	1.4599999999999996e-118	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g30192	i0	98.78	466.79674796748	246	3	100	0	1	246	279437	279192	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	114832	438	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11219478	11219478	PRJNA1073183_P_NODE_16309_length_324_cov_0.920319_g16214_i0	PRJNA1073183	16309	324	0.920319	2.98183356	Cetobacterium	180162	Bacteria	Bacteria	571	1.8899999999999993e-158	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g16214	i0	98.457	501.765432098765	324	5	100	0	1	324	279509	279832	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	162572	571	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11219564	11219564	PRJNA1073183_P_NODE_6769_length_488_cov_2.462651_g6675_i0	PRJNA1073183	6769	488	2.462651	12.01773688	Cetobacterium	180162	Bacteria	Bacteria	896	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g6675	i0	99.795	512.752049180328	488	1	100	0	1	488	279223	278736	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	250223	896	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11665861	11665861	PRJNA1073183_P_NODE_23050_length_272_cov_1.658291_g22955_i0	PRJNA1073183	23050	272	1.658291	4.51055152	Leptotrichia hofstadii	157688	Bacteria	Bacteria	475	1.2499999999999999e-129	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g22955	i0	98.162	424.727941176471	272	5	100	0	1	272	500145	499874	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	115526	475	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
11666086	11666086	PRJNA1073183_P_NODE_34670_length_240_cov_3.874251_g34575_i0	PRJNA1073183	34670	240	3.874251	9.2982024	Leptotrichia hofstadii	157688	Bacteria	Bacteria	444	3.05e-120	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g34575	i0	100	403.270833333333	240	0	100	0	1	240	2255424	2255185	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	96785	444	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
21418174	21418174	PRJNA1073183_P_NODE_7217_length_474_cov_1.847880_g7123_i0	PRJNA1073183	7217	474	1.84788	8.7589512	Leptotrichia	32067	Bacteria	Bacteria	828	0	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g7123	i0	98.309	461.145569620253	473	7	99	1	2	474	480898	480427	Leptotrichia buccalis DSM 1135, complete genome	blastn	218583	828	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
24413332	24413332	PRJNA1073183_P_NODE_33940_length_241_cov_9.785714_g33845_i0	PRJNA1073183	33940	241	9.785714	23.58357074	Leptotrichia hofstadii	157688	Bacteria	Bacteria	444	3.06e-120	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g33845	i0	100	419.224066390042	240	0	99	0	1	240	2256451	2256212	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	101033	444	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
27541441	27541441	PRJNA1073183_P_NODE_15644_length_330_cov_1.198444_g15549_i0	PRJNA1073183	15644	330	1.198444	3.9548652	unclassified Cetobacterium	2630983	Bacteria	Bacteria	146	8.189999999999998e-43	NR	WP_047383608.1	2630983	g15549	i0	100	0.6	66	0	60	0	328	131	57	122	WP_047383608.1 MULTISPECIES: desulfoferrodoxin family protein [unclassified Cetobacterium]	diamond	198	146	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium

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