metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA312107" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA312107" 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
2338861	2338861	PRJNA312107_P_NODE_24062_length_164_cov_0.904348_g23896_i0	PRJNA312107	24062	164	0.904348	1.48313072	Cetobacterium	180162	Bacteria	Bacteria	303	3.42e-78	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g23896	i0	100	8.37195121951219	164	0	100	0	1	164	1909006	1908843	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	1373	303	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6755195	6755195	PRJNA312107_P_NODE_10906_length_219_cov_1.923529_g10740_i0	PRJNA312107	10906	219	1.923529	4.21252851	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	405	1.29e-108	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g10740	i0	100	222.945205479452	219	0	100	0	1	219	70547	70765	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	48825	405	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
8030845	8030845	PRJNA312107_P_NODE_22467_length_165_cov_1.051724_g22301_i0	PRJNA312107	22467	165	1.051724	1.7353446	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	270	3.4999999999999993e-68	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g22301	i0	96.894	484.109090909091	161	5	98	0	1	161	805047	805207	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	79878	270	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
9305575	9305575	PRJNA312107_P_NODE_11428_length_214_cov_3.224242_g11262_i0	PRJNA312107	11428	214	3.224242	6.89987788	Leptotrichia wadei	157687	Bacteria	Bacteria	390	3.519999999999999e-104	NTclustered	gi\|1708582457\|dbj\|AP019841.1\|	157687	g11262	i0	99.533	169.102803738318	214	1	100	0	1	214	1756459	1756672	Leptotrichia wadei JMUB3936 DNA, complete genome	blastn	36188	390	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia wadei
11856282	11856282	PRJNA312107_P_NODE_25130_length_163_cov_0.912281_g24964_i0	PRJNA312107	25130	163	0.912281	1.48701803	Cetobacterium somerae	188913	Bacteria	Bacteria	255	9.65e-64	NTclustered	gi\|2201062198\|gb\|CP092520.1\|	188913	g24964	i0	95.597	7.03067484662577	159	7	98	0	4	162	221340	221182	Cetobacterium somerae strain CS2105-BJ plasmid unnamed1, complete sequence	blastn	1146	255	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
15091355	15091355	PRJNA312107_P_NODE_5112_length_312_cov_4.068441_g4946_i0	PRJNA312107	5112	312	4.068441	12.69353592	Fusobacterium	848	Bacteria	Bacteria	555	1.8199999999999994e-153	NTclustered	gi\|2705020071\|gb\|CP084132.1\|	851	g4946	i0	98.718	482.516025641026	312	4	100	0	1	312	107623	107934	Fusobacterium nucleatum strain KCOM3713 chromosome, complete genome	blastn	150545	555	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
16955021	16955021	PRJNA312107_P_NODE_9894_length_229_cov_1.100000_g9728_i0	PRJNA312107	9894	229	1.1	2.519	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	351	1.8e-92	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g9728	i0	94.348	453.039301310044	230	11	100	2	1	229	72783	73011	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	103746	351	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
18914975	18914975	PRJNA312107_P_NODE_22995_length_165_cov_0.896552_g22829_i0	PRJNA312107	22995	165	0.896552	1.4793108	Cetobacterium	180162	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g22829	i0	100	11.8909090909091	165	0	100	0	1	165	544815	544979	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	1962	305	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18914985	18914985	PRJNA312107_P_NODE_4175_length_344_cov_1.837288_g4009_i0	PRJNA312107	4175	344	1.837288	6.32027072	Fusobacterium	848	Bacteria	Bacteria	619	7.109999999999999e-173	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g4009	i0	99.128	472.982558139535	344	3	100	0	1	344	462728	463071	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	162706	625	0.9904	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum
19503585	19503585	PRJNA312107_P_NODE_21496_length_166_cov_0.888889_g21330_i0	PRJNA312107	21496	166	0.888889	1.47555574	Fusobacterium animalis	76859	Bacteria	Bacteria	296	5.82e-76	NTclustered	gi\|2706511199\|gb\|CP085045.1\|	76859	g21330	i0	98.795	99.433734939759	166	2	100	0	1	166	2431503	2431668	Fusobacterium animalis strain KCOM1279 chromosome, complete genome	blastn	16506	296	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
22054108	22054108	PRJNA312107_P_NODE_18078_length_171_cov_1.704918_g17912_i0	PRJNA312107	18078	171	1.704918	2.91540978	Leptotrichia hongkongensis	554406	Bacteria	Bacteria	305	9.96e-79	NTclustered	gi\|1708587163\|dbj\|AP019846.1\|	554406	g17912	i0	98.83	155.836257309942	171	2	100	0	1	171	1624325	1624495	Leptotrichia hongkongensis JMUB5056 DNA, complete genome	blastn	26648	305	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hongkongensis
25289776	25289776	PRJNA312107_P_NODE_9220_length_236_cov_1.647059_g9054_i0	PRJNA312107	9220	236	1.647059	3.88705924	Fusobacterium	848	Bacteria	Bacteria	431	2.33e-116	NTclustered	gi\|2078816781\|gb\|CP071094.1\|	76857	g9054	i0	99.576	476.96186440678	236	1	100	0	1	236	465213	464978	Fusobacterium polymorphum strain THCT15E1 chromosome, complete genome	blastn	112563	431	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);;