metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA796753" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA796753" 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
2056596	2056596	PRJNA796753_P_NODE_29142_length_283_cov_1.271429_g28830_i0	PRJNA796753	29142	283	1.271429	3.59814407	Leptotrichia shahii	157691	Bacteria	Bacteria	468	2.19e-127	NTclustered	gi\|1708568515\|dbj\|AP019827.1\|	157691	g28830	i0	96.466	13.8904593639576	283	10	100	0	1	283	1513098	1512816	Leptotrichia shahii JCM16776 DNA, complete genome	blastn	3931	468	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia shahii
8433833	8433833	PRJNA796753_P_NODE_37047_length_256_cov_1.754098_g36735_i0	PRJNA796753	37047	256	1.754098	4.49049088	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	453	5.460000000000001e-123	NTclustered	gi\|1276709865\|gb\|CP024700.1\|	2663009	g36735	i0	99.203	96.15234375	251	2	98	0	6	256	52931	53181	Fusobacterium pseudoperiodonticum strain KCOM 1263 chromosome, complete genome	blastn	24615	453	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
8869870	8869870	PRJNA796753_P_NODE_29687_length_281_cov_1.442308_g29375_i0	PRJNA796753	29687	281	1.442308	4.05288548	Leptotrichia	32067	Bacteria	Bacteria	468	2.17e-127	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g29375	i0	96.786	12.8967971530249	280	9	99	0	2	281	1544364	1544643	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	3624	468	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
13534372	13534372	PRJNA796753_P_NODE_33271_length_269_cov_1.571429_g32959_i0	PRJNA796753	33271	269	1.571429	4.22714401	Fusobacterium animalis	76859	Bacteria	Bacteria	464	2.67e-126	NTclustered	gi\|2706064790\|gb\|CP077192.1\|	76859	g32959	i0	97.77	41.3494423791822	269	6	100	0	1	269	2485247	2485515	Fusobacterium animalis strain SB024 chromosome, complete genome	blastn	11123	464	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
13534412	13534412	PRJNA796753_P_NODE_39771_length_251_cov_0.865169_g39459_i0	PRJNA796753	39771	251	0.865169	2.17157419	Fusobacterium polymorphum	76857	Bacteria	Bacteria	448	2.48e-121	NTclustered	gi\|2704950824\|gb\|CP056007.1\|	76857	g39459	i0	98.805	98.0836653386454	251	3	100	0	1	251	200175	199925	Fusobacterium polymorphum strain SB013 chromosome, complete genome	blastn	24619	448	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
13534466	13534466	PRJNA796753_P_NODE_47351_length_246_cov_0.890173_g47039_i0	PRJNA796753	47351	246	0.890173	2.18982558	Fusobacterium nucleatum	851	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|2704991197\|gb\|CP077142.1\|	851	g47039	i0	99.593	202.126016260163	246	1	100	0	1	246	1170809	1171054	Fusobacterium nucleatum strain KCOM2898 chromosome, complete genome	blastn	49723	449	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
15245160	15245160	PRJNA796753_P_NODE_44292_length_248_cov_0.880000_g43980_i0	PRJNA796753	44292	248	0.88	2.1824	Fusobacterium	848	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2705032171\|gb\|CP084140.1\|	851	g43980	i0	100	17	248	0	100	0	1	248	174457	174210	Fusobacterium nucleatum strain KCOM3187 chromosome, complete genome	blastn	4216	459	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
17358959	17358959	PRJNA796753_P_NODE_1414_length_1040_cov_4.482937_g184_i1	PRJNA796753	1414	1040	4.482937	46.6225448	Leptotrichia wadei	157687	Bacteria	Bacteria	1836	0	NTclustered	gi\|1708577445\|dbj\|AP019835.1\|	157687	g184	i1	98.558	480.221153846154	1040	14	100	1	1	1040	2368910	2369948	Leptotrichia wadei JMUB3934 DNA, complete genome	blastn	499430	1836	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
18632052	18632052	PRJNA796753_P_NODE_11275_length_415_cov_4.081871_g10963_i0	PRJNA796753	11275	415	4.081871	16.93976465	Leptotrichia alba	3239304	Bacteria	Bacteria	745	0	NTclustered	gi\|2785244533\|gb\|CP165647.1\|	3239304	g10963	i0	99.036	217.848192771084	415	4	100	0	1	415	88223	88637	Leptotrichia sp. HSP-536 chromosome, complete genome	blastn	90407	745	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia alba
18632245	18632245	PRJNA796753_P_NODE_45135_length_247_cov_0.885057_g44823_i0	PRJNA796753	45135	247	0.885057	2.18609079	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	185	2.11e-42	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g44823	i0	80.816	1.9919028340081	245	39	98	8	6	247	1515244	1515005	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	492	185	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
21183181	21183181	PRJNA796753_P_NODE_33797_length_267_cov_3.474227_g33485_i0	PRJNA796753	33797	267	3.474227	9.27618609	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	494	3.38e-135	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g33485	i0	100	184.606741573034	267	0	100	0	1	267	51593	51859	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	49290	494	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
21183286	21183286	PRJNA796753_P_NODE_51377_length_243_cov_0.905882_g51065_i0	PRJNA796753	51377	243	0.905882	2.20129326	Leptotrichia alba	3239304	Bacteria	Bacteria	427	3.11e-115	NTclustered	gi\|2785244533\|gb\|CP165647.1\|	3239304	g51065	i0	98.354	7.98353909465021	243	4	100	0	1	243	1191451	1191693	Leptotrichia sp. HSP-536 chromosome, complete genome	blastn	1940	427	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia alba
24168270	24168270	PRJNA796753_P_NODE_219_length_1939_cov_6.648982_g184_i0	PRJNA796753	219	1939	6.648982	128.92376098	Leptotrichia	32067	Bacteria	Bacteria	3504	0	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g184	i0	99.278	498.97627643115	1939	14	100	0	1	1939	21	1959	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	967515	3526	0.993760635280771	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis

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