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

23 rows where analysis = "blastn", bioproject = "PRJNA841653" 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
830014	830014	PRJNA841653_P_NODE_11361_length_494_cov_2.130641_g10692_i0	PRJNA841653	11361	494	2.130641	10.52536654	Leptotrichia sp. SK-5	3075818	Bacteria	Bacteria	889	0	NTclustered	gi\|2899356158\|dbj\|AP028931.1\|	3075818	g10692	i0	99.189	385.457489878543	493	4	99	0	1	493	200465	199973	Leptotrichia sp. SK-5 DNA, complete genome	blastn	190416	889	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. SK-5
830833	830833	PRJNA841653_P_NODE_53201_length_246_cov_0.890173_g52527_i0	PRJNA841653	53201	246	0.890173	2.18982558	Cetobacterium somerae	188913	Bacteria	Bacteria	363	9.039999999999999e-96	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g52527	i0	93.776	49.739837398374	241	15	98	0	1	241	1679229	1679469	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	12236	363	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
830867	830867	PRJNA841653_P_NODE_55281_length_244_cov_2.631579_g54607_i0	PRJNA841653	55281	244	2.631579	6.42105276	Cetobacterium somerae	188913	Bacteria	Bacteria	329	9.08e-86	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g54607	i0	92.275	14.4467213114754	233	17	95	1	6	237	1156867	1157099	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	3525	329	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
1230712	1230712	PRJNA841653_P_NODE_34601_length_279_cov_1.330097_g33927_i0	PRJNA841653	34601	279	1.330097	3.71097063	Cetobacterium	180162	Bacteria	Bacteria	453	6.03e-123	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g33927	i0	96.703	5.83154121863799	273	7	97	2	8	279	1858281	1858552	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1627	453	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
2506228	2506228	PRJNA841653_P_NODE_29722_length_299_cov_1.146018_g29048_i0	PRJNA841653	29722	299	1.146018	3.42659382	Cetobacterium	180162	Bacteria	Bacteria	497	2.97e-136	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g29048	i0	97.27	26.5150501672241	293	8	98	0	1	293	1902691	1902399	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	7928	497	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
4658598	4658598	PRJNA841653_P_NODE_19824_length_366_cov_13.890785_g19152_i0	PRJNA841653	19824	366	13.890785	50.8402731	Cetobacterium somerae	188913	Bacteria	Bacteria	592	1.6599999999999993e-164	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g19152	i0	96.379	23.2431693989071	359	13	98	0	2	360	1948407	1948765	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	8507	592	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
5933439	5933439	PRJNA841653_P_NODE_23805_length_334_cov_1.053640_g23131_i0	PRJNA841653	23805	334	1.05364	3.5191576	Cetobacterium somerae	188913	Bacteria	Bacteria	520	7.179999999999999e-143	NTclustered	gi\|2850954511\|gb\|CP173065.1\|	1319815	g23131	i0	95.399	15.5089820359281	326	15	98	0	9	334	796189	796514	Cetobacterium somerae ATCC BAA-474 chromosome	blastn	5180	520	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7608975	7608975	PRJNA841653_P_NODE_59726_length_242_cov_0.911243_g59052_i0	PRJNA841653	59726	242	0.911243	2.20520806	Cetobacterium	180162	Bacteria	Bacteria	422	1.44e-113	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g59052	i0	99.567	94.2272727272727	231	1	95	0	12	242	3484	3714	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	22803	422	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8883654	8883654	PRJNA841653_P_NODE_21147_length_354_cov_3.743772_g20473_i0	PRJNA841653	21147	354	3.743772	13.25295288	Fusobacterium	848	Bacteria	Bacteria	625	1.5699999999999996e-174	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g20473	i0	98.857	346.497175141243	350	4	99	0	5	354	459853	460202	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	122660	630	0.992063492063492	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
8883686	8883686	PRJNA841653_P_NODE_23627_length_335_cov_1.160305_g22953_i0	PRJNA841653	23627	335	1.160305	3.88702175	Cetobacterium	180162	Bacteria	Bacteria	510	4.339999999999998e-140	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g22953	i0	95.611	94.5283582089552	319	12	95	2	1	318	479364	479047	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	31667	510	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8883850	8883850	PRJNA841653_P_NODE_38227_length_266_cov_2.404145_g37553_i0	PRJNA841653	38227	266	2.404145	6.3950257	Leptotrichia	32067	Bacteria	Bacteria	409	1.2499999999999998e-109	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g37553	i0	96.016	412.890977443609	251	10	94	0	13	263	499883	500133	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	109829	409	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
12710317	12710317	PRJNA841653_P_NODE_29130_length_302_cov_1.296943_g28456_i0	PRJNA841653	29130	302	1.296943	3.91676786	Cetobacterium	180162	Bacteria	Bacteria	412	1.1199999999999997e-110	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g28456	i0	91.749	5.01655629139073	303	16	97	2	6	299	1730547	1730245	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1515	412	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
14858727	14858727	PRJNA841653_P_NODE_5012_length_766_cov_3.063492_g4407_i0	PRJNA841653	5012	766	3.063492	23.46634872	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	1395	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g4407	i0	99.607	502.044386422977	764	3	99	0	3	766	52762	51999	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	384566	1395	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
17409140	17409140	PRJNA841653_P_NODE_59834_length_242_cov_0.911243_g59160_i0	PRJNA841653	59834	242	0.911243	2.20520806	Cetobacterium somerae	188913	Bacteria	Bacteria	255	1.55e-63	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g59160	i0	86.325	5.16115702479339	234	32	97	0	4	237	1618282	1618515	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	1249	255	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
19956630	19956630	PRJNA841653_P_NODE_20776_length_358_cov_1.126316_g20102_i0	PRJNA841653	20776	358	1.126316	4.03221128	Leptotrichia hofstadii	157688	Bacteria	Bacteria	556	5.889999999999999e-154	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g20102	i0	94.93	246.583798882682	355	18	99	0	1	355	498004	497650	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	88277	556	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
20357053	20357053	PRJNA841653_P_NODE_30076_length_297_cov_1.357143_g29402_i0	PRJNA841653	30076	297	1.357143	4.03071471	Cetobacterium	180162	Bacteria	Bacteria	496	1.06e-135	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g29402	i0	97.26	20.6835016835017	292	8	98	0	6	297	1900989	1901280	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	6143	496	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
21232677	21232677	PRJNA841653_P_NODE_40117_length_260_cov_2.096257_g39443_i0	PRJNA841653	40117	260	2.096257	5.4502682	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	429	9.37e-116	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g39443	i0	98.361	181.873076923077	244	4	94	0	7	250	51833	51590	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	47287	429	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
23782792	23782792	PRJNA841653_P_NODE_34259_length_280_cov_1.463768_g33585_i0	PRJNA841653	34259	280	1.463768	4.0985504	Leptotrichia wadei	157687	Bacteria	Bacteria	518	2.12e-142	NTclustered	gi\|1708575239\|dbj\|AP019834.1\|	157687	g33585	i0	100	187.975	280	0	100	0	1	280	2244009	2244288	Leptotrichia wadei JMUB3933 DNA, complete genome	blastn	52633	518	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
23782991	23782991	PRJNA841653_P_NODE_44039_length_251_cov_0.865169_g43365_i0	PRJNA841653	44039	251	0.865169	2.17157419	Cetobacterium somerae	188913	Bacteria	Bacteria	219	2.1199999999999998e-52	NTclustered	gi\|2201062198\|gb\|CP092520.1\|	188913	g43365	i0	83.128	0.968127490039841	243	37	96	4	1	241	38243	38483	Cetobacterium somerae strain CS2105-BJ plasmid unnamed1, complete sequence	blastn	243	219	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24182358	24182358	PRJNA841653_P_NODE_33919_length_281_cov_1.899038_g33245_i0	PRJNA841653	33919	281	1.899038	5.33629678	Cetobacterium	180162	Bacteria	Bacteria	488	1.6699999999999998e-133	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g33245	i0	98.214	4.98220640569395	280	4	99	1	1	279	1901815	1901536	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1400	488	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24182541	24182541	PRJNA841653_P_NODE_62279_length_241_cov_0.916667_g61605_i0	PRJNA841653	62279	241	0.916667	2.20916747	Fusobacterium	848	Bacteria	Bacteria	435	1.84e-117	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g61605	i0	99.58	98.7551867219917	238	1	99	0	3	240	1408749	1408986	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	23800	435	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
24182559	24182559	PRJNA841653_P_NODE_64459_length_202_cov_9.713178_g63785_i0	PRJNA841653	64459	202	9.713178	19.62061956	Cetobacterium	180162	Bacteria	Bacteria	274	3.45e-69	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g63785	i0	91.837	4.85148514851485	196	16	97	0	2	197	81241	81046	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	980	274	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25457213	25457213	PRJNA841653_P_NODE_20720_length_358_cov_2.259649_g20046_i0	PRJNA841653	20720	358	2.259649	8.08954342	Cetobacterium	180162	Bacteria	Bacteria	566	9.789999999999999e-157	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g20046	i0	95.726	7.25698324022346	351	15	98	0	1	351	899217	898867	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	2598	566	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);;