metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA611476" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA611476" 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
589781	589781	PRJNA611476_P_NODE_63941_length_278_cov_1.126829_g63150_i0	PRJNA611476	63941	278	1.126829	3.13258462	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	207	5.16e-49	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g63150	i0	81.004	1.00359712230216	279	37	97	14	8	278	3216781	3216511	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	279	207	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
589787	589787	PRJNA611476_P_NODE_64401_length_277_cov_1.274510_g63610_i0	PRJNA611476	64401	277	1.27451	3.5303927	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	307	4.9300000000000005e-79	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g63610	i0	86.691	275.324909747292	278	35	100	2	1	277	2001	2277	Luteolibacter sp. SL250 chromosome	blastn	76265	307	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
590099	590099	PRJNA611476_P_NODE_87801_length_249_cov_0.875000_g87010_i0	PRJNA611476	87801	249	0.875	2.17875	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	187	5.919999999999998e-43	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g87010	i0	81.9	73.2128514056225	221	40	89	0	4	224	329902	330122	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	18230	187	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
1866136	1866136	PRJNA611476_P_NODE_95082_length_247_cov_0.885057_g94291_i0	PRJNA611476	95082	247	0.885057	2.18609079	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	339	1.5299999999999998e-88	NTclustered	gi\|2874253974\|emb\|OY970299.1\|	412056	g94291	i0	91.498	3.66396761133603	247	20	99	1	1	246	3335334	3335580	MAG: uncultured Verrucomicrobiae bacterium isolate MFD09603.bin.1.43 genome assembly, chromosome: 1	blastn	905	339	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
3140834	3140834	PRJNA611476_P_NODE_77043_length_253_cov_1.283333_g76252_i0	PRJNA611476	77043	253	1.283333	3.24683249	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	228	3.549999999999999e-55	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g76252	i0	86.19	2.6403162055336	210	29	83	0	43	252	4560024	4559815	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	668	228	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
4417375	4417375	PRJNA611476_P_NODE_66324_length_273_cov_1.870000_g65533_i0	PRJNA611476	66324	273	1.87	5.1051	Roseibacillus persicicus	454148	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2889362999\|gb\|CP151838.1\|	454148	g65533	i0	94.286	0.256410256410256	35	0	13	2	64	98	5056168	5056136	Roseibacillus persicicus strain AS69 chromosome, complete genome	blastn	70	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseibacillus	Roseibacillus persicicus
8242578	8242578	PRJNA611476_P_NODE_41147_length_333_cov_1.457692_g40356_i0	PRJNA611476	41147	333	1.457692	4.85411436	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	555	1.9599999999999995e-153	NTclustered	gi\|126566080\|gb\|EF446814.1\|	156588	g40356	i0	96.97	98.1711711711712	330	10	99	0	4	333	235	564	Uncultured Verrucomicrobia bacterium clone Ev219h1bfT3b20 16S ribosomal RNA gene, partial sequence	blastn	32691	555	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
14618237	14618237	PRJNA611476_P_NODE_26612_length_394_cov_1.679128_g25821_i0	PRJNA611476	26612	394	1.679128	6.61576432	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	671	0	NTclustered	gi\|1206255667\|emb\|LT843627.1\|	156588	g25821	i0	98.677	99.8527918781726	378	5	96	0	1	378	378	1	uncultured Verrucomicrobia bacterium partial 16S rRNA gene, isolate BACT_OTU_1753	blastn	39342	671	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
17166986	17166986	PRJNA611476_P_NODE_18594_length_460_cov_1.813953_g17804_i0	PRJNA611476	18594	460	1.813953	8.3441838	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	67.6	1.59e-6	NTclustered	gi\|2874253793\|emb\|OY969777.1\|	412056	g17804	i0	97.436	13.4	39	1	8	0	45	83	647746	647708	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1	blastn	6164	67.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18441919	18441919	PRJNA611476_P_NODE_70335_length_266_cov_1.196891_g69544_i0	PRJNA611476	70335	266	1.196891	3.18373006	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g69544	i0	100	0.105263157894737	28	0	11	0	71	98	1065303	1065276	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
19715342	19715342	PRJNA611476_P_NODE_100676_length_245_cov_0.895349_g99885_i0	PRJNA611476	100676	245	0.895349	2.19360505	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	272	1.56e-68	NTclustered	gi\|2874253793\|emb\|OY969777.1\|	412056	g99885	i0	89.401	136.567346938776	217	22	88	1	27	242	2363426	2363642	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1	blastn	33459	272	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22266851	22266851	PRJNA611476_P_NODE_58198_length_288_cov_1.316279_g57407_i0	PRJNA611476	58198	288	1.316279	3.79088352	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g57407	i0	100	0.0972222222222222	28	0	10	0	222	249	3324183	3324210	Lacunisphaera limnophila strain IG16b, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
23541876	23541876	PRJNA611476_P_NODE_37339_length_346_cov_1.117216_g36548_i0	PRJNA611476	37339	346	1.117216	3.86556736	Congregicoccus parvus	3081749	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|2599616993\|dbj\|AP028972.1\|	3081749	g36548	i0	100	0.0809248554913295	28	0	8	0	16	43	3569353	3569326	Opitutales bacterium ASA1 DNA, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Alterococcaceae	Congregicoccus	Congregicoccus parvus

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