metadata: contig_metadata: 12 rows where bioproject = "PRJNA379145" and tax

12 rows where bioproject = "PRJNA379145" 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
1675839	1675839	PRJNA379145_P_NODE_68082_length_164_cov_1.908397_g65928_i0	PRJNA379145	68082	164	1.908397	3.12977108	Leptotrichia sp. oral taxon 847	1785996	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|987458696\|gb\|CP014231.1\|	1785996	g65928	i0	100	0.170731707317073	28	0	17	0	25	52	1704059	1704086	Leptotrichia sp. oral taxon 847 strain F0260 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 847
4227846	4227846	PRJNA379145_P_NODE_22544_length_540_cov_56.301775_g20591_i0	PRJNA379145	22544	540	56.301775	304.029585	Cetobacterium somerae	188913	Bacteria	Bacteria	953	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g20591	i0	98.699	530.196296296296	538	6	99	1	1	538	49409	48873	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	286306	953	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
4228166	4228166	PRJNA379145_P_NODE_51084_length_227_cov_2.541237_g48930_i0	PRJNA379145	51084	227	2.541237	5.76860799	Leptotrichia wadei	157687	Bacteria	Bacteria	409	1.04e-109	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g48930	i0	99.119	400.775330396476	227	2	100	0	1	227	222450	222224	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	90976	409	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
4901900	4901900	PRJNA379145_P_NODE_17224_length_665_cov_46.696203_g15485_i0	PRJNA379145	17224	665	46.696203	310.52974995	Cetobacterium	180162	Bacteria	Bacteria	654	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g15485	i0	96.049	294.162406015038	405	10	60	6	264	665	279074	278673	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	195618	654	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11277212	11277212	PRJNA379145_P_NODE_33749_length_367_cov_1.520958_g31605_i0	PRJNA379145	33749	367	1.520958	5.58191586	Haliovirga abyssi	2996794	Bacteria	Bacteria	170	2e-47	NR	WP_307904636.1	2996794	g31605	i0	70.3	15.425068119891	118	35	96.5	0	361	8	456	573	WP_307904636.1 ABC transporter ATP-binding protein [Haliovirga abyssi]	diamond	5661	170	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Haliovirgaceae	Haliovirga	Haliovirga abyssi
11879603	11879603	PRJNA379145_P_NODE_39150_length_310_cov_4.451264_g36999_i0	PRJNA379145	39150	310	4.451264	13.7989184	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	573	4.999999999999998e-159	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g36999	i0	100	664.432258064516	310	0	100	0	1	310	71314	71623	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	205974	573	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
13827515	13827515	PRJNA379145_P_NODE_63311_length_177_cov_3.972222_g61157_i0	PRJNA379145	63311	177	3.972222	7.03083294	Cetobacterium	180162	Bacteria	Bacteria	239	1.07e-58	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g61157	i0	90.96	5	177	16	100	0	1	177	81065	81241	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	885	239	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16376411	16376411	PRJNA379145_P_NODE_11433_length_879_cov_50.777778_g10138_i0	PRJNA379145	11433	879	50.777778	446.33666862	Fusobacterium	848	Bacteria	Bacteria	1443	0	NTclustered	gi\|2444100754\|gb\|CP117525.1\|	851	g10138	i0	96.461	497.149032992036	876	27	100	4	4	879	85313	84442	Fusobacterium nucleatum strain FNV chromosome, complete genome	blastn	436994	1454	0.992434662998624	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
20200069	20200069	PRJNA379145_P_NODE_19156_length_616_cov_54.015437_g17323_i0	PRJNA379145	19156	616	54.015437	332.73509192	Fusobacterium	848	Bacteria	Bacteria	1072	0	NTclustered	gi\|15028908\|emb\|AJ307974.1\|	851	g17323	i0	98.055	483.412337662338	617	10	100	2	1	616	542	1157	Fusobacterium nucleatum 23S rRNA gene, strain DSM 20482	blastn	297782	1072	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
20802500	20802500	PRJNA379145_P_NODE_60497_length_187_cov_1.610390_g58343_i0	PRJNA379145	60497	187	1.61039	3.0114293	Haliovirga abyssi	2996794	Bacteria	Bacteria	80.5	7.34e-11	NTclustered	gi\|2502752323\|dbj\|AP027059.1\|	2996794	g58343	i0	88.235	1.27807486631016	68	6	36	2	115	181	638705	638771	Fusobacteria bacterium IC12 DNA, complete genome	blastn	239	80.5	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Haliovirgaceae	Haliovirga	Haliovirga abyssi
22750808	22750808	PRJNA379145_P_NODE_21018_length_572_cov_39.849722_g19121_i0	PRJNA379145	21018	572	39.849722	227.94040984	Cetobacterium	180162	Bacteria	Bacteria	857	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g19121	i0	93.728	518.103146853147	574	33	100	3	1	572	278444	279016	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	296355	857	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
23353047	23353047	PRJNA379145_P_NODE_58539_length_194_cov_2.248447_g56385_i0	PRJNA379145	58539	194	2.248447	4.36198718	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	353	4.1e-93	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g56385	i0	99.485	77.0979381443299	194	1	100	0	1	194	1995271	1995078	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	14957	353	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis

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