metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA799842" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA799842" 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
2069301	2069301	PRJNA799842_P_NODE_143502_length_250_cov_0.870056_g141929_i0	PRJNA799842	143502	250	0.870056	2.17514	Akkermansia muciniphila	239935	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g141929	i0	100	49.808	250	0	100	0	1	250	2150925	2151174	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	12452	462	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
3346928	3346928	PRJNA799842_P_NODE_90183_length_305_cov_1.646552_g88610_i0	PRJNA799842	90183	305	1.646552	5.0219836	Luteolibacter luteus	2728835	Bacteria	Bacteria	134	9.87e-27	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g88610	i0	88.288	22.6459016393443	111	13	36	0	68	178	3805015	3804905	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	6907	134	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
4621983	4621983	PRJNA799842_P_NODE_148804_length_249_cov_0.875000_g147231_i0	PRJNA799842	148804	249	0.875	2.17875	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	422	1.49e-113	NTclustered	gi\|226525317\|gb\|FJ872374.1\|	156588	g147231	i0	97.571	254.421686746988	247	5	99	1	3	249	3670	3915	Uncultured Verrucomicrobia bacterium clone 184 genomic sequence	blastn	63351	422	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
5047337	5047337	PRJNA799842_P_NODE_30724_length_524_cov_1.365854_g29162_i0	PRJNA799842	30724	524	1.365854	7.15707496	Bacteria	2	Bacteria	Bacteria	520	1.17e-142	NTclustered	gi\|2518556548\|emb\|OX638380.1\|	412056	g29162	i0	87.202	257.81679389313	461	54	87	4	68	524	3919226	3919685	MAG: uncultured Verrucomicrobiae bacterium isolate efd5e50e-5b6a-4a0f-a0a2-e496bae301b3 genome assembly, chromosome: 1	blastn	135096	520	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
5896816	5896816	PRJNA799842_P_NODE_12765_length_874_cov_2.820225_g11478_i0	PRJNA799842	12765	874	2.820225	24.6487665	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	1044	0	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g11478	i0	88.356	238.844393592677	876	92	100	9	1	874	16245	15378	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	208750	1044	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
5897553	5897553	PRJNA799842_P_NODE_169185_length_245_cov_0.895349_g167612_i0	PRJNA799842	169185	245	0.895349	2.19360505	Akkermansia muciniphila	239935	Bacteria	Bacteria	436	5.229999999999999e-118	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g167612	i0	98.776	484.738775510204	245	3	100	0	1	245	516117	516361	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	118761	436	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
5897710	5897710	PRJNA799842_P_NODE_177905_length_243_cov_0.905882_g176332_i0	PRJNA799842	177905	243	0.905882	2.20129326	Fontisphaera persica	2974023	Bacteria	Bacteria	117	7.6600000000000005e-22	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g176332	i0	92.593	13.7119341563786	81	6	33	0	58	138	3997591	3997671	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	3332	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
5897737	5897737	PRJNA799842_P_NODE_179405_length_243_cov_0.905882_g177832_i0	PRJNA799842	179405	243	0.905882	2.20129326	Akkermansia muciniphila	239935	Bacteria	Bacteria	363	8.909999999999999e-96	NTclustered	gi\|2051353120\|gb\|CP072035.1\|	239935	g177832	i0	95.964	17.7818930041152	223	9	100	0	21	243	2451698	2451920	Akkermansia muciniphila strain Akk1576 chromosome, complete genome	blastn	4321	363	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
7171604	7171604	PRJNA799842_P_NODE_132346_length_253_cov_1.711111_g130773_i0	PRJNA799842	132346	253	1.711111	4.32911083	Pedosphaera parvula	1032527	Bacteria	Bacteria	217	7.689999999999999e-52	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g130773	i0	82.422	113.624505928854	256	38	100	6	1	253	1440	1691	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	28747	217	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
7597197	7597197	PRJNA799842_P_NODE_191606_length_226_cov_2.013072_g190033_i0	PRJNA799842	191606	226	2.013072	4.54954272	Bacteria	2	Bacteria	Bacteria	86.1	1.98e-12	NTclustered	gi\|1966854496\|gb\|CP068475.1\|	1903058	g190033	i0	100	58.6991150442478	46	0	20	0	181	226	913680	913635	MAG: Candidatus Xiphinematobacter sp. isolate P21 chromosome, complete genome	blastn	13266	86.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria			Candidatus Xiphinematobacter	Candidatus Xiphinematobacter sp.
8445807	8445807	PRJNA799842_P_NODE_103887_length_286_cov_1.319249_g102314_i0	PRJNA799842	103887	286	1.319249	3.77305214	Haloferula helveola	490095	Bacteria	Bacteria	351	2.33e-92	NTclustered	gi\|2647781590\|dbj\|AP024702.1\|	490095	g102314	i0	88.85	93.3076923076923	287	30	100	2	1	286	775872	775587	Haloferula helveola CN-1 DNA, complete genome	blastn	26686	351	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula helveola
8446778	8446778	PRJNA799842_P_NODE_156107_length_247_cov_0.885057_g154534_i0	PRJNA799842	156107	247	0.885057	2.18609079	Akkermansia muciniphila	239935	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|1805910811\|gb\|CP027006.1\|	239935	g154534	i0	99.595	16	247	1	100	0	1	247	2299218	2298972	Akkermansia muciniphila strain EB-AMDK-30 chromosome, complete genome	blastn	3952	451	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
9723085	9723085	PRJNA799842_P_NODE_45428_length_422_cov_1.504298_g43855_i0	PRJNA799842	45428	422	1.504298	6.34813756	Pedosphaera parvula	1032527	Bacteria	Bacteria	473	7.319999999999999e-129	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g43855	i0	86.967	76.4241706161137	422	53	99	2	2	422	885	1305	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	32251	473	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
9723506	9723506	PRJNA799842_P_NODE_6628_length_1208_cov_2.112775_g5746_i0	PRJNA799842	6628	1208	2.112775	25.522322	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1869	0	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g5746	i0	94.628	109.738410596026	1210	59	100	5	1	1208	5153573	5152368	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	132564	1869	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
11422928	11422928	PRJNA799842_P_NODE_188829_length_241_cov_0.916667_g187256_i0	PRJNA799842	188829	241	0.916667	2.20916747	Akkermansia	239934	Bacteria	Bacteria	435	1.84e-117	NTclustered	gi\|2289586829\|dbj\|AP025943.1\|	2946555	g187256	i0	99.17	8.03319502074689	241	2	100	0	1	241	2600396	2600636	Akkermansia biwaensis WON2089 DNA, complete genome	blastn	1936	435	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia biwaensis
12275414	12275414	PRJNA799842_P_NODE_92850_length_301_cov_1.320175_g91277_i0	PRJNA799842	92850	301	1.320175	3.97372675	Akkermansia muciniphila	239935	Bacteria	Bacteria	545	1.0499999999999999e-150	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g91277	i0	99.336	95.0066445182724	301	2	100	0	1	301	714311	714011	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	28597	545	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
13546969	13546969	PRJNA799842_P_NODE_136251_length_251_cov_0.865169_g134678_i0	PRJNA799842	136251	251	0.865169	2.17157419	Akkermansia muciniphila	239935	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|2566450153\|gb\|CP114596.1\|	239935	g134678	i0	99.602	94.9641434262948	251	1	100	0	1	251	182830	182580	Akkermansia muciniphila strain MmAkk2 chromosome, complete genome	blastn	23836	459	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
13972821	13972821	PRJNA799842_P_NODE_159191_length_247_cov_0.885057_g157618_i0	PRJNA799842	159191	247	0.885057	2.18609079	Akkermansia	239934	Bacteria	Bacteria	433	6.82e-117	NTclustered	gi\|2289586829\|dbj\|AP025943.1\|	2946555	g157618	i0	98.374	5.97570850202429	246	4	99	0	1	246	2669843	2669598	Akkermansia biwaensis WON2089 DNA, complete genome	blastn	1476	433	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia biwaensis
16096270	16096270	PRJNA799842_P_NODE_157753_length_247_cov_0.885057_g156180_i0	PRJNA799842	157753	247	0.885057	2.18609079	Akkermansia muciniphila	239935	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g156180	i0	100	93.0040485829959	247	0	100	0	1	247	166539	166293	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	22972	457	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
16096720	16096720	PRJNA799842_P_NODE_181453_length_242_cov_0.911243_g179880_i0	PRJNA799842	181453	242	0.911243	2.20520806	Akkermansia muciniphila	239935	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2678353551\|gb\|CP085979.1\|	239935	g179880	i0	100	94.9545454545455	242	0	100	0	1	242	1911243	1911484	Akkermansia muciniphila strain MucX chromosome, complete genome	blastn	22979	448	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
17372644	17372644	PRJNA799842_P_NODE_184174_length_242_cov_0.911243_g182601_i0	PRJNA799842	184174	242	0.911243	2.20520806	Akkermansia muciniphila	239935	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|1805906055\|gb\|CP027004.1\|	239935	g182601	i0	99.587	100	242	1	100	0	1	242	461588	461347	Akkermansia muciniphila strain EB-AMDK-28 chromosome, complete genome	blastn	24200	442	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
19921074	19921074	PRJNA799842_P_NODE_183976_length_242_cov_0.911243_g182403_i0	PRJNA799842	183976	242	0.911243	2.20520806	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	368	1.91e-97	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g182403	i0	94.191	4.31818181818182	241	14	99	0	1	241	503570	503810	Lacunisphaera limnophila strain IG16b, complete genome	blastn	1045	368	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
21195830	21195830	PRJNA799842_P_NODE_138217_length_251_cov_0.865169_g136644_i0	PRJNA799842	138217	251	0.865169	2.17157419	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	261	3.47e-65	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g136644	i0	86.25	21.2669322709163	240	33	96	0	1	240	3137949	3137710	Luteolibacter sp. SL250 chromosome	blastn	5338	261	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
21621296	21621296	PRJNA799842_P_NODE_2997_length_1650_cov_13.706405_g1411_i1	PRJNA799842	2997	1650	13.706405	226.1556825	Chthoniobacter	295577	Bacteria	Bacteria	1912	0	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g1411	i1	87.711	188.02303030303	1660	178	99	25	1	1647	27010	28656	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	310238	1912	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
22471657	22471657	PRJNA799842_P_NODE_27138_length_562_cov_11.357873_g25583_i0	PRJNA799842	27138	562	11.357873	63.83124626	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	950	0	NTclustered	gi\|389545369\|gb\|JQ400297.1\|	156588	g25583	i0	97.153	97.3113879003559	562	16	100	0	1	562	5	566	Uncultured Verrucomicrobia bacterium clone CNY_00103 16S ribosomal RNA gene, partial sequence	blastn	54689	950	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
22472303	22472303	PRJNA799842_P_NODE_56498_length_378_cov_1.160656_g54925_i0	PRJNA799842	56498	378	1.160656	4.38727968	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	638	2.17e-178	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g54925	i0	97.09	288.015873015873	378	11	100	0	1	378	4716799	4716422	Luteolibacter sp. SL250 chromosome	blastn	108870	638	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
23746189	23746189	PRJNA799842_P_NODE_139819_length_250_cov_1.180791_g138246_i0	PRJNA799842	139819	250	1.180791	2.9519775	Akkermansia muciniphila	239935	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1554476654\|gb\|CP025824.1\|	239935	g138246	i0	100	100.036	250	0	100	0	1	250	2011019	2011268	Akkermansia muciniphila strain EB-AMDK-8 chromosome, complete genome	blastn	25009	462	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
23746868	23746868	PRJNA799842_P_NODE_178319_length_243_cov_0.905882_g176746_i0	PRJNA799842	178319	243	0.905882	2.20129326	Akkermansia muciniphila	239935	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2051380060\|gb\|CP072024.1\|	239935	g176746	i0	100	100	243	0	100	0	1	243	1290337	1290579	Akkermansia muciniphila strain Akk2030 chromosome, complete genome	blastn	24300	449	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
25020785	25020785	PRJNA799842_P_NODE_184100_length_242_cov_0.911243_g182527_i0	PRJNA799842	184100	242	0.911243	2.20520806	Akkermansia muciniphila	239935	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|1554502134\|gb\|CP025835.1\|	239935	g182527	i0	99.587	45	242	1	100	0	1	242	877444	877203	Akkermansia muciniphila strain EB-AMDK-20 chromosome, complete genome	blastn	10890	442	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila

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