metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA1011844" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA1011844" 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
155942	155942	PRJNA1011844_P_NODE_121941_length_280_cov_9.164251_g113364_i0	PRJNA1011844	121941	280	9.164251	25.6599028	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	468	2.16e-127	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g113364	i0	98.496	483.664285714286	266	2	95	2	12	276	52246	52510	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	135426	468	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
156161	156161	PRJNA1011844_P_NODE_140121_length_257_cov_2.326087_g131543_i0	PRJNA1011844	140121	257	2.326087	5.97804359	Leptotrichia trevisanii	109328	Bacteria	Bacteria	442	1.1899999999999995e-119	NTclustered	gi\|1708572621\|dbj\|AP019831.1\|	109328	g131543	i0	98.79	471.334630350195	248	3	96	0	1	248	159756	159509	Leptotrichia trevisanii JMUB3870 DNA, complete genome	blastn	121133	442	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia trevisanii
2277480	2277480	PRJNA1011844_P_NODE_84622_length_379_cov_10.493464_g76076_i0	PRJNA1011844	84622	379	10.493464	39.77022856	Fusobacterium	848	Bacteria	Bacteria	652	0	NTclustered	gi\|2704970001\|gb\|CP077124.1\|	851	g76076	i0	98.645	465.377308707124	369	4	97	1	2	369	2116867	2117235	Fusobacterium nucleatum strain KCOM3756 chromosome, complete genome	blastn	176378	658	0.990881458966565	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
3982563	3982563	PRJNA1011844_P_NODE_136864_length_261_cov_1.638298_g128286_i0	PRJNA1011844	136864	261	1.638298	4.27595778	Cetobacterium somerae	188913	Bacteria	Bacteria	283	7.749999999999999e-72	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g128286	i0	89.083	6.32950191570881	229	23	87	2	27	254	101412	101185	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1652	283	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
4830312	4830312	PRJNA1011844_P_NODE_79344_length_403_cov_2.281818_g70828_i0	PRJNA1011844	79344	403	2.281818	9.19572654	Leptotrichia	32067	Bacteria	Bacteria	708	0	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g70828	i0	99.486	312.084367245658	389	2	97	0	12	400	1148	1536	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	125770	713	0.992987377279102	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
6536138	6536138	PRJNA1011844_P_NODE_96086_length_339_cov_0.924812_g87523_i0	PRJNA1011844	96086	339	0.924812	3.13511268	uncultured Fusobacteriota bacterium	174329	Bacteria	Bacteria	466	9.65e-127	NTclustered	gi\|148615270\|gb\|EF188581.1\|	174329	g87523	i0	94.408	89.7463126843658	304	15	89	2	30	332	637	335	Uncultured Fusobacteria bacterium clone 77 16S ribosomal RNA gene, partial sequence	blastn	30424	466	1	Bacteria	Fusobacteriati	Fusobacteriota					uncultured Fusobacteriota bacterium
9083186	9083186	PRJNA1011844_P_NODE_102648_length_319_cov_9.406504_g94078_i0	PRJNA1011844	102648	319	9.406504	30.00674776	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	512	1.14e-140	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g94078	i0	97.039	101.74921630094	304	9	95	0	3	306	51886	51583	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	32458	512	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
9084779	9084779	PRJNA1011844_P_NODE_45608_length_679_cov_9.707921_g37505_i0	PRJNA1011844	45608	679	9.707921	65.91678359	Fusobacterium polymorphum	76857	Bacteria	Bacteria	1194	0	NTclustered	gi\|2706056059\|gb\|CP077188.1\|	76857	g37505	i0	98.954	486.717231222386	669	3	98	4	1	668	561964	561299	Fusobacterium polymorphum strain SB028 chromosome, complete genome	blastn	330481	1194	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
10358947	10358947	PRJNA1011844_P_NODE_113909_length_293_cov_4.863636_g105333_i0	PRJNA1011844	113909	293	4.863636	14.25045348	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	409	1.4e-109	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g105333	i0	93.478	407.412969283276	276	16	94	2	9	283	53037	52763	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	119372	409	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
12909748	12909748	PRJNA1011844_P_NODE_140851_length_256_cov_3.071038_g132273_i0	PRJNA1011844	140851	256	3.071038	7.86185728	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	364	2.6299999999999993e-96	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g132273	i0	95.217	442.96875	230	11	90	0	7	236	53509	53280	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	113400	364	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
12911100	12911100	PRJNA1011844_P_NODE_63071_length_502_cov_3.466200_g54658_i0	PRJNA1011844	63071	502	3.4662	17.400324	Leptotrichia hofstadii	157688	Bacteria	Bacteria	870	0	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g54658	i0	98.58	326.631474103586	493	6	98	1	1	493	498365	497874	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	163969	870	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
18008264	18008264	PRJNA1011844_P_NODE_167035_length_233_cov_2.375000_g158454_i0	PRJNA1011844	167035	233	2.375	5.53375	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	313	8.66e-81	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g158454	i0	92.627	0.931330472103004	217	16	93	0	13	229	1083648	1083864	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	217	313	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
19283327	19283327	PRJNA1011844_P_NODE_76836_length_415_cov_2.400585_g68332_i0	PRJNA1011844	76836	415	2.400585	9.96242775	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	684	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g68332	i0	97.506	244.250602409639	401	9	97	1	5	405	53421	53022	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	101364	684	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
20128184	20128184	PRJNA1011844_P_NODE_116036_length_289_cov_9.666667_g107460_i0	PRJNA1011844	116036	289	9.666667	27.93666763	Fusobacterium	848	Bacteria	Bacteria	499	7.95e-137	NTclustered	gi\|958164477\|gb\|CP013328.1\|	76857	g107460	i0	98.925	449.512110726644	279	3	97	0	11	289	164840	164562	Fusobacterium nucleatum subsp. polymorphum strain ChDC F319 genome	blastn	129909	499	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
21403874	21403874	PRJNA1011844_P_NODE_126397_length_274_cov_3.467662_g117819_i0	PRJNA1011844	126397	274	3.467662	9.50139388	Leptotrichia	32067	Bacteria	Bacteria	403	6.03e-108	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g117819	i0	95.635	414.237226277372	252	10	92	1	16	267	1701	1951	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	113501	403	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
21404171	21404171	PRJNA1011844_P_NODE_177277_length_207_cov_5.082090_g168695_i0	PRJNA1011844	177277	207	5.08209	10.5199263	Cetobacterium	180162	Bacteria	Bacteria	313	7.53e-81	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g168695	i0	94.975	64.9565217391304	199	10	96	0	1	199	1484826	1485024	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	13446	313	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
21833169	21833169	PRJNA1011844_P_NODE_157898_length_243_cov_1.594118_g149318_i0	PRJNA1011844	157898	243	1.594118	3.87370674	Leptotrichia hofstadii	157688	Bacteria	Bacteria	407	4.06e-109	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g149318	i0	98.283	433.855967078189	233	3	96	1	11	243	2255748	2255517	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	105427	407	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
23108883	23108883	PRJNA1011844_P_NODE_176259_length_210_cov_7.459854_g167677_i0	PRJNA1011844	176259	210	7.459854	15.6656934	Cetobacterium somerae	188913	Bacteria	Bacteria	309	9.9e-80	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g167677	i0	96.277	27.8142857142857	188	7	90	0	11	198	67459	67272	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	5841	309	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25228540	25228540	PRJNA1011844_P_NODE_76740_length_415_cov_7.932749_g68236_i0	PRJNA1011844	76740	415	7.932749	32.92090835	Fusobacterium	848	Bacteria	Bacteria	710	0	NTclustered	gi\|2706496642\|gb\|CP084152.1\|	76857	g68236	i0	98.511	463.486746987952	403	5	97	1	1	403	626701	626300	Fusobacterium polymorphum strain KCOM2594 chromosome, complete genome	blastn	192347	710	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum

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