metadata: contig_metadata: 11 rows where bioproject = "PRJEB83711" and tax

11 rows where bioproject = "PRJEB83711" 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
2273963	2273963	PRJEB83711_P_NODE_5902_length_745_cov_6.385417_g5665_i0	PRJEB83711	5902	745	6.385417	47.57135665	Cetobacterium	180162	Bacteria	Bacteria	1343	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g5665	i0	99.195	526.618791946309	745	6	100	0	1	745	279718	278974	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	392331	1343	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3549519	3549519	PRJEB83711_P_NODE_79923_length_239_cov_4.981928_g79657_i0	PRJEB83711	79923	239	4.981928	11.90680792	Cetobacterium	180162	Bacteria	Bacteria	436	5.0799999999999985e-118	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g79657	i0	99.582	504.991631799163	239	1	100	0	1	239	278728	278966	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	120693	436	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3969448	3969448	PRJEB83711_P_NODE_10464_length_556_cov_3.144928_g10202_i0	PRJEB83711	10464	556	3.144928	17.48579968	Cetobacterium somerae	188913	Bacteria	Bacteria	987	0	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g10202	i0	98.741	492.629496402878	556	5	100	2	1	556	1319021	1318468	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	273902	987	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3970855	3970855	PRJEB83711_P_NODE_72004_length_245_cov_1.494186_g71738_i0	PRJEB83711	72004	245	1.494186	3.6607557	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	425	1.1299999999999999e-114	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g71738	i0	97.959	8	245	5	100	0	1	245	174811	174567	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	1960	425	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
6522536	6522536	PRJEB83711_P_NODE_53606_length_260_cov_1.352941_g53340_i0	PRJEB83711	53606	260	1.352941	3.5176466	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	470	5.519999999999998e-128	NTclustered	gi\|1276705688\|gb\|CP024698.1\|	2663009	g53340	i0	99.231	29.2230769230769	260	2	100	0	1	260	765508	765767	Fusobacterium pseudoperiodonticum strain KCOM 1283 chromosome, complete genome	blastn	7598	470	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
6522941	6522941	PRJEB83711_P_NODE_72246_length_245_cov_0.906977_g71980_i0	PRJEB83711	72246	245	0.906977	2.22209365	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	420	5.26e-113	NTclustered	gi\|1276718681\|gb\|CP024704.1\|	2663009	g71980	i0	97.551	12.4122448979592	245	6	100	0	1	245	807381	807137	Fusobacterium pseudoperiodonticum strain KCOM 2555 chromosome, complete genome	blastn	3041	420	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
9071275	9071275	PRJEB83711_P_NODE_39648_length_290_cov_1.248848_g39382_i0	PRJEB83711	39648	290	1.248848	3.6216592	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	492	1.3399999999999996e-134	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g39382	i0	97.241	1	290	8	100	0	1	290	643061	642772	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	290	492	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
9071883	9071883	PRJEB83711_P_NODE_65268_length_249_cov_0.886364_g65002_i0	PRJEB83711	65268	249	0.886364	2.20704636	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1276718681\|gb\|CP024704.1\|	2663009	g65002	i0	100	115.602409638554	249	0	100	0	1	249	1218581	1218333	Fusobacterium pseudoperiodonticum strain KCOM 2555 chromosome, complete genome	blastn	28785	460	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
12897757	12897757	PRJEB83711_P_NODE_51051_length_265_cov_1.265625_g50785_i0	PRJEB83711	51051	265	1.265625	3.35390625	Fusobacterium pseudoperiodonticum	2663009	Bacteria	Bacteria	484	2.0199999999999998e-132	NTclustered	gi\|1276716588\|gb\|CP024703.1\|	2663009	g50785	i0	99.623	162.796226415094	265	1	100	0	1	265	1960189	1960453	Fusobacterium pseudoperiodonticum strain KCOM 2305 chromosome, complete genome	blastn	43141	484	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium pseudoperiodonticum
19270263	19270263	PRJEB83711_P_NODE_76456_length_243_cov_0.917647_g76190_i0	PRJEB83711	76456	243	0.917647	2.22988221	Leptotrichia wadei	157687	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g76190	i0	99.177	2.87654320987654	243	2	100	0	1	243	688313	688555	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	699	438	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
23096640	23096640	PRJEB83711_P_NODE_67079_length_248_cov_0.891429_g66813_i0	PRJEB83711	67079	248	0.891429	2.21074392	Cetobacterium somerae	188913	Bacteria	Bacteria	420	5.34e-113	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g66813	i0	97.177	4.91935483870968	248	7	100	0	1	248	1428854	1428607	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	1220	420	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);;