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

11 rows where analysis = "blastn", bioproject = "PRJNA1002816" and tax_phylum = "Pseudomonadota"

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
152913	152913	PRJNA1002816_P_NODE_19261_length_246_cov_0.890173_g19101_i0	PRJNA1002816	19261	246	0.890173	2.18982558	Plesiomonas shigelloides	703	Bacteria	Bacteria	448	2.4299999999999995e-121	NTclustered	gi\|2050160876\|gb\|CP076372.1\|	703	g19101	i0	100	682.650406504065	242	0	99	0	5	246	335658	335417	Plesiomonas shigelloides strain Colony13 chromosome	blastn	167932	448	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Plesiomonas	Plesiomonas shigelloides
2276027	2276027	PRJNA1002816_P_NODE_20482_length_242_cov_0.911243_g20322_i0	PRJNA1002816	20482	242	0.911243	2.20520806	Vibrio	662	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2271101951\|dbj\|AP024905.1\|	184755	g20322	i0	100	0.347107438016529	28	0	12	0	162	189	502138	502165	Vibrio ruber LMG 23124 DNA, chromosome 1, complete sequence	blastn	84	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio ruber
2703027	2703027	PRJNA1002816_P_NODE_13443_length_300_cov_1.775330_g13283_i0	PRJNA1002816	13443	300	1.77533	5.32599	Marinobacter sp. MMG032	3158548	Bacteria	Bacteria	159	1.6e-34	NTclustered	gi\|2741296914\|gb\|CP157802.1\|	3158548	g13283	i0	79.386	14.8733333333333	228	45	76	2	74	300	3240152	3239926	Marinobacter sp. MMG032 chromosome, complete genome	blastn	4462	159	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Marinobacteraceae	Marinobacter	Marinobacter sp. MMG032
2703070	2703070	PRJNA1002816_P_NODE_15783_length_271_cov_1.545455_g15623_i0	PRJNA1002816	15783	271	1.545455	4.18818305	Candidatus Stammera capleta	2608262	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2676815323\|gb\|CP144799.1\|	2608262	g15623	i0	100	0.206642066420664	28	0	10	0	178	205	146767	146794	MAG: Candidatus Stammera capleta isolate KBEPEHBJ chromosome	blastn	56	52.8	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Stammera	Candidatus Stammera capleta
2703294	2703294	PRJNA1002816_P_NODE_9303_length_367_cov_1.418367_g9143_i0	PRJNA1002816	9303	367	1.418367	5.20540689	Plesiomonas shigelloides	703	Bacteria	Bacteria	662	0	NTclustered	gi\|1037176310\|emb\|LT575468.1\|	703	g9143	i0	99.183	705.967302452316	367	3	100	0	1	367	2138623	2138989	Plesiomonas shigelloides strain NCTC10360 genome assembly, chromosome: 1	blastn	259090	662	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Plesiomonas	Plesiomonas shigelloides
11204222	11204222	PRJNA1002816_P_NODE_6969_length_429_cov_1.244382_g6809_i0	PRJNA1002816	6969	429	1.244382	5.33839878	Vibrio	662	Bacteria	Bacteria	765	0	NTclustered	gi\|1821214403\|gb\|CP049913.1\|	2714948	g6809	i0	98.834	896.107226107226	429	5	100	0	1	429	1044593	1045021	Vibrio sp. HDW18 chromosome, complete genome	blastn	384430	771	0.992217898832685	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio sp. HDW18
13754287	13754287	PRJNA1002816_P_NODE_15391_length_276_cov_1.413793_g15231_i0	PRJNA1002816	15391	276	1.413793	3.90206868	Escherichia	561	Bacteria	Bacteria	510	3.48e-140	NTclustered	gi\|2577445669\|gb\|CP115178.1\|	562	g15231	i0	100	58	276	0	100	0	1	276	3014777	3015052	Escherichia coli strain B chromosome, complete genome	blastn	16008	510	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
18004481	18004481	PRJNA1002816_P_NODE_11875_length_322_cov_0.879518_g11715_i0	PRJNA1002816	11875	322	0.879518	2.83204796	Plesiomonas shigelloides	703	Bacteria	Bacteria	595	1.1099999999999995e-165	NTclustered	gi\|2050160876\|gb\|CP076372.1\|	703	g11715	i0	100	776.748447204969	322	0	100	0	1	322	334578	334257	Plesiomonas shigelloides strain Colony13 chromosome	blastn	250113	595	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Plesiomonas	Plesiomonas shigelloides
19278498	19278498	PRJNA1002816_P_NODE_21136_length_226_cov_2.117647_g20976_i0	PRJNA1002816	21136	226	2.117647	4.78588222	Candidatus Desulfobacillus denitrificans	2608985	Bacteria	Bacteria	147	8.97e-31	NTclustered	gi\|1996214876\|dbj\|AP021857.1\|	2608985	g20976	i0	81.152	70.0265486725664	191	29	82	3	14	199	1499273	1499085	Candidatus Desulfobacillus denitrificans DNA, complete genome	blastn	15826	147	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria			Candidatus Desulfobacillus	Candidatus Desulfobacillus denitrificans
20127334	20127334	PRJNA1002816_P_NODE_20716_length_241_cov_1.214286_g20556_i0	PRJNA1002816	20716	241	1.214286	2.92642926	root	1	Root_unresolved	Root_unresolved	444	3.06e-120	NTclustered	gi\|922671885\|gb\|KP967513.1\|	703	g20556	i0	100	130.45643153527	240	0	99	0	1	240	7	246	Plesiomonas shigelloides strain M_S_TSA_21-14 16S ribosomal RNA gene, partial sequence	blastn	31440	444	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Plesiomonas	Plesiomonas shigelloides
20127349	20127349	PRJNA1002816_P_NODE_6576_length_442_cov_2.352304_g6416_i0	PRJNA1002816	6576	442	2.352304	10.39718368	Betaproteobacteria	28216	Bacteria	Bacteria	782	0	NTclustered	gi\|1218526113\|gb\|CP022423.1\|	63	g6416	i0	98.643	203.316742081448	442	5	99	1	2	442	637026	637467	Vitreoscilla filiformis strain ATCC 15551, complete genome	blastn	89866	789	0.991128010139417	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Vitreoscilla	Vitreoscilla filiformis

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