metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJEB3181" and tax

27 rows where analysis = "blastn", bioproject = "PRJEB3181" 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
988893	988893	PRJEB3181_S_NODE_7561_length_227_cov_75.770833_g7268_i0	PRJEB3181	7561	227	75.770833	171.99979091	Cetobacterium	180162	Bacteria	Bacteria	327	3e-85	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g7268	i0	100	19.6563876651982	177	0	78	0	1	177	258195	258371	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	4462	327	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
2606052	2606052	PRJEB3181_S_NODE_3603_length_304_cov_93.037175_g3310_i0	PRJEB3181	3603	304	93.037175	282.833012	Cetobacterium somerae	188913	Bacteria	Bacteria	433	8.66e-117	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g3310	i0	96.212	53.6907894736842	264	10	87	0	40	303	1612174	1612437	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	16322	433	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3539407	3539407	PRJEB3181_S_NODE_15663_length_164_cov_1.550388_g15370_i0	PRJEB3181	15663	164	1.550388	2.54263632	Cetobacterium	180162	Bacteria	Bacteria	187	3.6e-43	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g15370	i0	87.578	4.89024390243902	161	20	98	0	4	164	1164314	1164474	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	802	187	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3539415	3539415	PRJEB3181_S_NODE_17163_length_157_cov_0.983607_g16870_i0	PRJEB3181	17163	157	0.983607	1.54426299	Cetobacterium	180162	Bacteria	Bacteria	220	3.36e-53	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g16870	i0	94.444	85.0191082802548	144	7	91	1	12	154	479047	479190	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	13348	220	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3882024	3882024	PRJEB3181_P_NODE_1104_length_574_cov_1018.029466_g964_i0	PRJEB3181	1104	574	1018.029466	5843.48913484	Cetobacterium somerae	188913	Bacteria	Bacteria	968	0	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g964	i0	98.895	494.306620209059	543	5	95	1	3	545	49410	48869	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	283732	968	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
3882289	3882289	PRJEB3181_S_NODE_8624_length_214_cov_37029.653631_g8331_i0	PRJEB3181	8624	214	37029.653631	79243.45877034	Cetobacterium somerae	188913	Bacteria	Bacteria	230	8.11e-56	NTclustered	gi\|2201062197\|gb\|CP092519.1\|	188913	g8331	i0	92.994	54.2429906542056	157	11	73	0	1	157	1561370	1561214	Cetobacterium somerae strain CS2105-BJ chromosome, complete genome	blastn	11608	230	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
4816739	4816739	PRJEB3181_S_NODE_18384_length_152_cov_0.965812_g18091_i0	PRJEB3181	18384	152	0.965812	1.46803424	Cetobacterium	180162	Bacteria	Bacteria	281	1.46e-71	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g18091	i0	100	19.5592105263158	152	0	100	0	1	152	1906691	1906540	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	2973	281	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6091961	6091961	PRJEB3181_S_NODE_11485_length_189_cov_616.357143_g11192_i0	PRJEB3181	11485	189	616.357143	1164.91500027	Cetobacterium	180162	Bacteria	Bacteria	292	8.78e-75	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g11192	i0	99.379	406.582010582011	161	1	85	0	29	189	277867	278027	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	76844	292	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6091997	6091997	PRJEB3181_S_NODE_6405_length_244_cov_143.320574_g6112_i0	PRJEB3181	6405	244	143.320574	349.70220056	Cetobacterium	180162	Bacteria	Bacteria	311	3.29e-80	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g6112	i0	94.527	21.0450819672131	201	11	82	0	43	243	1903126	1902926	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	5135	311	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
6434096	6434096	PRJEB3181_P_NODE_10146_length_266_cov_1584.259574_g9882_i0	PRJEB3181	10146	266	1584.259574	4214.13046684	Cetobacterium somerae	188913	Bacteria	Bacteria	366	7.65e-97	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g9882	i0	98.551	368.609022556391	207	3	78	0	36	242	1318782	1318988	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	98050	366	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
7366466	7366466	PRJEB3181_S_NODE_5806_length_254_cov_1.981735_g5513_i0	PRJEB3181	5806	254	1.981735	5.0336069	Cetobacterium	180162	Bacteria	Bacteria	363	9.379999999999998e-96	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g5513	i0	97.63	12.2244094488189	211	5	83	0	44	254	1899975	1899765	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	3105	363	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
10258774	10258774	PRJEB3181_S_NODE_10809_length_194_cov_1431.484277_g10516_i0	PRJEB3181	10809	194	1431.484277	2777.07949738	Cetobacterium somerae	188913	Bacteria	Bacteria	305	1.16e-78	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g10516	i0	97.238	445.917525773196	181	4	93	1	1	180	1318954	1318774	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	86508	305	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
10258931	10258931	PRJEB3181_S_NODE_8349_length_218_cov_1.557377_g8056_i0	PRJEB3181	8349	218	1.557377	3.39508186	Cetobacterium somerae	188913	Bacteria	Bacteria	364	2.18e-96	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g8056	i0	96.789	12.8715596330275	218	7	100	0	1	218	1739598	1739381	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	2806	364	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
11192210	11192210	PRJEB3181_S_NODE_15149_length_167_cov_1.515152_g14856_i0	PRJEB3181	15149	167	1.515152	2.53030384	Cetobacterium	180162	Bacteria	Bacteria	263	5.94e-66	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g14856	i0	97.403	12.0958083832335	154	4	92	0	14	167	1905325	1905172	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	2020	263	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12467948	12467948	PRJEB3181_S_NODE_10470_length_197_cov_5.123457_g10177_i0	PRJEB3181	10470	197	5.123457	10.09321029	Cetobacterium	180162	Bacteria	Bacteria	346	6.99e-91	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g10177	i0	98.469	12.8883248730964	196	3	99	0	1	196	1774220	1774415	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	2539	346	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12467960	12467960	PRJEB3181_S_NODE_14670_length_169_cov_5.104478_g14377_i0	PRJEB3181	14670	169	5.104478	8.62656782	Cetobacterium	180162	Bacteria	Bacteria	285	1.28e-72	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g14377	i0	97.041	13.8639053254438	169	5	100	0	1	169	1906515	1906347	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	2343	285	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
12467999	12467999	PRJEB3181_S_NODE_7210_length_232_cov_513.314721_g6917_i0	PRJEB3181	7210	232	513.314721	1190.89015272	Cetobacterium	180162	Bacteria	Bacteria	294	3.12e-75	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g6917	i0	99.383	332.198275862069	162	1	70	0	1	162	278027	277866	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	77070	294	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
16291513	16291513	PRJEB3181_P_NODE_253_length_938_cov_531.115766_g196_i0	PRJEB3181	253	938	531.115766	4981.86588508	Cetobacterium	180162	Bacteria	Bacteria	1267	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g196	i0	91.295	517.095948827292	942	62	99	17	1	932	279617	278686	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	485036	1267	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18840523	18840523	PRJEB3181_S_NODE_11215_length_191_cov_856.910256_g10922_i0	PRJEB3181	11215	191	856.910256	1636.69858896	Cetobacterium	180162	Bacteria	Bacteria	300	5.31e-77	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g10922	i0	100	404.38219895288	162	0	85	0	30	191	277866	278027	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	77237	300	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
18840543	18840543	PRJEB3181_S_NODE_18355_length_152_cov_1.367521_g18062_i0	PRJEB3181	18355	152	1.367521	2.07863192	Cetobacterium	180162	Bacteria	Bacteria	163	5.5e-36	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g18062	i0	88.722	4.375	133	15	88	0	1	133	81110	81242	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	665	163	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
20115385	20115385	PRJEB3181_S_NODE_616_length_557_cov_18.923372_g210_i1	PRJEB3181	616	557	18.923372	105.40318204	Cetobacterium	180162	Bacteria	Bacteria	750	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g210	i1	91.166	493.673249551167	566	31	100	17	1	557	279274	278719	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	274976	750	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
21390937	21390937	PRJEB3181_P_NODE_1057_length_580_cov_37.548270_g920_i0	PRJEB3181	1057	580	37.54827	217.779966	Bacteria	2	Bacteria	Bacteria	126	3.33e-24	NTclustered	gi\|470485033\|ref\|NR_076681.1\|	826	g920	i0	89.899	83.0844827586207	99	9	17	1	282	379	250	152	Sebaldella termitidis strain ATCC 33386 23S ribosomal RNA gene, complete sequence	blastn	48189	126	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Leptotrichiaceae	Sebaldella	Sebaldella termitidis
21391008	21391008	PRJEB3181_S_NODE_5737_length_255_cov_137.618182_g5444_i0	PRJEB3181	5737	255	137.618182	350.9263641	Cetobacterium	180162	Bacteria	Bacteria	267	7.6e-67	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g5444	i0	89.202	17.3764705882353	213	23	84	0	1	213	1881460	1881672	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	4431	267	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
21391012	21391012	PRJEB3181_S_NODE_677_length_537_cov_15.818725_g424_i0	PRJEB3181	677	537	15.818725	84.94655325	Cetobacterium	180162	Bacteria	Bacteria	922	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g424	i0	98.654	486.409683426443	520	7	97	0	18	537	279760	279241	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	261202	922	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22665732	22665732	PRJEB3181_S_NODE_418_length_673_cov_17.415361_g210_i0	PRJEB3181	418	673	17.415361	117.20537953	Cetobacterium	180162	Bacteria	Bacteria	1112	0	NTclustered	gi\|2865368125\|gb\|CP122294.1\|	188913	g210	i0	99.349	467.90044576523	614	4	91	0	60	673	278661	279274	Cetobacterium somerae strain MSU41 plasmid p41_t2, complete sequence	blastn	314897	1112	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
22665740	22665740	PRJEB3181_S_NODE_6398_length_244_cov_381.224880_g6105_i0	PRJEB3181	6398	244	381.22488	930.1887072	Cetobacterium	180162	Bacteria	Bacteria	333	7.019999999999999e-87	NTclustered	gi\|2666488225\|gb\|CP143319.1\|	188913	g6105	i0	97.436	78.1926229508197	195	5	80	0	50	244	1904583	1904389	Cetobacterium somerae strain ceto chromosome, complete genome	blastn	19079	333	1	Bacteria	Fusobacteriati	Fusobacteriota	Fusobacteriia	Fusobacteriales	Fusobacteriaceae	Cetobacterium	Cetobacterium somerae
25215028	25215028	PRJEB3181_S_NODE_9300_length_207_cov_37425.104651_g9007_i0	PRJEB3181	9300	207	37425.104651	77469.96662757	Cetobacterium	180162	Bacteria	Bacteria	259	9.94e-65	NTclustered	gi\|2865366169\|gb\|CP122292.1\|	188913	g9007	i0	96.203	26.3188405797101	158	6	76	0	1	158	899017	899174	Cetobacterium somerae strain MSU41 chromosome, complete genome	blastn	5448	259	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);;