metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1123309" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1123309" 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
2828849	2828849	PRJNA1123309_P_NODE_23963_length_327_cov_2.897638_g23583_i0	PRJNA1123309	23963	327	2.897638	9.47527626	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	390	5.74e-104	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g23583	i0	90.301	157.862385321101	299	28	91	1	28	325	28484	28186	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	51621	390	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
2829034	2829034	PRJNA1123309_P_NODE_39383_length_272_cov_1.412060_g39003_i0	PRJNA1123309	39383	272	1.41206	3.8408032	Opitutus terrae	107709	Bacteria	Bacteria	241	4.96e-59	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g39003	i0	84.274	3.99264705882353	248	37	91	2	11	257	2579638	2579884	Opitutus terrae PB90-1, complete genome	blastn	1086	241	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
4857006	4857006	PRJNA1123309_P_NODE_35904_length_281_cov_1.052885_g35524_i0	PRJNA1123309	35904	281	1.052885	2.95860685	Verrucomicrobiota	74201	Bacteria	Bacteria	119	2.52e-22	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g35524	i0	75.735	146.060498220641	272	46	95	13	1	268	632753	632498	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	41043	119	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
6656146	6656146	PRJNA1123309_P_NODE_32786_length_288_cov_1.446512_g32406_i0	PRJNA1123309	32786	288	1.446512	4.16595456	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	283	8.679999999999999e-72	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g32406	i0	87.149	55.2222222222222	249	32	86	0	6	254	2699536	2699288	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	15904	283	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
6656464	6656464	PRJNA1123309_P_NODE_65446_length_242_cov_1.698225_g65066_i0	PRJNA1123309	65446	242	1.698225	4.1097045	Pedosphaera parvula	1032527	Bacteria	Bacteria	364	2.4699999999999992e-96	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g65066	i0	94.85	112.074380165289	233	12	96	0	10	242	2116	2348	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	27122	364	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
10481764	10481764	PRJNA1123309_P_NODE_22229_length_338_cov_1.977358_g21850_i0	PRJNA1123309	22229	338	1.977358	6.68347004	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	309	1.71e-79	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g21850	i0	84.81	211.147928994083	316	38	92	9	28	338	2749776	2749466	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	71368	309	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15581010	15581010	PRJNA1123309_P_NODE_24993_length_322_cov_0.843373_g24613_i0	PRJNA1123309	24993	322	0.843373	2.71566106	Pedosphaera parvula	1032527	Bacteria	Bacteria	333	9.639999999999998e-87	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g24613	i0	87.205	76.4782608695652	297	32	91	6	29	322	1013	1306	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	24626	333	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
20680038	20680038	PRJNA1123309_P_NODE_63257_length_244_cov_0.912281_g62877_i0	PRJNA1123309	63257	244	0.912281	2.22596564	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	272	1.55e-68	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g62877	i0	86.939	4.3155737704918	245	29	100	3	1	244	1469882	1470124	Lacunisphaera limnophila strain IG16b, complete genome	blastn	1053	272	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
21431026	21431026	PRJNA1123309_P_NODE_60317_length_245_cov_1.418605_g59937_i0	PRJNA1123309	60317	245	1.418605	3.47558225	Verrucomicrobiota	74201	Bacteria	Bacteria	390	4.129999999999999e-104	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g59937	i0	96.234	106.126530612245	239	7	98	2	7	245	1882	2118	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	26001	390	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
24504137	24504137	PRJNA1123309_P_NODE_2520_length_862_cov_4.736375_g2249_i0	PRJNA1123309	2520	862	4.736375	40.8275525	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	1306	0	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g2249	i0	94.893	260.044083526682	842	32	97	10	5	843	25883	26716	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	224158	1306	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota 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);;