metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA788929" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA788929" 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
2489870	2489870	PRJNA788929_P_NODE_6602_length_741_cov_62.610778_g5980_i0	PRJNA788929	6602	741	62.610778	463.94586498	Cetobacterium	180162	Bacteria	Bacteria	996	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g5980	i0	91.76	9.7004048582996	716	59	97	0	26	741	1221273	1220558	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	7188	996	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3320404	3320404	PRJNA788929_P_NODE_16243_length_415_cov_8.959064_g15584_i0	PRJNA788929	16243	415	8.959064	37.1801156	Cetobacterium somerae	188913	Bacteria	Bacteria	291	7.77e-74	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g15584	i0	87.649	32.6867469879518	251	29	75	1	142	392	1824814	1824566	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	13565	291	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3766116	3766116	PRJNA788929_P_NODE_43783_length_235_cov_8.611111_g43122_i0	PRJNA788929	43783	235	8.611111	20.23611085	Fusobacterium	848	Bacteria	Bacteria	388	1.41e-103	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g43122	i0	99.531	90.8	213	1	91	0	23	235	782705	782493	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	21338	388	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
5042457	5042457	PRJNA788929_P_NODE_22444_length_342_cov_20.873606_g21783_i0	PRJNA788929	22444	342	20.873606	71.38773252	Cetobacterium	180162	Bacteria	Bacteria	551	2.609999999999999e-152	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g21783	i0	97.806	27.3011695906433	319	7	93	0	1	319	480590	480272	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	9337	551	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6318477	6318477	PRJNA788929_P_NODE_8125_length_649_cov_56.522569_g7478_i0	PRJNA788929	8125	649	56.522569	366.83147281	Cetobacterium	180162	Bacteria	Bacteria	1003	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g7478	i0	95.687	25.9537750385208	626	23	96	4	24	648	1858281	1858903	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	16844	1003	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7147715	7147715	PRJNA788929_P_NODE_20666_length_359_cov_7.513986_g20006_i0	PRJNA788929	20666	359	7.513986	26.97520974	Cetobacterium somerae	188913	Bacteria	Bacteria	375	1.7799999999999997e-99	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g20006	i0	87.462	4.57660167130919	327	39	91	2	12	337	438112	437787	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	1643	375	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7147764	7147764	PRJNA788929_P_NODE_24086_length_327_cov_23.964567_g23425_i0	PRJNA788929	24086	327	23.964567	78.36413409	Cetobacterium somerae	188913	Bacteria	Bacteria	361	4.499999999999999e-95	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g23425	i0	87.908	4.67889908256881	306	37	94	0	22	327	1293991	1294296	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1530	361	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7148113	7148113	PRJNA788929_P_NODE_48126_length_210_cov_6.058394_g47465_i0	PRJNA788929	48126	210	6.058394	12.7226274	Cetobacterium somerae	188913	Bacteria	Bacteria	346	7.55e-91	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g47465	i0	100	416.504761904762	187	0	89	0	24	210	1318983	1318797	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	87466	346	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8867513	8867513	PRJNA788929_P_NODE_42287_length_241_cov_15.059524_g41626_i0	PRJNA788929	42287	241	15.059524	36.29345284	Cetobacterium	180162	Bacteria	Bacteria	322	1.5e-83	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g41626	i0	93.151	4.54356846473029	219	15	91	0	1	219	317246	317028	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1095	322	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8867526	8867526	PRJNA788929_P_NODE_44287_length_232_cov_28.484277_g43626_i0	PRJNA788929	44287	232	28.484277	66.08352264	Cetobacterium	180162	Bacteria	Bacteria	272	1.46e-68	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g43626	i0	91.5	4.31034482758621	200	14	85	3	35	232	150900	150702	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	1000	272	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
9697584	9697584	PRJNA788929_P_NODE_25108_length_319_cov_29.369919_g24447_i0	PRJNA788929	25108	319	29.369919	93.69004161	Cetobacterium somerae	188913	Bacteria	Bacteria	405	1.99e-108	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g24447	i0	91.246	20.9937304075235	297	26	93	0	1	297	1350927	1351223	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	6697	405	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
10973236	10973236	PRJNA788929_P_NODE_21549_length_350_cov_24.530686_g20888_i0	PRJNA788929	21549	350	24.530686	85.857401	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	604	2.0199999999999992e-168	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g20888	i0	100	126.082857142857	327	0	93	0	24	350	1995356	1995030	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	44129	604	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
11418063	11418063	PRJNA788929_P_NODE_14149_length_451_cov_24.701058_g13491_i0	PRJNA788929	14149	451	24.701058	111.40177158	Cetobacterium	180162	Bacteria	Bacteria	647	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g13491	i0	97.613	83.0665188470066	377	9	92	0	2	378	1782246	1782622	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	37463	647	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12694082	12694082	PRJNA788929_P_NODE_6910_length_722_cov_34.258860_g6281_i0	PRJNA788929	6910	722	34.25886	247.3489692	Cetobacterium	180162	Bacteria	Bacteria	1118	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g6281	i0	96.093	28.9113573407202	691	18	95	5	1	683	1900331	1899642	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	20874	1118	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13523022	13523022	PRJNA788929_P_NODE_2431_length_1347_cov_58.927002_g2115_i0	PRJNA788929	2431	1347	58.927002	793.74671694	Cetobacterium somerae	188913	Bacteria	Bacteria	1624	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g2115	i0	89.502	18.6785449146251	1286	131	95	4	54	1337	1411509	1412792	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	25160	1624	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
15242559	15242559	PRJNA788929_P_NODE_15932_length_419_cov_34.193642_g15273_i0	PRJNA788929	15932	419	34.193642	143.27135998	Cetobacterium	180162	Bacteria	Bacteria	514	4.28e-141	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g15273	i0	90.331	4.71837708830549	393	36	93	1	6	396	470789	470397	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1977	514	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
15242562	15242562	PRJNA788929_P_NODE_16392_length_412_cov_32.294985_g15733_i0	PRJNA788929	16392	412	32.294985	133.0553382	Cetobacterium	180162	Bacteria	Bacteria	254	1.01e-62	NTclustered	gi\|2865364693\|gb\|CP122286.1\|	188913	g15733	i0	91.489	2.28398058252427	188	10	45	4	189	375	127683	127865	Cetobacterium somerae strain MSU49 plasmid p49_t7	blastn	941	254	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16072152	16072152	PRJNA788929_P_NODE_49813_length_199_cov_8.912698_g49152_i0	PRJNA788929	49813	199	8.912698	17.73626902	Fusobacterium perfoetens	852	Bacteria	Bacteria	289	1.21e-73	NTclustered	gi\|13447141\|gb\|AF342857.1\|	852	g49152	i0	96.067	408.145728643216	178	5	88	2	2	177	450	273	Fusobacterium perfoetens strain ATCC 29250 16S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	81221	289	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium perfoetens
17347610	17347610	PRJNA788929_P_NODE_2874_length_1236_cov_23.718831_g2501_i0	PRJNA788929	2874	1236	23.718831	293.16475116	Cetobacterium somerae	188913	Bacteria	Bacteria	1062	0	NTclustered	gi\|2201062202\|gb\|CP092524.1\|	188913	g2501	i0	83.445	0.962783171521036	1190	150	94	34	76	1236	4230	3059	Cetobacterium somerae strain CS2105-BJ plasmid unnamed5, complete sequence	blastn	1190	1062	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
19896065	19896065	PRJNA788929_P_NODE_2156_length_1433_cov_84.429412_g1880_i0	PRJNA788929	2156	1433	84.429412	1209.87347396	Cetobacterium somerae	188913	Bacteria	Bacteria	1653	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g1880	i0	87.81	54.3224005582694	1411	172	98	0	1	1411	442427	441017	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	77844	1653	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
19896505	19896505	PRJNA788929_P_NODE_5636_length_825_cov_11.042553_g5038_i0	PRJNA788929	5636	825	11.042553	91.10106225	Cetobacterium somerae	188913	Bacteria	Bacteria	797	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g5038	i0	84.75	4.84848484848485	800	117	96	5	2	797	8052	8850	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	4000	797	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20340597	20340597	PRJNA788929_P_NODE_25156_length_319_cov_12.479675_g24495_i0	PRJNA788929	25156	319	12.479675	39.81016325	Cetobacterium	180162	Bacteria	Bacteria	470	6.969999999999998e-128	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g24495	i0	95.578	90.5705329153605	294	12	92	1	24	317	1816390	1816098	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	28892	470	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22446395	22446395	PRJNA788929_P_NODE_13038_length_476_cov_21.290323_g12381_i0	PRJNA788929	13038	476	21.290323	101.34193748	Cetobacterium somerae	188913	Bacteria	Bacteria	385	4.02e-102	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g12381	i0	82.018	4.78991596638655	456	78	95	4	1	454	1302192	1302645	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	2280	385	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22892079	22892079	PRJNA788929_P_NODE_4538_length_947_cov_51.906178_g4007_i0	PRJNA788929	4538	947	51.906178	491.55150566	Cetobacterium	180162	Bacteria	Bacteria	885	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g4007	i0	84.983	4.64202745512144	879	125	92	7	63	937	1992436	1993311	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	4396	885	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);;