metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1098727" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1098727" 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
211124	211124	PRJNA1098727_P_NODE_81_length_1912_cov_3.290929_g46_i0	PRJNA1098727	81	1912	3.290929	62.92256248	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	2920	0	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g46	i0	94.43	491.54550209205	1903	98	99	8	2	1900	51594	53492	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	939835	2920	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
4037826	4037826	PRJNA1098727_P_NODE_14904_length_164_cov_0.904348_g14663_i0	PRJNA1098727	14904	164	0.904348	1.48313072	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	291	2.67e-74	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g14663	i0	98.773	7.90853658536585	163	2	99	0	1	163	127907	127745	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	1297	291	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
4847889	4847889	PRJNA1098727_P_NODE_12844_length_169_cov_0.866667_g12603_i0	PRJNA1098727	12844	169	0.866667	1.46466723	Fusobacterium	848	Bacteria	Bacteria	309	7.58e-80	NTclustered	gi\|2707733444\|gb\|CP077171.1\|	76859	g12603	i0	100	98.8165680473373	167	0	99	0	2	168	682810	682644	Fusobacterium animalis strain SB043 chromosome, complete genome	blastn	16700	309	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium animalis
6122891	6122891	PRJNA1098727_P_NODE_1165_length_654_cov_2.773554_g951_i0	PRJNA1098727	1165	654	2.773554	18.13904316	Leptotrichia	32067	Bacteria	Bacteria	1116	0	NTclustered	gi\|470484715\|ref\|NR_076664.1\|	40542	g951	i0	97.833	460.241590214067	646	14	99	0	3	648	1269	1914	Leptotrichia buccalis strain C-1013-b 23S ribosomal RNA gene, complete sequence	blastn	300998	1127	0.990239574090506	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia buccalis
12498643	12498643	PRJNA1098727_P_NODE_4830_length_294_cov_1.118367_g4589_i0	PRJNA1098727	4830	294	1.1183670000000001	3.28799898	Fusobacterium	848	Bacteria	Bacteria	532	7.989999999999998e-147	NTclustered	gi\|2706506546\|gb\|CP084156.1\|	76857	g4589	i0	99.32	402.21768707483	294	2	100	0	1	294	1588054	1587761	Fusobacterium polymorphum strain KCOM2510 chromosome	blastn	118252	532	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium polymorphum
23163442	23163442	PRJNA1098727_P_NODE_2039_length_482_cov_2.956120_g1805_i0	PRJNA1098727	2039	482	2.95612	14.2484984	Leptotrichia sp. HMT-225	3058373	Bacteria	Bacteria	859	0	NTclustered	gi\|2557559843\|gb\|CP130323.1\|	3058373	g1805	i0	98.958	172.504149377593	480	5	99	0	2	481	197159	196680	Leptotrichia sp. HMT-225 chromosome, complete genome	blastn	83147	859	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. HMT-225
24437006	24437006	PRJNA1098727_P_NODE_4480_length_307_cov_1.678295_g4239_i0	PRJNA1098727	4480	307	1.678295	5.15236565	Leptotrichia sp. oral taxon 212	712357	Bacteria	Bacteria	564	2.98e-156	NTclustered	gi\|922689899\|gb\|CP012410.1\|	712357	g4239	i0	100	441.775244299674	305	0	99	0	1	305	53541	53845	Leptotrichia sp. oral taxon 212 strain W10393, complete genome	blastn	135625	564	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia sp. oral taxon 212
25246146	25246146	PRJNA1098727_P_NODE_10580_length_186_cov_2.087591_g10339_i0	PRJNA1098727	10580	186	2.087591	3.88291926	Leptotrichia	32067	Bacteria	Bacteria	339	1.0899999999999998e-88	NTclustered	gi\|1708566027\|dbj\|AP019823.1\|	157688	g10339	i0	100	301.645161290323	183	0	98	0	2	184	2256484	2256302	Leptotrichia hofstadii JCM16775 DNA, complete genome	blastn	56106	339	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Leptotrichia	Leptotrichia hofstadii
25246151	25246151	PRJNA1098727_P_NODE_11740_length_176_cov_1.566929_g11499_i0	PRJNA1098727	11740	176	1.566929	2.75779504	Fusobacterium	848	Bacteria	Bacteria	324	2.85e-84	NTclustered	gi\|2704983719\|gb\|CP077132.1\|	851	g11499	i0	100	493.977272727273	175	0	99	0	2	176	93146	92972	Fusobacterium nucleatum strain KCOM3208 chromosome, complete genome	blastn	86940	326	0.993865030674847	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium nucleatum
25246169	25246169	PRJNA1098727_P_NODE_2740_length_411_cov_1.737569_g2500_i0	PRJNA1098727	2740	411	1.737569	7.14140859	Fusobacterium	848	Bacteria	Bacteria	750	0	NTclustered	gi\|1370537877\|gb\|CP028108.1\|	860	g2500	i0	99.756	474.085158150852	409	1	99	0	2	410	462189	462597	Fusobacterium periodonticum strain 2_1_31 chromosome, complete genome	blastn	194849	756	0.992063492063492	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Fusobacterium	Fusobacterium periodonticum

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