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

10 rows where analysis = "blastn", bioproject = "PRJNA169559" and tax_phylum = "Mucoromycota"

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
364908	364908	PRJNA169559_P_NODE_22221_length_339_cov_102.874194_g20156_i0	PRJNA169559	22221	339	102.874194	348.74351766	Diversispora sp.	1931097	Fungi	Fungi	462	1.25e-125	NTclustered	gi\|1957552589\|gb\|MW486564.1\|	1931097	g20156	i0	91.496	100.144542772861	341	22	99	6	2	339	86	422	Diversispora sp. isolate SporeBB_M22 small subunit ribosomal RNA gene, partial sequence	blastn	33949	462	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Diversisporaceae	Diversispora	Diversispora sp.
2915709	2915709	PRJNA169559_P_NODE_35343_length_246_cov_4.184332_g33266_i0	PRJNA169559	35343	246	4.184332	10.29345672	Gamsiella multidivaricata	101098	Fungi	Fungi	58.4	4.78e-4	NTclustered	gi\|2323777632\|ref\|XM_051555321.1\|	101098	g33266	i0	94.595	0.296747967479675	37	2	15	0	66	102	26	62	Gamsiella multidivaricata ribosomal L29e protein family-domain-containing protein (BC939DRAFT_449038), mRNA	blastn	73	58.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Gamsiella	Gamsiella multidivaricata
2915757	2915757	PRJNA169559_P_NODE_4503_length_796_cov_25.559322_g3247_i0	PRJNA169559	4503	796	25.559322	203.45220312	Entrophospora claroidea	3049150	Fungi	Fungi	141	1.66e-28	NTclustered	gi\|365175915\|gb\|HQ856962.1\|	3049150	g3247	i0	83.553	3.05527638190955	152	23	19	2	371	521	667	517	Glomus claroideum isolate BR147A-4 clone 9 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	2432	141	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Entrophosporales	Entrophosporaceae	Entrophospora	Entrophospora claroidea
5468376	5468376	PRJNA169559_P_NODE_3685_length_873_cov_8.130332_g2557_i0	PRJNA169559	3685	873	8.130332	70.97779836	Phycomyces blakesleeanus	4837	Fungi	Fungi	339	6.029999999999998e-88	NTclustered	gi\|1069936519\|ref\|XM_018440025.1\|	763407	g2557	i0	80.682	44.2634593356243	440	82	50	2	146	585	135	571	Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA	blastn	38642	339	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces blakesleeanus
5468514	5468514	PRJNA169559_P_NODE_5765_length_707_cov_6.482301_g4364_i0	PRJNA169559	5765	707	6.482301	45.82986807	Phycomyces blakesleeanus	4837	Fungi	Fungi	337	1.7399999999999996e-87	NTclustered	gi\|1069938230\|ref\|XM_018429293.1\|	763407	g4364	i0	79.541	57.7029702970297	479	92	67	6	107	582	3071	3546	Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA	blastn	40796	337	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces blakesleeanus
13118807	13118807	PRJNA169559_P_NODE_30091_length_264_cov_4.093617_g28015_i0	PRJNA169559	30091	264	4.093617	10.80714888	Umbelopsis ramanniana	41833	Fungi	Fungi	122	1.81e-23	NTclustered	gi\|2323685971\|ref\|XM_051588073.1\|	1314678	g28015	i0	96	8.59848484848485	75	3	28	0	169	243	168	94	Umbelopsis ramanniana AG uncharacterized protein (K450DRAFT_235369), mRNA	blastn	2270	122	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Umbelopsidomycetes	Umbelopsidales	Umbelopsidaceae	Umbelopsis	Umbelopsis ramanniana
16942455	16942455	PRJNA169559_P_NODE_634_length_2126_cov_3.945637_g285_i0	PRJNA169559	634	2126	3.945637	83.88424262	Phycomyces blakesleeanus	4837	Fungi	Fungi	1351	0	NTclustered	gi\|1069962231\|ref\|XM_018439533.1\|	763407	g285	i0	81.373	78.8137347130762	1675	296	78	15	79	1745	20	1686	Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein partial mRNA	blastn	167558	1351	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces blakesleeanus
20180852	20180852	PRJNA169559_P_NODE_13236_length_460_cov_74.412993_g11339_i0	PRJNA169559	13236	460	74.412993	342.2997678	Eukaryota	2759	Fungi	Fungi	505	2.85e-138	NTclustered	gi\|461490351\|emb\|HF559249.1\|	231236	g11339	i0	92.857	75.9260869565217	350	21	76	4	113	460	326	673	Uncultured Paraglomus partial 18S rRNA gene, clone GAT2-25	blastn	34926	510	0.990196078431373	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Paraglomerales			uncultured Paraglomus
20766557	20766557	PRJNA169559_P_NODE_31357_length_259_cov_1.639130_g29281_i0	PRJNA169559	31357	259	1.63913	4.2453467	Phycomyces blakesleeanus	4837	Fungi	Fungi	52.8	0.024	NTclustered	gi\|1069952963\|ref\|XM_018439323.1\|	763407	g29281	i0	100	0.108108108108108	28	0	11	0	225	252	728	755	Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces blakesleeanus
24591154	24591154	PRJNA169559_P_NODE_16180_length_420_cov_2.843990_g14212_i0	PRJNA169559	16180	420	2.84399	11.944758	Phycomyces blakesleeanus	4837	Fungi	Fungi	106	3.06e-18	NTclustered	gi\|1069960134\|ref\|XM_018440121.1\|	763407	g14212	i0	93.056	0.895238095238095	72	5	17	0	22	93	212	141	Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA	blastn	376	106	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces blakesleeanus

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