metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA682078" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA682078" 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
4488992	4488992	PRJNA682078_P_NODE_241684_length_248_cov_0.880000_g239907_i0	PRJNA682078	241684	248	0.88	2.1824	Congregicoccus parvus	3081749	Bacteria	Bacteria	353	5.49e-93	NTclustered	gi\|2599616993\|dbj\|AP028972.1\|	3081749	g239907	i0	92.653	0.987903225806452	245	18	99	0	4	248	2927013	2926769	Opitutales bacterium ASA1 DNA, complete genome	blastn	245	353	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Alterococcaceae	Congregicoccus	Congregicoccus parvus
7039438	7039438	PRJNA682078_P_NODE_232066_length_250_cov_0.870056_g230289_i0	PRJNA682078	232066	250	0.870056	2.17514	Akkermansia muciniphila	239935	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1554474302\|gb\|CP025823.1\|	239935	g230289	i0	100	99.904	250	0	100	0	1	250	623488	623239	Akkermansia muciniphila strain EB-AMDK-7 chromosome, complete genome	blastn	24976	462	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
7039703	7039703	PRJNA682078_P_NODE_243606_length_248_cov_0.880000_g241829_i0	PRJNA682078	243606	248	0.88	2.1824	Akkermansia muciniphila	239935	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|1805960388\|gb\|CP029703.1\|	239935	g241829	i0	99.597	95	248	1	100	0	1	248	1570731	1570978	Akkermansia muciniphila strain EB-AMDK-46 chromosome, complete genome	blastn	23560	453	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
7040107	7040107	PRJNA682078_P_NODE_259526_length_246_cov_0.861272_g257749_i0	PRJNA682078	259526	246	0.861272	2.11872912	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	401	1.9199999999999992e-107	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g257749	i0	98.678	265.560975609756	227	2	92	1	21	246	855	629	Luteolibacter sp. SL250 chromosome	blastn	65328	401	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
7042196	7042196	PRJNA682078_P_NODE_75326_length_399_cov_0.944785_g73551_i0	PRJNA682078	75326	399	0.944785	3.76969215	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	521	2.4199999999999995e-143	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g73551	i0	90.226	97.8345864661654	399	39	100	0	1	399	3831673	3831275	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	39036	521	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8314308	8314308	PRJNA682078_P_NODE_243347_length_248_cov_0.880000_g241570_i0	PRJNA682078	243347	248	0.88	2.1824	Methylacidimicrobium sp. B4	2796139	Bacteria	Bacteria	176	1.28e-39	NTclustered	gi\|1999103383\|gb\|CP066203.1\|	2796139	g241570	i0	80.435	5.11290322580645	230	45	93	0	1	230	977050	976821	Methylacidimicrobium sp. B4 chromosome, complete genome	blastn	1268	176	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Methylacidimicrobium	Methylacidimicrobium sp. B4
10866964	10866964	PRJNA682078_P_NODE_5029_length_1667_cov_6.696989_g4105_i0	PRJNA682078	5029	1667	6.696989	111.63880663	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	1635	0	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g4105	i0	84.561	217.271145770846	1684	223	99	33	8	1667	26965	28635	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	362191	1635	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
12142638	12142638	PRJNA682078_P_NODE_63210_length_432_cov_10.707521_g61435_i0	PRJNA682078	63210	432	10.707521	46.25649072	Spartobacteria bacterium Gsoil 144	363895	Bacteria	Bacteria	684	0	NTclustered	gi\|84453017\|dbj\|AB245342.1\|	363895	g61435	i0	98.21	89.3425925925926	391	7	91	0	1	391	391	1	Spartobacteria bacterium Gsoil 144 gene for 16S rRNA, partial sequence	blastn	38596	684	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria				Spartobacteria bacterium Gsoil 144
14687084	14687084	PRJNA682078_P_NODE_119672_length_326_cov_0.901186_g117895_i0	PRJNA682078	119672	326	0.901186	2.93786636	Akkermansia muciniphila	239935	Bacteria	Bacteria	592	1.4599999999999996e-164	NTclustered	gi\|2566450153\|gb\|CP114596.1\|	239935	g117895	i0	99.387	99.9846625766871	326	2	100	0	1	326	1738321	1738646	Akkermansia muciniphila strain MmAkk2 chromosome, complete genome	blastn	32595	592	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
14689901	14689901	PRJNA682078_P_NODE_234812_length_249_cov_1.250000_g233035_i0	PRJNA682078	234812	249	1.25	3.1125	Akkermansia muciniphila	239935	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1805960388\|gb\|CP029703.1\|	239935	g233035	i0	100	99.9799196787149	249	0	100	0	1	249	223001	223249	Akkermansia muciniphila strain EB-AMDK-46 chromosome, complete genome	blastn	24895	460	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
14690437	14690437	PRJNA682078_P_NODE_257252_length_246_cov_0.890173_g255475_i0	PRJNA682078	257252	246	0.890173	2.18982558	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	178	3.5099999999999993e-40	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g255475	i0	83.333	0.91869918699187	198	28	80	5	51	246	3427523	3427329	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	226	178	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
15201516	15201516	PRJNA682078_P_NODE_222132_length_251_cov_0.865169_g220355_i0	PRJNA682078	222132	251	0.865169	2.17157419	Akkermansia	239934	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1805906055\|gb\|CP027004.1\|	239935	g220355	i0	100	99.9362549800797	251	0	100	0	1	251	1150004	1150254	Akkermansia muciniphila strain EB-AMDK-28 chromosome, complete genome	blastn	25084	464	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
15201848	15201848	PRJNA682078_P_NODE_256772_length_246_cov_0.890173_g254995_i0	PRJNA682078	256772	246	0.890173	2.18982558	Akkermansia	239934	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1510319856\|gb\|CP024740.1\|	239935	g254995	i0	100	100	246	0	100	0	1	246	374220	373975	Akkermansia muciniphila strain EB-AMDK-4 chromosome, complete genome	blastn	24600	455	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
18511876	18511876	PRJNA682078_P_NODE_191495_length_268_cov_1.251282_g189718_i0	PRJNA682078	191495	268	1.251282	3.35343576	Luteolibacter luteus	2728835	Bacteria	Bacteria	228	3.8e-55	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g189718	i0	82.022	72.2350746268657	267	48	99	0	2	268	5868964	5869230	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	19359	228	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
18512813	18512813	PRJNA682078_P_NODE_228075_length_250_cov_1.305085_g226298_i0	PRJNA682078	228075	250	1.305085	3.2627125	Akkermansia muciniphila	239935	Bacteria	Bacteria	446	8.89e-121	NTclustered	gi\|1173526690\|gb\|CP015409.2\|	239935	g226298	i0	98.8	94.236	250	3	100	0	1	250	366443	366194	Akkermansia muciniphila strain YL44, complete genome	blastn	23559	446	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
19788440	19788440	PRJNA682078_P_NODE_258216_length_246_cov_0.890173_g256439_i0	PRJNA682078	258216	246	0.890173	2.18982558	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	239	1.59e-58	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g256439	i0	85.281	1.63008130081301	231	34	94	0	10	240	373773	374003	Luteolibacter sp. SL250 chromosome	blastn	401	239	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
19788559	19788559	PRJNA682078_P_NODE_262636_length_245_cov_0.895349_g260859_i0	PRJNA682078	262636	245	0.895349	2.19360505	Akkermansia muciniphila	239935	Bacteria	Bacteria	436	5.229999999999999e-118	NTclustered	gi\|1805906055\|gb\|CP027004.1\|	239935	g260859	i0	98.776	99.9183673469388	245	3	100	0	1	245	1542208	1541964	Akkermansia muciniphila strain EB-AMDK-28 chromosome, complete genome	blastn	24480	436	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
20299274	20299274	PRJNA682078_P_NODE_221856_length_251_cov_1.196629_g220079_i0	PRJNA682078	221856	251	1.196629	3.00353879	PVC group	1783257	Bacteria	Bacteria	71.3	6.28e-8	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g220079	i0	97.561	14.800796812749	41	1	16	0	211	251	700804	700844	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	3715	71.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21061925	21061925	PRJNA682078_P_NODE_175797_length_277_cov_1.509804_g174020_i0	PRJNA682078	175797	277	1.509804	4.18215708	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	448	2.7799999999999996e-121	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g174020	i0	96.667	11.3862815884477	270	7	97	2	9	277	4489523	4489255	Luteolibacter sp. SL250 chromosome	blastn	3154	448	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
21063358	21063358	PRJNA682078_P_NODE_232157_length_250_cov_0.870056_g230380_i0	PRJNA682078	232157	250	0.870056	2.17514	Akkermansia muciniphila	239935	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|2566450153\|gb\|CP114596.1\|	239935	g230380	i0	100	98.692	247	0	99	0	1	247	1754826	1755072	Akkermansia muciniphila strain MmAkk2 chromosome, complete genome	blastn	24673	457	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
21064895	21064895	PRJNA682078_P_NODE_294197_length_237_cov_2.817073_g292420_i0	PRJNA682078	294197	237	2.817073	6.67646301	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	217	7.129999999999999e-52	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g292420	i0	84.545	90.9409282700422	220	32	92	2	19	237	1315184	1314966	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	21553	217	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21065549	21065549	PRJNA682078_P_NODE_54917_length_462_cov_7.989717_g53146_i0	PRJNA682078	54917	462	7.989717	36.91249254	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	730	0	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g53146	i0	95.228	194.528138528139	461	22	99	0	2	462	2748248	2748708	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	89872	730	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21575202	21575202	PRJNA682078_P_NODE_230737_length_250_cov_0.870056_g228960_i0	PRJNA682078	230737	250	0.870056	2.17514	Akkermansia	239934	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1510319856\|gb\|CP024740.1\|	239935	g228960	i0	100	99.836	250	0	100	0	1	250	2145536	2145785	Akkermansia muciniphila strain EB-AMDK-4 chromosome, complete genome	blastn	24959	462	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
22850836	22850836	PRJNA682078_P_NODE_277838_length_243_cov_0.905882_g276061_i0	PRJNA682078	277838	243	0.905882	2.20129326	Akkermansia	239934	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1173526690\|gb\|CP015409.2\|	239935	g276061	i0	100	99.9917695473251	243	0	100	0	1	243	907210	907452	Akkermansia muciniphila strain YL44, complete genome	blastn	24298	449	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
24125410	24125410	PRJNA682078_P_NODE_284039_length_242_cov_0.911243_g282262_i0	PRJNA682078	284039	242	0.911243	2.20520806	Akkermansia	239934	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|1554502134\|gb\|CP025835.1\|	239935	g282262	i0	99.587	96	242	1	100	0	1	242	981393	981152	Akkermansia muciniphila strain EB-AMDK-20 chromosome, complete genome	blastn	23232	442	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila

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