metadata: contig_metadata: 10 rows where bioproject = "PRJNA397736" and tax

10 rows where bioproject = "PRJNA397736" 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
1079936	1079936	PRJNA397736_S_NODE_1241_length_252_cov_11.147982_g1205_i0	PRJNA397736	1241	252	11.147982	28.09291464	Cetobacterium	180162	Bacteria	Bacteria	394	3.3e-105	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g1205	i0	94.882	509.456349206349	254	10	100	3	1	252	278800	279052	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	128383	394	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
1079938	1079938	PRJNA397736_S_NODE_1721_length_210_cov_4.198895_g1685_i0	PRJNA397736	1721	210	4.198895	8.8176795	Fusobacterium	848	Bacteria	Bacteria	388	1.24e-103	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g1685	i0	100	482.242857142857	210	0	100	0	1	210	92360	92569	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	101271	388	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
4239192	4239192	PRJNA397736_S_NODE_1404_length_236_cov_4.492754_g1368_i0	PRJNA397736	1404	236	4.492754	10.60289944	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	357	4.01e-94	NTclustered	gi\|1276718681\|gb\|CP024704.1\|	2663009	g1368	i0	94.068	451.911016949153	236	12	99	2	2	236	13768	14002	Fusobacterium pseudoperiodonticum strain KCOM 2555 chromosome, complete genome	blastn	106651	357	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
4907905	4907905	PRJNA397736_S_NODE_1024_length_284_cov_5.662745_g988_i0	PRJNA397736	1024	284	5.662745	16.0821958	Fusobacterium	848	Bacteria	Bacteria	490	4.69e-134	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g988	i0	98.221	481.869718309859	281	4	99	1	1	281	462972	462693	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	136851	490	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
8732692	8732692	PRJNA397736_S_NODE_1007_length_286_cov_5.805447_g971_i0	PRJNA397736	1007	286	5.805447	16.60357842	Cetobacterium	180162	Bacteria	Bacteria	492	1.31e-134	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g971	i0	97.895	502.646853146853	285	4	99	2	1	283	1577299	1577583	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	143757	492	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8732694	8732694	PRJNA397736_S_NODE_1707_length_211_cov_7.461538_g1671_i0	PRJNA397736	1707	211	7.461538	15.74384518	Fusobacterium	848	Bacteria	Bacteria	390	3.459999999999999e-104	NTclustered	gi\|2573686249\|gb\|CP133474.1\|	851	g1671	i0	100	481.777251184834	211	0	100	0	1	211	322039	322249	Fusobacterium nucleatum strain LMG 13131 chromosome, complete genome	blastn	101655	390	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
8732696	8732696	PRJNA397736_S_NODE_2787_length_158_cov_37.465116_g2751_i0	PRJNA397736	2787	158	37.465116	59.19488328	Cetobacterium	180162	Bacteria	Bacteria	292	7.07e-75	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g2751	i0	100	509.993670886076	158	0	100	0	1	158	279978	279821	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	80579	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
10007996	10007996	PRJNA397736_S_NODE_1868_length_200_cov_3.087719_g1832_i0	PRJNA397736	1868	200	3.087719	6.175438	Cetobacterium	180162	Bacteria	Bacteria	370	4.22e-98	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g1832	i0	100	494.67	200	0	100	0	1	200	279804	279605	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	98934	370	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22088650	22088650	PRJNA397736_S_NODE_1018_length_285_cov_5.140625_g982_i0	PRJNA397736	1018	285	5.140625	14.65078125	Cetobacterium somerae	188913	Bacteria	Bacteria	466	7.93e-127	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g982	i0	98.851	423.761403508772	261	3	92	0	25	285	48908	49168	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	120772	466	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24031668	24031668	PRJNA397736_S_NODE_2099_length_187_cov_1.803797_g2063_i0	PRJNA397736	2099	187	1.803797	3.37310039	Cetobacterium	180162	Bacteria	Bacteria	346	6.56e-91	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g2063	i0	100	60	187	0	100	0	1	187	279291	279477	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	11220	346	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);;