metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA572587" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA572587" 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
558631	558631	PRJNA572587_P_NODE_10781_length_359_cov_24.764516_g10454_i0	PRJNA572587	10781	359	24.764516	88.90461244	Fusobacterium polymorphum	76857	Bacteria	Bacteria	621	2.0699999999999997e-173	NTclustered	gi\|2706071841\|gb\|CP077111.1\|	76857	g10454	i0	100	84.4150417827298	336	0	94	0	1	336	2012299	2011964	Fusobacterium polymorphum strain KCOM1275 chromosome, complete genome	blastn	30305	621	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
3687381	3687381	PRJNA572587_P_NODE_35043_length_186_cov_10.197080_g34715_i0	PRJNA572587	35043	186	10.19708	18.9665688	Fusobacterium	848	Bacteria	Bacteria	309	8.55e-80	NTclustered	gi\|2706435836\|gb\|CP077154.1\|	76857	g34715	i0	98.305	94.5698924731183	177	2	95	1	1	176	381625	381449	Fusobacterium polymorphum strain KCOM1267 chromosome, complete genome	blastn	17590	309	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
5662701	5662701	PRJNA572587_P_NODE_30685_length_200_cov_20.801325_g30357_i0	PRJNA572587	30685	200	20.801325	41.60265	Leptotrichia alba	3239304	Bacteria	Bacteria	313	7.22e-81	NTclustered	gi\|2785244533\|gb\|CP165647.1\|	3239304	g30357	i0	98.857	13.025	175	2	88	0	3	177	1908486	1908660	Leptotrichia sp. HSP-536 chromosome, complete genome	blastn	2605	313	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia alba
5662923	5662923	PRJNA572587_P_NODE_7945_length_430_cov_52.070866_g7620_i0	PRJNA572587	7945	430	52.070866	223.9047238	Leptotrichia buccalis	40542	Bacteria	Bacteria	726	0	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g7620	i0	98.778	7.5953488372093	409	3	95	2	1	407	1404026	1404434	Leptotrichia buccalis DSM 1135, complete genome	blastn	3266	726	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
6936861	6936861	PRJNA572587_P_NODE_18386_length_265_cov_19.629630_g18058_i0	PRJNA572587	18386	265	19.62963	52.0185195	Leptotrichia alba	3239304	Bacteria	Bacteria	337	5.97e-88	NTclustered	gi\|2785244533\|gb\|CP165647.1\|	3239304	g18058	i0	96.569	327.577358490566	204	5	77	2	40	242	124870	124668	Leptotrichia sp. HSP-536 chromosome, complete genome	blastn	86808	337	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia alba
10763054	10763054	PRJNA572587_P_NODE_15989_length_287_cov_1.718487_g15661_i0	PRJNA572587	15989	287	1.718487	4.93205769	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	486	6.139999999999999e-133	NTclustered	gi\|1276709865\|gb\|CP024700.1\|	2663009	g15661	i0	100	10.9965156794425	263	0	92	0	25	287	2336114	2335852	Fusobacterium pseudoperiodonticum strain KCOM 1263 chromosome, complete genome	blastn	3156	486	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
10763406	10763406	PRJNA572587_P_NODE_40389_length_172_cov_4.910569_g40061_i0	PRJNA572587	40389	172	4.910569	8.44617868	Leptotrichia hofstadii	157688	Bacteria	Bacteria	274	2.83e-69	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g40061	i0	99.338	130.412790697674	151	1	88	0	1	151	497864	497714	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	22431	274	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
12614895	12614895	PRJNA572587_P_NODE_12710_length_326_cov_144.916968_g12382_i0	PRJNA572587	12710	326	144.916968	472.42931568	Leptotrichia	32067	Bacteria	Bacteria	503	7.039999999999998e-138	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g12382	i0	99.281	117.610429447853	278	2	85	0	44	321	256	533	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	38341	503	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
14587603	14587603	PRJNA572587_P_NODE_21152_length_245_cov_82.265306_g20824_i0	PRJNA572587	21152	245	82.265306	201.5499997	Fusobacterium polymorphum	76857	Bacteria	Bacteria	326	1.18e-84	NTclustered	gi\|2706504035\|gb\|CP084159.1\|	76857	g20824	i0	99.441	22.7795918367347	179	1	73	0	28	206	915893	915715	Fusobacterium polymorphum strain KCOM1330 chromosome, complete genome	blastn	5581	326	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
14587909	14587909	PRJNA572587_P_NODE_43992_length_165_cov_4.612069_g43664_i0	PRJNA572587	43992	165	4.612069	7.60991385	Leptotrichia sp. oral taxon 498	712368	Bacteria	Bacteria	276	7.52e-70	NTclustered	gi\|1227268105\|gb\|CP016753.1\|	712368	g43664	i0	99.342	244.927272727273	152	1	92	0	14	165	594205	594054	Leptotrichia sp. oral taxon 498, complete genome	blastn	40413	276	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 498
15164012	15164012	PRJNA572587_P_NODE_12272_length_333_cov_21.246479_g11944_i0	PRJNA572587	12272	333	21.246479	70.75077507	Fusobacterium	848	Bacteria	Bacteria	309	1.6900000000000002e-79	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g11944	i0	91.892	66.2192192192192	222	17	66	1	59	279	462977	462756	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	22051	309	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
15861281	15861281	PRJNA572587_P_NODE_12173_length_335_cov_5.555944_g11845_i0	PRJNA572587	12173	335	5.555944	18.6124124	Leptotrichia wadei	157687	Bacteria	Bacteria	575	1.5199999999999994e-159	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g11845	i0	98.765	9.09253731343284	324	2	97	1	1	324	1915500	1915821	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	3046	575	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei

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