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

9 rows where analysis = "blastn", bioproject = "PRJNA278119" and tax_kingdom = "Fusobacteriati"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2921943	2921943	PRJNA278119_P_NODE_29203_length_183_cov_1.544776_g28954_i0	PRJNA278119	29203	183	1.544776	2.82694008	Cetobacterium somerae	188913	Bacteria	Bacteria	315	1.8000000000000002e-81	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g28954	i0	97.814	57.3114754098361	183	3	100	1	1	183	420120	420301	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	10488	315	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
4886749	4886749	PRJNA278119_P_NODE_27884_length_187_cov_1.528986_g27635_i0	PRJNA278119	27884	187	1.528986	2.85920382	Cetobacterium	180162	Bacteria	Bacteria	346	6.56e-91	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g27635	i0	100	509.31550802139	187	0	100	0	1	187	278946	279132	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	95242	346	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11262051	11262051	PRJNA278119_P_NODE_4029_length_601_cov_2.577899_g3789_i0	PRJNA278119	4029	601	2.577899	15.49317299	Cetobacterium	180162	Bacteria	Bacteria	621	3.62e-173	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g3789	i0	94.763	364.053244592346	401	18	67	3	190	589	278441	278839	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	218796	621	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
15086431	15086431	PRJNA278119_P_NODE_33512_length_171_cov_2.040984_g33263_i0	PRJNA278119	33512	171	2.040984	3.49008264	Cetobacterium	180162	Bacteria	Bacteria	316	4.6e-82	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g33263	i0	100	499	171	0	100	0	1	171	280025	279855	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	85329	316	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16361201	16361201	PRJNA278119_P_NODE_15093_length_278_cov_2.314410_g14844_i0	PRJNA278119	15093	278	2.31441	6.4340598	Leptotrichia	32067	Bacteria	Bacteria	425	1.31e-114	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g14844	i0	94.245	224.438848920863	278	16	100	0	1	278	295	18	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	62394	425	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
16948762	16948762	PRJNA278119_P_NODE_35214_length_169_cov_0.866667_g34965_i0	PRJNA278119	35214	169	0.866667	1.46466723	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	196	6.16e-46	NTclustered	gi\|1276709865\|gb\|CP024700.1\|	2663009	g34965	i0	97.391	16.1420118343195	115	3	100	0	1	115	1054303	1054417	Fusobacterium pseudoperiodonticum strain KCOM 1263 chromosome, complete genome	blastn	2728	196	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
19496957	19496957	PRJNA278119_P_NODE_10356_length_362_cov_3.591054_g10109_i0	PRJNA278119	10356	362	3.591054	12.99961548	Leptotrichia wadei	157687	Bacteria	Bacteria	656	0	NTclustered	gi\|1708577445\|dbj\|AP019835.1\|	157687	g10109	i0	99.446	499.729281767956	361	2	99	0	2	362	2369119	2369479	Leptotrichia wadei JMUB3934 DNA, complete genome	blastn	180902	656	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
20772468	20772468	PRJNA278119_P_NODE_11377_length_342_cov_1.774744_g11129_i0	PRJNA278119	11377	342	1.774744	6.06962448	Leptotrichia wadei	157687	Bacteria	Bacteria	627	4.22e-175	NTclustered	gi\|1708577445\|dbj\|AP019835.1\|	157687	g11129	i0	99.708	384.672514619883	342	1	100	0	1	342	2368532	2368873	Leptotrichia wadei JMUB3934 DNA, complete genome	blastn	131558	627	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
22735770	22735770	PRJNA278119_P_NODE_9398_length_383_cov_1.359281_g9151_i0	PRJNA278119	9398	383	1.359281	5.20604623	Cetobacterium	180162	Bacteria	Bacteria	523	6.439999999999999e-144	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g9151	i0	91.384	341.046997389034	383	32	100	1	1	383	48667	48286	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	130621	523	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae

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