metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA1198392" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA1198392" 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
1043767	1043767	PRJNA1198392_P_NODE_11161_length_277_cov_1.132353_g11020_i0	PRJNA1198392	11161	277	1.132353	3.13661781	Fusobacterium	848	Bacteria	Bacteria	512	9.73e-141	NTclustered	gi\|958157244\|gb\|CP013336.1\|	1307443	g11020	i0	100	56.5415162454874	277	0	100	0	1	277	2222479	2222203	Fusobacterium hwasookii ChDC F206, complete genome	blastn	15662	512	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
2319084	2319084	PRJNA1198392_P_NODE_19062_length_245_cov_0.895349_g18921_i0	PRJNA1198392	19062	245	0.895349	2.19360505	Leptotrichia	32067	Bacteria	Bacteria	403	5.299999999999998e-108	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g18921	i0	96.327	12.8326530612245	245	9	100	0	1	245	542380	542624	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	3144	403	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
2875225	2875225	PRJNA1198392_P_NODE_11543_length_275_cov_1.222772_g11402_i0	PRJNA1198392	11543	275	1.222772	3.362623	Fusobacterium hwasookii	1583098	Bacteria	Bacteria	503	5.809999999999998e-138	NTclustered	gi\|958159838\|gb\|CP013334.1\|	1307444	g11402	i0	99.636	27.9854545454545	275	1	100	0	1	275	1149936	1149662	Fusobacterium hwasookii ChDC F300, complete genome	blastn	7696	503	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium hwasookii
4151355	4151355	PRJNA1198392_P_NODE_12184_length_271_cov_1.636364_g12043_i0	PRJNA1198392	12184	271	1.636364	4.43454644	Leptotrichia hofstadii	157688	Bacteria	Bacteria	496	9.55e-136	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g12043	i0	99.631	194.546125461255	271	1	100	0	1	271	577512	577242	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	52722	496	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
4151491	4151491	PRJNA1198392_P_NODE_16964_length_249_cov_0.875000_g16823_i0	PRJNA1198392	16964	249	0.875	2.17875	Fusobacterium nucleatum	851	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2704996929\|gb\|CP077149.1\|	851	g16823	i0	100	99.7751004016064	249	0	100	0	1	249	581111	580863	Fusobacterium nucleatum strain KCOM2013 chromosome, complete genome	blastn	24844	460	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
6702292	6702292	PRJNA1198392_P_NODE_12566_length_269_cov_2.331633_g12425_i0	PRJNA1198392	12566	269	2.331633	6.27209277	Leptotrichia buccalis	40542	Bacteria	Bacteria	459	1.2399999999999996e-124	NTclustered	gi\|257048753\|gb\|CP001685.1\|	523794	g12425	i0	97.398	15.0557620817844	269	7	100	0	1	269	2352829	2353097	Leptotrichia buccalis DSM 1135, complete genome	blastn	4050	459	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
6702424	6702424	PRJNA1198392_P_NODE_18686_length_246_cov_0.890173_g18545_i0	PRJNA1198392	18686	246	0.890173	2.18982558	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	427	3.16e-115	NTclustered	gi\|1276716588\|gb\|CP024703.1\|	2663009	g18545	i0	97.967	8.0609756097561	246	5	100	0	1	246	991636	991881	Fusobacterium pseudoperiodonticum strain KCOM 2305 chromosome, complete genome	blastn	1983	427	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
8696730	8696730	PRJNA1198392_P_NODE_16407_length_250_cov_0.870056_g16266_i0	PRJNA1198392	16407	250	0.870056	2.17514	Leptotrichia	32067	Bacteria	Bacteria	420	5.389999999999998e-113	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g16266	i0	97.571	485.06	247	3	98	2	6	250	918	673	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	121265	420	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
9252487	9252487	PRJNA1198392_P_NODE_16568_length_250_cov_0.870056_g16427_i0	PRJNA1198392	16568	250	0.870056	2.17514	Leptotrichia sp. oral taxon 498	712368	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|1227268105\|gb\|CP016753.1\|	712368	g16427	i0	99.6	4	250	1	100	0	1	250	335375	335126	Leptotrichia sp. oral taxon 498, complete genome	blastn	1000	457	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 498
9252629	9252629	PRJNA1198392_P_NODE_2908_length_440_cov_2.267030_g2767_i0	PRJNA1198392	2908	440	2.26703	9.974932	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	741	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g2767	i0	97.045	475.122727272727	440	13	100	0	1	440	54040	53601	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	209054	741	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
11247027	11247027	PRJNA1198392_P_NODE_11629_length_274_cov_1.532338_g11488_i0	PRJNA1198392	11629	274	1.532338	4.19860612	Leptotrichia	32067	Bacteria	Bacteria	507	4.47e-139	NTclustered	gi\|290759860\|gb\|GU561361.1\|	40542	g11488	i0	100	108.040145985401	274	0	100	0	1	274	1293	1020	Leptotrichia buccalis strain GEJ9 16S ribosomal RNA gene, partial sequence	blastn	29603	507	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
11802968	11802968	PRJNA1198392_P_NODE_12170_length_271_cov_1.944444_g12029_i0	PRJNA1198392	12170	271	1.944444	5.26944324	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	501	2.05e-137	NTclustered	gi\|2705022034\|gb\|CP084128.1\|	2663009	g12029	i0	100	13.7269372693727	271	0	100	0	1	271	2030280	2030550	Fusobacterium pseudoperiodonticum strain KCOM1322 chromosome, complete genome	blastn	3720	501	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
13078429	13078429	PRJNA1198392_P_NODE_9271_length_286_cov_1.122066_g9130_i0	PRJNA1198392	9271	286	1.122066	3.20910876	Fusobacterium animalis	76859	Bacteria	Bacteria	187	6.9399999999999985e-43	NTclustered	gi\|2704961909\|gb\|CP056024.1\|	76859	g9130	i0	99.038	18.8461538461538	104	1	36	0	1	104	1043763	1043660	Fusobacterium animalis strain SB001 chromosome, complete genome	blastn	5390	187	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
14353557	14353557	PRJNA1198392_P_NODE_17212_length_249_cov_0.875000_g17071_i0	PRJNA1198392	17212	249	0.875	2.17875	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1276718681\|gb\|CP024704.1\|	2663009	g17071	i0	100	99.9919678714859	249	0	100	0	1	249	605505	605753	Fusobacterium pseudoperiodonticum strain KCOM 2555 chromosome, complete genome	blastn	24898	460	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
15627326	15627326	PRJNA1198392_P_NODE_15833_length_251_cov_0.865169_g15692_i0	PRJNA1198392	15833	251	0.865169	2.17157419	Fusobacterium polymorphum	76857	Bacteria	Bacteria	431	2.4999999999999996e-116	NTclustered	gi\|2706071841\|gb\|CP077111.1\|	76857	g15692	i0	97.61	77.7609561752988	251	6	100	0	1	251	1128173	1128423	Fusobacterium polymorphum strain KCOM1275 chromosome, complete genome	blastn	19518	431	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
16901568	16901568	PRJNA1198392_P_NODE_10694_length_279_cov_1.495146_g10553_i0	PRJNA1198392	10694	279	1.495146	4.17145734	Leptotrichia sp. oral taxon 498	712368	Bacteria	Bacteria	516	7.58e-142	NTclustered	gi\|1227268105\|gb\|CP016753.1\|	712368	g10553	i0	100	147.405017921147	279	0	100	0	1	279	593111	592833	Leptotrichia sp. oral taxon 498, complete genome	blastn	41126	516	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 498
19450708	19450708	PRJNA1198392_P_NODE_21316_length_241_cov_0.916667_g21175_i0	PRJNA1198392	21316	241	0.916667	2.20916747	Leptotrichia trevisanii	109328	Bacteria	Bacteria	412	8.64e-111	NTclustered	gi\|1708584775\|dbj\|AP019845.1\|	109328	g21175	i0	97.51	12.9294605809129	241	6	100	0	1	241	593739	593979	Leptotrichia trevisanii JMUB4039 DNA, complete genome	blastn	3116	412	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
22001183	22001183	PRJNA1198392_P_NODE_12198_length_271_cov_1.555556_g12057_i0	PRJNA1198392	12198	271	1.555556	4.21555676	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	496	9.55e-136	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g12057	i0	99.631	100	271	1	100	0	1	271	1292872	1292602	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	27100	496	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
22001237	22001237	PRJNA1198392_P_NODE_14698_length_257_cov_1.673913_g14557_i0	PRJNA1198392	14698	257	1.673913	4.30195641	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	418	1.9999999999999994e-112	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g14557	i0	96.094	16.2645914396887	256	10	99	0	1	256	2231109	2230854	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	4180	418	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
23276701	23276701	PRJNA1198392_P_NODE_15019_length_255_cov_1.692308_g14878_i0	PRJNA1198392	15019	255	1.692308	4.3153854	Fusobacterium animalis	76859	Bacteria	Bacteria	466	6.98e-127	NTclustered	gi\|2706471657\|gb\|CP084079.1\|	76859	g14878	i0	99.608	65.3490196078431	255	1	100	0	1	255	1774745	1774491	Fusobacterium animalis strain SB052 chromosome, complete genome	blastn	16664	466	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
23276829	23276829	PRJNA1198392_P_NODE_20599_length_242_cov_0.911243_g20458_i0	PRJNA1198392	20599	242	0.911243	2.20520806	Pseudoleptotrichia goodfellowii	157692	Bacteria	Bacteria	303	5.45e-78	NTclustered	gi\|1708563796\|dbj\|AP019822.1\|	157692	g20458	i0	89.54	1.97520661157025	239	25	99	0	2	240	323610	323372	Leptotrichia goodfellowii JCM16774 DNA, complete genome	blastn	478	303	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Pseudoleptotrichia	Pseudoleptotrichia goodfellowii
23995906	23995906	PRJNA1198392_P_NODE_20579_length_242_cov_0.911243_g20438_i0	PRJNA1198392	20579	242	0.911243	2.20520806	Fusobacterium	848	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|2706407748\|gb\|CP077116.1\|	76857	g20438	i0	99.587	498.962809917355	242	1	100	0	1	242	190836	191077	Fusobacterium polymorphum strain KCOM1257 chromosome, complete genome	blastn	120749	442	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
24550646	24550646	PRJNA1198392_P_NODE_14880_length_256_cov_1.683060_g14739_i0	PRJNA1198392	14880	256	1.68306	4.3086336	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	460	3.2599999999999995e-125	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g14739	i0	99.219	8.1171875	256	1	100	1	1	256	848217	847963	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	2078	460	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225

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