metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA492280" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA492280" 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
452178	452178	PRJNA492280_P_NODE_4301_length_242_cov_3.521951_g4194_i0	PRJNA492280	4301	242	3.521951	8.52312142	Prosthecobacter debontii	48467	Bacteria	Bacteria	390	4.0699999999999996e-104	NTclustered	gi\|164510703\|emb\|AJ966882.1\|	48467	g4194	i0	96.61	276.351239669421	236	6	97	1	1	234	3198	2963	Prosthecobacter debontii 16S rRNA gene (partial), 23S rRNA gene (partial), tRNA-Ala gene, tRNA-Ile gene and ITS1, strain DSM 14044	blastn	66877	390	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter debontii
1726772	1726772	PRJNA492280_P_NODE_28882_length_153_cov_3.344828_g28775_i0	PRJNA492280	28882	153	3.344828	5.11758684	Chthoniobacter flavus	191863	Bacteria	Bacteria	261	1.91e-65	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g28775	i0	98	260.307189542484	150	3	98	0	4	153	2220	2369	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	39827	261	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
1726868	1726868	PRJNA492280_P_NODE_5542_length_218_cov_4.348066_g5435_i0	PRJNA492280	5542	218	4.348066	9.47878388	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	261	2.94e-65	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g5435	i0	89.767	176.619266055046	215	6	99	1	3	217	2297	2099	Luteolibacter sp. SL250 chromosome	blastn	38503	261	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
3002699	3002699	PRJNA492280_P_NODE_263_length_782_cov_5.281879_g204_i0	PRJNA492280	263	782	5.281879	41.30429378	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	475	3.929999999999999e-129	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g204	i0	81.219	120.846547314578	607	98	87	16	1	597	16659	17259	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	94502	475	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
3002805	3002805	PRJNA492280_P_NODE_3403_length_264_cov_2.546256_g3296_i0	PRJNA492280	3403	264	2.546256	6.72211584	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	368	2.11e-97	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g3296	i0	92.278	236.545454545455	259	20	98	0	3	261	2404	2146	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	62448	368	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
4279157	4279157	PRJNA492280_P_NODE_4284_length_242_cov_6.458537_g4177_i0	PRJNA492280	4284	242	6.458537	15.62965954	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	322	1.5e-83	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g4177	i0	91.453	133.190082644628	234	20	97	0	4	237	3894369	3894136	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	32232	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4279191	4279191	PRJNA492280_P_NODE_6604_length_202_cov_5.478788_g6497_i0	PRJNA492280	6604	202	5.478788	11.06715176	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	329	7.25e-86	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g6497	i0	96.482	283.049504950495	199	7	99	0	2	200	2099	2297	Luteolibacter sp. SL250 chromosome	blastn	57176	329	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
5555450	5555450	PRJNA492280_P_NODE_11525_length_164_cov_10.141732_g11418_i0	PRJNA492280	11525	164	10.141732	16.63244048	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	62.1	2.27e-5	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g11418	i0	91.111	0.274390243902439	45	4	27	0	117	161	1545149	1545105	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	45	62.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
5555462	5555462	PRJNA492280_P_NODE_125_length_1140_cov_14.106074_g22_i1	PRJNA492280	125	1140	14.106074	160.8092436	Fontisphaera persica	2974023	Bacteria	Bacteria	1024	0	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g22	i1	84.848	153.784210526316	1023	128	88	18	141	1140	3862238	3861220	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	175314	1024	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
5555537	5555537	PRJNA492280_P_NODE_20845_length_164_cov_3.196850_g20738_i0	PRJNA492280	20845	164	3.19685	5.242834	Luteolibacter sp.	1962973	Bacteria	Bacteria	119	1.33e-22	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g20738	i0	100	8.86585365853658	64	0	39	0	1	64	1010219	1010282	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	1454	119	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
5555698	5555698	PRJNA492280_P_NODE_365_length_696_cov_5.602428_g204_i1	PRJNA492280	365	696	5.602428	38.99289888	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	475	3.48e-129	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g204	i1	81.219	135.778735632184	607	98	98	16	100	696	17259	16659	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	94502	475	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
10027145	10027145	PRJNA492280_P_NODE_17168_length_164_cov_3.913386_g17061_i0	PRJNA492280	17168	164	3.913386	6.4179530400000004	Coraliomargarita	442430	Bacteria	Bacteria	75	2.92e-9	NTclustered	gi\|470486190\|ref\|NR_076741.1\|	395922	g17061	i0	87.879	17.0914634146341	66	4	39	3	13	76	309	372	Coraliomargarita akajimensis strain 04OKA010-24 23S ribosomal RNA gene, complete sequence	blastn	2803	75	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Coraliomargaritaceae	Coraliomargarita	Coraliomargarita akajimensis
10027384	10027384	PRJNA492280_P_NODE_4868_length_230_cov_4.554404_g4761_i0	PRJNA492280	4868	230	4.554404	10.4751292	Luteolibacter	518753	Bacteria	Bacteria	217	6.88e-52	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g4761	i0	94.928	83.1695652173913	138	7	91	0	82	219	2216544	2216681	Luteolibacter sp. LG18 DNA, complete genome	blastn	19129	219	0.990867579908676	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
10655794	10655794	PRJNA492280_P_NODE_33809_length_150_cov_3.619469_g33702_i0	PRJNA492280	33809	150	3.619469	5.4292035	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	130	5.49e-26	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g33702	i0	98.63	0.98	73	1	97	0	4	76	4463778	4463850	Luteolibacter sp. SL250 chromosome	blastn	147	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
11930748	11930748	PRJNA492280_P_NODE_6150_length_208_cov_3.970760_g6043_i0	PRJNA492280	6150	208	3.97076	8.2591808	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	272	1.28e-68	NTclustered	gi\|164510704\|emb\|AJ966883.1\|	48466	g6043	i0	91.045	438.692307692308	201	18	97	0	3	203	4806	4606	Prosthecobacter vanneervenii 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 12252	blastn	91248	272	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
13205849	13205849	PRJNA492280_P_NODE_4991_length_227_cov_8.836842_g4884_i0	PRJNA492280	4991	227	8.836842	20.05963134	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	206	1.4699999999999998e-48	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g4884	i0	96.748	55.8810572687225	123	4	54	0	9	131	2750196	2750318	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	12685	206	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
14480622	14480622	PRJNA492280_P_NODE_27572_length_161_cov_4.717742_g27465_i0	PRJNA492280	27572	161	4.717742	7.59556462	Haloferula helveola	490095	Bacteria	Bacteria	115	1.68e-21	NTclustered	gi\|2647781590\|dbj\|AP024702.1\|	490095	g27465	i0	80.503	109.347826086957	159	23	98	7	1	158	774773	774924	Haloferula helveola CN-1 DNA, complete genome	blastn	17605	115	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula helveola
15127134	15127134	PRJNA492280_P_NODE_7732_length_189_cov_5.815789_g7625_i0	PRJNA492280	7732	189	5.815789	10.99184121	Chthoniobacter	295577	Bacteria	Bacteria	307	3.1300000000000003e-79	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g7625	i0	96.739	465.291005291005	184	6	97	0	6	189	16836	16653	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	87940	307	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
15754511	15754511	PRJNA492280_P_NODE_15573_length_164_cov_4.385827_g15466_i0	PRJNA492280	15573	164	4.385827	7.19275628	Pedosphaera parvula	1032527	Bacteria	Bacteria	141	2.84e-29	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g15466	i0	82.32	1.10365853658537	181	15	100	5	1	164	1099	919	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	181	141	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
17029418	17029418	PRJNA492280_P_NODE_6814_length_199_cov_8.358025_g6707_i0	PRJNA492280	6814	199	8.358025	16.63246975	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	152	1.66e-32	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g6707	i0	91.818	26.6180904522613	110	7	54	2	89	196	3833488	3833597	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	5297	152	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
17676469	17676469	PRJNA492280_P_NODE_1554_length_356_cov_3.354232_g1448_i0	PRJNA492280	1554	356	3.354232	11.94106592	Chthoniobacter	295577	Bacteria	Bacteria	165	4.15e-36	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g1448	i0	98.913	49.2584269662921	92	1	26	0	261	352	16955	17046	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	17536	165	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
18303697	18303697	PRJNA492280_P_NODE_32835_length_150_cov_4.946903_g32728_i0	PRJNA492280	32835	150	4.946903	7.4203545	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	226	6.8e-55	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g32728	i0	94	235.68	150	8	99	1	2	150	1319926	1320075	Luteolibacter sp. Populi chromosome, complete genome	blastn	35352	226	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
18303736	18303736	PRJNA492280_P_NODE_4995_length_227_cov_7.347368_g4888_i0	PRJNA492280	4995	227	7.347368	16.67852536	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	206	1.4699999999999998e-48	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g4888	i0	96.748	56.1409691629956	123	4	54	0	97	219	2750318	2750196	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	12744	206	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
19577995	19577995	PRJNA492280_P_NODE_8696_length_180_cov_9.713287_g8589_i0	PRJNA492280	8696	180	9.713287	17.4839166	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	158	3.1499999999999993e-34	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g8589	i0	82.778	57.1	180	27	98	4	4	180	2418	2240	Luteolibacter sp. SL250 chromosome	blastn	10278	158	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
22128456	22128456	PRJNA492280_P_NODE_3198_length_270_cov_18.806867_g3091_i0	PRJNA492280	3198	270	18.806867	50.7785409	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	405	1.65e-108	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g3091	i0	94.318	103.8	264	15	98	0	1	264	3992113	3991850	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	28026	405	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
23404188	23404188	PRJNA492280_P_NODE_16959_length_164_cov_3.968504_g16852_i0	PRJNA492280	16959	164	3.968504	6.50834656	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	95.3	2.24e-15	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g16852	i0	95	0.652439024390244	60	3	37	0	90	149	3447827	3447886	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	107	95.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23404318	23404318	PRJNA492280_P_NODE_2899_length_280_cov_7.037037_g2792_i0	PRJNA492280	2899	280	7.037037	19.7037036	Pedosphaera parvula	1032527	Bacteria	Bacteria	281	3.02e-71	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g2792	i0	85.821	121.828571428571	268	35	95	3	14	280	1951	2216	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	34112	281	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula

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