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

10 rows where analysis = "blastn", bioproject = "PRJNA1262902" 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
2914234	2914234	PRJNA1262902_P_NODE_143_length_981_cov_2.647577_g116_i0	PRJNA1262902	143	981	2.647577	25.97273037	Hymenobacter volaticus	2932254	Bacteria	Bacteria	1701	0	NTclustered	gi\|2221934578\|gb\|CP095067.1\|	2932254	g116	i0	97.965	285.439347604485	983	17	100	3	1	981	64477	63496	Hymenobacter volaticus strain 5420 S-77 plasmid unnamed6, complete sequence	blastn	280016	1701	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter volaticus
2914276	2914276	PRJNA1262902_P_NODE_7943_length_250_cov_0.870056_g7901_i0	PRJNA1262902	7943	250	0.870056	2.17514	Sphingobacterium daejeonense	371142	Bacteria	Bacteria	448	2.4699999999999996e-121	NTclustered	gi\|1639029986\|emb\|LR590470.1\|	371142	g7901	i0	98.81	1.008	252	1	100	1	1	250	370122	370373	Sphingobacterium daejeonense strain NCTC13534 genome assembly, chromosome: 1	blastn	252	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium daejeonense
2914286	2914286	PRJNA1262902_P_NODE_8863_length_248_cov_0.880000_g8821_i0	PRJNA1262902	8863	248	0.88	2.1824	Chryseobacterium indologenes	253	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1519580736\|gb\|CP033930.1\|	253	g8821	i0	100	10.9879032258065	248	0	100	0	1	248	4724376	4724129	Chryseobacterium indologenes strain H5559 chromosome, complete genome	blastn	2725	459	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
6741342	6741342	PRJNA1262902_P_NODE_7606_length_251_cov_0.865169_g7564_i0	PRJNA1262902	7606	251	0.865169	2.17157419	Chryseobacterium sp. CY350	2997336	Bacteria	Bacteria	263	9.65e-66	NTclustered	gi\|2430443073\|gb\|CP116034.1\|	2997336	g7564	i0	85.83	15.4980079681275	247	35	98	0	5	251	598711	598465	Chryseobacterium sp. CY350 chromosome, complete genome	blastn	3890	263	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. CY350
15666413	15666413	PRJNA1262902_P_NODE_1613_length_376_cov_6.372937_g1571_i0	PRJNA1262902	1613	376	6.372937	23.96224312	Flavobacterium fluviale	2249356	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|1421732866\|gb\|CP030261.1\|	2249356	g1571	i0	100	0.0771276595744681	29	0	8	0	343	371	115149	115121	Flavobacterium fluviale strain HYN0086 chromosome, complete genome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium fluviale
20765078	20765078	PRJNA1262902_P_NODE_2017_length_352_cov_1.347670_g1975_i0	PRJNA1262902	2017	352	1.34767	4.7437984	Chitinophagaceae bacterium LGM1	2837399	Bacteria	Bacteria	444	4.699999999999998e-120	NTclustered	gi\|2046997110\|gb\|CP075895.1\|	2837399	g1975	i0	90.719	222.068181818182	334	29	94	2	8	339	1076929	1076596	Chitinophagaceae bacterium LGM1 chromosome, complete genome	blastn	78168	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium LGM1
22040192	22040192	PRJNA1262902_P_NODE_2518_length_332_cov_2.675676_g2476_i0	PRJNA1262902	2518	332	2.675676	8.88324432	Hymenobacter tibetensis	497967	Bacteria	Bacteria	608	1.479999999999999e-169	NTclustered	gi\|2218432809\|gb\|CP094673.1\|	497967	g2476	i0	99.699	267.551204819277	332	1	100	0	1	332	59235	59566	Hymenobacter tibetensis strain KACC 21982 plasmid unnamed4, complete sequence	blastn	88827	608	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter tibetensis
23315679	23315679	PRJNA1262902_P_NODE_1919_length_357_cov_2.309859_g1877_i0	PRJNA1262902	1919	357	2.309859	8.24619663	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	545	1.27e-150	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g1877	i0	94.15	10.8487394957983	359	19	100	1	1	357	3149230	3149588	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	3873	545	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3
23315740	23315740	PRJNA1262902_P_NODE_9719_length_246_cov_0.890173_g9677_i0	PRJNA1262902	9719	246	0.890173	2.18982558	uncultured Flavobacteriaceae bacterium	165436	Bacteria	Bacteria	255	1.58e-63	NTclustered	gi\|921059534\|gb\|KP887319.1\|	165436	g9677	i0	90.452	125.40243902439	199	11	78	8	42	233	1811	1614	Uncultured Flavobacteriaceae bacterium clone 201_DPL 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	30849	255	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		uncultured Flavobacteriaceae bacterium
24005988	24005988	PRJNA1262902_P_NODE_5999_length_265_cov_2.328125_g5957_i0	PRJNA1262902	5999	265	2.328125	6.16953125	Fluviicola	332102	Bacteria	Bacteria	333	7.719999999999999e-87	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g5957	i0	93.363	213.139622641509	226	14	85	1	17	242	1431	1207	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	56482	335	0.994029850746269	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis

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