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

16 rows where analysis = "blastn", bioproject = "PRJNA951810" 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
936773	936773	PRJNA951810_P_NODE_189881_length_216_cov_5.678322_g189536_i0	PRJNA951810	189881	216	5.678322	12.26517552	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	165	2.35e-36	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g189536	i0	80.822	1.01388888888889	219	34	99	7	1	215	813740	813954	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	219	165	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
936956	936956	PRJNA951810_P_NODE_22361_length_424_cov_5.472934_g22023_i0	PRJNA951810	22361	424	5.472934	23.20524016	Luteolibacter luteus	2728835	Bacteria	Bacteria	52.8	0.041	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g22023	i0	100	0.0660377358490566	28	0	7	0	354	381	3537444	3537417	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
937491	937491	PRJNA951810_P_NODE_49441_length_310_cov_5.700422_g49098_i0	PRJNA951810	49441	310	5.700422	17.6713082	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	69.4	2.88e-7	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g49098	i0	89.091	0.267741935483871	55	6	18	0	49	103	3112590	3112536	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	83	69.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
3486908	3486908	PRJNA951810_P_NODE_155183_length_254_cov_1.453039_g154838_i0	PRJNA951810	155183	254	1.453039	3.69071906	Akkermansia muciniphila	239935	Bacteria	Bacteria	464	2.4999999999999994e-126	NTclustered	gi\|2051367837\|gb\|CP072029.1\|	239935	g154838	i0	99.606	99.6535433070866	254	1	100	0	1	254	2420392	2420645	Akkermansia muciniphila strain Akk1713 chromosome, complete genome	blastn	25312	464	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
3487392	3487392	PRJNA951810_P_NODE_185763_length_224_cov_9.496689_g185418_i0	PRJNA951810	185763	224	9.496689	21.27258336	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	60.2	1.19e-4	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g185418	i0	92.683	1.04017857142857	41	3	18	0	73	113	1949085	1949125	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	233	60.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4765420	4765420	PRJNA951810_P_NODE_2564_length_1118_cov_14.880383_g2392_i0	PRJNA951810	2564	1118	14.880383	166.36268194	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	481	1.2199999999999996e-130	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g2392	i0	86.253	3.00357781753131	451	53	40	3	667	1117	3216453	3216012	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	3358	481	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
7313569	7313569	PRJNA951810_P_NODE_113266_length_284_cov_6.933649_g112922_i0	PRJNA951810	113266	284	6.933649	19.69156316	Haloferula helveola	490095	Bacteria	Bacteria	108	5.52e-19	NTclustered	gi\|2647781590\|dbj\|AP024702.1\|	490095	g112922	i0	85.577	35.7781690140845	104	13	36	2	178	280	742532	742634	Haloferula helveola CN-1 DNA, complete genome	blastn	10161	108	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula helveola
8588405	8588405	PRJNA951810_P_NODE_10547_length_580_cov_15.090730_g10237_i0	PRJNA951810	10547	580	15.09073	87.526234	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	407	1.06e-108	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g10237	i0	80.447	2.66379310344828	537	101	92	4	12	546	4559490	4560024	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1545	407	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
8588834	8588834	PRJNA951810_P_NODE_131527_length_272_cov_2.185930_g131182_i0	PRJNA951810	131527	272	2.18593	5.9457296	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	89.8	1.9e-13	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g131182	i0	92.063	21.9926470588235	63	5	23	0	86	148	3399330	3399268	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	5982	89.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
9866090	9866090	PRJNA951810_P_NODE_80348_length_299_cov_4.008850_g80004_i0	PRJNA951810	80348	299	4.00885	11.9864615	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	97.1	1.27e-15	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g80004	i0	77.907	3.37123745819398	172	26	55	12	56	220	287322	287156	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1008	97.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
11141691	11141691	PRJNA951810_P_NODE_81869_length_299_cov_3.442478_g81525_i0	PRJNA951810	81869	299	3.442478	10.29300922	Opitutus terrae	107709	Bacteria	Bacteria	126	1.62e-24	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g81525	i0	80.864	2.00334448160535	162	30	54	1	56	216	1633081	1633242	Opitutus terrae PB90-1, complete genome	blastn	599	126	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
12416455	12416455	PRJNA951810_P_NODE_40810_length_310_cov_12.206751_g40467_i0	PRJNA951810	40810	310	12.206751	37.8409281	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	156	2.15e-33	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g40467	i0	85.333	37.5193548387097	150	22	48	0	161	310	1447167	1447018	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	11631	156	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
13689931	13689931	PRJNA951810_P_NODE_156411_length_252_cov_11.910615_g156066_i0	PRJNA951810	156411	252	11.910615	30.0147498	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	159	1.31e-34	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g156066	i0	82.162	21.75	185	33	73	0	55	239	3148314	3148498	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	5481	159	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20064497	20064497	PRJNA951810_P_NODE_66356_length_310_cov_2.649789_g66013_i0	PRJNA951810	66356	310	2.649789	8.2143459	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	86.1	2.86e-12	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g66013	i0	79.832	1.49677419354839	119	22	40	2	193	310	2141647	2141530	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	464	86.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
22613599	22613599	PRJNA951810_P_NODE_173618_length_239_cov_3.548193_g173273_i0	PRJNA951810	173618	239	3.548193	8.48018127	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	189	1.5699999999999996e-43	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g173273	i0	86.705	10.2468619246862	173	19	72	4	2	172	1328019	1327849	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	2449	189	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
25161973	25161973	PRJNA951810_P_NODE_132800_length_271_cov_2.626263_g132455_i0	PRJNA951810	132800	271	2.626263	7.11717273	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	174	5.08e-39	NTclustered	gi\|2874253793\|emb\|OY969777.1\|	412056	g132455	i0	80.672	53.7416974169742	238	35	86	10	8	239	43382	43614	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1	blastn	14564	174	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);;