metadata: contig_metadata: 23 rows where bioproject = "PRJNA437204" and tax

23 rows where bioproject = "PRJNA437204" 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
2982306	2982306	PRJNA437204_P_NODE_109603_length_245_cov_0.895349_g109304_i0	PRJNA437204	109603	245	0.895349	2.19360505	Pseudomonadati	3379134	Bacteria	Bacteria	124	2.9199999999999996e-32	NR	MDX2226733.1	2499141	g109304	i0	72.2	12.5877551020408	79	22	96.7	0	243	7	139	217	MDX2226733.1 transaldolase [Verrucomicrobiia bacterium]	diamond	3084	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
5537259	5537259	PRJNA437204_P_NODE_91725_length_249_cov_0.875000_g91426_i0	PRJNA437204	91725	249	0.875	2.17875	Fontisphaera persica	2974023	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g91426	i0	100	0.116465863453815	29	0	12	0	151	179	3684527	3684555	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
11912130	11912130	PRJNA437204_P_NODE_82630_length_251_cov_0.865169_g82331_i0	PRJNA437204	82630	251	0.865169	2.17157419	Limisphaerales bacterium	2052186	Bacteria	Bacteria	56.2	6.67e-7	NR	MCS1411974.1	2052186	g82331	i0	65.9	0.49003984063745	41	14	49	0	1	123	274	314	MCS1411974.1 hypothetical protein [Limisphaerales bacterium]	diamond	123	56.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			Limisphaerales bacterium
22766197	22766197	PRJNA437204_P_NODE_102478_length_246_cov_0.890173_g102179_i0	PRJNA437204	102478	246	0.890173	2.18982558	root	1	Root_unresolved	Root_unresolved	56.5	0.002	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g102179	i0	100	4.29674796747967	30	0	12	0	216	245	1397908	1397937	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	1057	56.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
26695914	26695914	PRJNA437204_P_NODE_108081_length_245_cov_0.895349_g107782_i0	PRJNA437204	108081	245	0.895349	2.19360505	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	67.4	7.75e-11	NR	HYG84357.1	2499141	g107782	i0	47.9	0.893877551020408	73	34	89.4	1	229	11	118	186	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	219	67.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
26712174	26712174	PRJNA437204_P_NODE_128561_length_241_cov_0.916667_g128262_i0	PRJNA437204	128561	241	0.916667	2.20916747	Bacteria	2	Bacteria	Bacteria	70.5	3.06e-12	NR	WP_200349393.1	1144680	g128262	i0	62.7	3.11203319502075	51	19	63.5	0	86	238	29	79	WP_200349393.1 copper homeostasis protein CutC [Luteolibacter yonseiensis]	diamond	750	70.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter yonseiensis
26934061	26934061	PRJNA437204_P_NODE_81842_length_251_cov_0.865169_g81543_i0	PRJNA437204	81842	251	0.865169	2.17157419	Verrucomicrobiota	74201	Bacteria	Bacteria	111	9.949999999999999e-28	NR	MCA1660162.1	2026800	g81543	i0	66.3	2.97609561752988	83	28	99.2	0	2	250	51	133	MCA1660162.1 hypothetical protein [Verrucomicrobiaceae bacterium]	diamond	747	112	0.991071428571429	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
27377037	27377037	PRJNA437204_P_NODE_47483_length_306_cov_1.321888_g47184_i0	PRJNA437204	47483	306	1.321888	4.04497728	PVC group	1783257	Bacteria	Bacteria	79.7	2.3e-16	NR	HWA27176.1	1961806	g47184	i0	51.3	5.83333333333333	76	37	74.5	0	305	78	76	151	HWA27176.1 Hsp20/alpha crystallin family protein [Lacunisphaera sp.]	diamond	1785	79.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
27423774	27423774	PRJNA437204_P_NODE_116423_length_243_cov_0.905882_g116124_i0	PRJNA437204	116423	243	0.905882	2.20129326	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	100	1.19e-22	NR	HYG84357.1	2499141	g116124	i0	68.7	0.827160493827161	67	21	82.7	0	3	203	197	263	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	201	100	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27455296	27455296	PRJNA437204_P_NODE_25823_length_375_cov_1.529801_g25524_i0	PRJNA437204	25823	375	1.529801	5.73675375	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	44.7	0.0332	NR	MFM9090619.1	2026799	g25524	i0	52.2	0.536	67	30	52.8	2	242	45	490	555	MFM9090619.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	201	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28008425	28008425	PRJNA437204_P_NODE_60405_length_280_cov_1.487923_g60106_i0	PRJNA437204	60405	280	1.487923	4.1661844	Bacteria	2	Bacteria	Bacteria	60.1	4.59e-8	NR	MFN7139350.1	2052186	g60106	i0	47.1	4.81071428571429	70	36	73.9	1	74	280	17	86	MFN7139350.1 glycine dehydrogenase (aminomethyl-transferring) [Limisphaerales bacterium]	diamond	1347	60.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			Limisphaerales bacterium
29097051	29097051	PRJNA437204_P_NODE_123608_length_242_cov_0.911243_g123309_i0	PRJNA437204	123608	242	0.911243	2.20520806	Chthoniobacter sp.	2510640	Bacteria	Bacteria	45.8	0.00309	NR	MDR3402202.1	2510640	g123309	i0	65.5	0.359504132231405	29	10	36	0	233	147	124	152	MDR3402202.1 autotransporter domain-containing protein [Chthoniobacter sp.]	diamond	87	45.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
29444019	29444019	PRJNA437204_P_NODE_116690_length_243_cov_0.905882_g116391_i0	PRJNA437204	116690	243	0.905882	2.20129326	Opitutia bacterium	2026771	Bacteria	Bacteria	82.4	2.81e-18	NR	HAZ65878.1	2026771	g116391	i0	47.9	1.76543209876543	73	38	90.1	0	18	236	2	74	HAZ65878.1 divalent-cation tolerance protein CutA [Opitutia bacterium]	diamond	429	82.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
29618167	29618167	PRJNA437204_P_NODE_49650_length_301_cov_1.350877_g49351_i0	PRJNA437204	49650	301	1.350877	4.06613977	Pseudomonadati	3379134	Bacteria	Bacteria	107	3.21e-25	NR	MAS93032.1	2026801	g49351	i0	53.1	5.86046511627907	98	44	97.7	2	7	300	177	272	MAS93032.1 hydroxyacid dehydrogenase [Verrucomicrobiales bacterium]	diamond	1764	108	0.990740740740741	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
30329172	30329172	PRJNA437204_P_NODE_123332_length_242_cov_0.911243_g123033_i0	PRJNA437204	123332	242	0.911243	2.20520806	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	63.9	7.49e-10	NR	HUF62473.1	2026801	g123033	i0	48.1	2.6900826446281	52	25	64.5	1	157	2	22	71	HUF62473.1 thioredoxin [Verrucomicrobiales bacterium]	diamond	651	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
30345569	30345569	PRJNA437204_P_NODE_116432_length_243_cov_0.905882_g116133_i0	PRJNA437204	116432	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	73.9	8.48e-14	NR	MBD99721.1	2026799	g116133	i0	46.4	3.44444444444444	69	36	84	1	205	2	2	70	MBD99721.1 succinyl-CoA--3-ketoacid-CoA transferase [Verrucomicrobiota bacterium]	diamond	837	73.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30518194	30518194	PRJNA437204_P_NODE_119473_length_243_cov_0.905882_g119174_i0	PRJNA437204	119473	243	0.905882	2.20129326	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	80.5	1.87e-15	NR	MEO6846840.1	2201154	g119174	i0	49.4	1.04938271604938	85	38	98.8	1	241	2	327	411	MEO6846840.1 right-handed parallel beta-helix repeat-containing protein [Chthoniobacterales bacterium]	diamond	255	80.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
30612840	30612840	PRJNA437204_P_NODE_105433_length_246_cov_0.890173_g105134_i0	PRJNA437204	105433	246	0.890173	2.18982558	Candidatus Didemnitutus sp.	2814259	Bacteria	Bacteria	150	1.47e-40	NR	MCM2274947.1	2814259	g105134	i0	88.9	0.98780487804878	81	9	98.8	0	245	3	150	230	MCM2274947.1 HlyD family efflux transporter periplasmic adaptor subunit [Candidatus Didemnitutus sp.]	diamond	243	150	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Candidatus Didemnitutus	Candidatus Didemnitutus sp.
31244920	31244920	PRJNA437204_P_NODE_81135_length_251_cov_0.865169_g80836_i0	PRJNA437204	81135	251	0.865169	2.17157419	Opitutales bacterium ASA1	3081749	Bacteria	Bacteria	44.3	0.0116	NR	BET66732.1	3081749	g80836	i0	34.4	0.729083665338645	61	40	72.9	0	216	34	128	188	BET66732.1 amidase [Opitutales bacterium ASA1]	diamond	183	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Alterococcaceae	Congregicoccus	Congregicoccus parvus
31388048	31388048	PRJNA437204_P_NODE_69616_length_265_cov_2.302083_g69317_i0	PRJNA437204	69616	265	2.302083	6.10051995	Pseudomonadati	3379134	Bacteria	Bacteria	48.5	4.35e-4	NR	HAL03630.1	2026801	g69317	i0	58.7	2.60377358490566	46	19	52.1	0	252	115	129	174	HAL03630.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	690	48.9	0.991820040899796	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31419444	31419444	PRJNA437204_P_NODE_129296_length_239_cov_2.030120_g128997_i0	PRJNA437204	129296	239	2.03012	4.8519868	Bacteria	2	Bacteria	Bacteria	54.7	1.86e-7	NR	HZT22930.1	2499141	g128997	i0	55.1	5.97489539748954	49	22	61.5	0	3	149	45	93	HZT22930.1 RNA-binding protein [Verrucomicrobiia bacterium]	diamond	1428	55.1	0.992740471869329	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32210417	32210417	PRJNA437204_P_NODE_82898_length_251_cov_0.865169_g82599_i0	PRJNA437204	82898	251	0.865169	2.17157419	Bacteria	2	Bacteria	Bacteria	144	4.2399999999999996e-42	NR	HYT56961.1	2499141	g82599	i0	88.8	1.94820717131474	80	9	95.6	0	12	251	1	80	HYT56961.1 RidA family protein [Verrucomicrobiia bacterium]	diamond	489	144	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32856944	32856944	PRJNA437204_P_NODE_120320_length_242_cov_1.366864_g120021_i0	PRJNA437204	120320	242	1.366864	3.30781088	Chthoniobacter sp.	2510640	Bacteria	Bacteria	147	5.1e-40	NR	MDR3405335.1	2510640	g120021	i0	86.3	1.98347107438017	80	11	99.2	0	240	1	290	369	MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.]	diamond	480	147	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.

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