metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA1204310" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA1204310" 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
1044981	1044981	PRJNA1204310_P_NODE_20201_length_402_cov_2.148936_g19904_i0	PRJNA1204310	20201	402	2.148936	8.63872272	Cetobacterium	180162	Bacteria	Bacteria	457	6.989999999999999e-124	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g19904	i0	87.437	8.18159203980099	398	48	99	2	6	402	1336334	1335938	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	3289	457	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
2320349	2320349	PRJNA1204310_P_NODE_35122_length_315_cov_1.252066_g34825_i0	PRJNA1204310	35122	315	1.252066	3.9440079	Cetobacterium	180162	Bacteria	Bacteria	409	1.52e-109	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g34825	i0	90.127	4.99047619047619	314	31	99	0	2	315	1955631	1955318	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1572	409	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
2879674	2879674	PRJNA1204310_P_NODE_1903_length_1124_cov_4.632731_g1721_i0	PRJNA1204310	1903	1124	4.632731	52.07189644	Cetobacterium somerae	188913	Bacteria	Bacteria	1066	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g1721	i0	84.722	5.56316725978648	1080	149	95	16	51	1122	1358371	1357300	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	6253	1066	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
2880473	2880473	PRJNA1204310_P_NODE_51983_length_252_cov_0.871508_g51686_i0	PRJNA1204310	51983	252	0.871508	2.19620016	Cetobacterium somerae	188913	Bacteria	Bacteria	327	3.39e-85	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g51686	i0	90.157	5.03968253968254	254	22	100	3	1	252	1561562	1561814	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1270	327	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
2880793	2880793	PRJNA1204310_P_NODE_9503_length_566_cov_3.306288_g9211_i0	PRJNA1204310	9503	566	3.306288	18.71359008	Cetobacterium somerae	188913	Bacteria	Bacteria	586	1.24e-162	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g9211	i0	85.842	47.2420494699647	558	72	98	7	1	555	118516	117963	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	26739	586	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
4156359	4156359	PRJNA1204310_P_NODE_43544_length_281_cov_1.125000_g43247_i0	PRJNA1204310	43544	281	1.125	3.16125	Cetobacterium somerae	188913	Bacteria	Bacteria	453	6.08e-123	NTclustered	gi\|2850954511\|gb\|CP173065.1\|	1319815	g43247	i0	95.73	6.06405693950178	281	12	100	0	1	281	151812	151532	Cetobacterium somerae ATCC BAA-474 chromosome	blastn	1704	453	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
4873159	4873159	PRJNA1204310_P_NODE_42364_length_285_cov_1.174528_g42067_i0	PRJNA1204310	42364	285	1.174528	3.3474048	Cetobacterium	180162	Bacteria	Bacteria	527	3.59e-145	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g42067	i0	100	5.5859649122807	285	0	100	0	1	285	616070	615786	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	1592	527	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
5432926	5432926	PRJNA1204310_P_NODE_60045_length_244_cov_1.783626_g59748_i0	PRJNA1204310	60045	244	1.783626	4.35204744	Fusobacteriaceae bacterium	2053555	Bacteria	Bacteria	176	1.25e-39	NTclustered	gi\|2892346784\|dbj\|AP035781.1\|	2053555	g59748	i0	80.162	1.32377049180328	247	40	99	9	2	244	328470	328229	Fusobacteriaceae bacterium 9N8 DNA, complete genome	blastn	323	176	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae		Fusobacteriaceae bacterium
11248369	11248369	PRJNA1204310_P_NODE_42949_length_283_cov_1.138095_g42652_i0	PRJNA1204310	42949	283	1.138095	3.22080885	Bacteria	2	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|1540073569\|emb\|LR134390.1\|	856	g42652	i0	100	0.296819787985866	28	0	10	0	160	187	1844985	1845012	Fusobacterium varium strain NCTC10560 genome assembly, chromosome: 1	blastn	84	52.8	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium varium
12523626	12523626	PRJNA1204310_P_NODE_19510_length_408_cov_2.298507_g19213_i0	PRJNA1204310	19510	408	2.298507	9.37790856	Cetobacterium	180162	Bacteria	Bacteria	656	0	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g19213	i0	95.833	7.06127450980392	408	14	99	3	1	407	899211	898806	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	2881	656	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13082747	13082747	PRJNA1204310_P_NODE_32371_length_328_cov_1.223529_g32074_i0	PRJNA1204310	32371	328	1.223529	4.01317512	Cetobacterium somerae	188913	Bacteria	Bacteria	412	1.2299999999999997e-110	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g32074	i0	89.329	5	328	35	100	0	1	328	1373539	1373866	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	1640	412	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13083358	13083358	PRJNA1204310_P_NODE_58951_length_245_cov_2.267442_g58654_i0	PRJNA1204310	58951	245	2.267442	5.5552329	Cetobacterium somerae	188913	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2666491349\|gb\|CP143325.1\|	188913	g58654	i0	100	1	245	0	100	0	1	245	35280	35036	Cetobacterium somerae strain ceto plasmid p6, complete sequence	blastn	245	453	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13798424	13798424	PRJNA1204310_P_NODE_51111_length_253_cov_0.866667_g50814_i0	PRJNA1204310	51111	253	0.866667	2.19266751	Cetobacterium	180162	Bacteria	Bacteria	374	4.31e-99	NTclustered	gi\|2865369153\|gb\|CP122300.1\|	188913	g50814	i0	93.281	3.99209486166008	253	17	100	0	1	253	58107	57855	Cetobacterium somerae strain MSU41 plasmid p41_t14, complete sequence	blastn	1010	374	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
15631543	15631543	PRJNA1204310_P_NODE_14653_length_463_cov_5.184615_g14356_i0	PRJNA1204310	14653	463	5.184615	24.00476745	Cetobacterium somerae	188913	Bacteria	Bacteria	333	1.43e-86	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g14356	i0	81.311	3.55939524838013	412	75	89	2	52	462	1309078	1309488	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	1648	333	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16347498	16347498	PRJNA1204310_P_NODE_3473_length_883_cov_2.092593_g3239_i0	PRJNA1204310	3473	883	2.092593	18.47759619	Cetobacterium	180162	Bacteria	Bacteria	784	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g3239	i0	82.883	6.53114382785957	888	137	99	13	5	882	1368260	1369142	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	5767	784	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20171339	20171339	PRJNA1204310_P_NODE_55216_length_249_cov_0.886364_g54919_i0	PRJNA1204310	55216	249	0.886364	2.20704636	Cetobacterium	180162	Bacteria	Bacteria	418	1.9299999999999995e-112	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g54919	i0	97.166	23.8032128514056	247	7	99	0	2	248	1905622	1905868	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	5927	418	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20171348	20171348	PRJNA1204310_P_NODE_56556_length_248_cov_0.891429_g56259_i0	PRJNA1204310	56556	248	0.891429	2.21074392	Cetobacterium	180162	Bacteria	Bacteria	398	2.5e-106	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g56259	i0	95.565	14.9475806451613	248	11	100	0	1	248	1858878	1859125	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	3707	398	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
21446903	21446903	PRJNA1204310_P_NODE_34617_length_317_cov_1.778689_g34320_i0	PRJNA1204310	34617	317	1.778689	5.63844413	Cetobacterium	180162	Bacteria	Bacteria	370	7.22e-98	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g34320	i0	88.103	4.90220820189274	311	37	98	0	2	312	145236	144926	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1554	370	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22721801	22721801	PRJNA1204310_P_NODE_11658_length_515_cov_1.830317_g11361_i0	PRJNA1204310	11658	515	1.830317	9.42613255	Cetobacterium	180162	Bacteria	Bacteria	501	4.17e-137	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g11361	i0	84.272	1.99417475728155	515	79	99	2	1	514	296841	296328	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1027	501	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22721802	22721802	PRJNA1204310_P_NODE_11878_length_511_cov_1.246575_g11581_i0	PRJNA1204310	11878	511	1.246575	6.36999825	Cetobacterium	180162	Bacteria	Bacteria	560	6.72e-155	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g11581	i0	86.471	4.99021526418787	510	69	99	0	2	511	167926	168435	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	2550	560	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22721903	22721903	PRJNA1204310_P_NODE_32398_length_328_cov_1.168627_g32101_i0	PRJNA1204310	32398	328	1.168627	3.83309656	Cetobacterium	180162	Bacteria	Bacteria	601	2.4399999999999998e-167	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g32101	i0	99.695	5	328	1	100	0	1	328	55471	55798	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1640	606	0.991749174917492	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22721936	22721936	PRJNA1204310_P_NODE_40518_length_291_cov_1.366972_g40221_i0	PRJNA1204310	40518	291	1.366972	3.97788852	Cetobacterium	180162	Bacteria	Bacteria	394	3.89e-105	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g40221	i0	91.065	5	291	26	100	0	1	291	1955270	1955560	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1455	394	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
23280906	23280906	PRJNA1204310_P_NODE_18379_length_419_cov_1.118497_g18082_i0	PRJNA1204310	18379	419	1.118497	4.68650243	Cetobacterium somerae	188913	Bacteria	Bacteria	501	3.329999999999999e-137	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g18082	i0	88.361	5.02386634844869	421	43	99	5	2	419	1336100	1335683	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	2105	501	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
23281869	23281869	PRJNA1204310_P_NODE_61019_length_243_cov_1.835294_g60722_i0	PRJNA1204310	61019	243	1.835294	4.45976442	Cetobacterium somerae	188913	Bacteria	Bacteria	189	1.6e-43	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g60722	i0	80.894	5.06172839506173	246	41	100	5	1	243	28215	28457	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1230	189	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24555314	24555314	PRJNA1204310_P_NODE_36180_length_310_cov_1.316456_g35883_i0	PRJNA1204310	36180	310	1.316456	4.0810136	Cetobacterium somerae	188913	Bacteria	Bacteria	363	1.18e-95	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g35883	i0	88.158	3.92258064516129	304	36	98	0	5	308	956461	956158	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1216	363	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24555567	24555567	PRJNA1204310_P_NODE_47540_length_265_cov_2.265625_g47243_i0	PRJNA1204310	47540	265	2.265625	6.00390625	Cetobacterium somerae	188913	Bacteria	Bacteria	191	4.92e-44	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g47243	i0	91.367	2.5433962264150898	139	12	52	0	2	140	1498739	1498601	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	674	191	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);;