metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA864829" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA864829" 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
2122659	2122659	PRJNA864829_S_NODE_462_length_636_cov_23.359455_g48_i3	PRJNA864829	462	636	23.359455	148.5661338	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	843	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g48	i3	90.781	233.221698113208	640	45	99	13	6	636	1315451	1316085	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	148329	843	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
3397992	3397992	PRJNA864829_S_NODE_10323_length_197_cov_1.027027_g10237_i0	PRJNA864829	10323	197	1.027027	2.02324319	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	159	9.77e-35	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g10237	i0	82.011	0.959390862944162	189	32	95	2	2	189	933439	933252	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	189	159	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
3398011	3398011	PRJNA864829_S_NODE_2563_length_335_cov_1.213287_g2477_i0	PRJNA864829	2563	335	1.213287	4.06451145	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	292	1.71e-74	NTclustered	gi\|226525317\|gb\|FJ872374.1\|	156588	g2477	i0	91.943	176.510447761194	211	13	62	3	1	208	3895	3686	Uncultured Verrucomicrobia bacterium clone 184 genomic sequence	blastn	59131	292	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
9775283	9775283	PRJNA864829_S_NODE_10268_length_197_cov_1.912162_g10182_i0	PRJNA864829	10268	197	1.912162	3.76695914	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	215	2.06e-51	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g10182	i0	89.205	34.5634517766497	176	13	87	6	26	197	3833600	3833427	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	6809	215	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9775318	9775318	PRJNA864829_S_NODE_5428_length_255_cov_5.844660_g5342_i0	PRJNA864829	5428	255	5.84466	14.903883	Fontisphaera persica	2974023	Bacteria	Bacteria	368	2.03e-97	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g5342	i0	94.215	258.572549019608	242	13	95	1	2	243	3863265	3863505	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	65936	368	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
11440642	11440642	PRJNA864829_S_NODE_5349_length_257_cov_1.923077_g5263_i0	PRJNA864829	5349	257	1.923077	4.94230789	Opitutus	178440	Bacteria	Bacteria	279	9.85e-71	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g5263	i0	88.412	70.5330739299611	233	25	90	2	26	257	2015	2246	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	18127	279	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
12326410	12326410	PRJNA864829_S_NODE_12090_length_184_cov_1.503704_g12004_i0	PRJNA864829	12090	184	1.503704	2.76681536	Fontisphaera persica	2974023	Bacteria	Bacteria	158	3.23e-34	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g12004	i0	86.301	7.72826086956522	146	18	79	2	39	183	3862271	3862415	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	1422	158	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
13600937	13600937	PRJNA864829_S_NODE_10931_length_192_cov_1.818182_g10845_i0	PRJNA864829	10931	192	1.818182	3.49090944	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	100	5.82e-17	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g10845	i0	83.333	2.25	108	18	56	0	50	157	4386096	4385989	Luteolibacter sp. SL250 chromosome	blastn	432	100	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
13600967	13600967	PRJNA864829_S_NODE_311_length_754_cov_3.838298_g251_i0	PRJNA864829	311	754	3.838298	28.94076692	Pedosphaera parvula	1032527	Bacteria	Bacteria	808	0	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g251	i0	86.162	284.165782493369	766	84	100	20	1	754	1865	1110	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	214261	808	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
13600999	13600999	PRJNA864829_S_NODE_811_length_519_cov_4.446809_g726_i0	PRJNA864829	811	519	4.446809	23.07893871	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	207	1.03e-48	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g726	i0	78.571	127.352601156069	350	50	65	21	1	336	631657	631319	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	66096	207	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
13601007	13601007	PRJNA864829_S_NODE_991_length_482_cov_6.856813_g905_i0	PRJNA864829	991	482	6.856813	33.04983866	Horticoccus luteus	2862869	Bacteria	Bacteria	477	6.539999999999998e-130	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g905	i0	84.805	3.63485477178423	487	60	100	13	1	482	2449066	2448589	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	1752	477	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
16149957	16149957	PRJNA864829_S_NODE_1873_length_375_cov_5.208589_g1787_i0	PRJNA864829	1873	375	5.208589	19.53220875	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	189	2.6099999999999993e-43	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g1787	i0	77.429	121.778666666667	350	58	91	20	36	375	5627266	5626928	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	45667	189	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
16149973	16149973	PRJNA864829_S_NODE_4313_length_279_cov_2.152174_g4227_i0	PRJNA864829	4313	279	2.152174	6.00456546	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	296	1.08e-75	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g4227	i0	90	82.0286738351254	230	21	82	2	42	270	3833446	3833218	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	22886	296	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18698619	18698619	PRJNA864829_S_NODE_3395_length_303_cov_2.070866_g3309_i0	PRJNA864829	3395	303	2.070866	6.27472398	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	285	2.56e-72	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g3309	i0	85.357	222.871287128713	280	36	92	5	25	303	5625464	5625189	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	67530	285	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
19973877	19973877	PRJNA864829_S_NODE_156_length_976_cov_32.277238_g48_i2	PRJNA864829	156	976	32.277238	315.02584288	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1386	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g48	i2	92.269	245.508196721311	983	66	100	9	1	976	1315106	1316085	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	239616	1386	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
19973901	19973901	PRJNA864829_S_NODE_6076_length_245_cov_3.250000_g5990_i0	PRJNA864829	6076	245	3.25	7.9625	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	320	5.49e-83	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g5990	i0	92.411	187.2	224	17	91	0	1	224	3555486	3555263	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	45864	320	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
22523997	22523997	PRJNA864829_S_NODE_5578_length_253_cov_1.936275_g5492_i0	PRJNA864829	5578	253	1.936275	4.89877575	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	265	2.71e-66	NTclustered	gi\|226525317\|gb\|FJ872374.1\|	156588	g5492	i0	91.282	183.897233201581	195	16	77	1	24	217	3119	3313	Uncultured Verrucomicrobia bacterium clone 184 genomic sequence	blastn	46526	265	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
22523999	22523999	PRJNA864829_S_NODE_5818_length_249_cov_3.935000_g5732_i0	PRJNA864829	5818	249	3.935	9.79815	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	291	4.39e-74	NTclustered	gi\|226525317\|gb\|FJ872374.1\|	156588	g5732	i0	88.048	276.04016064257	251	22	99	7	2	249	2877	3122	Uncultured Verrucomicrobia bacterium clone 184 genomic sequence	blastn	68734	291	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
24188393	24188393	PRJNA864829_S_NODE_159_length_973_cov_6.451299_g121_i0	PRJNA864829	159	973	6.451299	62.77113927	Verrucomicrobiota	74201	Bacteria	Bacteria	604	6.029999999999999e-168	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g121	i0	79.045	60.6659815005139	921	164	93	23	66	967	5152310	5153220	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	59028	604	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
25073379	25073379	PRJNA864829_S_NODE_4860_length_267_cov_2.766055_g4774_i0	PRJNA864829	4860	267	2.766055	7.38536685	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	233	8.13e-57	NTclustered	gi\|226525317\|gb\|FJ872374.1\|	156588	g4774	i0	84.082	125.352059925094	245	36	91	3	21	264	2641	2883	Uncultured Verrucomicrobia bacterium clone 184 genomic sequence	blastn	33469	233	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota 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);;