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

9 rows where analysis = "blastn", bioproject = "PRJNA1041773" 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
1445588	1445588	PRJNA1041773_P_NODE_84702_length_248_cov_0.880000_g84369_i0	PRJNA1041773	84702	248	0.88	2.1824	Urbifossiella limnaea	2528023	Bacteria	Bacteria	211	3.5e-50	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g84369	i0	85.047	38.3709677419355	214	25	84	4	40	248	6276760	6276971	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	9516	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
2721499	2721499	PRJNA1041773_P_NODE_92403_length_245_cov_0.883721_g92070_i0	PRJNA1041773	92403	245	0.883721	2.16511645	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	119	2.15e-22	NTclustered	gi\|2518556548\|emb\|OX638380.1\|	412056	g92070	i0	80.519	5.77959183673469	154	30	63	0	8	161	3347427	3347580	MAG: uncultured Verrucomicrobiae bacterium isolate efd5e50e-5b6a-4a0f-a0a2-e496bae301b3 genome assembly, chromosome: 1	blastn	1416	119	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9098263	9098263	PRJNA1041773_P_NODE_68768_length_264_cov_1.612565_g68435_i0	PRJNA1041773	68768	264	1.612565	4.2571716	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	305	1.68e-78	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g68435	i0	87.594	1.9280303030303	266	30	100	3	1	264	10014963	10015227	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	509	305	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
10374154	10374154	PRJNA1041773_P_NODE_85349_length_248_cov_0.880000_g85016_i0	PRJNA1041773	85349	248	0.88	2.1824	Akkermansia muciniphila	239935	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2051370031\|gb\|CP072028.1\|	239935	g85016	i0	100	0.225806451612903	28	0	11	0	75	102	432415	432442	Akkermansia muciniphila strain Akk1756 chromosome, complete genome	blastn	56	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
10374356	10374356	PRJNA1041773_P_NODE_98569_length_242_cov_0.911243_g98236_i0	PRJNA1041773	98569	242	0.911243	2.20520806	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	207	4.4e-49	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g98236	i0	82.591	4.98760330578512	247	31	99	8	2	242	2602674	2602434	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	1207	207	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
18022849	18022849	PRJNA1041773_P_NODE_89055_length_246_cov_0.890173_g88722_i0	PRJNA1041773	89055	246	0.890173	2.18982558	uncultured Opitutaceae bacterium	333967	Bacteria	Bacteria	135	2.14e-27	NTclustered	gi\|2518551946\|emb\|OX638348.1\|	333967	g88722	i0	92.632	30.2764227642276	95	6	38	1	151	244	427402	427308	MAG: uncultured Opitutaceae bacterium isolate b1b57f99-08c0-43d1-969e-fd0ef39b1292 genome assembly, chromosome: 1	blastn	7448	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		uncultured Opitutaceae bacterium
19296346	19296346	PRJNA1041773_P_NODE_57816_length_284_cov_1.459716_g57483_i0	PRJNA1041773	57816	284	1.459716	4.14559344	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	261	4e-65	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g57483	i0	84	6.70422535211268	275	40	95	4	1	271	402471	402745	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	1904	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
20572271	20572271	PRJNA1041773_P_NODE_97697_length_242_cov_1.556213_g97364_i0	PRJNA1041773	97697	242	1.556213	3.76603546	Urbifossiella limnaea	2528023	Bacteria	Bacteria	265	2.5699999999999997e-66	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g97364	i0	86.42	12.6115702479339	243	31	100	2	1	242	5797945	5798186	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	3052	265	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
24396742	24396742	PRJNA1041773_P_NODE_68120_length_265_cov_1.604167_g67787_i0	PRJNA1041773	68120	265	1.604167	4.25104255	Humisphaera borealis	2807512	Bacteria	Bacteria	294	3.64e-75	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g67787	i0	87.5	16.0415094339623	256	30	96	2	8	262	1749512	1749766	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	4251	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis

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