metadata: contig_metadata: 17 rows where bioproject = "PRJEB7366" and tax

17 rows where bioproject = "PRJEB7366" 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
1409818	1409818	PRJEB7366_P_NODE_12502_length_227_cov_2.708333_g12068_i0	PRJEB7366	12502	227	2.708333	6.14791591	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	340	3.8499999999999996e-89	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g12068	i0	94.545	78.1850220264317	220	12	97	0	1	220	1403941	1403722	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	17748	340	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
1409819	1409819	PRJEB7366_P_NODE_12782_length_224_cov_1.904762_g12348_i0	PRJEB7366	12782	224	1.904762	4.26666688	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	327	2.95e-85	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g12348	i0	92.92	141.946428571429	226	14	100	1	1	224	1405134	1405359	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	31796	327	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
3546110	3546110	PRJEB7366_P_NODE_5723_length_374_cov_2.353982_g5290_i0	PRJEB7366	5723	374	2.353982	8.80389268	Opitutaceae	134623	Bacteria	Bacteria	669	0	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g5290	i0	98.93	196.580213903743	374	4	100	0	1	374	541410	541783	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	73521	675	0.991111111111111	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
5237805	5237805	PRJEB7366_P_NODE_20385_length_168_cov_2.045113_g19951_i0	PRJEB7366	20385	168	2.045113	3.43578984	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	250	4.66e-62	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g19951	i0	96.104	206.357142857143	154	5	91	1	1	153	1403983	1404136	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	34668	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
7373081	7373081	PRJEB7366_P_NODE_21286_length_164_cov_1.534884_g20852_i0	PRJEB7366	21286	164	1.534884	2.51720976	Verrucomicrobiales	48461	Bacteria	Bacteria	130	6.15e-26	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g20852	i0	81.437	128.90243902439	167	24	99	7	1	163	3411503	3411666	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	21140	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
9062500	9062500	PRJEB7366_P_NODE_11688_length_237_cov_3.366337_g11254_i0	PRJEB7366	11688	237	3.366337	7.97821869	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	348	2.4200000000000006e-91	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g11254	i0	93.939	32.3122362869198	231	13	97	1	1	231	1404909	1405138	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	7658	348	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
16711911	16711911	PRJEB7366_P_NODE_14334_length_208_cov_2.080925_g13900_i0	PRJEB7366	14334	208	2.080925	4.328324	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	351	1.6e-92	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g13900	i0	97.115	82.3413461538462	208	6	100	0	1	208	1404306	1404513	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	17127	351	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
17986867	17986867	PRJEB7366_P_NODE_6615_length_342_cov_1.638436_g6181_i0	PRJEB7366	6615	342	1.638436	5.60345112	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	399	1e-106	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g6181	i0	87.941	127.345029239766	340	39	99	2	1	339	3991679	3992017	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	43552	399	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
19260871	19260871	PRJEB7366_P_NODE_7936_length_305_cov_2.088889_g7502_i0	PRJEB7366	7936	305	2.088889	6.37111145	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	558	1.37e-154	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g7502	i0	99.672	97.5967213114754	305	1	100	0	1	305	1404828	1404524	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	29767	558	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
20536134	20536134	PRJEB7366_P_NODE_14457_length_207_cov_1.802326_g14023_i0	PRJEB7366	14457	207	1.802326	3.73081482	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	200	6.109999999999998e-47	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g14023	i0	91.724	178.299516908213	145	11	70	1	61	204	3990067	3990211	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	36908	200	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
26970711	26970711	PRJEB7366_P_NODE_12382_length_229_cov_1.329897_g11948_i0	PRJEB7366	12382	229	1.329897	3.04546413	Chthoniobacter sp.	2510640	Bacteria	Bacteria	110	4.33e-26	NR	MCE9611332.1	2510640	g11948	i0	71.2	2.86899563318777	73	21	95.6	0	1	219	587	659	MCE9611332.1 transketolase [Chthoniobacter sp.]	diamond	657	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
27318721	27318721	PRJEB7366_P_NODE_12903_length_223_cov_1.276596_g12469_i0	PRJEB7366	12903	223	1.276596	2.84680908	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	53.9	3.35e-6	NR	HEY1171809.1	2499141	g12469	i0	43.5	0.928251121076233	69	37	92.8	1	1	207	451	517	HEY1171809.1 ankyrin repeat domain-containing protein [Verrucomicrobiia bacterium]	diamond	207	53.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29837282	29837282	PRJEB7366_P_NODE_19871_length_171_cov_1.176471_g19437_i0	PRJEB7366	19871	171	1.176471	2.01176541	PVC group	1783257	Bacteria	Bacteria	52	7.56e-6	NR	MDB6077804.1	2562705	g19437	i0	47.5	1.94736842105263	59	27	96.5	2	169	5	133	191	MDB6077804.1 Por secretion system C-terminal sorting protein [Akkermansiaceae bacterium]	diamond	333	52.4	0.99236641221374	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
30097227	30097227	PRJEB7366_P_NODE_23072_length_156_cov_1.983471_g22638_i0	PRJEB7366	23072	156	1.983471	3.09421476	Verrucomicrobiota bacterium JB022	3064551	Bacteria	Bacteria	84.3	1.84e-17	NR	MDP0501723.1	3064551	g22638	i0	75	1	52	13	100	0	1	156	45	96	MDP0501723.1 ADP-forming succinate--CoA ligase subunit beta [Verrucomicrobiota bacterium JB022]	diamond	156	84.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium JB022
30855582	30855582	PRJEB7366_P_NODE_8654_length_288_cov_1.739130_g8220_i0	PRJEB7366	8654	288	1.73913	5.0086944	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	116	9.71e-28	NR	MEM9445814.1	2026799	g8220	i0	55	1.9375	100	41	100	1	288	1	510	609	MEM9445814.1 ATP-dependent chaperone ClpB [Verrucomicrobiota bacterium]	diamond	558	116	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32049999	32049999	PRJEB7366_P_NODE_10718_length_251_cov_1.944444_g10284_i0	PRJEB7366	10718	251	1.944444	4.88055444	Bacteria	2	Bacteria	Bacteria	90.1	8.98e-19	NR	MAD25628.1	2026801	g10284	i0	47.6	4.85258964143426	82	41	95.6	2	2	241	609	690	MAD25628.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	1218	90.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32563746	32563746	PRJEB7366_P_NODE_10699_length_251_cov_2.981481_g10265_i0	PRJEB7366	10699	251	2.981481	7.48351731	Oceaniferula flava	2800421	Bacteria	Bacteria	42.7	0.0407	NR	WP_309489737.1	2800421	g10265	i0	38.7	0.896414342629482	75	45	88.4	1	229	8	84	158	WP_309489737.1 polyamine aminopropyltransferase [Oceaniferula flava]	diamond	225	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Oceaniferula	Oceaniferula flava

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