metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA560932" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA560932" 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
1820418	1820418	PRJNA560932_P_NODE_4282_length_825_cov_2.425532_g3978_i0	PRJNA560932	4282	825	2.425532	20.010639	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	1386	0	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g3978	i0	97.192	111.718787878788	819	23	99	0	7	825	3558031	3557213	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	92168	1386	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
1820569	1820569	PRJNA560932_P_NODE_6722_length_666_cov_2.156830_g6371_i0	PRJNA560932	6722	666	2.15683	14.3644878	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	1081	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g6371	i0	95.946	253.45045045045	666	27	100	0	1	666	194	859	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	168798	1081	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
3681890	3681890	PRJNA560932_P_NODE_52503_length_251_cov_0.865169_g52147_i0	PRJNA560932	52503	251	0.865169	2.17157419	Verrucomicrobiota	74201	Bacteria	Bacteria	246	9.72e-61	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g52147	i0	87.156	75.3625498007968	218	27	86	1	35	251	1316133	1315916	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	18916	246	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4372196	4372196	PRJNA560932_P_NODE_48944_length_260_cov_1.459893_g48588_i0	PRJNA560932	48944	260	1.459893	3.7957218	Luteolibacter sp.	1962973	Bacteria	Bacteria	104	6.45e-18	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g48588	i0	86.458	0.830769230769231	96	11	37	2	7	101	2693427	2693333	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	216	104	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
4372206	4372206	PRJNA560932_P_NODE_50044_length_256_cov_2.311475_g49688_i0	PRJNA560932	50044	256	2.311475	5.917376	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	466	7.01e-127	NTclustered	gi\|312861021\|gb\|HM750069.1\|	156588	g49688	i0	99.608	99.671875	255	1	99	0	2	256	509	255	Uncultured Verrucomicrobia bacterium clone PS06-10-84 16S ribosomal RNA gene, partial sequence	blastn	25516	466	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
13298946	13298946	PRJNA560932_P_NODE_7931_length_616_cov_1.351750_g7578_i0	PRJNA560932	7931	616	1.35175	8.32678	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	481	6.57e-131	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g7578	i0	81.697	96.9675324675325	601	89	95	19	1	587	1903690	1904283	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	59732	481	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
14573726	14573726	PRJNA560932_P_NODE_49312_length_259_cov_1.241935_g48956_i0	PRJNA560932	49312	259	1.241935	3.21661165	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	348	2.69e-91	NTclustered	gi\|2874254040\|emb\|OY970364.1\|	412056	g48956	i0	91.085	187.660231660232	258	21	99	2	2	259	2168625	2168370	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1	blastn	48604	348	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15158579	15158579	PRJNA560932_P_NODE_30072_length_329_cov_0.902344_g29716_i0	PRJNA560932	30072	329	0.902344	2.96871176	Verrucomicrobiota	74201	Bacteria	Bacteria	451	2.61e-122	NTclustered	gi\|470483113\|ref\|NR_076574.1\|	107709	g29716	i0	92.949	75.8297872340426	312	18	94	4	1	310	467	158	Opitutus terrae strain PB90-1 23S ribosomal RNA gene, complete sequence	blastn	24948	451	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
15847551	15847551	PRJNA560932_P_NODE_39753_length_289_cov_1.004630_g39397_i0	PRJNA560932	39753	289	1.00463	2.9033807	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	484	2.2299999999999998e-132	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g39397	i0	96.886	41.1314878892734	289	9	100	0	1	289	348	60	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	11887	484	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
21532542	21532542	PRJNA560932_P_NODE_27937_length_339_cov_2.003759_g27581_i0	PRJNA560932	27937	339	2.003759	6.79274301	Prosthecobacter	48463	Bacteria	Bacteria	551	2.589999999999999e-152	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g27581	i0	96.142	59.4188790560472	337	13	99	0	1	337	1159	1495	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	20143	551	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
22221943	22221943	PRJNA560932_P_NODE_65378_length_242_cov_0.911243_g65022_i0	PRJNA560932	65378	242	0.911243	2.20520806	Opitutus terrae	107709	Bacteria	Bacteria	156	1.6200000000000002e-33	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g65022	i0	87.143	4.4504132231405	140	15	57	3	104	242	1181588	1181451	Opitutus terrae PB90-1, complete genome	blastn	1077	156	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae

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