metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA229468" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA229468" and tax_phylum = "Chordata"

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
367288	367288	PRJNA229468_S_NODE_321_length_277_cov_4.311404_g308_i0	PRJNA229468	321	277	4.311404	11.94258908	Ciona intestinalis	7719	Chordata	Chordata	235	2.3599999999999997e-57	NTclustered	gi\|1494783678\|ref\|XM_009862731.3\|	7719	g308	i0	82.955	152.649819494585	264	41	99	4	16	277	1225	1486	PREDICTED: Ciona intestinalis polyubiquitin-A (LOC100175058), transcript variant X1, mRNA	blastn	42284	235	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Phlebobranchia	Cionidae	Ciona	Ciona intestinalis
4194376	4194376	PRJNA229468_S_NODE_844_length_181_cov_2.303030_g831_i0	PRJNA229468	844	181	2.30303	4.1684843	Xenopus tropicalis	8364	Chordata	Chordata	111	2.5e-20	NTclustered	gi\|77620966\|emb\|CR761546.2\|	8364	g831	i0	79.29	3.7292817679558	169	27	91	6	11	175	271	107	Xenopus tropicalis finished cDNA, clone TGas127d10	blastn	675	111	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus tropicalis
5470639	5470639	PRJNA229468_S_NODE_905_length_177_cov_2.257812_g892_i0	PRJNA229468	905	177	2.257812	3.99632724	Scyliorhinus canicula	7830	Chordata	Chordata	95.3	2.45e-15	NTclustered	gi\|1952512345\|ref\|XM_038789812.1\|	7830	g892	i0	79.412	2.30508474576271	136	26	76	2	43	177	246	112	PREDICTED: Scyliorhinus canicula 60S ribosomal protein L11-like (LOC119962035), mRNA	blastn	408	95.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Carcharhiniformes	Scyliorhinidae	Scyliorhinus	Scyliorhinus canicula
9984666	9984666	PRJNA229468_S_NODE_1148_length_164_cov_1.217391_g1135_i0	PRJNA229468	1148	164	1.217391	1.99652124	root	1	Root_unresolved	Root_unresolved	189	1e-43	NTclustered	gi\|2805740242\|emb\|OZ078478.1\|	7748	g1135	i0	88.05	97.0731707317073	159	19	97	0	1	159	103581	103739	Lampetra fluviatilis genome assembly, chromosome: 75	blastn	15920	189	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
11845855	11845855	PRJNA229468_S_NODE_890_length_178_cov_1.790698_g877_i0	PRJNA229468	890	178	1.790698	3.18744244	Hyla sarda	327740	Chordata	Chordata	104	4.1e-18	NTclustered	gi\|2512160901\|ref\|XM_056558662.1\|	327740	g877	i0	81.967	2.45505617977528	122	22	69	0	1	122	302	181	PREDICTED: Hyla sarda tyrosine 3-monooxygenase/tryptophan 5-monooxygenase activation protein epsilon (YWHAE), transcript variant X1, mRNA	blastn	437	104	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Hylidae	Hyla	Hyla sarda
15670083	15670083	PRJNA229468_S_NODE_1033_length_168_cov_1.285714_g1020_i0	PRJNA229468	1033	168	1.285714	2.15999952	Chrysochloris asiatica	185453	Chordata	Chordata	95.3	2.31e-15	NTclustered	gi\|586491719\|ref\|XM_006876253.1\|	185453	g1020	i0	87.059	40.5178571428571	85	10	51	1	82	166	415	332	PREDICTED: Chrysochloris asiatica solute carrier family 25 (mitochondrial carrier; adenine nucleotide translocator), member 6 (SLC25A6), mRNA	blastn	6807	95.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia		Chrysochloridae	Chrysochloris	Chrysochloris asiatica
23319336	23319336	PRJNA229468_S_NODE_619_length_206_cov_0.974522_g606_i0	PRJNA229468	619	206	0.974522	2.00751532	Sitta europaea	50251	Chordata	Chordata	52.8	0.018	NTclustered	gi\|2917598300\|emb\|OZ228662.1\|	50251	g606	i0	100	0.135922330097087	28	0	14	0	1	28	9505611	9505584	Sitta europaea genome assembly, chromosome: 8	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Sittidae	Sitta	Sitta europaea
23319341	23319341	PRJNA229468_S_NODE_999_length_170_cov_2.421488_g986_i0	PRJNA229468	999	170	2.421488	4.1165296	Geotrypetes seraphini	260995	Chordata	Chordata	65.8	1.83e-6	NTclustered	gi\|1835613316\|ref\|XM_033917946.1\|	260995	g986	i0	75.94	4.00588235294118	133	28	77	4	35	165	346	476	PREDICTED: Geotrypetes seraphini ribosomal protein S25 (RPS25), mRNA	blastn	681	65.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Gymnophiona	Dermophiidae	Geotrypetes	Geotrypetes seraphini

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