metadata: contig_metadata: 22 rows where bioproject = "PRJNA931595" and tax

22 rows where bioproject = "PRJNA931595" 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
1254952	1254952	PRJNA931595_P_NODE_2641_length_442_cov_1.406504_g2534_i0	PRJNA931595	2641	442	1.406504	6.21674768	Cytophagales	768507	Bacteria	Bacteria	494	5.909999999999998e-135	NTclustered	gi\|507148283\|ref\|NR_103089.1\|	985	g2534	i0	86.86	346.649321266968	449	49	100	9	1	442	2475	2030	Cytophaga hutchinsonii strain ATCC 33406 23S ribosomal RNA gene, complete sequence	blastn	153219	497	0.993963782696177	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Cytophaga	Cytophaga hutchinsonii
8562443	8562443	PRJNA931595_P_NODE_1087_length_616_cov_4.449355_g980_i0	PRJNA931595	1087	616	4.449355	27.4080268	Bacteroidales bacterium SW299	2510306	Bacteria	Bacteria	819	0	NTclustered	gi\|2729058721\|emb\|OZ007021.1\|	2510306	g980	i0	90.645	286.896103896104	620	52	100	6	1	616	290869	290252	MAG: Bacteroidales bacterium SW299 isolate 6755_HET_CTRL_contig_977_metaflye_circ MAG genome assembly, chromosome: 1	blastn	176728	819	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium SW299
8562447	8562447	PRJNA931595_P_NODE_10967_length_263_cov_2.368421_g10858_i0	PRJNA931595	10967	263	2.368421	6.22894723	Prevotella melaninogenica	28132	Bacteria	Bacteria	475	1.2e-129	NTclustered	gi\|2028856500\|gb\|CP072350.1\|	28132	g10858	i0	99.615	215.745247148289	260	1	99	0	4	263	699130	698871	Prevotella melaninogenica strain F0301 chromosome 2, complete sequence	blastn	56741	475	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
8562578	8562578	PRJNA931595_P_NODE_15127_length_242_cov_1.366864_g15018_i0	PRJNA931595	15127	242	1.366864	3.30781088	Chitinophagaceae bacterium LGM1	2837399	Bacteria	Bacteria	392	1.1299999999999999e-104	NTclustered	gi\|2046997110\|gb\|CP075895.1\|	2837399	g15018	i0	95.868	311.818181818182	242	10	100	0	1	242	1076177	1075936	Chitinophagaceae bacterium LGM1 chromosome, complete genome	blastn	75460	392	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium LGM1
8562690	8562690	PRJNA931595_P_NODE_4807_length_355_cov_1.638298_g4698_i0	PRJNA931595	4807	355	1.638298	5.8159579	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	433	1.0299999999999999e-116	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g4698	i0	88.701	203.171830985916	354	40	99	0	1	354	2978005	2977652	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	72126	433	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
11458673	11458673	PRJNA931595_P_NODE_11949_length_254_cov_1.182320_g11840_i0	PRJNA931595	11949	254	1.18232	3.0030928	Chryseobacterium	59732	Bacteria	Bacteria	462	8.989999999999999e-126	NTclustered	gi\|1276741219\|gb\|CP022986.1\|	1265445	g11840	i0	99.605	409.681102362205	253	1	99	0	2	254	1202893	1203145	Chryseobacterium camelliae strain Dolsongi-HT1, complete genome	blastn	104059	462	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium camelliae
12388795	12388795	PRJNA931595_P_NODE_15070_length_242_cov_1.822485_g14961_i0	PRJNA931595	15070	242	1.822485	4.4104137	Pedobacter sp. SL55	2995161	Bacteria	Bacteria	425	1.11e-114	NTclustered	gi\|2381133349\|gb\|CP113059.1\|	2995161	g14961	i0	98.347	342.892561983471	242	4	100	0	1	242	517526	517767	Pedobacter sp. SL55 chromosome	blastn	82980	425	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. SL55
13663280	13663280	PRJNA931595_P_NODE_15671_length_240_cov_2.724551_g15562_i0	PRJNA931595	15671	240	2.724551	6.5389224	Flavisolibacter sp.	1954249	Bacteria	Bacteria	143	1.25e-37	NR	HWI91994.1	1954249	g15562	i0	87.2	1.95	78	10	97.5	0	2	235	266	343	HWI91994.1 leucine--tRNA ligase [Flavisolibacter sp.]	diamond	468	143	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter sp.
20381296	20381296	PRJNA931595_P_NODE_4376_length_367_cov_5.156463_g4267_i0	PRJNA931595	4376	367	5.156463	18.92421921	Phocaeicola	909656	Bacteria	Bacteria	335	3.089999999999999e-87	NTclustered	gi\|1966883226\|gb\|CP068488.1\|	821	g4267	i0	83.243	489.267029972752	370	57	100	5	1	367	2750552	2750185	Phocaeicola vulgatus strain FDAARGOS_1098 chromosome	blastn	179561	335	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola vulgatus
21311724	21311724	PRJNA931595_P_NODE_15497_length_241_cov_0.916667_g15388_i0	PRJNA931595	15497	241	0.916667	2.20916747	Chryseobacterium sp. PMSZPI	1033900	Bacteria	Bacteria	407	4.0199999999999995e-109	NTclustered	gi\|2894512347\|gb\|CP178384.1\|	1033900	g15388	i0	97.095	507.053941908714	241	7	100	0	1	241	1704182	1704422	Chryseobacterium sp. PMSZPI chromosome, complete genome	blastn	122200	407	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. PMSZPI
21311730	21311730	PRJNA931595_P_NODE_15657_length_241_cov_0.880952_g15548_i0	PRJNA931595	15657	241	0.880952	2.12309432	Kaistella haifensis	421525	Bacteria	Bacteria	142	7.36e-38	NR	ROI03799.1	421525	g15548	i0	83.5	1.96680497925311	79	13	98.3	0	3	239	6	84	ROI03799.1 glycosyltransferase [Kaistella haifensis]	diamond	474	142	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella haifensis
21657215	21657215	PRJNA931595_P_NODE_10977_length_263_cov_2.084211_g10868_i0	PRJNA931595	10977	263	2.084211	5.48147493	Flavobacterium	237	Bacteria	Bacteria	486	5.5499999999999986e-133	NTclustered	gi\|429324699\|emb\|HF564288.1\|	152509	g10868	i0	100	101.980988593156	263	0	100	0	1	263	382	644	Uncultured Bacteroidetes bacterium partial 16S rRNA gene, clone SeqBactT43	blastn	26821	486	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					uncultured Bacteroidota bacterium
22586493	22586493	PRJNA931595_P_NODE_11038_length_263_cov_1.221053_g10929_i0	PRJNA931595	11038	263	1.221053	3.21136939	Prevotella sp.	59823	Bacteria	Bacteria	363	9.769999999999999e-96	NTclustered	gi\|2580284204\|gb\|OR338521.1\|	59823	g10929	i0	91.667	546.494296577947	264	19	100	3	1	263	2604	2343	Prevotella sp. strain k141_12813 hypothetical protein gene, complete cds	blastn	143728	363	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
24206523	24206523	PRJNA931595_P_NODE_14079_length_245_cov_1.790698_g13970_i0	PRJNA931595	14079	245	1.790698	4.3872101	Aquirufa	2676247	Bacteria	Bacteria	366	6.95e-97	NTclustered	gi\|2259823876\|gb\|CP049835.1\|	2516559	g13970	i0	93.522	284.391836734694	247	14	100	2	1	245	214591	214345	Aquirufa antheringensis strain 44A-TON chromosome, complete genome	blastn	69676	366	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa antheringensis
25135654	25135654	PRJNA931595_P_NODE_10300_length_270_cov_0.786802_g10191_i0	PRJNA931595	10300	270	0.786802	2.1243654	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	483	7.409999999999998e-132	NTclustered	gi\|1527200821\|gb\|CP034160.1\|	2487072	g10191	i0	98.889	479.037037037037	270	3	100	0	1	270	669962	670231	Epilithonimonas vandammei strain H6466 chromosome, complete genome	blastn	129340	483	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
25136030	25136030	PRJNA931595_P_NODE_8800_length_283_cov_1.214286_g8691_i0	PRJNA931595	8800	283	1.214286	3.43642938	Bacteroidales bacterium	2030927	Bacteria	Bacteria	197	2.04e-56	NR	MBS7358709.1	2030927	g8691	i0	100	0.996466431095406	94	0	99.6	0	283	2	32	125	MBS7358709.1 aminomethyl-transferring glycine dehydrogenase [Bacteroidales bacterium]	diamond	282	197	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
25481565	25481565	PRJNA931595_P_NODE_6040_length_324_cov_1.533865_g5931_i0	PRJNA931595	6040	324	1.533865	4.9697226	Chryseobacterium	59732	Bacteria	Bacteria	592	1.4499999999999999e-164	NTclustered	gi\|2081116358\|gb\|CP080443.1\|	2864040	g5931	i0	100	502.413580246914	320	0	99	0	1	320	794061	794380	Chryseobacterium sp. LJ668 chromosome, complete genome	blastn	162782	592	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. LJ668
27056643	27056643	PRJNA931595_P_NODE_10782_length_265_cov_1.604167_g10673_i0	PRJNA931595	10782	265	1.604167	4.25104255	Hydrobacter penzbergensis	1235997	Bacteria	Bacteria	150	1.8799999999999994e-42	NR	WP_092723107.1	1235997	g10673	i0	90.5	0.950943396226415	84	6	92.8	1	2	247	235	318	WP_092723107.1 aldose 1-epimerase [Hydrobacter penzbergensis]	diamond	252	150	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Hydrobacter	Hydrobacter penzbergensis
27846131	27846131	PRJNA931595_P_NODE_9724_length_275_cov_1.450495_g9615_i0	PRJNA931595	9724	275	1.450495	3.98886125	Chitinophaga sp. H8	3163343	Bacteria	Bacteria	171	3.8e-53	NR	WP_354664049.1	3163343	g9615	i0	86.8	1.98545454545455	91	12	99.3	0	2	274	20	110	WP_354664049.1 hypothetical protein [Chitinophaga defluvii]	diamond	546	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga defluvii
28983162	28983162	PRJNA931595_P_NODE_10488_length_268_cov_1.528205_g10379_i0	PRJNA931595	10488	268	1.528205	4.0955894	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	154	1.15e-43	NR	HRE37100.1	1869212	g10379	i0	89.9	0.996268656716418	89	9	99.6	0	2	268	231	319	HRE37100.1 DNA replication and repair protein RecF [Chitinophagaceae bacterium]	diamond	267	154	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
29330200	29330200	PRJNA931595_P_NODE_14929_length_243_cov_0.905882_g14820_i0	PRJNA931595	14929	243	0.905882	2.20129326	Flavisolibacter sp.	1954249	Bacteria	Bacteria	149	6.51e-42	NR	MBD0376655.1	1954249	g14820	i0	95.1	1	81	4	100	0	243	1	179	259	MBD0376655.1 IS110 family transposase [Flavisolibacter sp.]	diamond	243	149	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter sp.
32774659	32774659	PRJNA931595_P_NODE_15960_length_228_cov_2.032258_g15851_i0	PRJNA931595	15960	228	2.032258	4.63354824	Bacteroidota bacterium	1898104	Bacteria	Bacteria	141	6.82e-38	NR	MEY3115090.1	1898104	g15851	i0	98.7	1	76	1	100	0	228	1	72	147	MEY3115090.1 hypothetical protein [Bacteroidota bacterium]	diamond	228	141	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium

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