metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA312899" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA312899" 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
379551	379551	PRJNA312899_P_NODE_4181_length_868_cov_27.377289_g3901_i0	PRJNA312899	4181	868	27.377289	237.63486852	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	608	4.139999999999998e-169	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g3901	i0	84.516	17.7615207373272	620	90	94	6	253	868	5267309	5267926	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	15417	608	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2339682	2339682	PRJNA312899_P_NODE_26642_length_361_cov_5.711538_g26200_i0	PRJNA312899	26642	361	5.711538	20.61865218	Opitutaceae	134623	Bacteria	Bacteria	305	2.38e-78	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g26200	i0	84.566	4.79224376731302	311	44	86	3	46	354	1435291	1435599	Lacunisphaera limnophila strain IG16b, complete genome	blastn	1730	305	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
4206490	4206490	PRJNA312899_P_NODE_28644_length_346_cov_3.548822_g28202_i0	PRJNA312899	28644	346	3.548822	12.27892412	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	449	9.94e-122	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g28202	i0	90.173	155.28901734104	346	32	99	2	1	345	1729204	1728860	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	53730	449	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8033242	8033242	PRJNA312899_P_NODE_67527_length_199_cov_2.553333_g67085_i0	PRJNA312899	67527	199	2.553333	5.08113267	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	189	1.26e-43	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g67085	i0	84.158	290.949748743719	202	24	99	8	1	198	15390	15587	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	57899	189	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
12543244	12543244	PRJNA312899_P_NODE_54930_length_232_cov_1.114754_g54488_i0	PRJNA312899	54930	232	1.114754	2.58622928	Opitutaceae	134623	Bacteria	Bacteria	60.2	1.24e-4	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g54488	i0	97.222	0.836206896551724	36	0	15	1	151	185	2497348	2497313	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	194	60.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
12543570	12543570	PRJNA312899_P_NODE_83890_length_171_cov_1.672131_g83448_i0	PRJNA312899	83890	171	1.672131	2.85934401	Opitutia	414999	Bacteria	Bacteria	145	2.3e-30	NTclustered	gi\|2518551946\|emb\|OX638348.1\|	333967	g83448	i0	87.5	226.298245614035	128	12	74	4	38	164	4608477	4608353	MAG: uncultured Opitutaceae bacterium isolate b1b57f99-08c0-43d1-969e-fd0ef39b1292 genome assembly, chromosome: 1	blastn	38697	145	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		uncultured Opitutaceae bacterium
13818272	13818272	PRJNA312899_P_NODE_651_length_1639_cov_103.354717_g577_i0	PRJNA312899	651	1639	103.354717	1693.98381163	Verrucomicrobiota	74201	Bacteria	Bacteria	1543	0	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g577	i0	84.596	211.114093959732	1571	222	95	18	55	1616	1	1560	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	346016	1555	0.992282958199357	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
22055495	22055495	PRJNA312899_P_NODE_11738_length_552_cov_21.630219_g11314_i0	PRJNA312899	11738	552	21.630219	119.39880888	Opitutus sp. VeGlc2	134634	Bacteria	Bacteria	811	0	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g11314	i0	93.419	86.0905797101449	547	36	99	0	6	552	2530	1984	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	47522	811	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
24016306	24016306	PRJNA312899_P_NODE_31979_length_324_cov_14.392727_g31537_i0	PRJNA312899	31979	324	14.392727	46.63243548	Verrucomicrobiales	48461	Bacteria	Bacteria	409	1.57e-109	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g31537	i0	89.474	272.950617283951	323	34	99	0	1	323	3411091	3411413	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	88436	411	0.995133819951338	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae 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);;