contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA929940" and tax_phylum = "Chordata"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 909141 | 909141 | PRJNA929940_S_NODE_40081_length_175_cov_1.384058_g39846_i0 | PRJNA929940 | 40081 | 175 | 1.384058 | 2.4221015 | Geotrypetes seraphini | 260995 | Chordata | Chordata | 52.8 | 0.015 | NTclustered | gi|1835611722|ref|XM_033925509.1| | 260995 | g39846 | i0 | 100 | 0.16 | 28 | 0 | 16 | 0 | 148 | 175 | 2191 | 2164 | PREDICTED: Geotrypetes seraphini elongator acetyltransferase complex subunit 5 (ELP5), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Gymnophiona | Dermophiidae | Geotrypetes | Geotrypetes seraphini | |
| 11458521 | 11458521 | PRJNA929940_S_NODE_45789_length_166_cov_1.503876_g45554_i0 | PRJNA929940 | 45789 | 166 | 1.503876 | 2.49643416 | Lampetra | 13103 | Chordata | Chordata | 267 | 4.559999999999999e-67 | NTclustered | gi|2814982574|emb|OZ078585.2| | 7748 | g45554 | i0 | 95.783 | 240.156626506024 | 166 | 5 | 100 | 2 | 1 | 165 | 982336 | 982500 | Lampetra fluviatilis genome assembly, chromosome: 17 | blastn | 39866 | 267 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lampetra | Lampetra fluviatilis | |
| 12388286 | 12388286 | PRJNA929940_S_NODE_55290_length_154_cov_2.136752_g55055_i0 | PRJNA929940 | 55290 | 154 | 2.136752 | 3.29059808 | Lampetra fluviatilis | 7748 | Chordata | Chordata | 244 | 1.94e-60 | NTclustered | gi|2805738660|emb|OZ078456.1| | 7748 | g55055 | i0 | 95.425 | 144.402597402597 | 153 | 7 | 100 | 0 | 1 | 153 | 3721252 | 3721404 | Lampetra fluviatilis genome assembly, chromosome: 53 | blastn | 22238 | 244 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Hyperoartia | Petromyzontiformes | Petromyzontidae | Lampetra | Lampetra fluviatilis | |
| 16212068 | 16212068 | PRJNA929940_S_NODE_29133_length_198_cov_1.664596_g28898_i0 | PRJNA929940 | 29133 | 198 | 1.664596 | 3.29590008 | Polypterus senegalus | 55291 | Chordata | Chordata | 56.5 | 0.001 | NTclustered | gi|1993890913|ref|XM_039742785.1| | 55291 | g28898 | i0 | 100 | 0.585858585858586 | 30 | 0 | 15 | 0 | 144 | 173 | 114 | 143 | PREDICTED: Polypterus senegalus microtubule-associated protein 1B-like (LOC120520355), mRNA | blastn | 116 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 17487391 | 17487391 | PRJNA929940_S_NODE_12334_length_275_cov_7.289916_g12099_i0 | PRJNA929940 | 12334 | 275 | 7.289916 | 20.047269 | Spinus spinus | 160760 | Chordata | Chordata | 54.7 | 0.007 | NTclustered | gi|2917663466|emb|OZ228753.1| | 160760 | g12099 | i0 | 94.444 | 0.261818181818182 | 36 | 1 | 13 | 1 | 229 | 263 | 37205157 | 37205122 | Spinus spinus genome assembly, chromosome: 5 | blastn | 72 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Fringillidae | Spinus | Spinus spinus | |
| 20035730 | 20035730 | PRJNA929940_S_NODE_31016_length_193_cov_2.378205_g30781_i0 | PRJNA929940 | 31016 | 193 | 2.378205 | 4.58993565 | Pteronotus mesoamericanus | 1884717 | Chordata | Chordata | 52.8 | 0.017 | NTclustered | gi|2466560394|ref|XM_054594616.1| | 1884717 | g30781 | i0 | 100 | 0.290155440414508 | 28 | 0 | 15 | 0 | 78 | 105 | 1840 | 1867 | PREDICTED: Pteronotus mesoamericanus uncharacterized LOC129087674 (LOC129087674), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Chiroptera | Mormoopidae | Pteronotus | Pteronotus mesoamericanus | |
| 20035733 | 20035733 | PRJNA929940_S_NODE_36076_length_182_cov_1.875862_g35841_i0 | PRJNA929940 | 36076 | 182 | 1.875862 | 3.41406884 | Bombina bombina | 8345 | Chordata | Chordata | 52.8 | 0.015 | NTclustered | gi|2445260820|ref|XM_053718804.1| | 8345 | g35841 | i0 | 100 | 0.307692307692308 | 28 | 0 | 15 | 0 | 95 | 122 | 1768 | 1795 | PREDICTED: Bombina bombina adenosine deaminase tRNA specific 3 (ADAT3), transcript variant X2, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bombinatoridae | Bombina | Bombina bombina |
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);;