metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA929922" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA929922" 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
906807	906807	PRJNA929922_P_NODE_25641_length_393_cov_1.246875_g25102_i0	PRJNA929922	25641	393	1.246875	4.90021875	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	604	2.3e-168	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g25102	i0	94.643	474.95165394402	392	17	99	4	1	390	52952	52563	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	186656	604	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
3456346	3456346	PRJNA929922_P_NODE_10523_length_514_cov_1.664399_g9991_i0	PRJNA929922	10523	514	1.664399	8.55501086	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	712	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g9991	i0	91.683	269.515564202335	517	37	100	6	1	514	52723	53236	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	138531	712	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
3458078	3458078	PRJNA929922_P_NODE_55583_length_314_cov_0.701245_g55043_i0	PRJNA929922	55583	314	0.701245	2.2019093	Leptotrichia hofstadii	157688	Bacteria	Bacteria	472	1.9e-128	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g55043	i0	94.481	440.707006369427	308	13	99	4	4	309	2374295	2374600	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	138382	472	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
4736366	4736366	PRJNA929922_S_NODE_19584_length_354_cov_1.348754_g19360_i0	PRJNA929922	19584	354	1.348754	4.77458916	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	603	7.369999999999998e-168	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g19360	i0	97.983	3.92090395480226	347	7	98	0	1	347	2190405	2190751	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	1388	603	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
8906515	8906515	PRJNA929922_P_NODE_41827_length_341_cov_1.149254_g41287_i0	PRJNA929922	41827	341	1.149254	3.91895614	Fusobacterium	848	Bacteria	Bacteria	625	1.5099999999999995e-174	NTclustered	gi\|2705015041\|gb\|CP084068.1\|	856	g41287	i0	99.707	11.8680351906158	341	1	100	0	1	341	2717992	2717652	Fusobacterium varium strain SB064 chromosome, complete genome	blastn	4047	625	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
9834594	9834594	PRJNA929922_P_NODE_161868_length_241_cov_0.916667_g161328_i0	PRJNA929922	161868	241	0.916667	2.20916747	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	344	3.199999999999999e-90	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g161328	i0	92.5	25.4979253112033	240	18	99	0	2	241	1107822	1107583	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	6145	344	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
14936633	14936633	PRJNA929922_S_NODE_66572_length_244_cov_3.152047_g66348_i0	PRJNA929922	66572	244	3.152047	7.69099468	Sneathia vaginalis	187101	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|2769795739\|gb\|CP160094.1\|	187101	g66348	i0	100	367.659836065574	244	0	100	0	1	244	3332	3575	Sneathia vaginalis strain CCUG_64370 chromosome, complete genome	blastn	89709	451	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia vaginalis
17483788	17483788	PRJNA929922_P_NODE_109954_length_251_cov_0.865169_g109414_i0	PRJNA929922	109954	251	0.865169	2.17157419	Leptotrichia buccalis	40542	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g109414	i0	99.602	14.8685258964143	251	1	100	0	1	251	706581	706831	Leptotrichia buccalis DSM 1135, complete genome	blastn	3732	459	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
17484089	17484089	PRJNA929922_P_NODE_124994_length_248_cov_0.880000_g124454_i0	PRJNA929922	124994	248	0.88	2.1824	Leptotrichia sp. oral taxon 221	712362	Bacteria	Bacteria	398	2.5e-106	NTclustered	gi\|2028889048\|gb\|CP072378.1\|	712362	g124454	i0	95.276	13.7620967741935	254	6	100	3	1	248	1966101	1966354	Leptotrichia sp. oral taxon 221 strain F0705 chromosome, complete genome	blastn	3413	398	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 221
17485257	17485257	PRJNA929922_P_NODE_4434_length_692_cov_2.644588_g3943_i0	PRJNA929922	4434	692	2.644588	18.30054896	Leptotrichia sp. oral taxon 218	712361	Bacteria	Bacteria	1253	0	NTclustered	gi\|2028887161\|gb\|CP072377.1\|	712361	g3943	i0	99.564	574.263005780347	688	2	99	1	5	692	3777	3091	Leptotrichia sp. oral taxon 218 strain F0707 chromosome, complete genome	blastn	397390	1253	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 218
17485279	17485279	PRJNA929922_P_NODE_4574_length_685_cov_2.436275_g4081_i0	PRJNA929922	4574	685	2.436275	16.68848375	Leptotrichia sp. oral taxon 218	712361	Bacteria	Bacteria	1266	0	NTclustered	gi\|2028887161\|gb\|CP072377.1\|	712361	g4081	i0	100	469.87299270073	685	0	100	0	1	685	1619006	1618322	Leptotrichia sp. oral taxon 218 strain F0707 chromosome, complete genome	blastn	321863	1266	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 218
20034536	20034536	PRJNA929922_S_NODE_15236_length_380_cov_2.420195_g15012_i0	PRJNA929922	15236	380	2.420195	9.196741	Sneathia sanguinegens	40543	Bacteria	Bacteria	623	6.119999999999999e-174	NTclustered	gi\|2769805188\|gb\|CP160095.1\|	40543	g15012	i0	99.417	308.768421052632	343	2	90	0	13	355	3324	2982	Sneathia sanguinegens strain CCUG 41628T chromosome, complete genome	blastn	117332	623	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sneathia	Sneathia sanguinegens
21309555	21309555	PRJNA929922_P_NODE_75737_length_284_cov_1.298578_g75197_i0	PRJNA929922	75737	284	1.298578	3.68796152	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	501	2.17e-137	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g75197	i0	99.278	98.306338028169	277	2	98	0	1	277	68856	68580	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	27919	501	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
21310386	21310386	PRJNA929922_S_NODE_38057_length_294_cov_1.045249_g37833_i0	PRJNA929922	38057	294	1.045249	3.07303206	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	488	1.7499999999999996e-133	NTclustered	gi\|2704959642\|gb\|CP077196.1\|	2663009	g37833	i0	96.61	40.0340136054422	295	9	100	1	1	294	2351890	2351596	Fusobacterium pseudoperiodonticum strain SB039 chromosome, complete genome	blastn	11770	488	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum

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