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

13 rows where analysis = "blastn", bioproject = "PRJNA1095825" 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
1475797	1475797	PRJNA1095825_P_NODE_292422_length_241_cov_1.833333_g289359_i0	PRJNA1095825	292422	241	1.833333	4.41833253	Congregicoccus parvus	3081749	Bacteria	Bacteria	128	3.4999999999999997e-25	NTclustered	gi\|2599616993\|dbj\|AP028972.1\|	3081749	g289359	i0	91.398	1.3195020746888	93	8	40	0	149	241	3551252	3551344	Opitutales bacterium ASA1 DNA, complete genome	blastn	318	128	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Alterococcaceae	Congregicoccus	Congregicoccus parvus
2751720	2751720	PRJNA1095825_P_NODE_276723_length_244_cov_0.900585_g273660_i0	PRJNA1095825	276723	244	0.900585	2.1974274	Horticoccus luteus	2862869	Bacteria	Bacteria	300	7.12e-77	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g273660	i0	89.451	25.0286885245902	237	25	97	0	2	238	3627573	3627809	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	6107	300	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
4027091	4027091	PRJNA1095825_P_NODE_218324_length_263_cov_1.621053_g215261_i0	PRJNA1095825	218324	263	1.621053	4.26336939	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	418	2.0499999999999995e-112	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g215261	i0	95.437	207.3536121673	263	10	100	2	1	263	16910	17170	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	54534	418	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
4027398	4027398	PRJNA1095825_P_NODE_250764_length_249_cov_0.875000_g247701_i0	PRJNA1095825	250764	249	0.875	2.17875	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	244	3.46e-60	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g247701	i0	84.615	4.94779116465863	247	36	99	2	1	246	844292	844537	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	1232	244	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
10404481	10404481	PRJNA1095825_P_NODE_290549_length_242_cov_0.911243_g287486_i0	PRJNA1095825	290549	242	0.911243	2.20520806	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	167	7.46e-37	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g287486	i0	82.234	1.69834710743802	197	31	81	4	27	221	1999724	1999530	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	411	167	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
12953695	12953695	PRJNA1095825_P_NODE_157811_length_310_cov_1.856540_g154748_i0	PRJNA1095825	157811	310	1.85654	5.755274	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	385	2.51e-102	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g154748	i0	89.474	5.50322580645161	304	32	98	0	1	304	3216188	3216491	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1706	385	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
18052518	18052518	PRJNA1095825_P_NODE_260035_length_247_cov_0.885057_g256972_i0	PRJNA1095825	260035	247	0.885057	2.18609079	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	159	1.28e-34	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g256972	i0	87.77	2.75708502024291	139	13	55	3	110	244	568157	568019	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	681	159	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
19326487	19326487	PRJNA1095825_P_NODE_244976_length_250_cov_0.870056_g241913_i0	PRJNA1095825	244976	250	0.870056	2.17514	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	150	7.799999999999999e-32	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g241913	i0	90.351	1.948	114	11	46	0	132	245	3215874	3215987	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	487	150	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
20602296	20602296	PRJNA1095825_P_NODE_290977_length_242_cov_0.911243_g287914_i0	PRJNA1095825	290977	242	0.911243	2.20520806	Fontisphaera persica	2974023	Bacteria	Bacteria	381	2.449999999999999e-101	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g287914	i0	95.041	114.061983471074	242	12	100	0	1	242	3863201	3862960	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	27603	381	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
20602358	20602358	PRJNA1095825_P_NODE_296997_length_241_cov_0.916667_g293934_i0	PRJNA1095825	296997	241	0.916667	2.20916747	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	244	3.33e-60	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g293934	i0	85.232	70.0207468879668	237	35	98	0	1	237	1766674	1766910	Luteolibacter sp. LG18 DNA, complete genome	blastn	16875	244	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
23152521	23152521	PRJNA1095825_P_NODE_194779_length_280_cov_1.487923_g191716_i0	PRJNA1095825	194779	280	1.487923	4.1661844	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	121	6.969999999999999e-23	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g191716	i0	79.532	2.84285714285714	171	33	61	2	8	177	800764	800933	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	796	121	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
23153181	23153181	PRJNA1095825_P_NODE_268599_length_246_cov_0.890173_g265536_i0	PRJNA1095825	268599	246	0.890173	2.18982558	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	296	9.3e-76	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g265536	i0	88.843	38.2073170731707	242	25	98	2	6	246	1737945	1738185	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	9399	296	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24426308	24426308	PRJNA1095825_P_NODE_213380_length_267_cov_1.216495_g210317_i0	PRJNA1095825	213380	267	1.216495	3.24804165	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	219	2.2799999999999993e-52	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g210317	i0	83.691	0.872659176029963	233	36	87	2	1	232	3867367	3867136	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	233	219	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis

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