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

9 rows where analysis = "blastn", bioproject = "PRJNA390533" 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
1078182	1078182	PRJNA390533_P_NODE_43121_length_168_cov_3.434109_g42094_i0	PRJNA390533	43121	168	3.434109	5.76930312	Akkermansia	239934	Bacteria	Bacteria	176	8.03e-40	NTclustered	gi\|2756360508\|gb\|CP156688.1\|	239935	g42094	i0	86.792	87.2976190476191	159	20	94	1	1	158	360605	360763	Akkermansia muciniphila strain AKK-TMU chromosome, complete genome	blastn	14666	176	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
1684630	1684630	PRJNA390533_P_NODE_33562_length_218_cov_2.955307_g32535_i0	PRJNA390533	33562	218	2.955307	6.44256926	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	333	6.149999999999999e-87	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g32535	i0	95.673	3.8302752293578	208	8	95	1	3	209	2833869	2833662	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	835	333	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
6787213	6787213	PRJNA390533_P_NODE_1286_length_1418_cov_19.247281_g1060_i0	PRJNA390533	1286	1418	19.247281	272.92644458	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	1858	0	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g1060	i0	93.546	100.625528913963	1255	69	88	10	21	1270	1904241	1902994	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	142687	1858	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
8062941	8062941	PRJNA390533_P_NODE_2327_length_1163_cov_5.368327_g1965_i0	PRJNA390533	2327	1163	5.368327	62.43364301	Pedosphaera parvula	1032527	Bacteria	Bacteria	1068	0	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g1965	i0	86.053	172.313843508169	1011	121	86	17	27	1026	588	1589	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	200401	1068	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
13163648	13163648	PRJNA390533_P_NODE_50511_length_150_cov_1.810811_g49484_i0	PRJNA390533	50511	150	1.810811	2.7162165	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	121	3.3e-23	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g49484	i0	81.208	3.84	149	28	99	0	2	150	4834727	4834579	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	576	121	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15712257	15712257	PRJNA390533_P_NODE_18613_length_408_cov_1.878049_g17594_i0	PRJNA390533	18613	408	1.878049	7.66243992	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	220	1.01e-52	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g17594	i0	93.289	17.4852941176471	149	10	79	0	1	149	2750188	2750040	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	7134	220	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18929557	18929557	PRJNA390533_P_NODE_14675_length_488_cov_3.293987_g13685_i0	PRJNA390533	14675	488	3.293987	16.07465656	Verrucomicrobiaceae	203557	Bacteria	Bacteria	248	5.6599999999999994e-61	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g13685	i0	82.333	16.9262295081967	300	40	61	9	32	329	632291	632579	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	8260	250	0.992	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
23361649	23361649	PRJNA390533_P_NODE_1519_length_1341_cov_19.612903_g1060_i1	PRJNA390533	1519	1341	19.612903	263.00902923	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	1681	0	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g1060	i1	92.186	94.6368381804623	1203	73	89	18	1	1193	1904185	1902994	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	126908	1681	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
24636131	24636131	PRJNA390533_P_NODE_3100_length_1045_cov_5.204771_g1965_i1	PRJNA390533	3100	1045	5.204771	54.38985695	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1284	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g1965	i1	91.186	168.203827751196	953	73	91	11	27	973	1315514	1316461	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	175773	1284	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);;