metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA993416" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA993416" 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
975790	975790	PRJNA993416_P_NODE_13481_length_248_cov_0.880000_g13376_i0	PRJNA993416	13481	248	0.88	2.1824	Akkermansia muciniphila	239935	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1805906055\|gb\|CP027004.1\|	239935	g13376	i0	100	96.9798387096774	248	0	100	0	1	248	2514706	2514953	Akkermansia muciniphila strain EB-AMDK-28 chromosome, complete genome	blastn	24051	459	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
7353621	7353621	PRJNA993416_P_NODE_16266_length_241_cov_0.916667_g16161_i0	PRJNA993416	16266	241	0.916667	2.20916747	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	259	1.19e-64	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g16161	i0	88.636	71.6016597510373	220	15	88	8	29	241	8564258	8564474	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	17256	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
7353641	7353641	PRJNA993416_P_NODE_2226_length_578_cov_2.558416_g2122_i0	PRJNA993416	2226	578	2.558416	14.78764448	Aquisphaera giovannonii	406548	Bacteria	Bacteria	121	1.5400000000000001e-22	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g2122	i0	80	1.00173010380623	165	32	28	1	1	164	3879699	3879535	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	579	121	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
12454926	12454926	PRJNA993416_P_NODE_11450_length_260_cov_1.647059_g11345_i0	PRJNA993416	11450	260	1.647059	4.2823534	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	204	6.179999999999999e-48	NTclustered	gi\|226525317\|gb\|FJ872374.1\|	156588	g11345	i0	81.061	1.99615384615385	264	43	100	7	1	260	29209	28949	Uncultured Verrucomicrobia bacterium clone 184 genomic sequence	blastn	519	204	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
20102326	20102326	PRJNA993416_P_NODE_14996_length_244_cov_0.900585_g14891_i0	PRJNA993416	14996	244	0.900585	2.1974274	Akkermansia muciniphila	239935	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g14891	i0	100	100	244	0	100	0	1	244	2167892	2168135	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	24400	451	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
20102525	20102525	PRJNA993416_P_NODE_8396_length_288_cov_1.130233_g8291_i0	PRJNA993416	8396	288	1.130233	3.25507104	Singulisphaera acidiphila	466153	Bacteria	Bacteria	320	6.61e-83	NTclustered	gi\|430012750\|gb\|CP003364.1\|	886293	g8291	i0	87.41	4.21875	278	35	97	0	11	288	1239554	1239277	Singulisphaera acidiphila DSM 18658, complete genome	blastn	1215	320	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
23928574	23928574	PRJNA993416_P_NODE_959_length_831_cov_2.481530_g869_i0	PRJNA993416	959	831	2.48153	20.6215143	Limnoglobus roseus	2598579	Bacteria	Bacteria	141	1.7299999999999999e-28	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g869	i0	100	1.55234657039711	76	0	9	0	619	694	8421753	8421678	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	1290	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
25202101	25202101	PRJNA993416_P_NODE_6000_length_340_cov_1.370787_g5895_i0	PRJNA993416	6000	340	1.370787	4.6606758	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	287	8.090000000000001e-73	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g5895	i0	82.388	77.6176470588235	335	53	98	6	6	337	2189261	2189592	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	26390	287	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola

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