metadata: contig_metadata: 33 rows where analysis = "blastn", bioproject = "PRJNA484127" and tax

33 rows where analysis = "blastn", bioproject = "PRJNA484127" 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
1097279	1097279	PRJNA484127_P_NODE_16861_length_314_cov_1.477178_g16712_i0	PRJNA484127	16861	314	1.477178	4.63833892	Cetobacterium	180162	Bacteria	Bacteria	545	1.11e-150	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g16712	i0	98.083	12.5796178343949	313	6	99	0	1	313	1903995	1904307	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	3950	545	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
1723464	1723464	PRJNA484127_P_NODE_40302_length_228_cov_3.019355_g40153_i0	PRJNA484127	40302	228	3.019355	6.8841294	Cetobacterium somerae	188913	Bacteria	Bacteria	366	6.39e-97	NTclustered	gi\|2201062198\|gb\|CP092520.1\|	188913	g40153	i0	95.614	5	228	10	100	0	1	228	221303	221076	Cetobacterium somerae strain CS2105-BJ plasmid unnamed1, complete sequence	blastn	1140	366	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
2372768	2372768	PRJNA484127_P_NODE_13902_length_337_cov_1.772727_g13753_i0	PRJNA484127	13902	337	1.772727	5.97408999	Cetobacterium	180162	Bacteria	Bacteria	505	2.03e-138	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g13753	i0	93.75	5.68842729970326	336	21	99	0	1	336	1907051	1907386	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1917	505	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
2999477	2999477	PRJNA484127_P_NODE_39663_length_236_cov_2.196319_g39514_i0	PRJNA484127	39663	236	2.196319	5.18331284	Cetobacterium somerae	188913	Bacteria	Bacteria	335	1.8799999999999996e-87	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g39514	i0	92.34	5.98728813559322	235	18	99	0	2	236	1903750	1903984	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1413	335	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
4925395	4925395	PRJNA484127_P_NODE_1124_length_979_cov_7.226269_g1015_i0	PRJNA484127	1124	979	7.226269	70.74517351	Cetobacterium	180162	Bacteria	Bacteria	826	0	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g1015	i0	82.209	5.29622063329928	978	156	99	17	13	979	370266	371236	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	5185	826	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
5551904	5551904	PRJNA484127_P_NODE_12345_length_353_cov_1.110714_g12196_i0	PRJNA484127	12345	353	1.110714	3.92082042	Cetobacterium somerae	188913	Bacteria	Bacteria	320	8.29e-83	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g12196	i0	83.051	5.01416430594901	354	58	100	2	1	353	1714122	1713770	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	1770	320	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
5552378	5552378	PRJNA484127_P_NODE_5525_length_487_cov_2.335749_g5377_i0	PRJNA484127	5525	487	2.335749	11.37509763	Cetobacterium somerae	188913	Bacteria	Bacteria	604	2.909999999999999e-168	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g5377	i0	89.117	4.85626283367557	487	51	99	2	2	487	1722906	1723391	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	2365	604	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6825922	6825922	PRJNA484127_P_NODE_16406_length_317_cov_1.856557_g16257_i0	PRJNA484127	16406	317	1.856557	5.88528569	Cetobacterium somerae	188913	Bacteria	Bacteria	436	7.019999999999999e-118	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g16257	i0	91.536	5.00630914826498	319	23	100	3	1	317	1722650	1722966	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1587	436	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7475287	7475287	PRJNA484127_P_NODE_18406_length_304_cov_1.913420_g18257_i0	PRJNA484127	18406	304	1.91342	5.8167968	Cetobacterium	180162	Bacteria	Bacteria	518	2.32e-142	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g18257	i0	97.368	7.76315789473684	304	8	100	0	1	304	899209	898906	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	2360	518	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8750231	8750231	PRJNA484127_P_NODE_13487_length_341_cov_1.746269_g13338_i0	PRJNA484127	13487	341	1.746269	5.95477729	Cetobacterium	180162	Bacteria	Bacteria	459	1.6199999999999999e-124	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g13338	i0	91.15	76.4545454545455	339	29	99	1	3	341	272035	271698	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	26071	459	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8750280	8750280	PRJNA484127_P_NODE_35567_length_246_cov_0.901734_g35418_i0	PRJNA484127	35567	246	0.901734	2.21826564	Cetobacterium	180162	Bacteria	Bacteria	315	2.57e-81	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g35418	i0	89.796	90.4959349593496	245	25	99	0	1	245	214856	215100	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	22262	315	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
9376571	9376571	PRJNA484127_P_NODE_5148_length_502_cov_3.002331_g5001_i0	PRJNA484127	5148	502	3.002331	15.07170162	Cetobacterium somerae	188913	Bacteria	Bacteria	531	5.17e-146	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g5001	i0	85.913	30.7609561752988	504	63	99	7	3	502	1510913	1510414	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	15442	531	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
10025581	10025581	PRJNA484127_P_NODE_21248_length_288_cov_1.451163_g21099_i0	PRJNA484127	21248	288	1.451163	4.17934944	Cetobacterium	180162	Bacteria	Bacteria	364	3.0099999999999993e-96	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g21099	i0	89.789	18.7430555555556	284	29	99	0	3	286	855365	855648	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	5398	364	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
10652492	10652492	PRJNA484127_P_NODE_5509_length_488_cov_1.503614_g5361_i0	PRJNA484127	5509	488	1.503614	7.33763632	Cetobacterium somerae	188913	Bacteria	Bacteria	579	1.77e-160	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g5361	i0	88.115	5	488	56	99	2	1	487	167947	167461	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	2440	579	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11927178	11927178	PRJNA484127_P_NODE_26710_length_263_cov_2.373684_g26561_i0	PRJNA484127	26710	263	2.373684	6.24278892	Cetobacterium somerae	188913	Bacteria	Bacteria	453	5.63e-123	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g26561	i0	97.719	6	263	6	100	0	1	263	1612579	1612317	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1578	453	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11927324	11927324	PRJNA484127_P_NODE_35350_length_246_cov_0.901734_g35201_i0	PRJNA484127	35350	246	0.901734	2.21826564	Cetobacterium somerae	188913	Bacteria	Bacteria	372	1.5e-98	NTclustered	gi\|2201062198\|gb\|CP092520.1\|	188913	g35201	i0	95.671	4.90650406504065	231	10	94	0	2	232	225395	225165	Cetobacterium somerae strain CS2105-BJ plasmid unnamed1, complete sequence	blastn	1207	372	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11927472	11927472	PRJNA484127_P_NODE_7190_length_436_cov_1.966942_g7042_i0	PRJNA484127	7190	436	1.966942	8.57586712	Cetobacterium somerae	188913	Bacteria	Bacteria	457	7.64e-124	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g7042	i0	85.584	3.00688073394495	437	61	99	2	1	435	1373794	1373358	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	1311	457	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
13202372	13202372	PRJNA484127_P_NODE_39291_length_240_cov_2.802395_g39142_i0	PRJNA484127	39291	240	2.802395	6.725748	uncultured Ilyobacter sp.	544433	Bacteria	Bacteria	337	5.32e-88	NTclustered	gi\|2814788377\|emb\|OY764057.2\|	544433	g39142	i0	92.405	187.6125	237	16	98	2	4	239	1725969	1725734	MAG: uncultured Ilyobacter sp. isolate b6197fd5-c757-4c76-928f-f28f0df2880b genome assembly, chromosome: 1	blastn	45027	337	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Ilyobacter	uncultured Ilyobacter sp.
13850904	13850904	PRJNA484127_P_NODE_18731_length_302_cov_1.956332_g18582_i0	PRJNA484127	18731	302	1.956332	5.90812264	Cetobacterium	180162	Bacteria	Bacteria	514	2.98e-141	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g18582	i0	97.351	13.2384105960265	302	8	100	0	1	302	1902442	1902141	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	3998	514	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16399858	16399858	PRJNA484127_P_NODE_24613_length_272_cov_1.567839_g24464_i0	PRJNA484127	24613	272	1.567839	4.26452208	Cetobacterium	180162	Bacteria	Bacteria	337	6.15e-88	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g24464	i0	89.219	4.74632352941176	269	29	99	0	1	269	1690649	1690917	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1291	337	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16399872	16399872	PRJNA484127_P_NODE_31253_length_251_cov_0.876404_g31104_i0	PRJNA484127	31253	251	0.876404	2.19977404	Cetobacterium	180162	Bacteria	Bacteria	220	5.89e-53	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g31104	i0	82.47	7.800796812749	251	44	100	0	1	251	2036741	2036991	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1958	220	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16399890	16399890	PRJNA484127_P_NODE_37453_length_243_cov_2.270588_g37304_i0	PRJNA484127	37453	243	2.270588	5.51752884	Cetobacterium	180162	Bacteria	Bacteria	407	4.06e-109	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g37304	i0	97.095	23.641975308642	241	7	99	0	1	241	1905862	1905622	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	5745	407	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16399904	16399904	PRJNA484127_P_NODE_6373_length_459_cov_1.616580_g6225_i0	PRJNA484127	6373	459	1.61658	7.4201022	Cetobacterium	180162	Bacteria	Bacteria	712	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g6225	i0	94.771	77.7821350762527	459	21	99	3	3	459	15847	16304	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	35702	712	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
17026117	17026117	PRJNA484127_P_NODE_874_length_1076_cov_5.883350_g784_i0	PRJNA484127	874	1076	5.88335	63.304846	Cetobacterium somerae	188913	Bacteria	Bacteria	1066	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g784	i0	84.722	5.81133828996283	1080	149	99	16	4	1075	1357300	1358371	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	6253	1066	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
17674905	17674905	PRJNA484127_P_NODE_20394_length_292_cov_2.579909_g20245_i0	PRJNA484127	20394	292	2.579909	7.53333428	Cetobacterium	180162	Bacteria	Bacteria	459	1.36e-124	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g20245	i0	95.205	9.33219178082192	292	11	99	3	1	291	1956127	1955838	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	2725	459	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
19574286	19574286	PRJNA484127_P_NODE_24896_length_271_cov_1.373737_g24747_i0	PRJNA484127	24896	271	1.373737	3.72282727	Cetobacterium somerae	188913	Bacteria	Bacteria	337	6.129999999999998e-88	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g24747	i0	89.219	1.98523985239852	269	29	99	0	1	269	746378	746646	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	538	337	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20223651	20223651	PRJNA484127_P_NODE_28356_length_257_cov_2.081522_g28207_i0	PRJNA484127	28356	257	2.081522	5.34951154	Cetobacterium	180162	Bacteria	Bacteria	344	3.44e-90	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g28207	i0	90.98	3.93385214007782	255	23	99	0	3	257	168181	168435	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1011	344	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
21499169	21499169	PRJNA484127_P_NODE_6677_length_450_cov_1.944297_g6529_i0	PRJNA484127	6677	450	1.944297	8.7493365	Cetobacterium	180162	Bacteria	Bacteria	754	0	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g6529	i0	96.889	99.9533333333333	450	14	100	0	1	450	1740789	1741238	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	44979	754	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22774316	22774316	PRJNA484127_P_NODE_6318_length_461_cov_2.211340_g6170_i0	PRJNA484127	6318	461	2.21134	10.1942774	Cetobacterium	180162	Bacteria	Bacteria	649	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g6170	i0	92.191	134.457700650759	461	33	100	1	1	461	1899327	1898870	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	61985	649	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24049184	24049184	PRJNA484127_P_NODE_24679_length_272_cov_1.447236_g24530_i0	PRJNA484127	24679	272	1.447236	3.93648192	Cetobacterium	180162	Bacteria	Bacteria	311	3.73e-80	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g24530	i0	87.732	4.98897058823529	269	30	99	2	1	269	1164501	1164236	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1357	311	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24049210	24049210	PRJNA484127_P_NODE_33439_length_248_cov_1.257143_g33290_i0	PRJNA484127	33439	248	1.257143	3.11771464	Cetobacterium	180162	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g33290	i0	99.597	5	248	1	100	0	1	248	1901443	1901690	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1240	453	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
24049236	24049236	PRJNA484127_P_NODE_9839_length_385_cov_3.125000_g9690_i0	PRJNA484127	9839	385	3.125	12.03125	Cetobacterium	180162	Bacteria	Bacteria	673	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g9690	i0	98.182	37.5402597402597	385	7	100	0	1	385	1906435	1906819	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	14453	673	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25323598	25323598	PRJNA484127_P_NODE_9260_length_394_cov_2.292835_g9111_i0	PRJNA484127	9260	394	2.292835	9.0337699	Fusobacterium	848	Bacteria	Bacteria	259	2.07e-64	NTclustered	gi\|2573686249\|gb\|CP133474.1\|	851	g9111	i0	80.286	14.5761421319797	350	63	88	6	14	360	2005903	2005557	Fusobacterium nucleatum strain LMG 13131 chromosome, complete genome	blastn	5743	259	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum

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