metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA1247234" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA1247234" and tax_clade = "delta/epsilon subdivisions"

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_clade	tax_class	tax_order	tax_family	tax_genus	tax_species
351284	351284	PRJNA1247234_P_NODE_21481_length_251_cov_0.876404_g21325_i0	PRJNA1247234	21481	251	0.876404	2.19977404	Microvenator marinus	2600177	Bacteria	Bacteria	182	2.78e-41	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g21325	i0	80.08	1	251	44	99	5	2	249	3898566	3898813	Microvenator marinus strain V1718 chromosome, complete genome	blastn	251	182	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
351347	351347	PRJNA1247234_P_NODE_25101_length_246_cov_0.901734_g24945_i0	PRJNA1247234	25101	246	0.901734	2.21826564	Microvenator marinus	2600177	Bacteria	Bacteria	366	6.99e-97	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g24945	i0	93.522	1.00406504065041	247	14	100	2	1	246	2956352	2956107	Microvenator marinus strain V1718 chromosome, complete genome	blastn	247	366	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
351359	351359	PRJNA1247234_P_NODE_25741_length_245_cov_0.906977_g25585_i0	PRJNA1247234	25741	245	0.906977	2.22209365	Microvenator marinus	2600177	Bacteria	Bacteria	359	1.16e-94	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g25585	i0	93.061	1	245	17	100	0	1	245	2901724	2901968	Microvenator marinus strain V1718 chromosome, complete genome	blastn	245	359	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
1626214	1626214	PRJNA1247234_P_NODE_25542_length_245_cov_0.906977_g25386_i0	PRJNA1247234	25542	245	0.906977	2.22209365	Microvenator marinus	2600177	Bacteria	Bacteria	420	5.26e-113	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g25386	i0	97.551	1	245	6	100	0	1	245	2303990	2303746	Microvenator marinus strain V1718 chromosome, complete genome	blastn	245	420	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
1626229	1626229	PRJNA1247234_P_NODE_26322_length_244_cov_0.912281_g26166_i0	PRJNA1247234	26322	244	0.912281	2.22596564	Microvenator marinus	2600177	Bacteria	Bacteria	353	5.389999999999998e-93	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g26166	i0	92.975	0.991803278688525	242	17	99	0	3	244	2553351	2553110	Microvenator marinus strain V1718 chromosome, complete genome	blastn	242	353	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
2902267	2902267	PRJNA1247234_P_NODE_20283_length_253_cov_0.866667_g20127_i0	PRJNA1247234	20283	253	0.866667	2.19266751	Microvenator marinus	2600177	Bacteria	Bacteria	169	2.1799999999999996e-37	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g20127	i0	81.221	0.841897233201581	213	36	83	4	1	211	3925910	3926120	Microvenator marinus strain V1718 chromosome, complete genome	blastn	213	169	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
2902298	2902298	PRJNA1247234_P_NODE_21563_length_251_cov_0.876404_g21407_i0	PRJNA1247234	21563	251	0.876404	2.19977404	Microvenator marinus	2600177	Bacteria	Bacteria	370	5.53e-98	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g21407	i0	93.227	1	251	17	100	0	1	251	2834695	2834445	Microvenator marinus strain V1718 chromosome, complete genome	blastn	251	370	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
2902350	2902350	PRJNA1247234_P_NODE_24503_length_247_cov_0.896552_g24347_i0	PRJNA1247234	24503	247	0.896552	2.21448344	Microvenator marinus	2600177	Bacteria	Bacteria	329	9.21e-86	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g24347	i0	90.688	1	247	23	100	0	1	247	816488	816734	Microvenator marinus strain V1718 chromosome, complete genome	blastn	247	329	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
5454882	5454882	PRJNA1247234_P_NODE_21885_length_251_cov_0.876404_g21729_i0	PRJNA1247234	21885	251	0.876404	2.19977404	Microvenator marinus	2600177	Bacteria	Bacteria	322	1.57e-83	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g21729	i0	89.96	0.99203187250996006	249	25	99	0	1	249	2815613	2815861	Microvenator marinus strain V1718 chromosome, complete genome	blastn	249	322	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
5455000	5455000	PRJNA1247234_P_NODE_27745_length_242_cov_0.923077_g27589_i0	PRJNA1247234	27745	242	0.923077	2.23384634	Microvenator marinus	2600177	Bacteria	Bacteria	313	9.06e-81	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g27589	i0	90.948	4.14876033057851	232	21	96	0	11	242	1879834	1879603	Microvenator marinus strain V1718 chromosome, complete genome	blastn	1004	313	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
6729192	6729192	PRJNA1247234_P_NODE_19746_length_255_cov_1.142857_g19590_i0	PRJNA1247234	19746	255	1.142857	2.91428535	Microvenator marinus	2600177	Bacteria	Bacteria	385	2.01e-102	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g19590	i0	94.422	0.984313725490196	251	13	98	1	6	255	1568742	1568492	Microvenator marinus strain V1718 chromosome, complete genome	blastn	251	385	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
8004767	8004767	PRJNA1247234_P_NODE_22507_length_250_cov_0.881356_g22351_i0	PRJNA1247234	22507	250	0.881356	2.20339	Microvenator marinus	2600177	Bacteria	Bacteria	401	1.9499999999999994e-107	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g22351	i0	95.618	1.004	251	10	100	1	1	250	2448015	2448265	Microvenator marinus strain V1718 chromosome, complete genome	blastn	251	401	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
8004821	8004821	PRJNA1247234_P_NODE_24807_length_246_cov_0.901734_g24651_i0	PRJNA1247234	24807	246	0.901734	2.21826564	Microvenator marinus	2600177	Bacteria	Bacteria	350	7.04e-92	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g24651	i0	92.276	1	246	19	100	0	1	246	1783898	1783653	Microvenator marinus strain V1718 chromosome, complete genome	blastn	246	350	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
9279618	9279618	PRJNA1247234_P_NODE_18488_length_264_cov_1.225131_g18332_i0	PRJNA1247234	18488	264	1.225131	3.23434584	Microvenator marinus	2600177	Bacteria	Bacteria	466	7.27e-127	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g18332	i0	98.485	1	264	4	100	0	1	264	4099335	4099598	Microvenator marinus strain V1718 chromosome, complete genome	blastn	264	466	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
9279724	9279724	PRJNA1247234_P_NODE_23688_length_248_cov_0.891429_g23532_i0	PRJNA1247234	23688	248	0.891429	2.21074392	Microvenator marinus	2600177	Bacteria	Bacteria	398	2.5e-106	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g23532	i0	95.565	1	248	11	100	0	1	248	2771851	2771604	Microvenator marinus strain V1718 chromosome, complete genome	blastn	248	398	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
9279778	9279778	PRJNA1247234_P_NODE_27008_length_243_cov_0.917647_g26852_i0	PRJNA1247234	27008	243	0.917647	2.22988221	Microvenator marinus	2600177	Bacteria	Bacteria	339	1.4999999999999997e-88	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g26852	i0	92.083	0.987654320987654	240	19	99	0	4	243	5768663	5768424	Microvenator marinus strain V1718 chromosome, complete genome	blastn	240	339	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
10555554	10555554	PRJNA1247234_P_NODE_22969_length_249_cov_0.886364_g22813_i0	PRJNA1247234	22969	249	0.886364	2.20704636	Microvenator marinus	2600177	Bacteria	Bacteria	411	3.2299999999999996e-110	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g22813	i0	96.386	1	249	9	100	0	1	249	1053347	1053099	Microvenator marinus strain V1718 chromosome, complete genome	blastn	249	411	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
11830167	11830167	PRJNA1247234_P_NODE_27010_length_243_cov_0.917647_g26854_i0	PRJNA1247234	27010	243	0.917647	2.22988221	Microvenator marinus	2600177	Bacteria	Bacteria	355	1.49e-93	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g26854	i0	93.004	1	243	17	100	0	1	243	1303500	1303742	Microvenator marinus strain V1718 chromosome, complete genome	blastn	243	355	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
13105304	13105304	PRJNA1247234_P_NODE_20851_length_252_cov_0.871508_g20695_i0	PRJNA1247234	20851	252	0.871508	2.19620016	Microvenator marinus	2600177	Bacteria	Bacteria	383	7.13e-102	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g20695	i0	94.048	1	252	15	100	0	1	252	3518191	3518442	Microvenator marinus strain V1718 chromosome, complete genome	blastn	252	383	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
14380628	14380628	PRJNA1247234_P_NODE_24152_length_247_cov_0.896552_g23996_i0	PRJNA1247234	24152	247	0.896552	2.21448344	Microvenator marinus	2600177	Bacteria	Bacteria	377	3.24e-100	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g23996	i0	94.309	0.995951417004049	246	14	99	0	1	246	1513963	1513718	Microvenator marinus strain V1718 chromosome, complete genome	blastn	246	377	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
16928656	16928656	PRJNA1247234_P_NODE_21634_length_251_cov_0.876404_g21478_i0	PRJNA1247234	21634	251	0.876404	2.19977404	Microvenator marinus	2600177	Bacteria	Bacteria	368	1.99e-97	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g21478	i0	93.2	0.99601593625498	250	17	99	0	2	251	1579791	1580040	Microvenator marinus strain V1718 chromosome, complete genome	blastn	250	368	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
19477459	19477459	PRJNA1247234_P_NODE_17696_length_270_cov_1.187817_g17540_i0	PRJNA1247234	17696	270	1.187817	3.2071059	Microvenator marinus	2600177	Bacteria	Bacteria	483	7.409999999999998e-132	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g17540	i0	98.889	1	270	3	100	0	1	270	4710332	4710601	Microvenator marinus strain V1718 chromosome, complete genome	blastn	270	483	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
19477531	19477531	PRJNA1247234_P_NODE_21876_length_251_cov_0.876404_g21720_i0	PRJNA1247234	21876	251	0.876404	2.19977404	Microvenator marinus	2600177	Bacteria	Bacteria	303	5.69e-78	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g21720	i0	88.492	1.00398406374502	252	27	100	2	1	251	959095	958845	Microvenator marinus strain V1718 chromosome, complete genome	blastn	252	303	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
19477687	19477687	PRJNA1247234_P_NODE_5816_length_425_cov_0.994318_g5662_i0	PRJNA1247234	5816	425	0.994318	4.2258515	Microvenator marinus	2600177	Bacteria	Bacteria	691	0	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g5662	i0	96	1	425	17	100	0	1	425	3652890	3652466	Microvenator marinus strain V1718 chromosome, complete genome	blastn	425	691	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
20752957	20752957	PRJNA1247234_P_NODE_22277_length_250_cov_0.881356_g22121_i0	PRJNA1247234	22277	250	0.881356	2.20339	Microvenator marinus	2600177	Bacteria	Bacteria	379	9.139999999999998e-101	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g22121	i0	94	1.396	250	15	100	0	1	250	571726	571975	Microvenator marinus strain V1718 chromosome, complete genome	blastn	349	379	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
20753000	20753000	PRJNA1247234_P_NODE_24777_length_246_cov_0.901734_g24621_i0	PRJNA1247234	24777	246	0.901734	2.21826564	Microvenator marinus	2600177	Bacteria	Bacteria	331	2.55e-86	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g24621	i0	91.02	0.995934959349594	245	22	99	0	2	246	2873504	2873260	Microvenator marinus strain V1718 chromosome, complete genome	blastn	245	331	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
22028210	22028210	PRJNA1247234_P_NODE_23538_length_248_cov_0.891429_g23382_i0	PRJNA1247234	23538	248	0.891429	2.21074392	Microvenator marinus	2600177	Bacteria	Bacteria	431	2.47e-116	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g23382	i0	97.984	1	248	5	100	0	1	248	3972273	3972026	Microvenator marinus strain V1718 chromosome, complete genome	blastn	248	431	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
22028302	22028302	PRJNA1247234_P_NODE_27898_length_242_cov_0.923077_g27742_i0	PRJNA1247234	27898	242	0.923077	2.23384634	Microvenator marinus	2600177	Bacteria	Bacteria	364	2.4699999999999992e-96	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g27742	i0	93.802	1	242	15	100	0	1	242	420407	420166	Microvenator marinus strain V1718 chromosome, complete genome	blastn	242	364	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
23303658	23303658	PRJNA1247234_P_NODE_13679_length_302_cov_0.882096_g13523_i0	PRJNA1247234	13679	302	0.882096	2.66392992	Microvenator marinus	2600177	Bacteria	Bacteria	399	8.719999999999998e-107	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g13523	i0	91.409	0.963576158940397	291	25	96	0	12	302	5076252	5076542	Microvenator marinus strain V1718 chromosome, complete genome	blastn	291	399	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
23303848	23303848	PRJNA1247234_P_NODE_24339_length_247_cov_0.896552_g24183_i0	PRJNA1247234	24339	247	0.896552	2.21448344	Microvenator marinus	2600177	Bacteria	Bacteria	396	8.95e-106	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g24183	i0	95.547	1	247	11	100	0	1	247	3798857	3799103	Microvenator marinus strain V1718 chromosome, complete genome	blastn	247	396	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
23303890	23303890	PRJNA1247234_P_NODE_26639_length_244_cov_0.912281_g26483_i0	PRJNA1247234	26639	244	0.912281	2.22596564	Microvenator marinus	2600177	Bacteria	Bacteria	357	4.16e-94	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g26483	i0	93.033	1	244	17	100	0	1	244	1159804	1159561	Microvenator marinus strain V1718 chromosome, complete genome	blastn	244	357	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
24577871	24577871	PRJNA1247234_P_NODE_27120_length_243_cov_0.917647_g26964_i0	PRJNA1247234	27120	243	0.917647	2.22988221	Microvenator marinus	2600177	Bacteria	Bacteria	289	1.53e-73	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g26964	i0	88.211	1.01234567901235	246	23	100	6	1	243	4726750	4726508	Microvenator marinus strain V1718 chromosome, complete genome	blastn	246	289	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus

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