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

20 rows where analysis = "blastn", bioproject = "PRJNA770826" 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
2022897	2022897	PRJNA770826_P_NODE_28442_length_167_cov_0.881356_g28271_i0	PRJNA770826	28442	167	0.881356	1.47186452	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	115	1.76e-21	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g28271	i0	81.69	1.4251497005988	142	22	84	4	28	167	2924528	2924389	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	238	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
3298030	3298030	PRJNA770826_P_NODE_11843_length_234_cov_1.405405_g11672_i0	PRJNA770826	11843	234	1.405405	3.2886477	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	167	7.1699999999999995e-37	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g11672	i0	83.243	76.2735042735043	185	28	79	2	34	218	1557210	1557391	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	17848	167	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
3298173	3298173	PRJNA770826_P_NODE_7383_length_303_cov_2.362205_g7212_i0	PRJNA770826	7383	303	2.362205	7.15748115	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g7212	i0	100	0.0924092409240924	28	0	9	0	273	300	162948	162975	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
5850383	5850383	PRJNA770826_P_NODE_17265_length_195_cov_1.027397_g17094_i0	PRJNA770826	17265	195	1.027397	2.00342415	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	130	7.57e-26	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g17094	i0	81.761	7.97435897435897	159	26	81	3	36	192	524937	525094	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	1555	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
7125534	7125534	PRJNA770826_P_NODE_10266_length_251_cov_3.386139_g10095_i0	PRJNA770826	10266	251	3.386139	8.49920889	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	326	1.21e-84	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g10095	i0	90.323	88.1235059760956	248	24	99	0	1	248	1316013	1316260	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	22119	326	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
7125548	7125548	PRJNA770826_P_NODE_12026_length_232_cov_1.595628_g11855_i0	PRJNA770826	12026	232	1.595628	3.70185696	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	268	1.89e-67	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g11855	i0	87.712	38.9913793103448	236	22	100	7	1	232	1316035	1316267	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	9046	268	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
7125616	7125616	PRJNA770826_P_NODE_24986_length_169_cov_0.866667_g24815_i0	PRJNA770826	24986	169	0.866667	1.46466723	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	165	1.74e-36	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g24815	i0	85.714	4.81656804733728	161	17	93	6	11	168	3990700	3990543	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	814	165	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
9675309	9675309	PRJNA770826_P_NODE_21328_length_175_cov_1.238095_g21157_i0	PRJNA770826	21328	175	1.238095	2.16666625	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	183	5.0099999999999996e-42	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g21157	i0	87.421	70.1828571428571	159	20	91	0	1	159	1931394	1931236	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	12282	183	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10135308	10135308	PRJNA770826_P_NODE_41128_length_163_cov_0.912281_g40957_i0	PRJNA770826	41128	163	0.912281	1.48701803	Nibricoccus	2576890	Bacteria	Bacteria	239	9.72e-59	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g40957	i0	93.711	75.6993865030675	159	10	98	0	1	159	2850763	2850921	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	12339	241	0.991701244813278	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
10950982	10950982	PRJNA770826_P_NODE_24509_length_169_cov_0.866667_g24338_i0	PRJNA770826	24509	169	0.866667	1.46466723	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	230	6.0699999999999995e-56	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g24338	i0	91.176	7.51479289940828	170	14	100	1	1	169	3832495	3832664	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	1270	230	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
12226638	12226638	PRJNA770826_P_NODE_3830_length_440_cov_1.851662_g3659_i0	PRJNA770826	3830	440	1.851662	8.1473128	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	713	0	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g3659	i0	95.909	198.609090909091	440	18	100	0	1	440	1896	1457	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	87388	713	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
12686309	12686309	PRJNA770826_P_NODE_1050_length_820_cov_2.211414_g922_i0	PRJNA770826	1050	820	2.211414	18.1335948	Prosthecobacter	48463	Bacteria	Bacteria	1304	0	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g922	i0	95.366	286.343902439024	820	38	100	0	1	820	601	1420	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	234802	1317	0.990129081245254	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
13960673	13960673	PRJNA770826_P_NODE_3511_length_460_cov_11.284672_g3340_i0	PRJNA770826	3511	460	11.284672	51.9094912	Verrucomicrobiota	74201	Bacteria	Bacteria	616	1.2599999999999999e-171	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g3340	i0	90.889	193.563043478261	461	38	99	4	1	459	1152	694	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	89039	616	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
16049599	16049599	PRJNA770826_P_NODE_8293_length_282_cov_1.587983_g8122_i0	PRJNA770826	8293	282	1.587983	4.47811206	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	383	8.12e-102	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g8122	i0	91.197	50.6631205673759	284	21	100	3	1	282	487	206	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	14287	383	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
17325162	17325162	PRJNA770826_P_NODE_1374_length_727_cov_5.480826_g1236_i0	PRJNA770826	1374	727	5.480826	39.84560502	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	693	0	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g1236	i0	84.054	122.741403026135	740	97	100	17	1	727	3989678	3990409	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	89233	693	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
17325243	17325243	PRJNA770826_P_NODE_30534_length_167_cov_0.881356_g30363_i0	PRJNA770826	30534	167	0.881356	1.47186452	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	117	4.900000000000001e-22	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g30363	i0	79.63	1.59281437125748	162	33	97	0	1	162	5471127	5470966	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	266	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
18598642	18598642	PRJNA770826_P_NODE_23335_length_169_cov_0.866667_g23164_i0	PRJNA770826	23335	169	0.866667	1.46466723	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	139	1.05e-28	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g23164	i0	82.5	0.946745562130177	160	26	94	2	1	159	1137180	1137022	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	160	139	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22424236	22424236	PRJNA770826_P_NODE_3758_length_445_cov_2.497475_g3587_i0	PRJNA770826	3758	445	2.497475	11.11376375	Prosthecobacter debontii	48467	Bacteria	Bacteria	699	0	NTclustered	gi\|164510703\|emb\|AJ966882.1\|	48467	g3587	i0	95.056	267.61797752809	445	20	100	2	1	445	4514	4072	Prosthecobacter debontii 16S rRNA gene (partial), 23S rRNA gene (partial), tRNA-Ala gene, tRNA-Ile gene and ITS1, strain DSM 14044	blastn	119090	699	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter debontii
23699790	23699790	PRJNA770826_P_NODE_139_length_1708_cov_9.696203_g107_i0	PRJNA770826	139	1708	9.696203	165.61114724	Fontisphaera persica	2974023	Bacteria	Bacteria	1755	0	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g107	i0	85.842	183.906908665105	1681	205	97	29	1	1661	3862696	3861029	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	314113	1755	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
23699967	23699967	PRJNA770826_P_NODE_7839_length_292_cov_1.283951_g7668_i0	PRJNA770826	7839	292	1.283951	3.74913692	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	99	3.43e-16	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g7668	i0	86.517	11.2431506849315	89	12	30	0	54	142	2545346	2545258	Luteolibacter sp. LG18 DNA, complete genome	blastn	3283	99	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18

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