metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA980839" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA980839" 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
2232372	2232372	PRJNA980839_P_NODE_130202_length_310_cov_1.130802_g126418_i0	PRJNA980839	130202	310	1.130802	3.5054862	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	291	5.64e-74	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g126418	i0	92.965	81.9709677419355	199	14	64	0	1	199	1316193	1316391	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	25411	291	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
2232381	2232381	PRJNA980839_P_NODE_130642_length_309_cov_1.741525_g126858_i0	PRJNA980839	130642	309	1.741525	5.38131225	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	296	1.21e-75	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g126858	i0	84.039	13.2330097087379	307	49	99	0	1	307	3621055	3621361	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	4089	296	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
6061937	6061937	PRJNA980839_P_NODE_211285_length_248_cov_0.880000_g207501_i0	PRJNA980839	211285	248	0.88	2.1824	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	276	1.22e-69	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g207501	i0	86.992	1.10483870967742	246	30	99	2	1	245	825058	825302	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	274	276	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
7336336	7336336	PRJNA980839_P_NODE_206506_length_249_cov_0.875000_g202722_i0	PRJNA980839	206506	249	0.875	2.17875	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	340	4.29e-89	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g202722	i0	91.532	287.060240963855	248	20	99	1	1	248	5625211	5625457	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	71478	340	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
12436607	12436607	PRJNA980839_P_NODE_150230_length_287_cov_1.205607_g146446_i0	PRJNA980839	150230	287	1.205607	3.46009209	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	161	4.23e-35	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g146446	i0	77.551	1.02439024390244	294	49	99	15	3	287	81926	82211	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	294	161	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
12437359	12437359	PRJNA980839_P_NODE_188190_length_257_cov_1.326087_g184406_i0	PRJNA980839	188190	257	1.326087	3.40804359	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	272	1.65e-68	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g184406	i0	86.275	24.9377431906615	255	30	98	5	7	257	4348224	4348477	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	6409	272	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
12437669	12437669	PRJNA980839_P_NODE_205110_length_249_cov_1.034091_g201326_i0	PRJNA980839	205110	249	1.034091	2.57488659	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	248	2.68e-61	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g201326	i0	85.837	72.710843373494	233	33	94	0	7	239	2749842	2750074	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	18105	248	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
12438581	12438581	PRJNA980839_P_NODE_32230_length_884_cov_2.512947_g28900_i0	PRJNA980839	32230	884	2.512947	22.21445148	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	361	1.3e-94	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g28900	i0	85.237	2.92194570135747	359	44	41	4	521	879	3215874	3216223	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	2583	361	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
13713204	13713204	PRJNA980839_P_NODE_39911_length_734_cov_1.679274_g36316_i0	PRJNA980839	39911	734	1.679274	12.32587116	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	464	7.969999999999999e-126	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g36316	i0	78.562	10.224795640327	723	142	97	11	20	734	2332685	2333402	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	7505	464	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
16261608	16261608	PRJNA980839_P_NODE_215253_length_247_cov_0.885057_g211469_i0	PRJNA980839	215253	247	0.885057	2.18609079	Pedosphaera parvula	1032527	Bacteria	Bacteria	276	1.22e-69	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g211469	i0	91.133	29.8380566801619	203	18	82	0	30	232	1459	1257	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	7370	276	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
17537098	17537098	PRJNA980839_P_NODE_240214_length_240_cov_2.215569_g236430_i0	PRJNA980839	240214	240	2.215569	5.3173656	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	154	5.75e-33	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g236430	i0	84.177	1.70833333333333	158	25	66	0	1	158	4559529	4559686	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	410	154	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
22634961	22634961	PRJNA980839_P_NODE_172698_length_268_cov_1.620513_g168914_i0	PRJNA980839	172698	268	1.620513	4.34297484	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	364	2.769999999999999e-96	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g168914	i0	91.386	254.462686567164	267	21	99	2	4	268	3832556	3832822	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	68196	364	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae 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);;