metadata: contig_metadata: 5 rows where bioproject = "PRJNA474426", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA474426", tax_kingdom = "Metazoa" and tax_phylum = "Mollusca"

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
4274525	4274525	PRJNA474426_P_NODE_37064_length_159_cov_3.018182_g36859_i0	PRJNA474426	37064	159	3.018182	4.79890938	Bradybaena similaris	145626	Mollusca	Mollusca	52.8	0.013	NTclustered	gi\|2912988862\|dbj\|AP039593.1\|	145626	g36859	i0	100	0.176100628930818	28	0	18	0	132	159	34542891	34542864	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
11300232	11300232	PRJNA474426_P_NODE_6169_length_436_cov_1.165375_g5966_i0	PRJNA474426	6169	436	1.165375	5.081035	Metazoa	33208	Mollusca	Mollusca	56.5	0.003	NTclustered	gi\|2912993551\|dbj\|AP039598.1\|	145626	g5966	i0	96.97	0.857798165137615	33	1	8	0	286	318	14733548	14733580	Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence	blastn	374	56.5	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Stylommatophora	Camaenidae	Bradybaena	Bradybaena similaris
18299037	18299037	PRJNA474426_P_NODE_25715_length_192_cov_1.272727_g25510_i0	PRJNA474426	25715	192	1.272727	2.44363584	Aplysia californica	6500	Mollusca	Mollusca	52.8	0.017	NTclustered	gi\|871252906\|ref\|XM_013086174.1\|	6500	g25510	i0	96.875	0.166666666666667	32	0	17	1	132	163	2621	2591	PREDICTED: Aplysia californica uncharacterized LOC106012645 (LOC106012645), partial mRNA	blastn	32	52.8	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda	Aplysiida	Aplysiidae	Aplysia	Aplysia californica
25323150	25323150	PRJNA474426_P_NODE_30860_length_172_cov_1.260163_g30655_i0	PRJNA474426	30860	172	1.260163	2.16748036	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	73.2	2.62e-13	NR	XP_069107631.1	31199	g30655	i0	57.9	3.97674418604651	57	24	99.4	0	1	171	302	358	XP_069107631.1 tyrosine--tRNA ligase, mitochondrial-like [Argopecten irradians]	diamond	684	73.2	1	Eukaryota	Opisthokonta	Metazoa	Mollusca	Bivalvia	Pectinida	Pectinidae	Argopecten	Argopecten irradians
27724544	27724544	PRJNA474426_P_NODE_27404_length_185_cov_1.500000_g27199_i0	PRJNA474426	27404	185	1.5	2.775	Metazoa	33208	Mollusca	Mollusca	49.7	6.2e-5	NR	XP_055860289.1	6526	g27199	i0	47.7	2.85405405405405	44	23	71.4	0	182	51	606	649	XP_055860289.1 uncharacterized protein LOC129921730 [Biomphalaria glabrata]	diamond	528	50.1	0.992015968063872	Eukaryota	Opisthokonta	Metazoa	Mollusca	Gastropoda		Planorbidae	Biomphalaria	Biomphalaria glabrata

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