metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA549880" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA549880" and tax_phylum = "Bacteroidota"

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
3062937	3062937	PRJNA549880_P_NODE_9103_length_269_cov_1.229592_g9010_i0	PRJNA549880	9103	269	1.229592	3.30760248	Muribaculaceae bacterium MF13079	2767078	Bacteria	Bacteria	185	2.3299999999999993e-42	NTclustered	gi\|2320761719\|gb\|CP061009.1\|	2767078	g9010	i0	80.478	2.30855018587361	251	41	92	8	6	252	286363	286117	Muribaculaceae bacterium MF13079 chromosome, complete genome	blastn	621	185	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Muribaculaceae		Muribaculaceae bacterium MF13079
4947722	4947722	PRJNA549880_P_NODE_12584_length_247_cov_0.885057_g12491_i0	PRJNA549880	12584	247	0.885057	2.18609079	Hymenobacteraceae	1853232	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|27497649\|gb\|AY167829.1\|	217083	g12491	i0	100	107.008097165992	247	0	100	0	1	247	215	461	Hymenobacter sp. SAFR-033 16S ribosomal RNA gene, partial sequence	blastn	26431	457	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. SAFR-033
4947729	4947729	PRJNA549880_P_NODE_13164_length_246_cov_0.890173_g13071_i0	PRJNA549880	13164	246	0.890173	2.18982558	Chryseobacterium	59732	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|1966888383\|gb\|CP068486.1\|	250	g13071	i0	99.593	96.9024390243902	246	1	100	0	1	246	2961765	2962010	Chryseobacterium gleum strain FDAARGOS_1103 chromosome	blastn	23838	449	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gleum
5615630	5615630	PRJNA549880_P_NODE_12545_length_247_cov_0.885057_g12452_i0	PRJNA549880	12545	247	0.885057	2.18609079	Chryseobacterium sp. M5	3379128	Bacteria	Bacteria	300	7.22e-77	NTclustered	gi\|2853920187\|gb\|CP173626.1\|	3379128	g12452	i0	88.664	8.02024291497976	247	27	99	1	1	246	3556333	3556087	Chryseobacterium sp. M5 chromosome, complete genome	blastn	1981	300	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. M5
9440239	9440239	PRJNA549880_P_NODE_1868_length_523_cov_2.691111_g1775_i0	PRJNA549880	1868	523	2.691111	14.07451053	Pontibacter akesuensis	388950	Bacteria	Bacteria	878	0	NTclustered	gi\|1015602746\|gb\|CP014766.1\|	388950	g1775	i0	96.941	293.286806883365	523	16	100	0	1	523	1433637	1433115	Pontibacter akesuensis strain AKS 1T, complete genome	blastn	153389	878	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Pontibacter	Pontibacter akesuensis
13265639	13265639	PRJNA549880_P_NODE_11151_length_250_cov_0.870056_g11058_i0	PRJNA549880	11151	250	0.870056	2.17514	Sphingobacterium spiritivorum	258	Bacteria	Bacteria	374	4.2499999999999986e-99	NTclustered	gi\|1958211526\|gb\|CP068082.1\|	258	g11058	i0	93.6	3	250	16	100	0	1	250	2149015	2149264	Sphingobacterium spiritivorum strain FDAARGOS_1146 chromosome, complete genome	blastn	750	374	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium spiritivorum
13265911	13265911	PRJNA549880_P_NODE_9431_length_264_cov_1.612565_g9338_i0	PRJNA549880	9431	264	1.612565	4.2571716	Pontibacter russatus	2694929	Bacteria	Bacteria	405	1.61e-108	NTclustered	gi\|1802158094\|gb\|CP047984.1\|	2694929	g9338	i0	94.361	241.223484848485	266	11	100	4	1	264	1999059	1998796	Pontibacter russatus strain BT326 chromosome, complete genome	blastn	63683	405	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Pontibacter	Pontibacter russatus
14540601	14540601	PRJNA549880_P_NODE_10712_length_251_cov_0.865169_g10619_i0	PRJNA549880	10712	251	0.865169	2.17157419	Aquimarina sp. TRL1	2736252	Bacteria	Bacteria	89.8	1.73e-13	NTclustered	gi\|1860281542\|gb\|CP053590.1\|	2736252	g10619	i0	89.041	1.09163346613546	73	6	29	2	76	147	5284046	5283975	Aquimarina sp. TRL1 chromosome, complete genome	blastn	274	89.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aquimarina	Aquimarina sp. TRL1
14540788	14540788	PRJNA549880_P_NODE_5392_length_334_cov_1.869732_g5299_i0	PRJNA549880	5392	334	1.869732	6.24490488	Prevotella intermedia	28131	Bacteria	Bacteria	562	1.18e-155	NTclustered	gi\|1276670087\|gb\|CP024728.1\|	28131	g5299	i0	97.015	260.559880239521	335	9	100	1	1	334	274193	273859	Prevotella intermedia strain KCOM 1949 chromosome 2, complete sequence	blastn	87027	562	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella intermedia
15814829	15814829	PRJNA549880_P_NODE_9153_length_268_cov_1.553846_g9060_i0	PRJNA549880	9153	268	1.553846	4.16430728	Leadbetterella byssophila	316068	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|311905355\|gb\|CP002305.1\|	649349	g9060	i0	100	0.111940298507463	30	0	11	0	164	193	960711	960740	Leadbetterella byssophila DSM 17132, complete genome	blastn	30	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Leadbetterella	Leadbetterella byssophila
18971128	18971128	PRJNA549880_P_NODE_15235_length_242_cov_0.911243_g15142_i0	PRJNA549880	15235	242	0.911243	2.20520806	Bacteroidota	976	Bacteria	Bacteria	63.9	1.01e-5	NTclustered	gi\|1717444187\|gb\|CP031708.1\|	332999	g15142	i0	100	2.62809917355372	34	0	14	0	177	210	4925171	4925138	Pedobacter suwonensis strain Fj_001 chromosome, complete genome	blastn	636	63.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter suwonensis
19638061	19638061	PRJNA549880_P_NODE_12976_length_246_cov_0.890173_g12883_i0	PRJNA549880	12976	246	0.890173	2.18982558	Bacteroidales bacterium SW299	2510306	Bacteria	Bacteria	281	2.6000000000000007e-71	NTclustered	gi\|2729058721\|emb\|OZ007021.1\|	2510306	g12883	i0	87.5	327.715447154472	248	26	100	5	1	246	3143072	3142828	MAG: Bacteroidales bacterium SW299 isolate 6755_HET_CTRL_contig_977_metaflye_circ MAG genome assembly, chromosome: 1	blastn	80618	281	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium SW299
21521668	21521668	PRJNA549880_P_NODE_13637_length_245_cov_0.895349_g13544_i0	PRJNA549880	13637	245	0.895349	2.19360505	Chryseobacterium	59732	Bacteria	Bacteria	372	1.49e-98	NTclustered	gi\|1494289966\|gb\|CP033070.1\|	2478663	g13544	i0	94.262	93.734693877551	244	13	99	1	2	245	1666260	1666502	Chryseobacterium sp. 3008163 chromosome, complete genome	blastn	22965	375	0.992	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. 3008163
22188691	22188691	PRJNA549880_P_NODE_14058_length_244_cov_0.900585_g13965_i0	PRJNA549880	14058	244	0.900585	2.1974274	Flavobacterium sp. KACC 22758	3025667	Bacteria	Bacteria	274	4.31e-69	NTclustered	gi\|2446139215\|gb\|CP117878.1\|	3025667	g13965	i0	86.885	101.393442622951	244	32	100	0	1	244	164227	163984	Flavobacterium sp. KACC 22758 chromosome, complete genome	blastn	24740	274	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. KACC 22758

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