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

20 rows where analysis = "blastn", bioproject = "PRJNA597223" 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
1845227	1845227	PRJNA597223_P_NODE_82742_length_155_cov_1.200000_g80896_i0	PRJNA597223	82742	155	1.2	1.86	Chthoniobacter flavus	191863	Bacteria	Bacteria	213	5.52e-51	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g80896	i0	91.558	31.9677419354839	154	13	99	0	1	154	2116	1963	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	4955	213	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
3119844	3119844	PRJNA597223_P_NODE_1723_length_1285_cov_9.685600_g1110_i0	PRJNA597223	1723	1285	9.6856	124.45996	Pedosphaera parvula	1032527	Bacteria	Bacteria	1304	0	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g1110	i0	86.026	121.275486381323	1238	147	95	24	60	1285	421	1644	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	155839	1304	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
3120370	3120370	PRJNA597223_P_NODE_67083_length_175_cov_2.657143_g65237_i0	PRJNA597223	67083	175	2.657143	4.65000025	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	313	6.13e-81	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g65237	i0	98.857	36.0514285714286	175	2	100	0	1	175	2558573	2558399	Lacunisphaera limnophila strain IG16b, complete genome	blastn	6309	313	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
4396574	4396574	PRJNA597223_P_NODE_29044_length_282_cov_2.012146_g27198_i0	PRJNA597223	29044	282	2.012146	5.67425172	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	457	4.72e-124	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g27198	i0	96.39	40.790780141844	277	10	98	0	1	277	5153112	5152836	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	11503	457	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4396863	4396863	PRJNA597223_P_NODE_5384_length_752_cov_3.316597_g4121_i0	PRJNA597223	5384	752	3.316597	24.94080944	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	102	7.38e-17	NTclustered	gi\|29372944\|gb\|AY226274.1\|	156588	g4121	i0	92.958	9.29255319148936	71	4	9	1	344	414	106	175	Uncultured Verrucomicrobia bacterium clone BBBB-96 16S ribosomal RNA gene, partial sequence	blastn	6988	102	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
4397229	4397229	PRJNA597223_P_NODE_8724_length_589_cov_4.608303_g7161_i0	PRJNA597223	8724	589	4.608303	27.14290467	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	802	0	NTclustered	gi\|226525317\|gb\|FJ872374.1\|	156588	g7161	i0	91.246	192.089983022071	594	45	100	7	1	589	2974	2383	Uncultured Verrucomicrobia bacterium clone 184 genomic sequence	blastn	113141	802	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
5672669	5672669	PRJNA597223_P_NODE_21285_length_347_cov_3.660256_g19447_i0	PRJNA597223	21285	347	3.660256	12.70108832	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	383	1.0299999999999998e-101	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g19447	i0	86.994	84.492795389049	346	38	98	5	9	347	1315673	1315328	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	29319	383	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
5672709	5672709	PRJNA597223_P_NODE_24965_length_312_cov_78.519856_g23121_i0	PRJNA597223	24965	312	78.519856	244.98195072	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	499	8.67e-137	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g23121	i0	96.078	137.673076923077	306	12	98	0	7	312	736152	736457	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	42954	499	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
6947289	6947289	PRJNA597223_P_NODE_37986_length_234_cov_1.984925_g36140_i0	PRJNA597223	37986	234	1.984925	4.6447245	Opitutus sp. VeGlc2	134634	Bacteria	Bacteria	396	8.4e-106	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g36140	i0	97.425	42.4615384615385	233	5	99	1	2	234	2339	2108	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	9936	396	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
10773424	10773424	PRJNA597223_P_NODE_4289_length_842_cov_17.710037_g3177_i0	PRJNA597223	4289	842	17.710037	149.11851154	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	830	0	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g3177	i0	84.831	105.823040380048	857	95	99	24	1	838	3832760	3833600	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	89103	830	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
11344084	11344084	PRJNA597223_P_NODE_50929_length_195_cov_2.600000_g49083_i0	PRJNA597223	50929	195	2.6	5.07	Verrucomicrobiales	48461	Bacteria	Bacteria	305	1.17e-78	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g49083	i0	94.872	287.994871794872	195	10	100	0	1	195	3413010	3412816	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	56159	305	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
13322777	13322777	PRJNA597223_P_NODE_18071_length_386_cov_2.299145_g16250_i0	PRJNA597223	18071	386	2.299145	8.8746997	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	342	1.95e-89	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g16250	i0	91.27	79.1735751295337	252	20	65	2	135	386	3992475	3992226	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	30561	342	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
13323534	13323534	PRJNA597223_P_NODE_9411_length_566_cov_30.555556_g7801_i0	PRJNA597223	9411	566	30.555556	172.94444696	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	889	0	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g7801	i0	95.993	101.28445229682	549	18	97	3	1	548	736424	736969	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	57327	889	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
17147013	17147013	PRJNA597223_P_NODE_63534_length_182_cov_1.360544_g61688_i0	PRJNA597223	63534	182	1.360544	2.47619008	Rubellicoccus peritrichatus	3080537	Bacteria	Bacteria	99	1.96e-16	NTclustered	gi\|2605121622\|gb\|CP136920.1\|	3080537	g61688	i0	90.667	60.3846153846154	75	5	41	2	1	74	2162624	2162551	Rubellicoccus peritrichatus strain CR14 isolate coral tank chromosome, complete genome	blastn	10990	99	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Rubellicoccus	Rubellicoccus peritrichatus
17718594	17718594	PRJNA597223_P_NODE_54554_length_189_cov_2.954545_g52708_i0	PRJNA597223	54554	189	2.954545	5.58409005	root	1	Root_unresolved	Root_unresolved	135	1.57e-27	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g52708	i0	100	21.8201058201058	73	0	89	0	115	187	973	901	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	4124	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
21542610	21542610	PRJNA597223_P_NODE_50477_length_196_cov_2.826087_g48631_i0	PRJNA597223	50477	196	2.826087	5.53913052	Akkermansia	239934	Bacteria	Bacteria	143	9.779999999999999e-30	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g48631	i0	90.09	167.632653061224	111	9	56	2	52	160	139780	139890	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	32856	143	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
22246242	22246242	PRJNA597223_P_NODE_43618_length_214_cov_2.229050_g41772_i0	PRJNA597223	43618	214	2.22905	4.770167	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	298	2.19e-76	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g41772	i0	93.5	8.52803738317757	200	13	93	0	15	214	915039	914840	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	1825	298	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23521832	23521832	PRJNA597223_P_NODE_77779_length_160_cov_2.280000_g75933_i0	PRJNA597223	77779	160	2.28	3.648	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	195	2.08e-45	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g75933	i0	89.61	33.325	154	14	96	2	7	159	5636712	5636864	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	5332	195	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
25366947	25366947	PRJNA597223_P_NODE_12280_length_487_cov_4.780973_g10542_i0	PRJNA597223	12280	487	4.780973	23.28333851	Pseudomonadati	3379134	Bacteria	Bacteria	634	3.709999999999999e-177	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g10542	i0	90.144	189.094455852156	487	48	100	0	1	487	1728872	1728386	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	92089	638	0.993730407523511	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
25366996	25366996	PRJNA597223_P_NODE_33660_length_254_cov_1.881279_g31814_i0	PRJNA597223	33660	254	1.881279	4.77844866	Bacteria	2	Bacteria	Bacteria	99	2.92e-16	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g31814	i0	90.541	10.0196850393701	74	7	29	0	24	97	546560	546633	Lacunisphaera limnophila strain IG16b, complete genome	blastn	2545	99	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila

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