metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJDB4941" and tax

17 rows where analysis = "blastn", bioproject = "PRJDB4941" and tax_clade = "PVC group"

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
1284793	1284793	PRJDB4941_P_NODE_36382_length_167_cov_0.881356_g35614_i0	PRJDB4941	36382	167	0.881356	1.47186452	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	106	1.06e-18	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g35614	i0	81.538	32.3592814371258	130	22	77	2	31	159	3991538	3991666	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	5404	106	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
2256755	2256755	PRJDB4941_P_NODE_11042_length_335_cov_4.146853_g10274_i0	PRJDB4941	11042	335	4.146853	13.89195755	Engelhardtia	139931	Bacteria	Bacteria	189	2.31e-43	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g10274	i0	80.769	19.4388059701493	260	34	75	15	3	254	387998	387747	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	6512	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
5112727	5112727	PRJDB4941_P_NODE_28665_length_186_cov_2.656934_g27897_i0	PRJDB4941	28665	186	2.656934	4.94189724	Haloferula helveola	490095	Bacteria	Bacteria	137	4.27e-28	NTclustered	gi\|2647781590\|dbj\|AP024702.1\|	490095	g27897	i0	81.503	7.16129032258065	173	26	91	6	14	183	2548531	2548700	Haloferula helveola CN-1 DNA, complete genome	blastn	1332	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula helveola
7662478	7662478	PRJDB4941_P_NODE_17267_length_250_cov_2.328358_g16499_i0	PRJDB4941	17267	250	2.328358	5.820895	Tichowtungia aerotolerans	2697043	Bacteria	Bacteria	102	2.22e-17	NTclustered	gi\|1798450978\|gb\|CP047593.1\|	2697043	g16499	i0	98.276	4.36	58	1	23	0	155	212	3724769	3724826	Tichowtungia aerotolerans strain S-5007 chromosome, complete genome	blastn	1090	102	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Tichowtungiia	Tichowtungiales	Tichowtungiaceae	Tichowtungia	Tichowtungia aerotolerans
7662744	7662744	PRJDB4941_P_NODE_31167_length_178_cov_1.209302_g30399_i0	PRJDB4941	31167	178	1.209302	2.15255756	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	113	6.81e-21	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g30399	i0	80.405	1.67415730337079	148	29	83	0	17	164	2866916	2867063	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	298	113	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8937030	8937030	PRJDB4941_P_NODE_13948_length_287_cov_2.105042_g13180_i0	PRJDB4941	13948	287	2.105042	6.04147054	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	126	1.5399999999999999e-24	NTclustered	gi\|2108165213\|gb\|CP070718.1\|	2052180	g13180	i0	82.857	0.895470383275261	140	24	49	0	137	276	2869895	2870034	MAG: Phycisphaerales bacterium isolate bin470 chromosome	blastn	257	126	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
10213191	10213191	PRJDB4941_P_NODE_28249_length_188_cov_1.496403_g27481_i0	PRJDB4941	28249	188	1.496403	2.81323764	Opitutus terrae	107709	Bacteria	Bacteria	117	5.63e-22	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g27481	i0	85.586	0.590425531914894	111	16	59	0	66	176	2020382	2020272	Opitutus terrae PB90-1, complete genome	blastn	111	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
11488205	11488205	PRJDB4941_P_NODE_21870_length_217_cov_1.476190_g21102_i0	PRJDB4941	21870	217	1.47619	3.2033323	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	132	2.39e-26	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g21102	i0	78.605	0.990783410138249	215	35	96	7	1	209	4044533	4044742	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	215	132	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
11488659	11488659	PRJDB4941_P_NODE_8690_length_398_cov_2.000000_g7922_i0	PRJDB4941	8690	398	2	7.96	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	292	2.0599999999999993e-74	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g7922	i0	80.863	18.3819095477387	371	71	93	0	11	381	1778736	1779106	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	7316	292	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
12763592	12763592	PRJDB4941_P_NODE_13811_length_289_cov_2.050000_g13043_i0	PRJDB4941	13811	289	2.05	5.9245	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	167	9.16e-37	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g13043	i0	78.277	16	267	52	91	6	6	269	2668885	2668622	Planctomyces sp. SH-PL14, complete genome	blastn	4624	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
12764135	12764135	PRJDB4941_P_NODE_41951_length_154_cov_2.085714_g41183_i0	PRJDB4941	41951	154	2.085714	3.21199956	Opitutus terrae	107709	Bacteria	Bacteria	141	2.62e-29	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g41183	i0	83.784	9.06493506493507	148	24	96	0	3	150	1089325	1089472	Opitutus terrae PB90-1, complete genome	blastn	1396	141	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
16587491	16587491	PRJDB4941_P_NODE_4754_length_628_cov_2.804836_g4003_i0	PRJDB4941	4754	628	2.804836	17.61437008	Synoicihabitans lomoniglobus	2909285	Bacteria	Bacteria	60.2	3.73e-4	NTclustered	gi\|2452067159\|gb\|CP119075.1\|	2909285	g4003	i0	100	0.0509554140127389	32	0	5	0	30	61	222775	222806	Synoicihabitans lomoniglobus strain LMO-M01 chromosome, complete genome	blastn	32	60.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Synoicihabitans	Synoicihabitans lomoniglobus
20108122	20108122	PRJDB4941_P_NODE_25896_length_197_cov_2.108108_g25128_i0	PRJDB4941	25896	197	2.108108	4.15297276	Opitutaceae	134623	Bacteria	Bacteria	239	1.22e-58	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g25128	i0	88.718	6.77157360406091	195	22	99	0	1	195	4843191	4842997	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	1334	239	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
20108211	20108211	PRJDB4941_P_NODE_39216_length_164_cov_0.904348_g38448_i0	PRJDB4941	39216	164	0.904348	1.48313072	Urbifossiella	2807415	Bacteria	Bacteria	159	7.84e-35	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g38448	i0	84.756	492.487804878049	164	19	99	6	2	164	3454759	3454601	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	80768	159	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
20411115	20411115	PRJDB4941_P_NODE_34517_length_169_cov_0.866667_g33749_i0	PRJDB4941	34517	169	0.866667	1.46466723	Opitutus terrae	107709	Bacteria	Bacteria	156	1.05e-33	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g33749	i0	85.43	0.893491124260355	151	20	88	2	10	158	1106456	1106606	Opitutus terrae PB90-1, complete genome	blastn	151	156	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
21687006	21687006	PRJDB4941_P_NODE_31518_length_176_cov_2.370079_g30750_i0	PRJDB4941	31518	176	2.370079	4.17133904	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	137	3.98e-28	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g30750	i0	82.278	1.46022727272727	158	28	90	0	18	175	1460184	1460027	Lacipirellula limnantheis strain I41 chromosome	blastn	257	137	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
23933919	23933919	PRJDB4941_P_NODE_14859_length_276_cov_1.731278_g14091_i0	PRJDB4941	14859	276	1.731278	4.77832728	Gemmata	113	Bacteria	Bacteria	189	1.8499999999999993e-43	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g14091	i0	79.649	3.80797101449275	285	40	99	15	4	276	526191	525913	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	1051	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus

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