metadata: contig_metadata: 23 rows where bioproject = "PRJEB6097" and tax

23 rows where bioproject = "PRJEB6097" and tax_clade = "Opisthokonta"

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
125585	125585	PRJEB6097_S_NODE_6501_length_157_cov_8.311475_g6447_i0	PRJEB6097	6501	157	8.311475	13.04901575	Lampetra planeri	7750	Chordata	Chordata	67.6	4.63e-7	NTclustered	gi\|2814976159\|emb\|OZ078388.2\|	7750	g6447	i0	97.436	1.12101910828025	39	1	25	0	119	157	5643537	5643499	Lampetra planeri genome assembly, chromosome: 65	blastn	176	67.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra planeri
1400067	1400067	PRJEB6097_S_NODE_5422_length_211_cov_2.840909_g5368_i0	PRJEB6097	5422	211	2.840909	5.99431799	Spelobia clunipes	1888022	Arthropoda	Arthropoda	315	2.1399999999999993e-81	NTclustered	gi\|1880643096\|gb\|MT584135.1\|	1888022	g5368	i0	96.335	93.3981042654028	191	7	91	0	21	211	6401	6591	Spelobia clunipes isolate DM962 mitochondrion	blastn	19707	315	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Sphaeroceridae	Spelobia	Spelobia clunipes
3542811	3542811	PRJEB6097_S_NODE_6083_length_170_cov_9.466667_g6029_i0	PRJEB6097	6083	170	9.466667	16.0933339	Agaricomycetes	155619	Fungi	Fungi	99	1.8e-16	NTclustered	gi\|565619620\|gb\|KC603718.1\|	91677	g6029	i0	88.889	11.7647058823529	81	8	47	1	91	170	100	20	Hebeloma radicosum voucher TNS Kasuya B791 large subunit ribosomal RNA gene, partial sequence	blastn	2000	99	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Hymenogastraceae	Hebeloma	Hebeloma radicosum
6095434	6095434	PRJEB6097_S_NODE_5765_length_186_cov_2.450331_g5711_i0	PRJEB6097	5765	186	2.450331	4.55761566	Bombus	28641	Arthropoda	Arthropoda	52.8	0.016	NTclustered	gi\|2832700248\|ref\|XR_011174825.1\|	103934	g5711	i0	100	0.301075268817204	28	0	15	0	99	126	1433	1460	PREDICTED: Bombus flavifrons uncharacterized lncRNA (LOC138186175), ncRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Hymenoptera	Apidae	Bombus	Bombus flavifrons
7778083	7778083	PRJEB6097_S_NODE_6087_length_170_cov_5.748148_g6033_i0	PRJEB6097	6087	170	5.748148	9.7718516	uncultured fungus	175245	Fungi	Fungi	252	1.31e-62	NTclustered	gi\|400178660\|gb\|JX241713.1\|	175245	g6033	i0	93.491	6.22941176470588	169	11	99	0	1	169	269	101	Uncultured fungus clone CheiFrLf2291 26S ribosomal RNA gene, partial sequence	blastn	1059	252	1	Eukaryota	Opisthokonta	Fungi						uncultured fungus
7778086	7778086	PRJEB6097_S_NODE_6287_length_164_cov_1.689922_g6233_i0	PRJEB6097	6287	164	1.689922	2.77147208	Ophiostoma torulosum	96403	Fungi	Fungi	303	3.42e-78	NTclustered	gi\|325513885\|gb\|HQ343317.1\|	96403	g6233	i0	100	96.640243902439	164	0	100	0	1	164	3275	3112	Ophiostoma torulosum strain CBS 730.71 small subunit ribosomal RNA gene, complete sequence; and reverse transcriptase and double motif LAGLIDADG homing endonuclease genes, complete cds; mitochondrial	blastn	15849	303	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Ophiostomatales	Ophiostomataceae	Ophiostoma	Ophiostoma torulosum
8645381	8645381	PRJEB6097_S_NODE_5907_length_178_cov_1.391608_g5853_i0	PRJEB6097	5907	178	1.391608	2.47706224	Petromyzontidae	7746	Chordata	Chordata	60.2	9e-5	NTclustered	gi\|2815004333\|emb\|OZ078626.2\|	7748	g5853	i0	97.143	1.5561797752809	35	1	20	0	59	93	2122290	2122324	Lampetra fluviatilis genome assembly, chromosome: 58	blastn	277	60.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
9052848	9052848	PRJEB6097_S_NODE_6328_length_163_cov_1.562500_g6274_i0	PRJEB6097	6328	163	1.5625	2.546875	Mus musculus	10090	Chordata	Chordata	54.7	0.004	NTclustered	gi\|68448667\|gb\|AC160561.2\|	10090	g6274	i0	100	0.177914110429448	29	0	18	0	135	163	34628	34600	Mus musculus BAC clone RP23-102D22 from chromosome 12, complete sequence	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
9920474	9920474	PRJEB6097_S_NODE_5848_length_181_cov_4.993151_g5794_i0	PRJEB6097	5848	181	4.993151	9.03760331	Saccharomyces	4930	Fungi	Fungi	292	8.32e-75	NTclustered	gi\|2161760974\|gb\|OL763550.1\|	4932	g5794	i0	99.379	88.9005524861878	161	1	89	0	1	161	277	117	Saccharomyces cerevisiae clone S5-19 large subunit ribosomal RNA gene, partial sequence	blastn	16091	292	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Saccharomyces	Saccharomyces cerevisiae
10328635	10328635	PRJEB6097_S_NODE_6009_length_173_cov_2.623188_g5955_i0	PRJEB6097	6009	173	2.623188	4.53811524	Chironomus tepperi	113505	Arthropoda	Arthropoda	111	2.36e-20	NTclustered	gi\|2874216783\|ref\|XM_070642639.1\|	113505	g5955	i0	89.011	15.4913294797688	91	8	52	2	84	173	1462	1373	PREDICTED: Chironomus tepperi elongation factor 1-alpha-like (LOC139092294), mRNA	blastn	2680	111	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Chironomidae	Chironomus	Chironomus tepperi
10328638	10328638	PRJEB6097_S_NODE_6389_length_161_cov_2.833333_g6335_i0	PRJEB6097	6389	161	2.833333	4.56166613	Bradybaena similaris	145626	Mollusca	Mollusca	58.4	2.87e-4	NTclustered	gi\|2912984370\|dbj\|AP039589.1\|	145626	g6335	i0	100	1.79503105590062	31	0	19	0	107	137	66230485	66230455	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence	blastn	289	58.4	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
12471248	12471248	PRJEB6097_S_NODE_110_length_573_cov_21970.540892_g56_i0	PRJEB6097	110	573	21970.540892	125891.19931116	Eukaryota	2759	Fungi	Fungi	636	1.2299999999999998e-177	NTclustered	gi\|514829572\|gb\|KC771883.1\|	4929	g56	i0	100	56.1099476439791	344	0	60	0	230	573	368	25	Meyerozyma guilliermondii strain SNP3S 26S ribosomal RNA gene, partial sequence	blastn	32151	636	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Meyerozyma	Meyerozyma guilliermondii
12879215	12879215	PRJEB6097_S_NODE_2831_length_275_cov_31.000000_g2777_i0	PRJEB6097	2831	275	31	85.25	uncultured fungus	175245	Fungi	Fungi	448	2.7599999999999995e-121	NTclustered	gi\|2159201441\|emb\|OU940475.1\|	175245	g2777	i0	96	95.4872727272727	275	11	100	0	1	275	722	996	uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus01768	blastn	26259	448	1	Eukaryota	Opisthokonta	Fungi						uncultured fungus
12879225	12879225	PRJEB6097_S_NODE_6151_length_168_cov_3.827068_g6097_i0	PRJEB6097	6151	168	3.827068	6.42947424	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	52.8	0.014	NTclustered	gi\|2782839894\|ref\|XM_067055043.1\|	252671	g6097	i0	100	0.333333333333333	28	0	17	0	57	84	7988	7961	PREDICTED: Clytia hemisphaerica uncharacterized protein (LOC136798434), transcript variant X2, mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
16294941	16294941	PRJEB6097_S_NODE_1333_length_338_cov_38955.623762_g1279_i0	PRJEB6097	1333	338	38955.623762	131670.00831556	Eukaryota	2759	Fungi	Fungi	167	1.09e-36	NTclustered	gi\|658131895\|emb\|HF968949.1\|	4874	g1279	i0	96.078	45.1420118343195	102	4	30	0	237	338	1619	1518	Gigaspora margarita partial 28S rRNA gene, strain BEG152, isolate spore 2, clone FL2_12_91	blastn	15258	167	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora margarita
16294944	16294944	PRJEB6097_S_NODE_513_length_432_cov_29761.506297_g459_i0	PRJEB6097	513	432	29761.506297	128569.70720304	Opisthokonta	33154	Fungi	Fungi	374	7.829999999999997e-99	NTclustered	gi\|66805490\|gb\|DQ008146.1\|	29917	g459	i0	99.512	47.4537037037037	205	1	47	0	1	205	193	397	Cladosporium cladosporioides strain CBS 109501 28S large subunit ribosomal RNA gene, partial sequence	blastn	20500	374	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium cladosporioides
16294945	16294945	PRJEB6097_S_NODE_6593_length_155_cov_1.591667_g6539_i0	PRJEB6097	6593	155	1.591667	2.46708385	root	1	Root_unresolved	Root_unresolved	281	1.49e-71	NTclustered	gi\|78097480\|gb\|AC167666.4\|	7176	g6539	i0	99.355	287	155	1	100	0	1	155	1013	1167	Culex pipiens quinquefasciatus, clone Culex pipiens quinquefasciatus-3940120D9, complete sequence	blastn	44485	281	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Culicidae	Culex	Culex quinquefasciatus
16702254	16702254	PRJEB6097_S_NODE_2914_length_271_cov_22.855932_g2860_i0	PRJEB6097	2914	271	22.855932	61.93957572	uncultured fungus	175245	Fungi	Fungi	315	2.87e-81	NTclustered	gi\|583831600\|gb\|KF565163.1\|	175245	g2860	i0	87.591	89.7675276752768	274	30	100	4	1	271	312	40	Uncultured soil fungus clone NCD_LSU_otu193 28S ribosomal RNA gene, partial sequence	blastn	24327	315	1	Eukaryota	Opisthokonta	Fungi						uncultured fungus
20526523	20526523	PRJEB6097_S_NODE_5277_length_227_cov_4.234375_g5223_i0	PRJEB6097	5277	227	4.234375	9.61203125	Meyerozyma guilliermondii	4929	Fungi	Fungi	217	6.78e-52	NTclustered	gi\|146421244\|ref\|XM_001486523.1\|	294746	g5223	i0	90.741	115.638766519824	162	15	71	0	1	162	1207	1368	Meyerozyma guilliermondii ATCC 6260 ubiquitin (PGUG_02244), partial mRNA	blastn	26250	217	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Meyerozyma	Meyerozyma guilliermondii
20526533	20526533	PRJEB6097_S_NODE_97_length_599_cov_20504.757092_g44_i0	PRJEB6097	97	599	20504.757092	122823.49498108	uncultured fungus	175245	Fungi	Fungi	394	8.55e-105	NTclustered	gi\|2159202025\|emb\|OU940232.1\|	175245	g44	i0	91.409	44.8597662771285	291	20	48	5	1	287	165	454	uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus01527	blastn	26871	394	1	Eukaryota	Opisthokonta	Fungi						uncultured fungus
23944600	23944600	PRJEB6097_S_NODE_119_length_564_cov_21758.034026_g65_i0	PRJEB6097	119	564	21758.034026	122715.31190664	Eukaryota	2759	Fungi	Fungi	617	4.37e-172	NTclustered	gi\|514829572\|gb\|KC771883.1\|	4929	g65	i0	100	54.6879432624113	334	0	59	0	1	334	25	358	Meyerozyma guilliermondii strain SNP3S 26S ribosomal RNA gene, partial sequence	blastn	30844	617	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Meyerozyma	Meyerozyma guilliermondii
27476026	27476026	PRJEB6097_S_NODE_3823_length_256_cov_1.945701_g3769_i0	PRJEB6097	3823	256	1.945701	4.98099456	Jimgerdemannia flammicorona	994334	Fungi	Fungi	46.2	7.6e-4	NR	RUS34214.1	994334	g3769	i0	38.8	0.57421875	49	30	57.4	0	21	167	67	115	RUS34214.1 hypothetical protein BC938DRAFT_481852 [Jimgerdemannia flammicorona]	diamond	147	46.2	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Endogonomycetes	Endogonales	Endogonaceae	Jimgerdemannia	Jimgerdemannia flammicorona
29938986	29938986	PRJEB6097_S_NODE_6251_length_165_cov_2.130769_g6197_i0	PRJEB6097	6251	165	2.130769	3.51576885	Watersipora subatra	2589382	Bryozoa	other_Eukaryota	50.4	2.42e-5	NR	XP_067931533.1	2589382	g6197	i0	70.4	0.981818181818182	27	8	49.1	0	104	24	399	425	XP_067931533.1 uncharacterized protein [Watersipora subatra]	diamond	162	50.4	1	Eukaryota	Opisthokonta	Metazoa	Bryozoa	Gymnolaemata	Cheilostomatida	Watersiporidae	Watersipora	Watersipora subatra

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