metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA670521" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA670521" 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
2440280	2440280	PRJNA670521_P_NODE_92302_length_241_cov_0.916667_g91557_i0	PRJNA670521	92302	241	0.916667	2.20916747	Cetobacterium	180162	Bacteria	Bacteria	302	1.95e-77	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g91557	i0	89.256	5.0207468879668	242	24	100	2	1	241	167590	167830	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1210	302	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3188930	3188930	PRJNA670521_P_NODE_17183_length_449_cov_1.228723_g16441_i0	PRJNA670521	17183	449	1.228723	5.51696627	Cetobacterium somerae	188913	Bacteria	Bacteria	483	1.2999999999999995e-131	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g16441	i0	86.323	5.63251670378619	446	57	99	4	5	449	408790	408348	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	2529	483	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3716659	3716659	PRJNA670521_P_NODE_39963_length_324_cov_0.920319_g39218_i0	PRJNA670521	39963	324	0.920319	2.98183356	Cetobacterium	180162	Bacteria	Bacteria	499	9.039999999999999e-137	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g39218	i0	94.444	48.4506172839506	324	18	100	0	1	324	1877001	1876678	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	15698	499	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
4993267	4993267	PRJNA670521_P_NODE_89704_length_242_cov_0.911243_g88959_i0	PRJNA670521	89704	242	0.911243	2.20520806	Cetobacterium	180162	Bacteria	Bacteria	309	1.17e-79	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g88959	i0	90.909	11.9256198347107	231	20	95	1	12	241	1659162	1658932	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	2886	309	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7542773	7542773	PRJNA670521_P_NODE_36386_length_335_cov_2.790076_g35641_i0	PRJNA670521	36386	335	2.790076	9.3467546	Cetobacterium	180162	Bacteria	Bacteria	564	3.279999999999999e-156	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g35641	i0	97.015	7.51044776119403	335	10	100	0	1	335	899213	898879	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	2516	564	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7542809	7542809	PRJNA670521_P_NODE_67526_length_256_cov_1.683060_g66781_i0	PRJNA670521	67526	256	1.68306	4.3086336	Cetobacterium	180162	Bacteria	Bacteria	468	1.95e-127	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g66781	i0	99.609	100.34375	256	1	100	0	1	256	1906135	1906390	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	25688	468	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7542825	7542825	PRJNA670521_P_NODE_78686_length_247_cov_1.327586_g77941_i0	PRJNA670521	78686	247	1.327586	3.27913742	Cetobacterium	180162	Bacteria	Bacteria	385	1.94e-102	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g77941	i0	95.082	4.93927125506073	244	12	99	0	1	244	1907970	1907727	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1220	385	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8291591	8291591	PRJNA670521_P_NODE_78627_length_247_cov_1.327586_g77882_i0	PRJNA670521	78627	247	1.327586	3.27913742	Cetobacterium somerae	188913	Bacteria	Bacteria	401	1.9199999999999992e-107	NTclustered	gi\|2850954511\|gb\|CP173065.1\|	1319815	g77882	i0	95.951	5	247	10	100	0	1	247	151516	151762	Cetobacterium somerae ATCC BAA-474 chromosome	blastn	1235	401	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8291729	8291729	PRJNA670521_P_NODE_91047_length_242_cov_0.911243_g90302_i0	PRJNA670521	91047	242	0.911243	2.20520806	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	431	2.4e-116	NTclustered	gi\|1276709865\|gb\|CP024700.1\|	2663009	g90302	i0	98.76	49.7231404958678	242	3	100	0	1	242	1799976	1799735	Fusobacterium pseudoperiodonticum strain KCOM 1263 chromosome, complete genome	blastn	12033	431	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
11368516	11368516	PRJNA670521_P_NODE_8289_length_618_cov_7.788991_g7564_i0	PRJNA670521	8289	618	7.788991	48.13596438	Cetobacterium	180162	Bacteria	Bacteria	852	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g7564	i0	91.401	72.1957928802589	628	44	100	7	1	618	67689	67062	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	44617	852	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12117463	12117463	PRJNA670521_P_NODE_59470_length_274_cov_1.223881_g58725_i0	PRJNA670521	59470	274	1.223881	3.35343394	Cetobacterium somerae	188913	Bacteria	Bacteria	379	1.02e-100	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g58725	i0	91.912	80.8978102189781	272	21	99	1	1	271	1086534	1086805	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	22166	379	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12644254	12644254	PRJNA670521_P_NODE_93530_length_240_cov_2.065868_g92785_i0	PRJNA670521	93530	240	2.065868	4.9580832	Cetobacterium	180162	Bacteria	Bacteria	433	6.599999999999997e-117	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g92785	i0	99.167	99.5625	240	2	100	0	1	240	3712	3473	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	23895	433	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13392060	13392060	PRJNA670521_P_NODE_10511_length_553_cov_2.058333_g9778_i0	PRJNA670521	10511	553	2.058333	11.38258149	Cetobacterium somerae	188913	Bacteria	Bacteria	907	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g9778	i0	96.37	31.0542495479204	551	20	99	0	2	552	1904435	1903885	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	17173	907	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
15941040	15941040	PRJNA670521_P_NODE_68553_length_254_cov_1.375691_g67808_i0	PRJNA670521	68553	254	1.375691	3.49425514	Cetobacterium somerae	188913	Bacteria	Bacteria	462	8.989999999999999e-126	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g67808	i0	99.605	4.98031496062992	253	1	99	0	2	254	1776349	1776601	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1265	462	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16467844	16467844	PRJNA670521_P_NODE_49393_length_297_cov_1.674107_g48648_i0	PRJNA670521	49393	297	1.674107	4.97209779	Cetobacterium	180162	Bacteria	Bacteria	494	3.81e-135	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g48648	i0	96.633	20.040404040404	297	10	100	0	1	297	1904852	1904556	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	5952	494	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16467854	16467854	PRJNA670521_P_NODE_57233_length_279_cov_1.436893_g56488_i0	PRJNA670521	57233	279	1.436893	4.00893147	Cetobacterium	180162	Bacteria	Bacteria	414	2.84e-111	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g56488	i0	93.525	5.92114695340502	278	18	99	0	1	278	1097190	1096913	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1652	414	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
17216175	17216175	PRJNA670521_P_NODE_52294_length_290_cov_1.419355_g51549_i0	PRJNA670521	52294	290	1.419355	4.1161295	Cetobacterium somerae	188913	Bacteria	Bacteria	326	1.43e-84	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g51549	i0	87.108	4.94827586206897	287	37	99	0	1	287	1714090	1714376	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	1435	326	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
17216413	17216413	PRJNA670521_P_NODE_86654_length_244_cov_0.900585_g85909_i0	PRJNA670521	86654	244	0.900585	2.1974274	Cetobacterium somerae	188913	Bacteria	Bacteria	279	9.27e-71	NTclustered	gi\|2850953754\|gb\|CP173062.1\|	1319815	g85909	i0	87.347	83.4795081967213	245	29	100	2	1	244	581824	581581	Cetobacterium somerae ATCC BAA-474 plasmid unnamed01	blastn	20369	279	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18490592	18490592	PRJNA670521_P_NODE_50235_length_295_cov_1.387387_g49490_i0	PRJNA670521	50235	295	1.387387	4.09279165	Cetobacterium somerae	188913	Bacteria	Bacteria	449	8.310000000000001e-122	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g49490	i0	94.218	98.4372881355932	294	17	99	0	2	295	1817219	1817512	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	29039	449	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
19765356	19765356	PRJNA670521_P_NODE_86936_length_244_cov_0.900585_g86191_i0	PRJNA670521	86936	244	0.900585	2.1974274	Fusobacterium varium	856	Bacteria	Bacteria	265	2.6e-66	NTclustered	gi\|2705015041\|gb\|CP084068.1\|	856	g86191	i0	87.391	92.8770491803279	230	29	94	0	11	240	2426598	2426827	Fusobacterium varium strain SB064 chromosome, complete genome	blastn	22662	265	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
20291341	20291341	PRJNA670521_P_NODE_32016_length_352_cov_0.863799_g31271_i0	PRJNA670521	32016	352	0.863799	3.04057248	Cetobacterium	180162	Bacteria	Bacteria	582	9.539999999999999e-162	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g31271	i0	96.581	99.34375	351	12	99	0	2	352	1905411	1905061	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	34969	582	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
21040610	21040610	PRJNA670521_P_NODE_31877_length_352_cov_1.616487_g31132_i0	PRJNA670521	31877	352	1.616487	5.69003424	Cetobacterium somerae	188913	Bacteria	Bacteria	540	5.82e-149	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g31132	i0	94.318	6.21875	352	20	100	0	1	352	557643	557292	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	2189	540	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
21567027	21567027	PRJNA670521_P_NODE_73657_length_250_cov_0.870056_g72912_i0	PRJNA670521	73657	250	0.870056	2.17514	Cetobacterium	180162	Bacteria	Bacteria	303	5.66e-78	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g72912	i0	89.831	3.884	236	24	94	0	13	248	1773448	1773213	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	971	303	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
21567038	21567038	PRJNA670521_P_NODE_81617_length_246_cov_0.890173_g80872_i0	PRJNA670521	81617	246	0.890173	2.18982558	Cetobacterium	180162	Bacteria	Bacteria	405	1.48e-108	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g80872	i0	96.341	5.80487804878049	246	9	100	0	1	246	1071273	1071518	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1428	405	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22315566	22315566	PRJNA670521_P_NODE_61278_length_270_cov_1.172589_g60533_i0	PRJNA670521	61278	270	1.172589	3.1659903	Cetobacterium somerae	188913	Bacteria	Bacteria	468	2.07e-127	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g60533	i0	98.134	34.9407407407407	268	5	99	0	1	268	1743687	1743420	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	9434	468	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae

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