metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJDB9741" and tax

17 rows where analysis = "blastn", bioproject = "PRJDB9741" 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
4809678	4809678	PRJDB9741_P_NODE_13364_length_189_cov_3.835714_g13047_i0	PRJDB9741	13364	189	3.835714	7.24949946	Fusobacterium	848	Bacteria	Bacteria	350	5.14e-92	NTclustered	gi\|2704981563\|gb\|CP077131.1\|	851	g13047	i0	100	464.883597883598	189	0	100	0	1	189	671837	671649	Fusobacterium nucleatum strain KCOM3321 chromosome, complete genome	blastn	87863	350	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
6085013	6085013	PRJDB9741_P_NODE_445_length_1322_cov_8.886881_g310_i0	PRJDB9741	445	1322	8.886881	117.48456682	Cetobacterium	180162	Bacteria	Bacteria	2318	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g310	i0	98.335	493.164145234493	1321	22	99	0	2	1322	278513	279833	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	651963	2318	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7359520	7359520	PRJDB9741_P_NODE_32406_length_165_cov_0.879310_g32089_i0	PRJDB9741	32406	165	0.87931	1.4508615	Fusobacterium	848	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|958162200\|gb\|CP013331.1\|	1307442	g32089	i0	100	99.3575757575758	165	0	100	0	1	165	2155812	2155648	Fusobacterium hwasookii ChDC F174, complete genome	blastn	16394	305	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
7663204	7663204	PRJDB9741_P_NODE_22147_length_174_cov_1.944000_g21830_i0	PRJDB9741	22147	174	1.944	3.38256	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	296	6.12e-76	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g21830	i0	97.688	14.0632183908046	173	3	99	1	3	174	51735	51563	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	2447	296	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
7663211	7663211	PRJDB9741_P_NODE_23287_length_172_cov_3.024390_g22970_i0	PRJDB9741	23287	172	3.02439	5.2019508	Leptotrichia wadei	157687	Bacteria	Bacteria	285	1.31e-72	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g22970	i0	96.512	27.7383720930233	172	6	100	0	1	172	481854	482025	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	4771	285	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
7663350	7663350	PRJDB9741_P_NODE_467_length_1292_cov_3.186645_g328_i0	PRJDB9741	467	1292	3.186645	41.1714534	Leptotrichia wadei	157687	Bacteria	Bacteria	2272	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g328	i0	98.378	597.09520123839	1295	17	100	4	1	1292	2288241	2289534	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	771447	2272	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
9909944	9909944	PRJDB9741_P_NODE_12888_length_190_cov_2.737589_g12571_i0	PRJDB9741	12888	190	2.737589	5.2014191	Fusobacterium	848	Bacteria	Bacteria	185	1.54e-42	NTclustered	gi\|958159838\|gb\|CP013334.1\|	1307444	g12571	i0	100	66.8631578947368	100	0	100	0	1	100	483809	483908	Fusobacterium hwasookii ChDC F300, complete genome	blastn	12704	185	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
11185075	11185075	PRJDB9741_P_NODE_1209_length_769_cov_4.729167_g946_i0	PRJDB9741	1209	769	4.729167	36.36729423	Fusobacterium	848	Bacteria	Bacteria	1254	0	NTclustered	gi\|2444100754\|gb\|CP117525.1\|	851	g946	i0	96.109	501.375812743823	771	26	100	4	1	769	85593	84825	Fusobacterium nucleatum strain FNV chromosome, complete genome	blastn	385558	1254	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
12461054	12461054	PRJDB9741_P_NODE_43050_length_152_cov_2.805825_g42733_i0	PRJDB9741	43050	152	2.805825	4.264854	Fusobacterium	848	Bacteria	Bacteria	276	6.770000000000001e-70	NTclustered	gi\|958157244\|gb\|CP013336.1\|	1307443	g42733	i0	99.342	99.9736842105263	152	1	100	0	1	152	1092870	1093021	Fusobacterium hwasookii ChDC F206, complete genome	blastn	15196	276	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
12764408	12764408	PRJDB9741_P_NODE_1811_length_572_cov_2.768642_g1508_i0	PRJDB9741	1811	572	2.768642	15.83663224	Leptotrichia wadei	157687	Bacteria	Bacteria	996	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g1508	i0	98.077	462.047202797203	572	11	100	0	1	572	2298733	2299304	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	264291	996	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
12764591	12764591	PRJDB9741_P_NODE_42111_length_155_cov_4.849057_g41794_i0	PRJDB9741	42111	155	4.849057	7.51603835	Leptotrichia wadei	157687	Bacteria	Bacteria	287	3.21e-73	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g41794	i0	100	421.774193548387	155	0	100	0	1	155	2246442	2246288	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	65375	287	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
13735326	13735326	PRJDB9741_P_NODE_37911_length_162_cov_0.902655_g37594_i0	PRJDB9741	37911	162	0.902655	1.4623011	Fusobacterium	848	Bacteria	Bacteria	298	1.57e-76	NTclustered	gi\|958157244\|gb\|CP013336.1\|	1307443	g37594	i0	100	383.512345679012	161	0	99	0	1	161	632942	633102	Fusobacterium hwasookii ChDC F206, complete genome	blastn	62129	298	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
16587832	16587832	PRJDB9741_P_NODE_31334_length_165_cov_1.387931_g31017_i0	PRJDB9741	31334	165	1.387931	2.29008615	Fusobacterium polymorphum	76857	Bacteria	Bacteria	300	4.46e-77	NTclustered	gi\|1208657894\|gb\|CP021934.1\|	76857	g31017	i0	99.394	78.2727272727273	165	1	100	0	1	165	1729654	1729490	Fusobacterium nucleatum subsp. polymorphum strain KCOM 1260 (=ChDC F218) genome	blastn	12915	300	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
17862919	17862919	PRJDB9741_P_NODE_9975_length_208_cov_2.553459_g9658_i0	PRJDB9741	9975	208	2.553459	5.31119472	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	379	7.359999999999998e-101	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g9658	i0	99.519	277.649038461538	208	1	100	0	1	208	1624537	1624330	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	57751	379	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
18833602	18833602	PRJDB9741_P_NODE_26675_length_168_cov_1.126050_g26358_i0	PRJDB9741	26675	168	1.12605	1.891764	Leptotrichia	32067	Bacteria	Bacteria	294	2.12e-75	NTclustered	gi\|1708572621\|dbj\|AP019831.1\|	109328	g26358	i0	98.214	485.720238095238	168	3	100	0	1	168	159534	159701	Leptotrichia trevisanii JMUB3870 DNA, complete genome	blastn	81601	294	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
18833643	18833643	PRJDB9741_P_NODE_38715_length_161_cov_4.428571_g38398_i0	PRJDB9741	38715	161	4.428571	7.12999931	Fusobacterium	848	Bacteria	Bacteria	296	5.6e-76	NTclustered	gi\|958162200\|gb\|CP013331.1\|	1307442	g38398	i0	100	95.0621118012422	160	0	99	0	2	161	439746	439587	Fusobacterium hwasookii ChDC F174, complete genome	blastn	15305	296	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
22962740	22962740	PRJDB9741_P_NODE_16599_length_184_cov_1.222222_g16282_i0	PRJDB9741	16599	184	1.222222	2.24888848	Leptotrichia hofstadii	157688	Bacteria	Bacteria	307	3.0300000000000004e-79	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g16282	i0	96.739	10.9728260869565	184	6	100	0	1	184	336624	336807	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	2019	307	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii

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