metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA315399" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA315399" and tax_phylum = "Verrucomicrobiota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
381674	381674	PRJNA315399_P_NODE_175661_length_186_cov_8.187919_g175213_i0	PRJNA315399	175661	186	8.187919	15.22952934	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	65.8	2.04e-6	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g175213	i0	91.489	0.704301075268817	47	4	25	0	38	84	5649057	5649103	Luteolibacter sp. Populi chromosome, complete genome	blastn	131	65.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
381680	381680	PRJNA315399_P_NODE_176901_length_186_cov_6.718121_g176453_i0	PRJNA315399	176901	186	6.718121	12.49570506	Congregicoccus parvus	3081749	Bacteria	Bacteria	71.3	4.39e-8	NTclustered	gi\|2599616993\|dbj\|AP028972.1\|	3081749	g176453	i0	92	0.268817204301075	50	4	27	0	112	161	2346903	2346854	Opitutales bacterium ASA1 DNA, complete genome	blastn	50	71.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Alterococcaceae	Congregicoccus	Congregicoccus parvus
382301	382301	PRJNA315399_P_NODE_281701_length_179_cov_16.852113_g281253_i0	PRJNA315399	281701	179	16.852113	30.16528227	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	71.3	4.19e-8	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g281253	i0	97.561	0.402234636871508	41	1	23	0	26	66	746141	746181	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	72	71.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
383819	383819	PRJNA315399_P_NODE_63301_length_223_cov_10.268817_g62853_i0	PRJNA315399	63301	223	10.268817	22.89946191	Akkermansia muciniphila	239935	Bacteria	Bacteria	230	8.52e-56	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g62853	i0	100	83.7399103139013	124	0	86	0	87	210	1113479	1113602	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	18674	230	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
1656572	1656572	PRJNA315399_P_NODE_194682_length_185_cov_4.358108_g194234_i0	PRJNA315399	194682	185	4.358108	8.0624998	Opitutales bacterium	2026772	Bacteria	Bacteria	62.1	2.62e-5	NTclustered	gi\|2626245913\|emb\|OY829953.1\|	2026772	g194234	i0	93.023	273.767567567568	43	2	23	1	17	59	4282973	4283014	MAG: Opitutales bacterium isolate cf0dc631-26ae-4be7-9546-4b6096dd6533 genome assembly, chromosome: 1	blastn	50647	62.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
1656720	1656720	PRJNA315399_P_NODE_219142_length_183_cov_13.856164_g218694_i0	PRJNA315399	219142	183	13.856164	25.35678012	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g218694	i0	100	0.153005464480874	28	0	15	0	136	163	2701015	2701042	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2341265	2341265	PRJNA315399_P_NODE_37962_length_255_cov_18.197248_g37515_i0	PRJNA315399	37962	255	18.197248	46.4029824	Akkermansia	239934	Bacteria	Bacteria	135	2.24e-27	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g37515	i0	98.684	70.2980392156863	76	1	75	0	162	237	2931449	2931524	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	17926	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
3617691	3617691	PRJNA315399_S_NODE_72443_length_194_cov_4.611465_g72242_i0	PRJNA315399	72443	194	4.611465	8.9462421	Verrucomicrobiales	48461	Bacteria	Bacteria	257	3.31e-64	NTclustered	gi\|1774728408\|gb\|MN684281.1\|	2736	g72242	i0	97.351	77.7731958762887	151	4	78	0	41	191	839	689	Verrucomicrobium spinosum strain MT_SG_E_24_27F.27F 16S ribosomal RNA gene, partial sequence	blastn	15088	259	0.992277992277992	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium spinosum
5486479	5486479	PRJNA315399_P_NODE_380885_length_164_cov_2.330709_g380437_i0	PRJNA315399	380885	164	2.330709	3.82236276	Akkermansia muciniphila	239935	Bacteria	Bacteria	235	1.27e-57	NTclustered	gi\|2051360498\|gb\|CP072032.1\|	239935	g380437	i0	98.507	4.90243902439024	134	0	82	1	15	148	1568044	1568175	Akkermansia muciniphila strain Akk1613 chromosome, complete genome	blastn	804	235	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
6762922	6762922	PRJNA315399_S_NODE_43446_length_223_cov_4.489247_g43245_i0	PRJNA315399	43446	223	4.489247	10.01102081	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	270	5.02e-68	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g43245	i0	92.188	127.322869955157	192	13	86	2	11	201	3833035	3833225	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	28393	270	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10585761	10585761	PRJNA315399_P_NODE_219009_length_183_cov_15.075342_g218561_i0	PRJNA315399	219009	183	15.075342	27.58787586	Akkermansia muciniphila	239935	Bacteria	Bacteria	230	6.71e-56	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g218561	i0	88.75	77.8142076502732	160	18	87	0	10	169	1070244	1070085	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	14240	230	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
10588117	10588117	PRJNA315399_S_NODE_125029_length_168_cov_6.366412_g124828_i0	PRJNA315399	125029	168	6.366412	10.69557216	Chthoniobacter flavus	191863	Bacteria	Bacteria	217	4.73e-52	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g124828	i0	91.667	15.0654761904762	156	13	93	0	1	156	1018	863	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	2531	217	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
11268932	11268932	PRJNA315399_P_NODE_256209_length_181_cov_4.930556_g255761_i0	PRJNA315399	256209	181	4.930556	8.92430636	root	1	Root_unresolved	Root_unresolved	117	5.38e-22	NTclustered	gi\|2566450153\|gb\|CP114596.1\|	239935	g255761	i0	94.667	13.2541436464088	75	4	77	0	100	174	2542451	2542377	Akkermansia muciniphila strain MmAkk2 chromosome, complete genome	blastn	2399	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
15685523	15685523	PRJNA315399_P_NODE_375613_length_164_cov_8.929134_g375165_i0	PRJNA315399	375613	164	8.929134	14.64377976	Akkermansia muciniphila	239935	Bacteria	Bacteria	237	3.52e-58	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g375165	i0	95.973	45.4268292682927	149	0	87	1	15	157	1364467	1364319	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	7450	237	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
18234071	18234071	PRJNA315399_P_NODE_307015_length_178_cov_4.581560_g306567_i0	PRJNA315399	307015	178	4.58156	8.1551768	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g306567	i0	96.97	0.185393258426966	33	0	18	1	142	173	2565724	2565756	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	33	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18237263	18237263	PRJNA315399_S_NODE_77795_length_190_cov_16.607843_g77594_i0	PRJNA315399	77795	190	16.607843	31.5549017	Horticoccus luteus	2862869	Bacteria	Bacteria	91.6	3.46e-14	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g77594	i0	85.882	0.447368421052632	85	12	45	0	82	166	2843267	2843351	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	85	91.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
19508282	19508282	PRJNA315399_P_NODE_283796_length_179_cov_7.852113_g283348_i0	PRJNA315399	283796	179	7.852113	14.05528227	Akkermansia muciniphila	239935	Bacteria	Bacteria	139	1.13e-28	NTclustered	gi\|1554497555\|gb\|CP025833.1\|	239935	g283348	i0	100	20.268156424581	75	0	78	0	4	78	2216018	2215944	Akkermansia muciniphila strain EB-AMDK-18 chromosome, complete genome	blastn	3628	139	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
20785016	20785016	PRJNA315399_P_NODE_490157_length_152_cov_3.417391_g489709_i0	PRJNA315399	490157	152	3.417391	5.19443432	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	148	1.54e-31	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g489709	i0	86.131	0.901315789473684	137	19	90	0	11	147	3469664	3469800	Luteolibacter sp. SL250 chromosome	blastn	137	148	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
20787113	20787113	PRJNA315399_S_NODE_73957_length_193_cov_4.237179_g73756_i0	PRJNA315399	73957	193	4.237179	8.17775547	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	303	4.16e-78	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g73756	i0	96.703	49.9170984455959	182	6	94	0	12	193	2556188	2556369	Lacunisphaera limnophila strain IG16b, complete genome	blastn	9634	303	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
20787139	20787139	PRJNA315399_S_NODE_76117_length_192_cov_1.529032_g75916_i0	PRJNA315399	76117	192	1.529032	2.93574144	Luteolibacter sp. AS25	3135776	Bacteria	Bacteria	255	1.17e-63	NTclustered	gi\|2889346039\|gb\|CP151837.1\|	3135776	g75916	i0	90.625	41.5520833333333	192	18	100	0	1	192	454596	454787	Luteolibacter sp. AS25 chromosome, complete genome	blastn	7978	255	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. AS25
20787262	20787262	PRJNA315399_S_NODE_87197_length_185_cov_2.905405_g86996_i0	PRJNA315399	87197	185	2.905405	5.37499925	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	204	4.119999999999999e-48	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g86996	i0	89.506	8.25405405405405	162	16	88	1	10	171	440249	440089	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	1527	204	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
22059886	22059886	PRJNA315399_P_NODE_464178_length_154_cov_12.350427_g463730_i0	PRJNA315399	464178	154	12.350427	19.01965758	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	67.6	4.51e-7	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g463730	i0	93.478	0.298701298701299	46	2	29	1	42	86	111340	111295	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	46	67.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
23333706	23333706	PRJNA315399_P_NODE_185359_length_186_cov_2.489933_g184911_i0	PRJNA315399	185359	186	2.489933	4.63127538	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	143	9.17e-30	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g184911	i0	78.495	34.5645161290323	186	35	97	2	6	186	3078255	3078440	Luteolibacter sp. LG18 DNA, complete genome	blastn	6429	143	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
23333756	23333756	PRJNA315399_P_NODE_191339_length_185_cov_6.398649_g190891_i0	PRJNA315399	191339	185	6.398649	11.83750065	Akkermansia muciniphila	239935	Bacteria	Bacteria	174	3.23e-39	NTclustered	gi\|1805906055\|gb\|CP027004.1\|	239935	g190891	i0	86.145	230.016216216216	166	6	90	2	8	173	377938	378086	Akkermansia muciniphila strain EB-AMDK-28 chromosome, complete genome	blastn	42553	174	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
23337143	23337143	PRJNA315399_S_NODE_35739_length_236_cov_2.281407_g35538_i0	PRJNA315399	35739	236	2.281407	5.38412052	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	303	5.29e-78	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g35538	i0	92.823	227.940677966102	209	15	89	0	1	209	3413520	3413728	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	53794	303	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium

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