metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJEB1404" and tax

13 rows where analysis = "blastn", bioproject = "PRJEB1404" and tax_phylum = "Bacteroidota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
21114	21114	PRJEB1404_S_NODE_3321_length_177_cov_3.084507_g3301_i0	PRJEB1404	3321	177	3.084507	5.45957739	Dyadobacter pollutisoli	2910158	Bacteria	Bacteria	152	1.43e-32	NTclustered	gi\|2381182547\|gb\|CP112998.1\|	2910158	g3301	i0	83.333	170.508474576271	174	19	97	9	7	175	2309	2141	Dyadobacter pollutisoli strain U1 chromosome	blastn	30180	152	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter pollutisoli
985716	985716	PRJEB1404_P_NODE_1141_length_308_cov_4.039711_g1116_i0	PRJEB1404	1141	308	4.039711	12.44230988	Chryseobacterium	59732	Bacteria	Bacteria	569	6.419999999999998e-158	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g1116	i0	100	458.529220779221	308	0	100	0	1	308	1783520	1783213	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	141227	569	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
1295286	1295286	PRJEB1404_S_NODE_2302_length_211_cov_4.937500_g2282_i0	PRJEB1404	2302	211	4.9375	10.418125	Chryseobacterium gambrini	373672	Bacteria	Bacteria	374	3.4799999999999995e-99	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g2282	i0	99.512	380.402843601896	205	1	97	0	7	211	1783487	1783283	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	80265	374	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
3847312	3847312	PRJEB1404_S_NODE_4384_length_155_cov_2.000000_g4364_i0	PRJEB1404	4384	155	2	3.1	Chryseobacterium sp. ZHDP1	2838877	Bacteria	Bacteria	281	1.49e-71	NTclustered	gi\|2046786976\|gb\|CP075682.1\|	2838877	g4364	i0	99.355	99.9806451612903	155	1	100	0	1	155	3562212	3562366	Chryseobacterium sp. ZHDP1 chromosome, complete genome	blastn	15497	281	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. ZHDP1
5123488	5123488	PRJEB1404_P_NODE_3985_length_176_cov_2.151724_g3959_i0	PRJEB1404	3985	176	2.151724	3.78703424	Chryseobacterium sp. ZHDP1	2838877	Bacteria	Bacteria	320	3.69e-83	NTclustered	gi\|2046786976\|gb\|CP075682.1\|	2838877	g3959	i0	99.432	96.0965909090909	176	1	100	0	1	176	3562386	3562211	Chryseobacterium sp. ZHDP1 chromosome, complete genome	blastn	16913	320	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. ZHDP1
9913876	9913876	PRJEB1404_P_NODE_4808_length_154_cov_4.747967_g4782_i0	PRJEB1404	4808	154	4.747967	7.31186918	Chryseobacterium	59732	Bacteria	Bacteria	257	2.5e-64	NTclustered	gi\|2429067237\|gb\|CP115859.1\|	1265445	g4782	i0	97.368	473.811688311688	152	3	98	1	1	151	1728890	1729041	Chryseobacterium camelliae strain VAN22-5A chromosome, complete genome	blastn	72967	257	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium camelliae
10223844	10223844	PRJEB1404_P_NODE_3869_length_179_cov_2.405405_g3843_i0	PRJEB1404	3869	179	2.405405	4.30567495	Chryseobacterium sp. ZHDP1	2838877	Bacteria	Bacteria	281	1.78e-71	NTclustered	gi\|2046786976\|gb\|CP075682.1\|	2838877	g3843	i0	99.355	82.9217877094972	155	1	87	0	1	155	2063620	2063466	Chryseobacterium sp. ZHDP1 chromosome, complete genome	blastn	14843	281	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. ZHDP1
12464858	12464858	PRJEB1404_S_NODE_3510_length_172_cov_3.766423_g3490_i0	PRJEB1404	3510	172	3.766423	6.47824756	Cloacibacterium	501783	Bacteria	Bacteria	267	4.73e-67	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g3490	i0	94.767	482.808139534884	172	8	100	1	1	172	129532	129362	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	83043	267	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
14049218	14049218	PRJEB1404_S_NODE_1072_length_274_cov_1.171548_g1052_i0	PRJEB1404	1072	274	1.171548	3.21004152	Chryseobacterium gambrini	373672	Bacteria	Bacteria	507	4.47e-139	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g1052	i0	100	42.9452554744526	274	0	100	0	1	274	3009146	3009419	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	11767	507	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
15323264	15323264	PRJEB1404_P_NODE_2353_length_230_cov_1.793970_g2327_i0	PRJEB1404	2353	230	1.79397	4.126131	Dyadobacter fanqingshengii	2906443	Bacteria	Bacteria	132	2.56e-26	NTclustered	gi\|2257605683\|gb\|CP098806.1\|	2906443	g2327	i0	83.673	156.921739130435	147	17	64	6	77	220	4703419	4703277	Dyadobacter fanqingshengii strain CY399 chromosome, complete genome	blastn	36092	132	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Dyadobacter	Dyadobacter fanqingshengii
18837520	18837520	PRJEB1404_S_NODE_2715_length_195_cov_4.156250_g2695_i0	PRJEB1404	2715	195	4.15625	8.1046875	Flavobacterium	237	Bacteria	Bacteria	305	1.17e-78	NTclustered	gi\|470491666\|ref\|NR_077051.1\|	312277	g2695	i0	94.872	611.748717948718	195	10	100	0	1	195	63	257	Flavobacterium indicum strain GPTSA100-9 23S ribosomal RNA gene, complete sequence	blastn	119291	305	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium indicum
20112286	20112286	PRJEB1404_S_NODE_1716_length_237_cov_4.113861_g1696_i0	PRJEB1404	1716	237	4.113861	9.74985057	Flavobacteriaceae	49546	Bacteria	Bacteria	121	5.75e-23	NTclustered	gi\|2863961238\|gb\|CP137731.1\|	107401	g1696	i0	77.293	559.223628691983	229	37	93	14	1	221	3079763	3079984	Tenacibaculum maritimum strain TCFB 0813 chromosome, complete genome	blastn	132536	122	0.991803278688525	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Tenacibaculum	Tenacibaculum maritimum
25211780	25211780	PRJEB1404_P_NODE_240_length_480_cov_6.755011_g222_i0	PRJEB1404	240	480	6.755011	32.4240528	Cytophagales	768507	Bacteria	Bacteria	401	4.029999999999999e-107	NTclustered	gi\|2581931629\|dbj\|AP025313.1\|	866807	g222	i0	82.7	282.604166666667	474	61	97	16	8	471	5902	6364	Aureibacter tunicatorum NBRC 107587 plasmid pATrrn DNA, complete genome	blastn	135650	403	0.995037220843672	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Persicobacteraceae	Aureibacter	Aureibacter tunicatorum

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