metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA1098727" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA1098727" and tax_phylum = "Verrucomicrobiota"

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
2761819	2761819	PRJNA1098727_P_NODE_8503_length_211_cov_1.246914_g8262_i0	PRJNA1098727	8503	211	1.246914	2.63098854	Pedosphaera parvula	1032527	Bacteria	Bacteria	316	5.95e-82	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g8262	i0	93.839	211.758293838863	211	11	99	2	2	210	1685	1895	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	44681	316	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
6122910	6122910	PRJNA1098727_P_NODE_4585_length_304_cov_1.172549_g4344_i0	PRJNA1098727	4585	304	1.172549	3.56454896	Verrucomicrobiota	74201	Bacteria	Bacteria	313	1.18e-80	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g4344	i0	86.879	79.5855263157895	282	33	92	4	2	281	1262	983	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	24194	316	0.990506329113924	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
10414499	10414499	PRJNA1098727_P_NODE_15429_length_163_cov_0.912281_g15188_i0	PRJNA1098727	15429	163	0.912281	1.48701803	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	84.2	4.82e-12	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g15188	i0	88.406	0.791411042944785	69	8	42	0	2	70	2040997	2041065	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	129	84.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
11689833	11689833	PRJNA1098727_P_NODE_15510_length_162_cov_1.840708_g15269_i0	PRJNA1098727	15510	162	1.840708	2.98194696	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	195	2.12e-45	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g15269	i0	88.415	21.6234567901235	164	15	99	4	2	162	1315648	1315486	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	3503	195	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24437007	24437007	PRJNA1098727_P_NODE_6100_length_254_cov_2.804878_g5859_i0	PRJNA1098727	6100	254	2.804878	7.12439012	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	440	4.209999999999998e-119	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g5859	i0	98.024	135.984251968504	253	5	99	0	2	254	15935	15683	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	34540	440	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium

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