metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1035005" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1035005" 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
6546887	6546887	PRJNA1035005_P_NODE_37586_length_272_cov_3.914573_g37180_i0	PRJNA1035005	37586	272	3.914573	10.64763856	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	278	3.78e-70	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g37180	i0	88.136	396.191176470588	236	25	86	3	37	271	2001871	2001638	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	107764	278	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
7821459	7821459	PRJNA1035005_P_NODE_41787_length_267_cov_1.608247_g41381_i0	PRJNA1035005	41787	267	1.608247	4.29401949	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	183	8.3e-42	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g41381	i0	82.326	20.1535580524345	215	34	80	4	37	249	3957034	3956822	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	5381	183	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
15471546	15471546	PRJNA1035005_P_NODE_19553_length_301_cov_3.754386_g19147_i0	PRJNA1035005	19553	301	3.754386	11.30070186	Limnoglobus roseus	2598579	Bacteria	Bacteria	427	3.9799999999999998e-115	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g19147	i0	92.359	98.6976744186046	301	21	100	1	1	301	2955179	2955477	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	29708	427	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
16745724	16745724	PRJNA1035005_P_NODE_26174_length_287_cov_2.602804_g25768_i0	PRJNA1035005	26174	287	2.602804	7.47004748	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	374	4.989999999999998e-99	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g25768	i0	90.311	163.766550522648	289	23	100	5	1	287	2002190	2001905	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	47001	374	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
18020673	18020673	PRJNA1035005_P_NODE_3455_length_584_cov_1.810176_g3062_i0	PRJNA1035005	3455	584	1.810176	10.57142784	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	922	0	NTclustered	gi\|576901573\|gb\|KF827166.1\|	120965	g3062	i0	96.441	92.9897260273973	562	14	96	4	1	562	556	1	Uncultured planctomycete clone C-30-34 16S ribosomal RNA gene, partial sequence	blastn	54306	922	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
19294872	19294872	PRJNA1035005_P_NODE_71916_length_247_cov_0.896552_g71510_i0	PRJNA1035005	71916	247	0.896552	2.21448344	Planctomycetes bacterium K2D	2528022	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1712768844\|gb\|CP036350.1\|	2527962	g71510	i0	100	28.7854251012146	247	0	100	0	1	247	4246591	4246837	Planctomycetes bacterium K2D chromosome, complete genome	blastn	7110	457	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium K2D
20570098	20570098	PRJNA1035005_P_NODE_53097_length_253_cov_1.688889_g52691_i0	PRJNA1035005	53097	253	1.688889	4.27288917	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	383	7.17e-102	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g52691	i0	94.715	99.296442687747	246	13	97	0	1	246	5154269	5154514	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	25122	383	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24394700	24394700	PRJNA1035005_P_NODE_11400_length_350_cov_1.321300_g10995_i0	PRJNA1035005	11400	350	1.3213	4.62455	uncultured Opitutia bacterium	575426	Bacteria	Bacteria	625	1.5499999999999995e-174	NTclustered	gi\|523452328\|gb\|KF182748.1\|	575426	g10995	i0	98.857	99.8314285714286	350	4	100	0	1	350	481	830	Uncultured Opitutae bacterium clone S1-003 16S ribosomal RNA gene, partial sequence	blastn	34941	625	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				uncultured Opitutia bacterium
24395061	24395061	PRJNA1035005_P_NODE_62200_length_250_cov_0.881356_g61794_i0	PRJNA1035005	62200	250	0.881356	2.20339	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	446	8.89e-121	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g61794	i0	98.8	45.784	250	3	100	0	1	250	1361	1610	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	11446	446	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis

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