metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA1020854" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA1020854" 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
1436103	1436103	PRJNA1020854_S_NODE_7342_length_562_cov_1199.450281_g4732_i0	PRJNA1020854	7342	562	1199.450281	6740.91057922	Leptotrichia hofstadii	157688	Bacteria	Bacteria	784	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g4732	i0	95.02	164.330960854093	502	19	88	3	12	508	2256891	2257391	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	92354	784	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
2711125	2711125	PRJNA1020854_S_NODE_18003_length_265_cov_4.512712_g15239_i0	PRJNA1020854	18003	265	4.512712	11.9586868	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	228	3.7499999999999994e-55	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g15239	i0	95.139	144.433962264151	144	7	54	0	120	263	51737	51880	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	38275	228	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
2711329	2711329	PRJNA1020854_S_NODE_27763_length_198_cov_4.846154_g24999_i0	PRJNA1020854	27763	198	4.846154	9.59538492	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	263	7.28e-66	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g24999	i0	92.818	4.61111111111111	181	13	91	0	5	185	749915	749735	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	913	263	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
3553596	3553596	PRJNA1020854_S_NODE_10883_length_387_cov_28.455307_g8136_i0	PRJNA1020854	10883	387	28.455307	110.12203809	Fusobacterium	848	Bacteria	Bacteria	710	0	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g8136	i0	99.742	475.93023255814	387	1	100	0	1	387	462789	463175	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	184185	715	0.993006993006993	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
4831120	4831120	PRJNA1020854_S_NODE_13884_length_320_cov_22.099656_g11120_i0	PRJNA1020854	13884	320	22.099656	70.7188992	Fusobacterium	848	Bacteria	Bacteria	494	4.15e-135	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g11120	i0	94.688	486	320	13	100	3	1	320	462696	463011	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	155520	494	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
6539046	6539046	PRJNA1020854_S_NODE_20906_length_239_cov_5.976190_g18142_i0	PRJNA1020854	20906	239	5.97619	14.2830941	Leptotrichia sp. oral taxon 498	712368	Bacteria	Bacteria	411	3.079999999999999e-110	NTclustered	gi\|1227268105\|gb\|CP016753.1\|	712368	g18142	i0	98.701	323.443514644351	231	3	97	0	1	231	593615	593385	Leptotrichia sp. oral taxon 498, complete genome	blastn	77303	411	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 498
10364209	10364209	PRJNA1020854_S_NODE_30269_length_187_cov_12.873418_g27505_i0	PRJNA1020854	30269	187	12.873418	24.07329166	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	333	5.1e-87	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g27505	i0	98.925	387.711229946524	186	2	99	0	1	186	196889	196704	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	72502	333	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
10364592	10364592	PRJNA1020854_S_NODE_9729_length_423_cov_7.652284_g7001_i0	PRJNA1020854	9729	423	7.652284	32.36916132	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	776	0	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g7001	i0	99.764	476.151300236407	423	1	100	0	1	423	967243	967665	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	201412	776	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
14189403	14189403	PRJNA1020854_S_NODE_18552_length_259_cov_10.121739_g15788_i0	PRJNA1020854	18552	259	10.121739	26.21530401	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	374	4.4299999999999994e-99	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g15788	i0	93.6	53.9498069498069	250	16	97	0	10	259	51864	52113	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	13973	374	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
15464142	15464142	PRJNA1020854_S_NODE_9653_length_426_cov_6.682620_g6929_i0	PRJNA1020854	9653	426	6.68262	28.4679612	Leptotrichia wadei	157687	Bacteria	Bacteria	734	0	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g6929	i0	99.261	231.544600938967	406	3	95	0	1	406	1756368	1756773	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	98638	734	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
19286393	19286393	PRJNA1020854_S_NODE_15376_length_297_cov_7.895522_g12612_i0	PRJNA1020854	15376	297	7.895522	23.44970034	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	501	2.28e-137	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g12612	i0	97.288	106.531986531987	295	8	99	0	3	297	51880	51586	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	31640	501	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
21837483	21837483	PRJNA1020854_S_NODE_12418_length_348_cov_24.852665_g9654_i0	PRJNA1020854	12418	348	24.852665	86.4872742	Fusobacterium polymorphum	76857	Bacteria	Bacteria	621	1.9999999999999997e-173	NTclustered	gi\|2706504035\|gb\|CP084159.1\|	76857	g9654	i0	98.851	489.002873563218	348	4	100	0	1	348	284482	284829	Fusobacterium polymorphum strain KCOM1330 chromosome, complete genome	blastn	170173	621	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
22679918	22679918	PRJNA1020854_S_NODE_14658_length_307_cov_23.032374_g11894_i0	PRJNA1020854	14658	307	23.032374	70.70938818	Fusobacterium	848	Bacteria	Bacteria	484	2.3799999999999994e-132	NTclustered	gi\|958162200\|gb\|CP013331.1\|	1307442	g11894	i0	95.146	498.446254071661	309	11	100	4	1	307	310284	309978	Fusobacterium hwasookii ChDC F174, complete genome	blastn	153023	484	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
24387129	24387129	PRJNA1020854_S_NODE_31300_length_183_cov_1472.558442_g28536_i0	PRJNA1020854	31300	183	1472.558442	2694.78194886	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	198	1.8899999999999998e-46	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g28536	i0	94.531	189.704918032787	128	7	70	0	9	136	749735	749608	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	34716	198	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
25229317	25229317	PRJNA1020854_S_NODE_14720_length_306_cov_27.227437_g11956_i0	PRJNA1020854	14720	306	27.227437	83.31595722	Fusobacterium	848	Bacteria	Bacteria	551	2.309999999999999e-152	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g11956	i0	99.029	492.794117647059	309	0	100	1	1	306	462703	463011	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	150795	551	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum

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