metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA1031674" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA1031674" 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
166551	166551	PRJNA1031674_P_NODE_12921_length_284_cov_1.227488_g12710_i0	PRJNA1031674	12921	284	1.227488	3.48606592	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	497	2.8e-136	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g12710	i0	98.239	107.961267605634	284	5	100	0	1	284	2833761	2833478	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	30661	497	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
166775	166775	PRJNA1031674_P_NODE_27021_length_242_cov_2.733728_g26810_i0	PRJNA1031674	27021	242	2.733728	6.61562176	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	63.9	1.01e-5	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g26810	i0	95.122	0.169421487603306	41	1	17	1	21	61	5696895	5696934	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	41	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
1006860	1006860	PRJNA1031674_P_NODE_24141_length_247_cov_2.477011_g23930_i0	PRJNA1031674	24141	247	2.477011	6.11821717	Akkermansia	239934	Bacteria	Bacteria	84.2	7.92e-12	NTclustered	gi\|2051350654\|gb\|CP072036.1\|	2927224	g23930	i0	96.154	20.6558704453441	52	1	21	1	196	247	2906574	2906524	Akkermansia massiliensis strain Akk1573 chromosome, complete genome	blastn	5102	84.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia massiliensis
2717060	2717060	PRJNA1031674_P_NODE_1523_length_603_cov_2.179245_g1317_i0	PRJNA1031674	1523	603	2.179245	13.14084735	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	375	3.119999999999999e-99	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g1317	i0	87.202	128.426202321725	336	35	55	8	1	330	3990515	3990848	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	77441	375	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
2717227	2717227	PRJNA1031674_P_NODE_25483_length_245_cov_1.418605_g25272_i0	PRJNA1031674	25483	245	1.418605	3.47558225	Pedosphaera parvula	1032527	Bacteria	Bacteria	339	1.5199999999999998e-88	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g25272	i0	92.766	189.440816326531	235	16	96	1	8	242	890	657	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	46413	339	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
2717259	2717259	PRJNA1031674_P_NODE_28003_length_241_cov_0.916667_g27792_i0	PRJNA1031674	28003	241	0.916667	2.20916747	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	375	1.1299999999999998e-99	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g27792	i0	95.708	0.966804979253112	233	10	97	0	1	233	3497534	3497302	Luteolibacter sp. SL250 chromosome	blastn	233	375	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
6544790	6544790	PRJNA1031674_P_NODE_20986_length_255_cov_1.439560_g20775_i0	PRJNA1031674	20986	255	1.43956	3.670878	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	399	7.179999999999999e-107	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g20775	i0	94.902	122.890196078431	255	13	100	0	1	255	1405581	1405835	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	31337	399	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
10369877	10369877	PRJNA1031674_P_NODE_17729_length_267_cov_2.974227_g17518_i0	PRJNA1031674	17729	267	2.974227	7.94118609	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	488	1.5699999999999998e-133	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g17518	i0	99.625	108.98127340824	267	1	100	0	1	267	2558671	2558405	Lacunisphaera limnophila strain IG16b, complete genome	blastn	29098	488	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
14195232	14195232	PRJNA1031674_P_NODE_1552_length_596_cov_2.592734_g1346_i0	PRJNA1031674	1552	596	2.592734	15.45269464	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	841	0	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g1346	i0	92.114	73.6107382550336	596	47	100	0	1	596	5154176	5153581	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	43872	841	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15034641	15034641	PRJNA1031674_P_NODE_7452_length_323_cov_2.320000_g7241_i0	PRJNA1031674	7452	323	2.32	7.4936	Opitutus	178440	Bacteria	Bacteria	532	8.879999999999998e-147	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g7241	i0	96.573	35.3684210526316	321	11	99	0	1	321	714	1034	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	11424	532	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
16743660	16743660	PRJNA1031674_P_NODE_22494_length_250_cov_1.615819_g22283_i0	PRJNA1031674	22494	250	1.615819	4.0395475	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	392	1.1699999999999999e-104	NTclustered	gi\|2874253974\|emb\|OY970299.1\|	412056	g22283	i0	95.161	92.964	248	12	99	0	3	250	1258157	1258404	MAG: uncultured Verrucomicrobiae bacterium isolate MFD09603.bin.1.43 genome assembly, chromosome: 1	blastn	23241	392	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
19292455	19292455	PRJNA1031674_P_NODE_17736_length_267_cov_2.783505_g17525_i0	PRJNA1031674	17736	267	2.783505	7.43195835	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	185	2.31e-42	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g17525	i0	79.688	12.2172284644195	256	52	96	0	12	267	684084	683829	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	3262	185	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
20133317	20133317	PRJNA1031674_P_NODE_4396_length_393_cov_2.409375_g4186_i0	PRJNA1031674	4396	393	2.409375	9.46884375	Bacteria	2	Bacteria	Bacteria	614	3.819999999999999e-171	NTclustered	gi\|351694033\|gb\|JN656847.1\|	156588	g4186	i0	94.924	99.6539440203562	394	16	99	2	2	393	205	596	Uncultured Verrucomicrobia bacterium clone KWK12S.02 16S ribosomal RNA gene, partial sequence	blastn	39164	614	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
20567704	20567704	PRJNA1031674_P_NODE_13197_length_283_cov_1.385714_g12986_i0	PRJNA1031674	13197	283	1.385714	3.92157062	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	490	4.67e-134	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g12986	i0	97.88	265.127208480565	283	6	100	0	1	283	3894809	3894527	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	75031	490	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21843700	21843700	PRJNA1031674_P_NODE_28138_length_240_cov_2.407186_g27927_i0	PRJNA1031674	28138	240	2.407186	5.7772464	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	366	6.79e-97	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g27927	i0	94.167	109.6375	240	14	100	0	1	240	2834665	2834904	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	26313	366	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
24392735	24392735	PRJNA1031674_P_NODE_1940_length_545_cov_1.347458_g1732_i0	PRJNA1031674	1940	545	1.347458	7.3436461	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	785	0	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g1732	i0	92.701	125.220183486239	548	35	100	5	1	545	5152323	5152868	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	68245	785	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae 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);;