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

10 rows where analysis = "blastn", bioproject = "PRJEB55250" 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
2671802	2671802	PRJEB55250_P_NODE_15143_length_244_cov_0.900585_g15019_i0	PRJEB55250	15143	244	0.900585	2.1974274	Aptenodytes forsteri	9233	Chordata	Chordata	390	4.11e-104	NTclustered	gi\|1110999049\|ref\|XM_019470459.1\|	9233	g15019	i0	95.492	1.11885245901639	244	11	100	0	1	244	862	619	PREDICTED: Aptenodytes forsteri prophage integrase IntA-like (LOC109279286), mRNA	blastn	273	390	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Sphenisciformes	Spheniscidae	Aptenodytes	Aptenodytes forsteri
3542396	3542396	PRJEB55250_P_NODE_16183_length_242_cov_0.911243_g16059_i0	PRJEB55250	16183	242	0.911243	2.20520806	root	1	Root_unresolved	Root_unresolved	448	2.3799999999999995e-121	NTclustered	gi\|74207406\|dbj\|AK152023.1\|	10090	g16059	i0	100	40.9214876033058	242	0	100	0	1	242	1236	1477	Mus musculus bone marrow macrophage cDNA, RIKEN full-length enriched library, clone:I830045H07 product:p21 (CDKN1A)-activated kinase 2, full insert sequence	blastn	9903	448	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
4819883	4819883	PRJEB55250_P_NODE_8424_length_273_cov_1.540000_g8300_i0	PRJEB55250	8424	273	1.54	4.2042	Bovidae	9895	Chordata	Chordata	104	6.82e-18	NTclustered	gi\|2633720223\|ref\|XR_009740456.1\|	9906	g8300	i0	89.157	21.5604395604396	83	9	30	0	7	89	11397	11479	PREDICTED: Bos javanicus uncharacterized LOC133259584 (LOC133259584), ncRNA	blastn	5886	104	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bos	Bos javanicus
9049085	9049085	PRJEB55250_P_NODE_568_length_868_cov_2.357233_g468_i0	PRJEB55250	568	868	2.357233	20.46078244	Meriones unguiculatus	10047	Chordata	Chordata	69.4	8.69e-7	NTclustered	gi\|2599590958\|ref\|XM_060390852.1\|	10047	g468	i0	90.566	0.42741935483871	53	3	6	2	155	205	302	250	PREDICTED: Meriones unguiculatus calpain 7 (Capn7), transcript variant X3, mRNA	blastn	371	69.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Meriones	Meriones unguiculatus
15424072	15424072	PRJEB55250_P_NODE_13153_length_248_cov_0.880000_g13029_i0	PRJEB55250	13153	248	0.88	2.1824	Mus musculus	10090	Chordata	Chordata	459	1.13e-124	NTclustered	gi\|1061975057\|ref\|NM_001331048.1\|	10090	g13029	i0	100	6	248	0	100	0	1	248	4998	4751	Mus musculus hyaluronan synthase 3 (Has3), transcript variant 2, mRNA	blastn	1488	459	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
15424164	15424164	PRJEB55250_P_NODE_16853_length_237_cov_2.292683_g16729_i0	PRJEB55250	16853	237	2.292683	5.43365871	Mus musculus	10090	Chordata	Chordata	54.7	0.006	NTclustered	gi\|71533340\|gb\|AC156162.2\|	10090	g16729	i0	100	0.122362869198312	29	0	12	0	30	58	100755	100783	Mus musculus BAC clone RP24-342A17 from chromosome 9, complete sequence	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
16294572	16294572	PRJEB55250_P_NODE_4753_length_322_cov_0.927711_g4629_i0	PRJEB55250	4753	322	0.927711	2.98722942	root	1	Root_unresolved	Root_unresolved	584	2.41e-162	NTclustered	gi\|21727344\|emb\|AL627314.6\|	10090	g4629	i0	99.379	100.88198757764	322	2	100	0	1	322	35120	34799	Mouse DNA sequence from clone RP23-354H24 on chromosome 4, complete sequence	blastn	32484	584	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
19247469	19247469	PRJEB55250_P_NODE_8416_length_273_cov_1.540000_g8292_i0	PRJEB55250	8416	273	1.54	4.2042	Stegostoma tigrinum	3053191	Chordata	Chordata	52.8	0.025	NTclustered	gi\|2579323054\|ref\|XM_048560041.2\|	3053191	g8292	i0	100	0.41025641025641	28	0	10	0	129	156	4890	4863	PREDICTED: Stegostoma tigrinum BTB/POZ domain-containing protein 2-like (LOC125465982), transcript variant X1, mRNA	blastn	112	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Orectolobiformes	Stegostomatidae	Stegostoma	Stegostoma tigrinum
20522596	20522596	PRJEB55250_P_NODE_13357_length_247_cov_1.770115_g13233_i0	PRJEB55250	13357	247	1.770115	4.37218405	Bubalus bubalis	89462	Chordata	Chordata	316	7.17e-82	NTclustered	gi\|2148424236\|ref\|XR_006552564.2\|	89462	g13233	i0	96.825	1.16599190283401	189	6	77	0	59	247	1	189	PREDICTED: Bubalus bubalis uncharacterized LOC123334545 (LOC123334545), ncRNA	blastn	288	316	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Bovidae	Bubalus	Bubalus bubalis
21393961	21393961	PRJEB55250_P_NODE_3497_length_360_cov_1.609756_g3373_i0	PRJEB55250	3497	360	1.609756	5.7951216	root	1	Root_unresolved	Root_unresolved	660	0	NTclustered	gi\|686598286\|ref\|XM_009277024.1\|	9233	g3373	i0	99.722	11.0888888888889	360	1	100	0	1	360	582	223	PREDICTED: Aptenodytes forsteri allantoicase (ALLC), partial mRNA	blastn	3992	665	0.992481203007519	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Sphenisciformes	Spheniscidae	Aptenodytes	Aptenodytes forsteri

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