metadata: contig_metadata: 17 rows where bioproject = "PRJNA1046144" and tax

17 rows where bioproject = "PRJNA1046144" 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
5275187	5275187	PRJNA1046144_P_NODE_43105_length_264_cov_1.035897_g42810_i0	PRJNA1046144	43105	264	1.035897	2.73476808	Planctomycetota bacterium	2026780	Bacteria	Bacteria	63.5	5.57e-10	NR	MCH8147289.1	2026780	g42810	i0	100	0.363636363636364	32	0	36.4	0	264	169	159	190	MCH8147289.1 adenylyl-sulfate kinase [Planctomycetota bacterium]	diamond	96	63.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
14200430	14200430	PRJNA1046144_P_NODE_11492_length_469_cov_2.150000_g11197_i0	PRJNA1046144	11492	469	2.15	10.0835	Planctomycetota bacterium	2026780	Bacteria	Bacteria	322	5.12e-105	NR	MCH8147294.1	2026780	g11197	i0	100	0.991471215351812	155	0	99.1	0	3	467	159	313	MCH8147294.1 non-ribosomal peptide synthetase [Planctomycetota bacterium]	diamond	465	322	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
19298545	19298545	PRJNA1046144_P_NODE_62456_length_231_cov_0.888889_g62161_i0	PRJNA1046144	62456	231	0.888889	2.05333359	Pseudomonadati	3379134	Bacteria	Bacteria	150	4.25e-42	NR	MBA4040124.1	37635	g62161	i0	100	1.97402597402597	76	0	98.7	0	229	2	52	127	MBA4040124.1 ABC transporter substrate-binding protein [Planctomyces sp.]	diamond	456	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp.
21849639	21849639	PRJNA1046144_P_NODE_62778_length_230_cov_1.788820_g62483_i0	PRJNA1046144	62778	230	1.78882	4.114286	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	339	1.41e-88	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g62483	i0	93.45	90.8913043478261	229	13	99	2	2	229	4959701	4959928	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	20905	339	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
27003423	27003423	PRJNA1046144_P_NODE_41562_length_267_cov_2.181818_g41267_i0	PRJNA1046144	41562	267	2.181818	5.82545406	Opitutales bacterium	2026772	Bacteria	Bacteria	115	9.55e-28	NR	MDD4348863.1	2026772	g41267	i0	66.3	0.932584269662921	83	28	93.3	0	14	262	637	719	MDD4348863.1 hypothetical protein [Opitutales bacterium]	diamond	249	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
27129645	27129645	PRJNA1046144_P_NODE_59882_length_232_cov_1.766871_g59587_i0	PRJNA1046144	59882	232	1.766871	4.09914072	Limnoglobus roseus	2598579	Bacteria	Bacteria	91.7	1.97e-19	NR	WP_149114490.1	2598579	g59587	i0	53.8	1.00862068965517	78	35	99.6	1	1	231	274	351	WP_149114490.1 BatA domain-containing protein [Limnoglobus roseus]	diamond	234	91.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
27288087	27288087	PRJNA1046144_P_NODE_62303_length_231_cov_0.888889_g62008_i0	PRJNA1046144	62303	231	0.888889	2.05333359	Planctomycetota bacterium	2026780	Bacteria	Bacteria	142	1.68e-38	NR	MFN6302747.1	2026780	g62008	i0	98.7	1	77	1	100	0	1	231	165	241	MFN6302747.1 hypothetical protein [Planctomycetota bacterium]	diamond	231	142	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27351568	27351568	PRJNA1046144_P_NODE_40563_length_270_cov_1.388060_g40268_i0	PRJNA1046144	40563	270	1.38806	3.747762	Sedimentisphaera salicampi	1941349	Bacteria	Bacteria	86.3	2.46e-17	NR	WP_094760291.1	1941349	g40268	i0	44.2	1.91111111111111	86	48	95.6	0	8	265	319	404	WP_094760291.1 AAA family ATPase [Sedimentisphaera salicampi]	diamond	516	86.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales	Sedimentisphaeraceae	Sedimentisphaera	Sedimentisphaera salicampi
27762088	27762088	PRJNA1046144_P_NODE_68444_length_227_cov_0.911392_g68149_i0	PRJNA1046144	68444	227	0.911392	2.06885984	Opitutus sp.	1913982	Bacteria	Bacteria	123	1.5e-30	NR	MBA4136060.1	1913982	g68149	i0	87.7	1.95594713656388	73	9	96.5	0	8	226	398	470	MBA4136060.1 hypothetical protein [Opitutus sp.]	diamond	444	123	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
27817106	27817106	PRJNA1046144_P_NODE_49344_length_249_cov_1.600000_g49049_i0	PRJNA1046144	49344	249	1.6	3.984	Verrucomicrobiota	74201	Bacteria	Bacteria	46.2	0.0021	NR	MBI3870638.1	2026799	g49049	i0	66.7	1.73493975903614	36	12	43.4	0	108	1	9	44	MBI3870638.1 WecB/TagA/CpsF family glycosyltransferase [Verrucomicrobiota bacterium]	diamond	432	46.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27974776	27974776	PRJNA1046144_P_NODE_5605_length_665_cov_2.060403_g5325_i0	PRJNA1046144	5605	665	2.060403	13.70167995	Pseudomonadati	3379134	Bacteria	Bacteria	357	1.2599999999999998e-121	NR	MBA4040115.1	37635	g5325	i0	98.9	1.69624060150376	188	2	84.8	0	1	564	118	305	MBA4040115.1 glycosyltransferase [Planctomyces sp.]	diamond	1128	359	0.994428969359331	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp.
28519725	28519725	PRJNA1046144_P_NODE_40427_length_270_cov_1.880597_g40132_i0	PRJNA1046144	40427	270	1.880597	5.0776119	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	63.9	1.81e-9	NR	MFN0130331.1	2026801	g40132	i0	44.4	2.96666666666667	90	46	98.9	2	267	1	398	484	MFN0130331.1 ATP-binding protein [Verrucomicrobiales bacterium]	diamond	801	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
29245825	29245825	PRJNA1046144_P_NODE_62889_length_230_cov_1.614907_g62594_i0	PRJNA1046144	62889	230	1.614907	3.7142861	Lacunisphaera sp.	1961806	Bacteria	Bacteria	134	1.2799999999999998e-35	NR	HRG56840.1	1961806	g62594	i0	93.4	0.991304347826087	76	5	99.1	0	229	2	240	315	HRG56840.1 helicase RepA family protein [Lacunisphaera sp.]	diamond	228	134	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
29530024	29530024	PRJNA1046144_P_NODE_20170_length_363_cov_1.670068_g19875_i0	PRJNA1046144	20170	363	1.670068	6.06234684	Phycisphaerales bacterium JB064	3342862	Bacteria	Bacteria	44.3	0.037	NR	MFI4882814.1	3342862	g19875	i0	40.6	0.528925619834711	64	32	48.8	5	131	307	24	86	MFI4882814.1 HD-GYP domain-containing protein [Phycisphaerales bacterium JB064]	diamond	192	44.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium JB064
30446167	30446167	PRJNA1046144_P_NODE_69953_length_226_cov_0.917197_g69658_i0	PRJNA1046144	69953	226	0.917197	2.07286522	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	50.4	5.67e-5	NR	HZN66645.1	2876886	g69658	i0	50	0.690265486725664	52	26	69	0	181	26	120	171	HZN66645.1 oligosaccharide flippase family protein [Tepidisphaeraceae bacterium]	diamond	156	50.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
30572158	30572158	PRJNA1046144_P_NODE_52413_length_242_cov_2.098266_g52118_i0	PRJNA1046144	52413	242	2.098266	5.07780372	Planctomycetota bacterium	2026780	Bacteria	Bacteria	149	1.92e-44	NR	MCH8147290.1	2026780	g52118	i0	100	0.991735537190083	80	0	99.2	0	1	240	23	102	MCH8147290.1 aspartate 1-decarboxylase [Planctomycetota bacterium]	diamond	240	149	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32784894	32784894	PRJNA1046144_P_NODE_56260_length_235_cov_0.867470_g55965_i0	PRJNA1046144	56260	235	0.86747	2.0385545	Verrucomicrobium sp.	72225	Bacteria	Bacteria	157	5.129999999999999e-47	NR	MCE2828095.1	72225	g55965	i0	96.2	0.995744680851064	78	3	99.6	0	234	1	43	120	MCE2828095.1 hypothetical protein [Verrucomicrobium sp.]	diamond	234	157	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium 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);;