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

11 rows where analysis = "blastn", bioproject = "PRJNA505329" 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
483185	483185	PRJNA505329_P_NODE_17461_length_221_cov_10.604651_g16990_i0	PRJNA505329	17461	221	10.604651	23.43627871	Fusobacterium polymorphum	76857	Bacteria	Bacteria	409	1.0100000000000001e-109	NTclustered	gi\|2704883040\|gb\|CP056004.1\|	76857	g16990	i0	100	496	221	0	100	0	1	221	2214631	2214411	Fusobacterium polymorphum strain SB016 chromosome, complete genome	blastn	109616	409	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
1110378	1110378	PRJNA505329_P_NODE_40261_length_171_cov_3.024590_g39790_i0	PRJNA505329	40261	171	3.02459	5.1720489	Fusobacterium	848	Bacteria	Bacteria	305	9.96e-79	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g39790	i0	100	481.906432748538	165	0	98	0	4	168	94469	94305	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	82406	305	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
1110398	1110398	PRJNA505329_P_NODE_44361_length_167_cov_0.881356_g43890_i0	PRJNA505329	44361	167	0.881356	1.47186452	Cetobacterium	180162	Bacteria	Bacteria	267	4.599999999999999e-67	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g43890	i0	95.758	4.94011976047904	165	7	99	0	3	167	324594	324758	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	825	267	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
8763190	8763190	PRJNA505329_P_NODE_1187_length_1099_cov_17.292381_g724_i1	PRJNA505329	1187	1099	17.292381	190.04326719	Cetobacterium	180162	Bacteria	Bacteria	1864	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g724	i1	97.273	519.376706096451	1100	29	100	1	1	1099	278465	279564	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	570795	1864	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
9411608	9411608	PRJNA505329_P_NODE_428_length_1942_cov_5.646593_g331_i0	PRJNA505329	428	1942	5.646593	109.65683606	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	2453	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g331	i0	97.115	444.669412976313	1456	38	99	4	486	1939	1842714	1844167	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	863548	2453	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
13237507	13237507	PRJNA505329_P_NODE_51291_length_158_cov_2.238532_g50820_i0	PRJNA505329	51291	158	2.238532	3.53688056	Leptotrichia hofstadii	157688	Bacteria	Bacteria	287	3.29e-73	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g50820	i0	100	390.088607594937	155	0	98	0	4	158	499705	499859	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	61634	287	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
14512454	14512454	PRJNA505329_P_NODE_4252_length_391_cov_3.961988_g3787_i0	PRJNA505329	4252	391	3.961988	15.49137308	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	279	1.58e-70	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g3787	i0	100	114.590792838875	151	0	93	0	241	391	70589	70739	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	44805	279	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
15786147	15786147	PRJNA505329_P_NODE_38073_length_175_cov_1.626984_g37602_i0	PRJNA505329	38073	175	1.626984	2.847222	Leptotrichia hofstadii	157688	Bacteria	Bacteria	302	1.33e-77	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g37602	i0	98.266	6.47428571428571	173	2	99	1	1	173	639554	639383	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	1133	302	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
18335205	18335205	PRJNA505329_P_NODE_435_length_1933_cov_5.540340_g331_i1	PRJNA505329	435	1933	5.54034	107.0947722	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	2453	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g331	i1	97.115	446.114330056906	1456	38	99	4	4	1457	1844167	1842714	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	862339	2453	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
20236818	20236818	PRJNA505329_P_NODE_38196_length_174_cov_6.368000_g37725_i0	PRJNA505329	38196	174	6.368	11.08032	Cetobacterium	180162	Bacteria	Bacteria	222	1.05e-53	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g37725	i0	90.058	4.91379310344828	171	17	98	0	4	174	81071	81241	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	855	222	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20236933	20236933	PRJNA505329_P_NODE_936_length_1282_cov_15.597729_g724_i0	PRJNA505329	936	1282	15.597729	199.96288578	Fusobacterium	848	Bacteria	Bacteria	2322	0	NTclustered	gi\|2078816781\|gb\|CP071094.1\|	76857	g724	i0	99.375	471.907956318253	1281	8	99	0	1	1281	964691	963411	Fusobacterium polymorphum strain THCT15E1 chromosome, complete genome	blastn	604986	2322	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum

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